《1710.高性能MySQL（第3版）（影印版）》.pdf

高性能MySQL（第3版）（影印版） 猛点这里下载全部内容 目录： foreword preface 1.mysqlarchitectureandhistory mysqlslogicalarchitecture connectionmanagementandsecurity optimizationandexecution concurrencycontrol read/writelocks lockgranularity transactions isolationlevels deadlocks transactionlogging transactionsinmysql multiversionconcurrencycontrol mysqlsstorageengines theinnodbengine themylsamengine otherbuilt-inmysqlengines third-partystorageengines selectingtherightengine tableconversions amysqltimeline mysqlsdevelopmentmodel summary 2.benchmarkingmysql whybenchmark? benchmarkingstrategies whattomeasure benchmarkingtactics designingandplanningabenchmark howlongshouldthebenchmarklast? capturingsystemperformanceandstatus gettingaccurateresults runningthebenchmarkandanalyzingresults theimportanceofplotting benchmarkingtools full-stacktools single-componenttools benchmarkingexamples httpload mysqlbenchmarksuite sysbench dbt2tpc-conthedatabasetestsuite perconastpcc-mysqltool summary 3.profilingserverperformance introductiontoperformanceoptimization optimizationthroughprofiling interpretingtheprofile profilingyourapplication instrumentingphpapplications profilingmysqlqueries profilingaserversworkload profilingasinglequery usingtheprofileforoptimization diagnosingintermittentproblems single-queryversusserver-wideproblems capturingdiagnosticdata acasestudyindiagnostics otherprofilingtools usingtheuser_statisticstables usingstrace summary 4.optimizingschemaanddatatypes choosingoptimaldatatypes wholenumbers realnumbers stringtypes dateandtimetypes bit-packeddatatypes choosingidentifiers specialtypesofdata schemadesigngotchasinmysql normalizationanddenormalization prosandconsofanormalizedschema prosandconsofadenormalizedschema amixtureofnormalizedanddenormalized cacheandsummarytables materializedviews countertables speedingupaltertable modifyingonlythefrmfile buildingmylsamindexesquickly summary 5.indexingforhig