数据库优化经验谈肖鹏

《数据库优化经验谈肖鹏》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、හഝପս۸ᕪḵ᧨ᙆỨፓ୯•Օᕨ•ս۸௏᪠•ս۸ਫ᪢•௛ᕮՕᕨӻՈՕᕨ•ᙆỨ•ෛၵஙܗᎸݎӾஞහഝପದ๞ᕪቘ•10ଙහഝପ՗ӱᕪḵӫဳԭහഝପᶾऒጱṛݢአṛݢᶌ޾ຝ຅ս۸ොᶎ੒ԭय़ᥢཛྷᵞᗭᬩᖌᓕቘํӞਧጱஞ஑๐ۓᔄࣳၾ௳ᴚڜMCQKafkaᖨਂ੶MCRedis೮ԋਂؙMySQLRedisHBaseෛၵஙܗහഝପ༷ೡMySQL2k๐ۓ࢏300T4kጱਫጯՊNoSQL2k๐ۓ࢏70T1.6wጱਫӡՊս۸௏᪠ӱ۠᩽઀ݎۓ123456789ABҖܔ๢ݢඪඅᰁಭفԾڊྲຝ຅ս۸አս۸᫫կս۸ᔮᕹ᧣ෆᏝկս۸ӣ๵๠ᔰጱս۸ܻڞ•lessismore•Ke

2、epItSimpleandStupid(KISS)•Performanceisallaboutcodepathս۸ਫ᪢Ꮭկᓤߥଫ෸ᳵSSDVSHDDࢶᇆ๶ᛔᗑᕶհ໒ᕪḵ•෸ᳵ๢տ౮๜ᑖᕒܨ᭙•Ոێ౮๜ᬱṛԭ๐ۓ࢏౮๜•ړೆጱᥝ஠ӧ੝ٺս۸ਫ᪢ᔮᕹᓤIO᧣ଶᓒဩ•CFQ•DEADLIN•NOOPRAIDᒽኼ•writeback•writethrough•BBUhttp://m.osslab.com.tw/@api/deki/files/2318/=wb.gifᗑܜग़ᴚڜ•cpusoftirq•lspci-vvv•/proc/interrupts

3、•irqbalanceTIPS•swapness•XFSorEXT4•ulimit•NUMAս۸ਫ᪢᫫կᓤMYSQL•innodb_buffer_pool_size•innodb_log_file_size•innodb_flush_log_at_trx_commit•sync_binlog•query_cache•innodb_io_capacity•innodb_buffer_pool_instancesᇇ๜ᭌೠ•groupreplication•MRR•ICP•innodb_purge_threadsREDISBGSAVEఽݑ•ဌํ۸սጱ

4、ᚆ੶կ᫫ࣁێᚆ໐ٖᶋଉํᴴս۸ਫ᪢አᓤMCԏSLAB•memcache-itool.pyREDISԏKEYړຉ•Redis-rdb-Tools•Redis-sampler•Redis-auditMYSQLԏSLOWLOG•pt-query-digest•boxanemometer•allbecauseindex1.32svs0.03sMYSQLԏBATCHINSERT•500ӻinsertintotbvaluesҁ҂•10ӻinsertintotbvaluesҁ҂ҁ҂አړຉ•vc-MySQL-sniffer•vc-Redis-sniffer

5、•vc-pg-snifferwww.vividcortex.compt-query-digestս۸ਫ᪢ຝ຅ᓤᭌࣳRedismemcacheMySQLPikaMongoDBHBaseᦡᦇWEBMCQMCQMCQMCMCMCMyMyMyMySQLSQLSQLSQL๜ࣈ۸WEBWEBMCQMCMCQMCMyMySQLSQLړ੶MCMCMCMCMCMCMCMCҁL0҂ҁL0҂ҁL0҂ҁL0҂ҁL0҂ҁL0҂ҁL0҂ҁL0҂MCMCMCMCMCMCMCMCL1L1L1L1L1L1L1L1MCҁMaster҂MySQLೆړ•࣮ፗೆړአಁىᔮܗ෈•࿜ଘ

6、ೆړᦧᦞᦧᦞᦧᦞ•෸ᳵᖌଶ୭໩hashҁ҂Ծߝ᭦ᬋ•Top1isdon’tdo௛ᕮ“Whatgetsmeasuredgetsmanaged.”–PeterDruckerහഝḝۖૡཿ࠺ٌڥض஠Ԫٌ࢏ᕪḵ•casebycaseӧᥝᕪḵԆԎ•വၥᵱᥝԪਫ๶ᦤก•ࢩຎᄍᕩํ෸ײӧইഭᴻဩ•ӞེӞӻࢩᔰ᭿عଗಟຝ຅ս۸አս۸෸ᳵړ૲᫫կս۸ᔮᕹ᧣ෆᏝկս۸THANKYOU