- 11
- 0
- 约1.09万字
- 约 12页
- 2015-10-20 发布于河南
- 举报
《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
您可能关注的文档
- 《09 Nanogranular Magnetic Core Inductors- Design》.pdf
- 《0942禚孝文:清华简《程寤》集释》.pdf
- 《099S101_GE10L01》.pptx
- 《09_RFID于制造、物流与零售业之应用》.ppt
- 《09年美的维修手册TM-S1-01A&Dsk2105》.pdf
- 《09版TS16949条文考试试题》.doc
- 《0_PVC_final_report》.pdf
- 《0料的PVC涂层织物下角料的再利用特性研究》.pdf
- 《1 TD-SCDMA技术基础》.pdf
- 《1- Testing Center_ Li Zhen-2016 Spring Plug Fest & Open Flow Certification Update》.pdf
- 小区绿化施工协议书.docx
- 墙面施工协议书.docx
- 1 古诗二首(课件)--2025-2026学年统编版语文二年级下册.pptx
- (2026春新版)部编版八年级道德与法治下册《3.1《公民基本权利》PPT课件.pptx
- (2026春新版)部编版八年级道德与法治下册《4.3《依法履行义务》PPT课件.pptx
- (2026春新版)部编版八年级道德与法治下册《6.2《按劳分配为主体、多种分配方式并存》PPT课件.pptx
- (2026春新版)部编版八年级道德与法治下册《6.1《公有制为主体、多种所有制经济共同发展》PPT课件.pptx
- 初三教学管理交流发言稿.docx
- 小学生课外阅读总结.docx
- 餐饮门店夜经济运营的社会责任报告(夜间贡献)撰写流程试题库及答案.doc
原创力文档

文档评论(0)