MySQLºÞ²z¤§¹D¡G©Ê¯à½ÕÀu¡B°ª¥i¥Î»PºÊ±±¡]²Ä2ª©¡^ ( ²Åé ¦r) |
§@ªÌ¡G¶P¬K? | Ãþ§O¡G1. -> ¸ê®Æ®w -> MySQL |
ĶªÌ¡G |
¥Xª©ªÀ¡G¾÷±ñ¤u·~¥Xª©ªÀ | 3dWoo®Ñ¸¹¡G 45122 ¸ß°Ý®ÑÄy½Ð»¡¥X¦¹®Ñ¸¹¡I¡i¯Ê®Ñ¡j NT°â»ù¡G 395 ¤¸ |
¥Xª©¤é¡G9/1/2016 |
¶¼Æ¡G373 |
¥úºÐ¼Æ¡G0 |
|
¯¸ªø±ÀÂË¡G |
¦L¨ê¡G¶Â¥Õ¦L¨ê | »y¨t¡G ( ²Åé ª© ) |
|
¥[¤JÁʪ«¨® ¢x¥[¨ì§Úªº³Ì·R (½Ð¥ýµn¤J·|û) |
ISBN¡G9787111547792 |
§@ªÌ§Ç¡@|¡@ĶªÌ§Ç¡@|¡@«e¨¥¡@|¡@¤º®e²¤¶¡@|¡@¥Ø¿ý¡@|¡@§Ç |
(²Åé®Ñ¤W©Òz¤§¤U¸ü³sµ²¯Ó®É¶O¥\, ®¤¤£¾A¥Î¦b¥xÆW, YŪªÌ»Ýn½Ð¦Û¦æ¹Á¸Õ, ®¤¤£«OÃÒ) |
§@ªÌ§Ç¡G |
ĶªÌ§Ç¡G |
«e¨¥¡G |
¤º®e²¤¶¡G¥»®Ñº¥ý¤¶²Ð¤FMySQL5.7©MMariaDB10.1ª©¥»ªº·s¯S©Ê¡AµM¦Z¥Hºc«Ø°ª©Ê¯àMySQLªA°È¾¹¬°®Ö¤ß¡A±q¬G»Ù¶EÂ_»PÀu¤Æ¡B©Ê¯à½ÕÀu¡B³Æ¥÷»P«ì´_¡B°ª¥i¥Î¶°¸s¬[ºc·f«Ø»PºÞ²z¡BŪ¼g¤ÀÂ÷©M¤À¥¬¦¡DB¬[ºc·f«Ø»PºÞ²z¡B©Ê¯à©MªA°ÈºÊ±±µ¥¤è±¦h¨¤«×²`¤JÁ¿¸Ñ¤F¦p¦ó¥hºÞ²z»PºûÅ@MySQLªA°È¾¹¡C®Ñ¤¤¤º®e¥H¹ê¾Ô¬°¾É¦V¡A©Ò¦³¤º®e§¡¨Ó¦Û¤_µ§ªÌ¦h¦~¹ê½î¸gÅ窺Á`µ²©M·sª¾ÃѪº©Ý®i¡A¦P®É¤]°w¹ï¹Bºû¤Hû¡BDBAµ¥¬ÛÃö¤u§@ªÌ·|¹J¨ìªº¦³¥Nªí©ÊªººÃÃø°ÝÃDµ¹¥X¤F¹ê¥Îªº±¡´º¼ÒÀÀ¡A¦}µ¹¥X¤F¸Ñ¨M¤è®×¡C¤£½×§A¥Ø«e¦³¨S¦³¹J¨ì¹L¦¹Ãþ°ÝÃD¡A¬Û«H¹ï§A¥H¦Z³B²z¬ÛÃö°ÝÃD³£·|¦³©ÒÉų¡C¥»®Ñ¾A¦X©Ò¦³§Æ±æºc«Ø©MºÞ²z°ª©Ê¯à¡B°ª¥i¥Î©ÊªºMySQL¼Æ¾Ú®w¨t²Îªº¶}µoªÌ©MDBA¾\Ū¡C |
¥Ø¿ý¡G±ÀÂ˧ǡG¸ÅDªº²Ä2ª© «e¡@¨¥ ²Ä1³¹¡@MariaDB¬[ºc»P¾ú¥v 1 1.1¡@MariaDBªº¤¶²Ð 1 1.2¡@MariaDB©MMySQLªºÝ®e©Ê 2 1.3¡@MariaDB 10.0·s¼Wªº¥\¯à 3 1.3.1¡@§ó¦hªº¦sÀx¤ÞÀº 4 1.3.2¡@³t«×ªº´£¤É 5 1.3.3¡@ÂX®i©M·s¥\¯à 5 1.4¡@¦p¦ó±NMySQL¾E²¾¦ÜMariaDB 8 1.5¡@¨Ï¥Î¤G¶i¨î¥]¦w¸ËMariaDB 10.1¥ø·~ª© 10 1.6¡@Á`µ² 12 ²Ä2³¹¡@MySQL 5.7»PMariaDB 10.1ªº·s¯S©Ê 13 2.1¡@©Ê¯à´£¤É 14 2.2¡@¦w¥þ©Êªº´£¤É 15 2.2.1¡@Àq»{¶}±ÒSSL 15 2.2.2¡@¤£¦A©ú¤åÅã¥Ü¥Î¤á±K½X 20 2.2.3¡@sql_modeªº§ïÅÜ 20 2.3¡@InnoDB¦sÀx¤ÞÀºªº´£¤É 22 2.3.1¡@§ó§ï¯Á¤Þ¦W¦r®É¤£·|Âêªí 22 2.3.2¡@¦b½uDDLקïvarchar¦r¬qÄݩʮɤ£Âêªí 23 2.3.3¡@InnoDB/MyisAM¦sÀx¤ÞÀº¤ä«ù¤¤¤å¥þ¤å¯Á¤Þ 26 2.3.4¡@InnoDB Buffer Pool¹w¼ö§ï¶i 29 2.3.5¡@¦b½u½Õ¾ãinnodb_Buffer_Pool_Size¤£¥Î«±Òmysql¶iµ{ 31 2.3.6¡@¦^¦¬¡]¦¬ÁY¡^undo log¦^ºu¤é§Óª«²z¤å¥óªÅ¶¡ 32 2.3.7¡@InnoDB´£¨Ñ³q¥ÎªíªÅ¶¡ 33 2.3.8¡@³Ð«ØInnoDB¿W¥ßªíªÅ¶¡«ü©w¦s©ñ¸ô®| 34 2.3.9¡@¾E²¾³æ¿W¤@±iInnoDBªí¨ì»·µ{ªA°È¾¹ 35 2.3.10¡@קïInnoDB redo log¨Æ°È¤é§Ó¤å¥ó¤j¤p§ó¤H©Ê¤Æ 36 2.3.11¡@¦ºÂê¥i¥H¥´¦L¨ì¿ù»~¤é§Ó¨½ 37 2.3.12¡@¤ä«ùInnoDB¥uŪ¨Æ°È 37 2.3.13¡@¤ä«ùInnoDBªíªÅ¶¡¼Æ¾Ú¸H¤ù¾ã²z 38 2.4¡@JSON®æ¦¡ªº¤ä«ù 39 2.4.1¡@¤ä«ù¥ÎJSON®æ¦¡¦sÀx¼Æ¾Ú 39 2.4.2¡@°ÊºA¦C¤ä«ù¥ÎJSON®æ¦¡¦sÀx¼Æ¾Ú 41 2.5¡@¤ä«ùµêÀÀ¦C¡]¨ç¼Æ¯Á¤Þ¡^ 44 2.5.1¡@MySQL 5.7¤ä«ù¨ç¼Æ¯Á¤Þ 44 2.5.2¡@MariaDB 10.0/10.1¤ä«ù¨ç¼Æ¯Á¤Þ 45 2.6¡@¥\¯à´£¤É 46 2.6.1¡@¤ä«ù±þ¦ººCªºSQL»y¥y 46 2.6.2¡@¤ä«ù¤@±iªí¦³¦hÓINSERT/DELETE/UPDATEIJµo¾¹ 48 2.6.3¡@¤Þ¤J½uµ{¦À¡]Thread Pool¡^§Þ³N 49 2.6.4¡@´£¨Ñ¼fp¤é§Ó¥\¯à 52 2.6.5¡@¤ä«ùexplain update 53 2.6.6¡@¦bMySQL 5.7 ¤¤«öCtrl+C²Õ¦XÁ䤣·|°h¥X«È¤áºÝ 54 2.6.7¡@¥i±N¿ù»~¤é§Ó¥´¦L¨ì¨t²Î¤é§Ó¤å¥ó¤¤ 54 2.6.8¡@¤ä«ù³Ð«Ø¨¤¦â 55 2.6.9¡@¤ä«ùTokuDB¦sÀx¤ÞÀº 56 2.7¡@Àu¤Æ¾¹§ï¶i 59 2.7.1¡@°w¹ï¤l¬d¸ßselectªö¥Î¥b³s±µÀu¤Æ 59 2.7.2¡@Àu¤Æ¬£¥Í¤l¬d¸ß 62 2.7.3¡@Àu¤Æ±Æ§Çlimit 65 2.7.4¡@Àu¤ÆIN±ø¥óªí¹F¦¡ 66 2.7.5¡@Àu¤Æunion all 69 2.7.6¡@¤ä«ù¯Á¤Þ¤U±ÀÀu¤Æ 70 2.7.7¡@¤ä«ùMulti Range Read¯Á¤ÞÀu¤Æ 72 2.7.8¡@¤ä«ùBatched Key Access¡]BKA¡^¯Á¤ÞÀu¤Æ 75 2.7.9¡@¤ä«ùHash Join¯Á¤ÞÀu¤Æ 77 2.8¡@¥b¦P¨B´_¨î§ï¶i 78 2.8.1¡@¥b¦P¨B´_¨î²¤¶ 78 2.8.2¡@¥b¦P¨B´_¨îªº¦w¸Ë°t¸m 79 2.8.3¡@°Ñ¼Æ»¡©ú 79 2.8.4¡@¥\¯à´ú¸Õ 80 2.8.5¡@©Ê¯à´ú¸Õ 84 2.9¡@GTID´_¨î§ï¶i 87 2.9.1¡@GTID´_¨î·§z 87 2.9.2¡@¦bMySQL 5.6ªºGTID¼Ò¦¡¤U¦P¨B´_¨î³ø¿ù¤£¯à¸õ¹Lªº¸Ñ¨M¤èªk 90 2.9.3¡@MySQL 5.7¤¤GTID´_¨îªº§ï¶i 93 2.9.4¡@GTID´_¨îªº³´¨À 95 2.9.5¡@MariaDB 10.1¤¤GTID´_¨îªº§ï¶i 96 2.9.6¡@GTIDªº¨Ï¥Î¤è¦¡¤£¦P 97 2.10¡@MySQL 5.6/5.7±q®w±Y¼ì¦w¥þ«ì´_ 98 2.11¡@MariaDB 10.0/10.1±q®w±Y¼ì¦w¥þ«ì´_ 99 2.12¡@slave±q®w¦h½uµ{´_¨î 99 2.13¡@slave¤ä«ù¦h·½´_¨î 101 2.14¡@MySQL 5.7³]¸m¦P¨B´_¨î¹LÂo¤£¥Î«±ÒmysqlªA°È¶iµ{ 103 2.15¡@¤pµ² 104 ²Ä3³¹¡@¬G»Ù¶EÂ_ 105 3.1¡@¼vÅTMySQL©Ê¯àªº¦]¯À 105 3.2¡@¨t²Î©Ê¯àµû¦ô¼Ð·Ç 106 3.2.1¡@¼vÅTLinuxªA°È¾¹©Ê¯àªº¦]¯À 106 3.2.2¡@¨t²Î©Ê¯àµû¦ô«ü¼Ð 107 3.2.3¡@¶}·½ºÊ±±©Mµû¦ô¤u¨ã¤¶²Ð 109 3.3¡@¬G»Ù»P³B²z 112 3.3.1¡@³s±µ¼Æ¹L¦h¾ÉPµ{§Ç³s±µ³ø¿ùªºì¦] 112 3.3.2¡@°O¿ý¤l¬d¸ß¤Þ°_ªºÌX¾÷ 117 3.3.3¡@¶EÂ_¨Æ°È¶q¬ð°ªªºì¦] 120 3.3.4¡@ÂÔ·V³]¸mbinlog_format=MIXED 123 3.3.5¡@¥¼³]¸mswap¤À°Ï¾ÉP¤º¦s¯ÓºÉ¡A¥D¾÷¦º¾÷ 127 3.3.6¡@MySQL¬G»Ù¤Á´«¤§¨Æ¥ó½Õ«×¾¹ª`·N¨Æ¶µ 128 3.3.7¡@¤H¤u»~§R°£InnoDB ibdata¼Æ¾Ú¤å¥ó¡A¦p¦ó«ì´_ 130 3.3.8¡@update§Ñ¥[where±ø¥ó»~¾Þ§@«ì´_¡]¼ÒÀÀOracle°{¦^¥\¯à¡^ 132 3.3.9¡@delete§Ñ¥[where±ø¥ó»~¾Þ§@«ì´_¡]¼ÒÀÀOracle°{¦^¥\¯à¡^ 141 ²Ä4³¹¡@¦P¨B´_¨î³ø¿ù¬G»Ù³B²z 145 4.1¡@³Ì±`¨£ªº3ºØ¬G»Ù 145 4.1.1¡@¦bmaster¤W§R°£¤@±ø°O¿ý®É¥X²{ªº¬G»Ù 146 4.1.2¡@¥DÁä«´_ 147 4.1.3¡@¦bmaster¤W§ó·s¤@±ø°O¿ý¡A¦Óslave¤W«o§ä¤£¨ì 148 4.2¡@¯S®í±¡ªp¡Gslaveªº¤¤Ä~¤é§Órelay-log·lÃa 149 4.3¡@¤H¬°¥¢»~ 151 4.4¡@ÁקK¦bmaster¤W°õ¦æ¤j¨Æ°È 152 4.5¡@slave_exec_mode°Ñ¼Æ¥i¦Û°Ê³B²z¦P¨B´_¨î¿ù»~ 153 4.6¡@¦p¦óÅçÃÒ¥D±q¼Æ¾Ú¤@P 154 4.7¡@binlog_ignore_db¤Þ°_ªº¦P¨B´_¨î¬G»Ù 156 4.8¡@MySQL5.5.19/20¦P¨B¤@ÓBug 157 4.9¡@«ì´_slave±q¾÷¤Wªº¬Y´X±iªíªºÂ²n¤èªk 159 4.10¡@¦p¦ó¤zÐä¦a²M°£slave¦P¨B«H®§ 160 ²Ä5³¹¡@©Ê¯à½ÕÀu 162 5.1¡@ªí³]p 162 5.2¡@¦r¬qÃþ«¬ªº¿ï¨ú 166 5.2.1¡@¼ÆÈÃþ«¬ 167 5.2.2¡@¦r²ÅÃþ«¬ 172 5.2.3¡@®É¶¡Ãþ«¬ 174 5.2.4¡@¤p§Þ¥©¡G§Ö³tקïªíµ²ºc 181 5.2.5¡@pt-online-schema-change¦b½u§ó§ïªíµ²ºc 185 5.2.6¡@MySQL5.6¦b½uDDL§ó§ïªí´ú¸Õ 191 5.3¡@ªö¥Î¦X¾AªºÂê¾÷¨î 194 5.3.1¡@ªíÂꪺºt¥Ü 194 5.3.2¡@¦æÂꪺºt¥Ü 197 5.3.3¡@InnoDB¤ÞÀº»PMyISAM¤ÞÀºªº©Ê¯à¹ï¤ñ 199 5.4¡@¿ï¾Ü¦X¾Aªº¨Æ°È¹jÂ÷¯Å§O 201 5.4.1¡@¨Æ°Èªº·§©À 201 5.4.2¡@¨Æ°Èªº¹ê²{ 202 5.4.3¡@¨Æ°È¹jÂ÷¯Å§O¤¶²Ð 204 5.5¡@SQLÀu¤Æ»P¦X²z§Q¥Î¯Á¤Þ 210 5.5.1¡@¦p¦ó©w¦ì°õ¦æ«ÜºCªºSQL»y¥y 210 5.5.2¡@SQLÀu¤Æ®×¨Ò¤ÀªR 211 5.5.3¡@¦X²z¨Ï¥Î¯Á¤Þ 221 5.6¡@my.cnf°t¸m¤å¥ó½ÕÀu 231 5.6.1¡@per_thread_buffersÀu¤Æ 231 5.6.2¡@global_buffersÀu¤Æ 233 5.6.3¡@Query Cache¦b¤£¦PÀô¹Ò¤Uªº¨Ï¥Î 234 5.6.4¡@tuning-primer.sh©Ê¯à½Õ¸Õ¤u¨ãªº¨Ï¥Î 238 5.6.5¡@72 GB¤º¦sªºmy.cnf°t¸m¤å¥ó 241 5.6.6¡@ÂÔ·V¨Ï¥Î¤À°Ïªí¥\¯à 244 5.7¡@MySQL5.6¦P¨B´_¨î·s¯S©Ê¸Ô¸Ñ 246 ²Ä6³¹¡@³Æ¥÷»P«ì´_ 256 6.1¡@§N³Æ¥÷ 257 6.2¡@ÅÞ¿è³Æ¥÷ 257 6.2.1¡@mysqldump¼W¥[¤F¤@Ó«n°Ñ¼Æ 258 6.2.2¡@¨ú¥Nmysqldumpªº·s¤u¨ãmydumper 259 6.2.3¡@ÅÞ¿è³Æ¥÷¥þ¶q¡B¼W¶q³Æ¥÷¸}¥» 262 6.3¡@¼ö³Æ¥÷»P«ì´_ 263 ²Ä7³¹¡@°ª¥i¥ÎMHA¬[ºc¶°¸sºÞ²z 268 7.1¡@MHA¬[ºc²¤¶ 268 7.1.1¡@master¦Û°ÊºÊ±±©M¬G»ÙÂಾ 270 7.1.2¡@¤â¤u³B²zmaster¬G»ÙÂಾ 270 7.1.3¡@¦b½u¥·Æ¤Á´« 270 7.2¡@MHA°t¸m¦w¸Ë 270 7.3¡@MHA¬G»Ù¤Á´«ºt¥Ü 277 7.3.1¡@³õ´º¤@¡Gmaster¦Û°ÊºÊ±±©M¬G»ÙÂಾ 277 7.3.2¡@³õ´º¤G¡Gmaster¤â¤u¬G»ÙÂಾ 285 7.3.3¡@³õ´º¤T¡G¦b½u¥·Æ¤Á´« 285 7.4¡@MHA°ª¥i¥Î¬[ºcÁ`µ² 290 ²Ä8³¹¡@MySQL¬[ºcºt¶i¡G¡§¤@¥D¦h±q¡BŪ/¼g¤ÀÂ÷¡¨ 293 8.1¡@¹ê²{Ū/¼g¤ÀÂ÷ªº¨âºØ¤è¦¡ 293 8.2¡@¥D±q¦P¨B©µ¿ðªº§PÂ_¼Ð·Ç 297 8.3¡@HAProxy·Pª¾MySQL¥D±q¦P¨B©µ¿ð 300 8.4¡@Ū/¼g¤ÀÂ÷MariaDB MaxScale¬[ºc·f«Øºt¥Ü 307 8.4.1¡@°t¸mÀô¹Ò¤Î¦w¸Ë¤¶²Ð 307 8.4.2¡@°ò¤_connect¤è¦¡ªº´ú¸Õ 311 8.4.3¡@°ò¤_statement¤è¦¡¡]SQL¸ÑªR¡^ªº´ú¸Õ 312 8.4.4¡@MaxScale©µ¿ðÀË´ú 313 8.5¡@Ū/¼g¤ÀÂ÷OneProxy¤¶²Ð¤Î¬[ºc·f«Øºt¥Ü 315 8.5.1¡@OneProxy²¤¶ 316 8.5.2¡@OneProxyªº¥\¯à¤Î¦w¸Ë¤¶²Ð 316 8.5.3¡@OneProxyŪ/¼g¤ÀÂ÷±µ¤J¨î 320 ²Ä9³¹¡@Codership Galera Cluster ¶°¸s¬[ºc·f«Ø»PºÞ²z 322 9.1¡@Codership Galera Clusterªº¯S©Ê©MÀu¯ÊÂI 323 9.2¡@Codership Galera Clusterªº§½©Ê 323 9.3¡@Codership Galera Clusterªº¤u§@ì²z 324 9.4¡@Codership Galera Clusterªº°t¸m 328 9.4.1¡@Codership Galera Clusterªº°t¸mÀô¹Ò¤Î¦w¸Ë 328 9.4.2¡@¥\¯à´ú¸Õ 332 9.5¡@HAProxyµ²¦XGalera Cluster¹ê²{µL³æÂI¬í¯Å¬G»Ù¤Á´« 337 ²Ä10³¹¡@OneProxy¤À®w¤Àªíªº·f«Ø»PºÞ²z 345 10.1¡@OneProxy ¤À®w¤Àªíªº·f«Ø 346 10.1.1¡@°t¸m»P¦w¸Ë 346 10.1.2¡@«eºÝPHP/Javaµ{§Ç±µ¤J¨Æ¶µ 349 10.2¡@OneProxy¤À®w¤Àªí±µ¤J¨î 349 10.3¡@OneProxy¤À®w¤Àªí°ò¥»´ú¸Õ 351 10.3.1¡@¤À®w¤Àªíªº¥\¯à´ú¸Õ 351 10.3.2¡@¤À®w¤Àªíªº¤G¯Å¤À°Ï´ú¸Õ 354 10.3.3¡@¤À®w¤Àªíªº»E¦X´ú¸Õ 358 10.3.4¡@¤À®w¤Àªíªº´¡¤J´ú¸Õ 359 10.3.5¡@¤À®w¤Àªí¤£¤ä«ù¸ó®wjoinªº´ú¸Õ 360 10.3.6¡@¤À®w¤Àªí¤£¤ä«ù¤À¥¬¦¡¨Æ°Èªº´ú¸Õ 361 10.3.7¡@¤À®w¤Àªí¤£¤ä«ù¦sÀx¹Lµ{ªº´ú¸Õ 361 10.4¡@·f«ØOneProxy°ª¥i¥Î¬G»Ù¤Á´«HA 362 10.5¡@OneProxy ¶Â¦W³æSQL¨¾¤õùÙ·f«Ø´ú¸Õ 363 ²Ä11³¹¡@LepusºC¤é§Ó¤ÀªR¥»O·f«Ø»PºûÅ@ 367 11.1¡@Lepus°ò¦²Õ¥óªº¦w¸Ë 367 11.2¡@¦w¸Ëpercona-toolkit¤u¨ã 370
|
§Ç¡G |