-- ·|­û / µù¥U -- ¡@
¡@±b¸¹¡G
¡@±K½X¡G
¡@ | µù¥U | §Ñ°O±K½X
3/26 ·s®Ñ¨ì¡I 3/19 ·s®Ñ¨ì¡I 3/14 ·s®Ñ¨ì¡I 12/12 ·s®Ñ¨ì¡I
ÁʮѬyµ{¡EQ & A¡E¯¸°È¯d¨¥ª©¡E«ÈªA«H½c
¢x 3ds Max¢x Maya¢x Rhino¢x After Effects¢x SketchUp¢x ZBrush¢x Painter¢x Unity¢x
¢x PhotoShop¢x AutoCad¢x MasterCam¢x SolidWorks¢x Creo¢x UG¢x Revit¢x Nuke¢x
¢x C#¢x C¢x C++¢x Java¢x ¹CÀ¸µ{¦¡¢x Linux¢x ´O¤J¦¡¢x PLC¢x FPGA¢x Matlab¢x
¢x Àb«È¢x ¸ê®Æ®w¢x ·j¯Á¤ÞÀº¢x ¼v¹³³B²z¢x Fluent¢x VR+AR¢x ANSYS¢x ²`«×¾Ç²ß¢x
¢x ³æ´¹¤ù¢x AVR¢x OpenGL¢x Arduino¢x Raspberry Pi¢x ¹q¸ô³]­p¢x Cadence¢x Protel¢x
¢x Hadoop¢x Python¢x Stm32¢x Cortex¢x Labview¢x ¤â¾÷µ{¦¡¢x Android¢x iPhone¢x
¥i¬d®Ñ¦W,§@ªÌ,ISBN,3dwoo®Ñ¸¹
¸Ô²Ó®ÑÄy¤ÀÃþ

MySQLºÞ²z¤§¹D¡G©Ê¯à½ÕÀu¡B°ª¥i¥Î»PºÊ±±¡]²Ä2ª©¡^

( ²Åé ¦r)
§@ªÌ¡G¶P¬K?Ãþ§O¡G1. -> ¸ê®Æ®w -> MySQL
ĶªÌ¡G
¥Xª©ªÀ¡G¾÷±ñ¤u·~¥Xª©ªÀMySQLºÞ²z¤§¹D¡G©Ê¯à½ÕÀu¡B°ª¥i¥Î»PºÊ±±¡]²Ä2ª©¡^ 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¡@´£¨Ñ¼f­p¤é§Ó¥\¯à 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