O'Reilly logo

MySQL by Robert D. Schneider

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Index

A

aborted clients status setting, database connectivity, 215

accelerating data loading from data exports, 319–322

concurrency management, 320

error handling, 320–321

InnoDB engine recommendations, 322

MyISAM engine recommendations, 321

adaptive hash indexes (InnoDB), 137–138

administrators, prerequisite knowledge for optimization, 2

ALTER TABLE statement (InnoDB), 289–290

ALTER TABLE, ORDER BY statement, column sort order, 148–149

ANALYZE TABLE com- mand, table statistics, 234

analyze() function, column selection results, 75–77

ANALYZER TABLE com- mand (optimizer), 96–97

Apache web servers, PHP tuning tips, 301–302

bottleneck elimination, 302

build suggestions, 302

HostNameLookups setting, 302–303

KeepAlive setting, 303

KeepAliveTimeout ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required