-- ·|­û / µù¥U -- ¡@
¡@±b¸¹¡G
¡@±K½X¡G
¡@ | µù¥U | §Ñ°O±K½X
10/8 ·s®Ñ¨ì¡I 10/1 ·s®Ñ¨ì¡I 9/24 ·s®Ñ¨ì¡I 9/18 ·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¤ÀÃþ

²`¤J²L¥XMySQL ¼Æ¾Ú®w¶}µo Àu¤Æ»PºÞ²zºûÅ@ ²Ä3ª©

( ²Åé ¦r)
§@ªÌ¡G»C®¶¿³¡B±iùÚÅÉ¡B±Z¬KµØ¡B¶Àºa¡B¸³ñ¯»ÊÃþ§O¡G1. -> ¸ê®Æ®w -> MySQL
ĶªÌ¡G
¥Xª©ªÀ¡G¤H¥Á¶l¹q¥Xª©ªÀ²`¤J²L¥XMySQL ¼Æ¾Ú®w¶}µo Àu¤Æ»PºÞ²zºûÅ@ ²Ä3ª© 3dWoo®Ñ¸¹¡G 51717
¸ß°Ý®ÑÄy½Ð»¡¥X¦¹®Ñ¸¹¡I

¡i¯Ê®Ñ¡j
NT°â»ù¡G 690 ¤¸

¥Xª©¤é¡G9/1/2019
­¶¼Æ¡G682
¥úºÐ¼Æ¡G0
¯¸ªø±ÀÂË¡G
¦L¨ê¡G¶Â¥Õ¦L¨ê»y¨t¡G ( ²Åé ª© )
¥[¤JÁʪ«¨® ¢x¥[¨ì§Úªº³Ì·R
(½Ð¥ýµn¤J·|­û)
ISBN¡G9787115515391
§@ªÌ§Ç¡@|¡@ĶªÌ§Ç¡@|¡@«e¨¥¡@|¡@¤º®e²¤¶¡@|¡@¥Ø¿ý¡@|¡@§Ç
(²Åé®Ñ¤W©Ò­z¤§¤U¸ü³sµ²¯Ó®É¶O¥\, ®¤¤£¾A¥Î¦b¥xÆW, ­YŪªÌ»Ý­n½Ð¦Û¦æ¹Á¸Õ, ®¤¤£«OÃÒ)
§@ªÌ§Ç¡G

ĶªÌ§Ç¡G

«e¨¥¡G

¤º®e²¤¶¡G

¡m²`¤J²L¥XMySQL¡G¼Æ¾Ú®w¶}µo¡BÀu¤Æ»PºÞ²zºûÅ@¡]²Ä3ª©¡^¡n·½¦Ûºô©ö¤½¥q¦h¦ì¸ê²`¼Æ¾Ú®w±M®a¼Æ¦~ªº¸gÅçÁ`µ²©MMySQL¼Æ¾Ú®wªº¨Ï¥Î¤ß±o¡A¦b¤§«eª©¥»ªº°ò¦¤§¤W¡A°ò¤_MySQL 5.7ª©¥»¶i¦æ¤F¤º®e¤É¯Å¡A¦P®É¤]¹ïMySQL 8.0ªº­«­n¥\¯à¶i¦æ¤F¤¶²Ð¡C°£¤F¹ï­ì¦³¤º®eªº§ó·s¤§¥~¡A¥»®ÑÁÙ·s¼W¤F§@ªÌ¦b°ª¥i¥Î¬[ºc¡B¼Æ¾Ú®w¦Û°Ê¤Æ¹Bºû¡A¥H¤Î¼Æ¾Ú®w¤¤¶¡¥ó¤è­±ªº¹ê½î©M¿n²Ö¡C
¡m²`¤J²L¥XMySQL¡G¼Æ¾Ú®w¶}µo¡BÀu¤Æ»PºÞ²zºûÅ@¡]²Ä3ª©¡^¡n¤À¬°¡§°ò¦½g¡¨¡§¶}µo½g¡¨¡§Àu¤Æ½g¡¨¡§ºÞ²zºûÅ@½g¡¨©M¡§¬[ºc½g¡¨5­Ó³¡¤À¡A¦@32³¹¡C°ò¦½g­±¦VMySQLªºªì¾ÇªÌ¡A¤¶²Ð¤FMySQLªº¦w¸Ë»P°t¸m¡BSQL°ò¦¡BMySQL¤ä«ùªº¼Æ¾ÚÃþ«¬¡BMySQL¤¤ªº¹Bºâ²Å¡B±`¥Î¨ç¼Æµ¥¤º®e¡C¶}µo½g­±¦Vªº¬OMySQL³]­p©M¶}µo¤H­û¡A¤º®e²[»\¤FªíÃþ«¬¡]¦sÀx¤ÞÀº¡^ªº¿ï¾Ü¡B¿ï¾Ü¦X¾Aªº¼Æ¾ÚÃþ«¬¡B¦r²Å¶°¡B¯Á¤Þªº³]­p©M¨Ï¥Î¡B¶}µo±`¥Î¼Æ¾Ú®w¹ï¶H¡B¨Æ°È±±¨î©MÂê©w»y¥y¡BSQL¤¤ªº¦w¥þ°ÝÃD¡BSQL Mode¤Î¬ÛÃö°ÝÃD¡BMySQL¤À°Ïµ¥¡CÀu¤Æ½g°w¹ïªº¬O¶}µo¤H­û©M¼Æ¾Ú®wºÞ²z¤H­û¡A¤º®e¥]¬ASQLÀu¤Æ¡BÂê°ÝÃD¡BÀu¤ÆMySQL Server¡BºÏ½LI/O°ÝÃD¡BÀ³¥ÎÀu¤Æ¡BPS/SYS¼Æ¾Ú®w¡B¬G»Ù¶EÂ_µ¥¤º®e¡CºÞ²zºûÅ@½g¾A¦X¼Æ¾Ú®wºÞ²z­û¾\Ū¡A¤¶²Ð¤FMySQL°ª¯Å¦w¸Ë©M¤É¯Å¡BMySQL¤¤ªº±`¥Î¤u¨ã¡BMySQL¤é§Ó¡B³Æ¥÷»P«ì´_¡BMySQLÅv­­»P¦w¥þ¡BMySQLºÊ±±¡BMySQL±`¨£°ÝÃD©MÀ³¥Î§Þ¥©¡B¦Û°Ê¤Æ¹Bºû¨t²Îªº¶}µoµ¥¤º®e¡C¬[ºc½g¥D­n­±¦V°ª¯Å¼Æ¾Ú®wºÞ²z¤H­û©M¼Æ¾Ú®w¬[ºc³]­p®v¡A¤º®e¥]¬AMySQL´_¨î¡B°ª¥i¥Î¬[ºc¡BMySQL¤¤¶¡¥óµ¥¤º®e¡C
¡m²`¤J²L¥XMySQL¡G¼Æ¾Ú®w¶}µo¡BÀu¤Æ»PºÞ²zºûÅ@¡]²Ä3ª©¡^¡n¤º®e¹ê¥Î¡AÂл\¼sªx¡AÁ¿¸Ñ¥Ñ²L¤J²`¡AÁÙ´£¨Ñ¤F¤j¶q¨Ó¦Û¤@½uªº¤u§@¹ê¨Ò¡A¶i¤@¨B´£¤É¤F¥»®Ñªº¹ê¾Ô©Ê©M¥i¾Þ§@©Ê¡C¥»®Ñ¾A¦X¼Æ¾Ú®wºÞ²z¤H­û¡B¼Æ¾Ú®w¶}µo¤H­û¡B¨t²ÎºûÅ@¤H­û¡B¼Æ¾Ú®wªì¾ÇªÌ¤Î¨ä¥L¼Æ¾Ú®w±q·~¤H­û¾\Ū¡A¤]¾A¦X¥Î§@¤j¤¤±M°|®Õ¬ÛÃö±M·~®v¥Íªº°Ñ¦Ò¥Î®Ñ©M¬ÛÃö°ö°V¾÷ºcªº°ö°V±Ð§÷¡C
¥Ø¿ý¡G

²Ä ¤@³¡¤À °ò¦½g
²Ä¡@1³¹ MySQLªº¦w¸Ë»P°t¸m¡@2
1.1¡@MySQLªº¤U¸ü¡@2
1.1.1¡@¦bWindows¥­»O¤U¤U¸üMySQL¡@3
1.1.2¡@¦bLinux¥­»O¤U¤U¸üMySQL¡@3
1.2¡@MySQLªº¦w¸Ë¡@5
1.2.1¡@¦bWindows¥­»O¤U¦w¸ËMySQL¡@5
1.2.2¡@¦bLinux¥­»O¤U¦w¸ËMySQL¡@8
1.3¡@MySQLªº°t¸m¡@12
1.3.1¡@Windows¥­»O¤U°t¸mMySQL¡@12
1.3.2¡@Linux¥­»O¤U°t¸mMySQL¡@13
1.4¡@±Ò°Ê©MÃö³¬MySQLªA°È¡@13
1.4.1¡@¦bWindows¥­»O¤U±Ò°Ê©MÃö³¬MySQLªA°È¡@13
1.4.2¡@¦bLinux¥­»O¤U±Ò°Ê©MÃö³¬MySQLªA°È¡@13
1.5¡@¤pµ²¡@14
²Ä¡@2³¹ SQL°ò¦¡@15
2.1¡@SQL²¤¶¡@15
2.2¡@¡]My¡^SQL¨Ï¥Î¤Jªù¡@15
2.2.1¡@SQL¤ÀÃþ¡@15
2.2.2¡@DDL»y¥y¡@16
2.2.3¡@DML»y¥y¡@23
2.2.4¡@DCL»y¥y¡@33
2.3¡@À°§Uªº¨Ï¥Î¡@34
2.3.1¡@«ö·Ó¼h¦¸¬ÝÀ°§U¡@34
2.3.2¡@§Ö³t¬d¾\À°§U¡@35
2.4¡@¬d¸ß¤¸¼Æ¾Ú«H®§¡@36
2.5¡@¤pµ²¡@37
²Ä3³¹¡@MySQL¤ä«ùªº¼Æ¾ÚÃþ«¬¡@38
3.1¡@¼Æ­ÈÃþ«¬¡@38
3.2¡@¤é´Á®É¶¡Ãþ«¬¡@43
3.3¡@¦r²Å¦êÃþ«¬¡@49
3.3.1¡@CHAR©MVARCHARÃþ«¬¡@50
3.3.2¡@BINARY©MVARBINARYÃþ«¬¡@51
3.3.3¡@ENUMÃþ«¬¡@51
3.3.4¡@SETÃþ«¬¡@52
3.4¡@JSONÃþ«¬¡@52
3.5¡@¤pµ²¡@54
²Ä4³¹¡@MySQL¤¤ªº¹Bºâ²Å¡@55
4.1¡@ºâ³N¹Bºâ²Å¡@55
4.2¡@¤ñ¸û¹Bºâ²Å¡@56
4.3¡@ÅÞ¿è¹Bºâ²Å¡@59
4.4¡@¦ì¹Bºâ²Å¡@60
4.5¡@¹Bºâ²ÅªºÀu¥ý¯Å¡@61
4.6¡@¤pµ²¡@62
²Ä5³¹¡@±`¥Î¨ç¼Æ¡@63
5.1¡@¦r²Å¦ê¨ç¼Æ¡@63
5.2¡@¼Æ­È¨ç¼Æ¡@66
5.3¡@¤é´Á©M®É¶¡¨ç¼Æ¡@68
5.4¡@¬yµ{¨ç¼Æ¡@71
5.5¡@JSON¨ç¼Æ¡@73
5.5.1¡@³Ð«ØJSON¨ç¼Æ¡@74
5.5.2¡@¬d¸ßJSON¨ç¼Æ¡@75
5.5.3¡@­×§ïJSONªº¨ç¼Æ¡@79
5.5.4¡@¬d¸ßJSON¤¸¼Æ¾Ú¨ç¼Æ¡@81
5.5.5¡@JSON¤u¨ã¨ç¼Æ¡@83
5.6¡@µ¡¤f¨ç¼Æ¡@86
5.6.1¡@ROW_NUMBER()¡@87
5.6.2¡@RANK()/DENSE_RANK()¡@89
5.6.3¡@PERCENT_RANK()/CUME_DIST()¡@89
5.6.4¡@NFILE(N)¡@90
5.6.5¡@NTH_VALUE(expr,N)¡@91
5.6.6¡@LAG(expr,N)/LEAD(expr,N)¡@91
5.6.7¡@FIRST_VALUE¡]expr¡^/LAST_VALUE¡]expr¡^¡@92
5.6.8¡@»E¦X¨ç¼Æ§@¬°µ¡¤f¨ç¼Æ¡@93
5.7¡@¨ä¥L±`¥Î¨ç¼Æ¡@93
5.8¡@¤pµ²¡@95
²Ä¤G³¡¤À¡@¶}µo½g
²Ä6³¹¡@ªíÃþ«¬¡]¦sÀx¤ÞÀº¡^ªº¿ï¾Ü¡@98
6.1¡@MySQL¦sÀx¤ÞÀº·§­z¡@98
6.2¡@¦UºØ¦sÀx¤ÞÀºªº¯S©Ê¡@100
6.2.1¡@MyISAM¡@101
6.2.2¡@InnoDB¡@102
6.2.3¡@MEMORY¡@108
6.2.4¡@MERGE¡@109
6.2.5¡@TokuDB¡@111
6.3¡@¦p¦ó¿ï¾Ü¦X¾Aªº¦sÀx¤ÞÀº¡@112
6.4¡@¤pµ²¡@113
²Ä7³¹¡@¿ï¾Ü¦X¾Aªº¼Æ¾ÚÃþ«¬¡@114
7.1¡@CHAR»PVARCHAR¡@114
7.2¡@TEXT»PBLOB¡@115
7.3¡@¯BÂI¼Æ»P©wÂI¼Æ¡@118
7.4¡@¤é´ÁÃþ«¬¿ï¾Ü¡@120
7.5¡@¤pµ²¡@120
²Ä8³¹¡@¦r²Å¶°¡@121
8.1¡@¦r²Å¶°·§­z¡@121
8.2¡@Unicode²­z¡@121
8.3¡@º~¦r¤Î¤@¨Ç±`¨£¦r²Å¶°¡@123
8.4¡@«ç¼Ë¿ï¾Ü¦X¾Aªº¦r²Å¶°¡@124
8.5¡@MySQL¤ä«ùªº¦r²Å¶°Â²¤¶¡@125
8.6¡@MySQL¦r²Å¶°ªº³]¸m¡@126
8.6.1¡@ªA°È¾¹¦r²Å¶°©M±Æ§Ç³W«h¡@126
8.6.2¡@¼Æ¾Ú®w¦r²Å¶°©M±Æ§Ç³W«h¡@127
8.6.3¡@ªí¦r²Å¶°©M±Æ§Ç³W«h¡@127
8.6.4¡@¦C¦r²Å¶°©M±Æ§Ç³W«h¡@128
8.6.5¡@³s±µ¦r²Å¶°©M±Æ§Ç³W«h¡@128
8.7¡@¦r²Å¶°ªº­×§ï¨BÆJ¡@129
8.8¡@¤pµ²¡@129
²Ä9³¹¡@¯Á¤Þªº³]­p©M¨Ï¥Î¡@130
9.1¡@¯Á¤Þ·§­z¡@130
9.2¡@³]­p¯Á¤Þªº­ì«h¡@131
9.3¡@¯Á¤Þ³]­pªº»~°Ï¡@132
9.4¡@¯Á¤Þ³]­pªº¤@¯ë¨BÆJ¡@132
9.5¡@BTREE¯Á¤Þ»PHASH¯Á¤Þ¡@133
9.6¡@¯Á¤Þ¦bMySQL 8.0¤¤ªº§ï¶i¡@134
9.6.1¡@¤£¥i¨£¯Á¤Þ¡@134
9.6.2¡@­Ë§Ç¯Á¤Þ¡@135
9.7¡@¤pµ²¡@136
²Ä¡@10³¹ ¶}µo±`¥Î¼Æ¾Ú®w¹ï¶H¡@137
10.1¡@µø¹Ï¡@137
10.1.1¡@¤°¤\¬Oµø¹Ï¡@137
10.1.2¡@µø¹Ï¾Þ§@¡@137
10.1.3¡@³Ð«Ø©ÎªÌ­×§ïµø¹Ï¡@137
10.1.4¡@§R°£µø¹Ï¡@139
10.1.5¡@¬d¬Ýµø¹Ï¡@139
10.2¡@¦sÀx¹Lµ{©M¨ç¼Æ¡@140
10.2.1¡@¤°¤\¬O¦sÀx¹Lµ{©M¨ç¼Æ¡@141
10.2.2¡@¦sÀx¹Lµ{©M¨ç¼Æªº¬ÛÃö¾Þ§@¡@141
10.2.3¡@³Ð«Ø¡B­×§ï¦sÀx¹Lµ{©ÎªÌ¨ç¼Æ¡@141
10.2.4¡@§R°£¦sÀx¹Lµ{©ÎªÌ¨ç¼Æ¡@144
10.2.5¡@¬d¬Ý¦sÀx¹Lµ{©ÎªÌ¨ç¼Æ¡@144
10.2.6¡@Åܶqªº¨Ï¥Î¡@146
10.2.7¡@©w¸q±ø¥ó©M³B²z¡@146
10.2.8¡@¥ú¼Ðªº¨Ï¥Î¡@148
10.2.9¡@¬yµ{±±¨î¡@149
10.2.10¡@¨Æ¥ó½Õ«×¾¹¡@152
10.3¡@IJµo¾¹¡@155
10.3.1¡@³Ð«ØIJµo¾¹¡@155
10.3.2¡@§R°£Ä²µo¾¹¡@157
10.3.3¡@¬d¬ÝIJµo¾¹¡@157
10.3.4¡@IJµo¾¹ªº¨Ï¥Î¡@158
10.4¡@¤pµ²¡@159
²Ä¡@11³¹ ¨Æ°È±±¨î©MÂê©w»y¥y¡@160
11.1¡@LOCK TABLES©MUNLOCK TABLES¡@160
11.2¡@¨Æ°È±±¨î¡@161
11.3¡@¤À¥¬¦¡¨Æ°Èªº¨Ï¥Î¡@166
11.3.1¡@¤À¥¬¦¡¨Æ°Èªº­ì²z¡@166
11.3.2¡@¤À¥¬¦¡¨Æ°Èªº»yªk¡@166
11.3.3¡@¦s¦bªº°ÝÃD¡@168
11.4¡@¤pµ²¡@171
²Ä¡@12³¹ SQL¤¤ªº¦w¥þ°ÝÃD¡@172
12.1¡@SQLª`¤J²¤¶¡@172
12.2¡@À³¥Î¶}µo¤¤¥i¥Hªö¨úªºÀ³¹ï±¹¬I¡@173
12.2.1¡@PrepareStatement+Bind-Variable¡@173
12.2.2¡@¨Ï¥ÎÀ³¥Îµ{§Ç´£¨ÑªºÂà´«¨ç¼Æ¡@174
12.2.3¡@¦Û¤v©w¸q¨ç¼Æ¶i¦æ®ÕÅç¡@174
12.3¡@¤pµ²¡@175
²Ä¡@13³¹ SQL Mode¤Î¬ÛÃö°ÝÃD¡@176
13.1¡@MySQL SQL Mode²¤¶¡@176
13.2¡@SQL Modeªº±`¨£¥\¯à¡@178
13.3¡@±`¥ÎªºSQL Mode¡@180
13.4¡@SQL Mode¦b¾E²¾¤¤¦p¦ó¨Ï¥Î¡@182
13.5¡@¤pµ²¡@183
²Ä¡@14³¹ MySQL¤À°Ï¡@184
14.1¡@¤À°Ï·§­z¡@184
14.2¡@¤À°ÏÃþ«¬¡@185
14.2.1¡@RANGE¤À°Ï¡@187
14.2.2¡@LIST ¤À°Ï¡@188
14.2.3¡@COLUMNS ¤À°Ï¡@189
14.2.4¡@HASH¤À°Ï¡@192
14.2.5¡@KEY¤À°Ï¡@195
14.2.6¡@¤l¤À°Ï¡@196
14.2.7¡@MySQL¤À°Ï³B²zNULL­Èªº¤è¦¡¡@197
14.3¡@¤À°ÏºÞ²z¡@199
14.3.1¡@RANGE»PLIST¤À°ÏºÞ²z¡@199
14.3.2¡@HASH»PKEY¤À°ÏºÞ²z¡@205
14.3.3¡@¥æ´«¤À°Ï¡@206
14.4¡@¤pµ²¡@208
²Ä¤T³¡¤À¡@Àu¤Æ½g
²Ä¡@15³¹ SQLÀu¤Æ¡@210
15.1¡@Àu¤ÆSQL»y¥yªº¤@¯ë¨BÆJ¡@210
15.1.1¡@³q¹Lshow status©R¥O¤F¸Ñ¦UºØSQLªº°õ¦æÀW²v¡@210
15.1.2¡@©w¦ì°õ¦æ®Ä²v¸û§CªºSQL»y¥y¡@211
15.1.3¡@³q¹LEXPLAIN¤ÀªR§C®ÄSQLªº°õ¦æ­p¹º¡@211
15.1.4¡@³q¹Lshow profile¤ÀªRSQL¡@216
15.1.5¡@³q¹Ltrace¤ÀªRÀu¤Æ¾¹¦p¦ó¿ï¾Ü°õ¦æ­p¹º¡@219
15.1.6¡@½T©w°ÝÃD¦}ªö¨ú¬ÛÀ³ªºÀu¤Æ±¹¬I¡@220
15.2¡@¯Á¤Þ°ÝÃD¡@220
15.2.1¡@¯Á¤Þªº¦sÀx¤ÀÃþ¡@220
15.2.2¡@MySQL¦p¦ó¨Ï¥Î¯Á¤Þ¡@222
15.2.3¡@¬d¬Ý¯Á¤Þ¨Ï¥Î±¡ªp¡@231
15.3¡@¨â­Ó²³æ¹ê¥ÎªºÀu¤Æ¤èªk¡@231
15.3.1¡@©w´Á¤ÀªRªí©MÀˬdªí¡@232
15.3.2¡@©w´ÁÀu¤Æªí¡@233
15.4¡@±`¥ÎSQLªºÀu¤Æ¡@233
15.4.1¡@¤j§å¶q´¡¤J¼Æ¾Ú¡@234
15.4.2¡@Àu¤ÆINSERT»y¥y¡@235
15.4.3¡@Àu¤ÆORDER BY»y¥y¡@235
15.4.4¡@Àu¤ÆGROUP BY»y¥y¡@239
15.4.5¡@Àu¤ÆJOIN¾Þ§@¡@239
15.4.6¡@Àu¤Æ´O®M¬d¸ß¡@243
15.4.7¡@MySQL¦p¦óÀu¤ÆOR±ø¥ó¡@245
15.4.8¡@Àu¤Æ¤À­¶¬d¸ß¡@246
15.4.9¡@¨Ï¥ÎSQL´£¥Ü¡@248
15.5¡@ª½¤è¹Ï¡@250
15.5.1¡@¤°¤\¬Oª½¤è¹Ï¡@250
15.5.2¡@ª½¤è¹Ïªº¤ÀÃþ¡@251
15.5.3¡@ª½¤è¹Ï¹ê¨ÒÀ³¥Î¡@252
15.5.4¡@ª½¤è¹Ï¤pµ²¡@256
15.6¡@¨Ï¥Î¬d¸ß­«¼g¡@256
15.7¡@±`¥ÎSQL§Þ¥©¡@259
15.7.1¡@¥¿«hªí¹F¦¡ªº¨Ï¥Î¡@259
15.7.2¡@¥©¥ÎRAND()´£¨úÀH¾÷¦æ¡@261
15.7.3¡@§Q¥ÎGROUP BYªºWITH ROLLUP¤l¥y¡@262
15.7.4¡@¥ÎBIT GROUP FUNCTIONS°µ²Î­p¡@263
15.7.5¡@¼Æ¾Ú®w¦W¡Bªí¦W¤j¤p¼g°ÝÃD¡@265
15.7.6¡@¨Ï¥Î¥~Áä»Ý­nª`·Nªº°ÝÃD¡@265
15.8¡@¤pµ²¡@266
²Ä¡@16³¹ Âê°ÝÃD¡@267
16.1¡@MySQLÂê·§­z¡@267
16.2¡@MyISAMªíÂê¡@268
16.2.1¡@¬d¸ßªí¯ÅÂꪧ¥Î±¡ªp¡@268
16.2.2¡@MySQLªí¯ÅÂꪺÂê¼Ò¦¡¡@268
16.2.3¡@¦p¦ó¥[ªíÂê¡@269
16.2.4¡@¦}µo´¡¤J¡]Concurrent Inserts¡^¡@271
16.2.5¡@MyISAMªºÂê½Õ«×¡@272
16.3¡@InnoDBÂê°ÝÃD¡@273
16.3.1¡@­I´ºª¾ÃÑ¡@273
16.3.2¡@Àò¨úInnoDB¦æÂꪧ¥Î±¡ªp¡@275
16.3.3¡@InnoDBªº¦æÂê¼Ò¦¡¤Î¥[Âê¤èªk¡@276
16.3.4¡@InnoDB¦æÂê¹ê²{¤è¦¡¡@279
16.3.5¡@Next-KeyÂê¡@283
16.3.6¡@«ì´_©M´_¨îªº»Ý­n¡A¹ïInnoDBÂê¾÷¨îªº¼vÅT¡@284
16.3.7¡@InnoDB¦b¤£¦P¹jÂ÷¯Å§O¤Uªº¤@­P©ÊŪ¤ÎÂꪺ®t²§¡@287
16.3.8¡@¤°¤\®É­Ô¨Ï¥ÎªíÂê¡@288
16.3.9¡@Ãö¤_¦ºÂê¡@289
16.4¡@¤pµ²¡@294
²Ä¡@17³¹ Àu¤ÆMySQL Server¡@296
17.1¡@MySQLÅé¨tµ²ºc·§Äý¡@296
17.2¡@MySQL¤º¦sºÞ²z¤ÎÀu¤Æ¡@298
17.2.1¡@¤º¦sÀu¤Æ­ì«h¡@298
17.2.2¡@MyISAM¤º¦sÀu¤Æ¡@298
17.2.3¡@InnoDB¤º¦sÀu¤Æ¡@301
17.2.4¡@½Õ¾ã¥Î¤áªA°È½uµ{±Æ§Ç½w¦s°Ï¡@305
17.3¡@InnoDB log¾÷¨î¤ÎÀu¤Æ¡@305
17.3.1¡@InnoDB­«°µ¤é§Ó¡@305
17.3.2¡@innodb_flush_log_at_trx_commitªº³]¸m¡@306
17.3.3¡@³]¸mlog file size¡A±±¨îÀˬdÂI¡@307
17.3.4¡@½Õ¾ãinnodb_log_buffer_size¡@308
17.4¡@½Õ¾ãMySQL¦}µo¬ÛÃöªº°Ñ¼Æ¡@308
17.4.1¡@½Õ¾ãmax_connections¡A´£°ª¦}µo³s±µ¡@308
17.4.2¡@½Õ¾ãback_log¡@309
17.4.3¡@½Õ¾ãtable_open_cache¡@309
17.4.4¡@½Õ¾ãthread_cache_size¡@309
17.4.5¡@innodb_lock_wait_timeoutªº³]¸m¡@309
17.5¡@«ù¤[¤Æ¥þ§½Åܶq¡@309
17.6¡@¨Ï¥Î¸ê·½²Õ¡@310
17.7¡@¤pµ²¡@312
²Ä¡@18³¹ ºÏ½LI/O°ÝÃD¡@313
18.1¡@¨Ï¥Î©TºAµw½L¡@313
18.2¡@¨Ï¥ÎºÏ½L°}¦C¡@314
18.2.1¡@±`¨£RAID¯Å§O¤Î¨ä¯S©Ê¡@314
18.2.2¡@¦p¦ó¿ï¾ÜRAID¯Å§O¡@315
18.3¡@µêÀÀ¤å¥ó¨÷©Î³nRAID¡@315
18.4¡@¨Ï¥ÎSymbolic Links¤À¥¬I/O¡@315
18.5¡@¸T¤î¾Þ§@¨t²Î§ó·s¤å¥óªºatimeÄÝ©Ê¡@316
18.6¡@½Õ¾ãI/O½Õ«×ºâªk¡@316
18.7¡@RAID¥d¹q¦À¥R©ñ¹q°ÝÃD¡@318
18.7.1¡@¤°¤\¬ORAID¥d¹q¦À¥R©ñ¹q¡@318
18.7.2¡@RAID¥d½w¦sµ¦²¤¡@319
18.7.3¡@¦p¦óÀ³¹ïRAID¥d¹q¦À¥R©ñ¹q±a¨ÓªºI/O©Ê¯àªi°Ê¡@321
18.8¡@NUMA¬[ºcÀu¤Æ¡@322
18.9¡@¤pµ²¡@325
²Ä¡@19³¹ À³¥ÎÀu¤Æ¡@326
19.1¡@Àu¤Æ¼Æ¾Úªíªº³]­p¡@326
19.1.1¡@Àu¤Æªíªº¼Æ¾ÚÃþ«¬¡@326
19.1.2¡@³q¹L©î¤À´£°ªªíªº³X°Ý®Ä²v¡@328
19.1.3¡@°f³W­S¤Æ¡@329
19.2¡@¼Æ¾Ú®wÀ³¥ÎÀu¤Æ¡@330
19.2.1¡@¨Ï¥Î³s±µ¦À¡@330
19.2.2¡@´î¤Ö¹ïMySQLªº³X°Ý¡@330
19.2.3¡@­t¸ü§¡¿Å¡@331
19.3¡@¤pµ²¡@331
²Ä¡@20³¹ PS/SYS¼Æ¾Ú®w¡@332
20.1¡@Performance Schema®w¡@332
20.1.1¡@¦p¦ó¶}±ÒPS®w¡@332
20.1.2¡@PS®wªºªí¡@333
20.2¡@SYS ®w¡@335
20.2.1¡@SYS®wªº¹ï¶H¡@335
20.2.2¡@SYS¹ï¶Hªº¹ê»ÚÀ³¥Î¡@336
20.3¡@¤pµ²¡@340
²Ä¡@21³¹ ¬G»Ù¶EÂ_¡@341
21.1¡@¬G»Ù¶EÂ_©M³B²zªº­ì«h¡@341
21.2¡@¬G»Ù³B²z¤@¯ë¬yµ{¡@343
21.2.1¡@¬G»Ùµo²{¡@343
21.2.2¡@¬G»Ù©w¦ì¡@345
21.2.3¡@¬G»Ù¸Ñ¨M¡@346
21.3¡@¨å«¬¬G»Ù®×¨Ò¡@349
21.3.1¡@®×¨Ò1¡@349
21.3.2¡@®×¨Ò2¡@353
21.4¡@¤pµ²¡@356
²Ä¥|³¡¤À¡@ºÞ²zºûÅ@½g
²Ä¡@22³¹ MySQL°ª¯Å¦w¸Ë©M¤É¯Å¡@358
22.1¡@Linux/UNIX¥­»O¤Uªº¦w¸Ë¡@358
22.1.1¡@¦w¸Ë¥]¤ñ¸û¡@358
22.1.2¡@¦w¸Ë¤G¶i¨î¥]¡@359
22.1.3¡@¦w¸Ë·½½X¥]¡@359
22.1.4¡@°Ñ¼Æ³]¸m¤èªk¡@360
22.2¡@¤É¯ÅMySQL¡@361
22.3¡@¤pµ²¡@363
²Ä¡@23³¹ MySQL¤¤ªº±`¥Î¤u¨ã¡@364
23.1¡@MySQL©x¤è¤u¨ã¡@364
23.1.1¡@mysql¡]«È¤áºÝ³s±µ¤u¨ã¡^¡@364
23.1.2¡@mysqladmin¡]MySQLºÞ²z¤u¨ã¡^¡@371
23.1.3¡@mysqlbinlog¡]¤é§ÓºÞ²z¤u¨ã¡^¡@371
23.1.4¡@mysqlcheck¡]ªíºûÅ@¤u¨ã¡^¡@378
23.1.5¡@mysqldump¡]¼Æ¾Ú¾É¥X¤u¨ã¡^¡@380
23.1.6¡@mysqlpump¡]¦}¦æªº¼Æ¾Ú¾É¥X¤u¨ã¡^¡@384
23.1.7¡@mysqlimport¡]¼Æ¾Ú¾É¤J¤u¨ã¡^¡@385
23.1.8¡@mysqlshow¡]¼Æ¾Ú®w¹ï¶H¬d¬Ý¤u¨ã¡^¡@385
23.1.9¡@perror¡]¿ù»~¥N½X¬d¬Ý¤u¨ã¡^¡@387
23.1.10¡@MySQL Shell¡@387
23.2¡@Percona¤u¨ã¥]¡@390
23.2.1¡@pt-archiver¡]¼Æ¾ÚÂkÀɤu¨ã¡^¡@391
23.2.2¡@pt-config-diff¡]°Ñ¼Æ¹ï¤ñ¤u¨ã¡^¡@393
23.2.3¡@pt-duplicate-key-checker¡]Àˬd¤¾§E¯Á¤Þ¤u¨ã¡^¡@394
23.2.4¡@pt-find¡]¬d§ä¤u¨ã¡^¡@395
23.2.5¡@pt-heartbeat¡]ºÊ±±¥D±q©µ¿ð¤u¨ã¡^¡@395
23.2.6¡@pt-kill¡]±þ¦º·|¸Ü¤u¨ã¡^¡@397
23.2.7¡@pt-online-schema-change¡]¦b½u­×§ïªíµ²ºc¤u¨ã¡^¡@397
23.2.8¡@pt-query-digest¡]SQL¤ÀªR¤u¨ã¡^¡@399
23.2.9¡@pt-table-checksum¡]¼Æ¾ÚÀËÅç¤u¨ã¡^¡@401
23.2.10¡@pt-table-sync¡]¼Æ¾Ú¦P¨B¤u¨ã¡^¡@402
23.3¡@¤pµ²¡@403
²Ä¡@24³¹ MySQL¤é§Ó¡@404
24.1¡@¿ù»~¤é§Ó¡@404
24.2¡@¤G¶i¨î¤é§Ó¡@405
24.2.1¡@¤é§Óªº¦ì¸m©M®æ¦¡¡@405
24.2.2¡@¤é§ÓªºÅª¨ú¡@406
24.2.3¡@¤é§Óªº§R°£¡@407
24.2.4¡@¤é§Óªº¨Æ¥ó¡@411
24.2.5¡@¤é§Ó°{¦^¡@412
24.3¡@¬d¸ß¤é§Ó¡@415
24.3.1¡@¤é§Óªº¦ì¸m©M®æ¦¡¡@415
24.3.2¡@¤é§ÓªºÅª¨ú¡@416
24.4¡@ºC¬d¸ß¤é§Ó¡@416
24.4.1¡@¤å¥ó¦ì¸m©M®æ¦¡¡@416
24.4.2¡@¤é§ÓªºÅª¨ú¡@417
24.4.3¡@Anemometer²¤¶¡@419
24.5¡@¤pµ²¡@421
²Ä¡@25³¹ ³Æ¥÷»P«ì´_¡@422
25.1¡@³Æ¥÷/«ì´_µ¦²¤¡@422
25.2¡@ÅÞ¿è³Æ¥÷©M«ì´_¡@422
25.2.1¡@³Æ¥÷¡@423
25.2.2¡@§¹¥þ«ì´_¡@425
25.2.3¡@°ò¤_®É¶¡ÂI«ì´_¡@427
25.2.4¡@°ò¤_¦ì¸m«ì´_¡@427
25.2.5¡@¦}¦æ«ì´_¡@427
25.3¡@ª«²z³Æ¥÷©M«ì´_¡@428
25.3.1¡@§N³Æ¥÷©M¼ö³Æ¥÷¡@428
25.3.2¡@MyISAM¦sÀx¤ÞÀºªº¼ö³Æ¥÷¡@429
25.3.3¡@InnoDB¦sÀx¤ÞÀºªº¼ö³Æ¥÷¡@429
25.4¡@ªíªº¾É¤J©M¾É¥X¡@438
25.4.1¡@¾É¥X¡@438
25.4.2¡@¾É¤J¡@442
25.5¡@¤pµ²¡@445
²Ä¡@26³¹ MySQLÅv­­»P¦w¥þ¡@446
26.1¡@MySQLÅv­­ºÞ²z¡@446
26.1.1¡@Åv­­¨t²Îªº¤u§@­ì²z¡@446
26.1.2¡@Åv­­ªíªº¦s¨ú¡@446
26.1.3¡@½ã¸¹ºÞ²z¡@449
26.2¡@MySQL¦w¥þ°ÝÃD¡@461
26.2.1¡@¾Þ§@¨t²Î¬ÛÃöªº¦w¥þ°ÝÃD¡@461
26.2.2¡@¼Æ¾Ú®w¬ÛÃöªº¦w¥þ°ÝÃD¡@463
26.3¡@¨ä¥L¦w¥þ³]¸m¿ï¶µ¡@471
26.3.1¡@±K½X´¡¥ó¡@471
26.3.2¡@safe-user-create¡@472
26.3.3¡@ªíªÅ¶¡¥[±K¡@473
26.3.4¡@skip-grant-tables¡@474
26.3.5¡@skip-networking¡@474
26.3.6¡@skip-show-database¡@475
26.4¡@¤pµ²¡@475
²Ä¡@27³¹ MySQLºÊ±±¡@476
27.1¡@¦p¦ó¿ï¾Ü¤@­ÓºÊ±±¤è®×¡@476
27.1.1¡@¿ï¾Ü¦óºØºÊ±±¤è¦¡¡@476
27.1.2¡@¦p¦ó¿ï¾Ü¾A¦X¦Û¤vªººÊ±±¤u¨ã¡@477
27.2¡@±`¥Îªººôµ¸ºÊ±±¤u¨ã¡@477
27.2.1¡@Open-Falcon²¤¶¡@477
27.2.2¡@Nagios²¤¶¡@479
27.2.3¡@Zabbix²¤¶¡@480
27.2.4¡@´XºØ±`¨£¶}·½³n¥ó¤ñ¸û¡@481
27.3¡@Zabbix ³¡¸p¡@481
27.3.1¡@Zabbix Server³n¥ó¦w¸Ë¡@482
27.3.2¡@Zabbix Server°t¸m»P±Ò°Ê¡@482
27.3.3¡@°t¸mZabbix WebªA°ÈºÝ¡@483
27.3.4¡@Zabbix Agent¦w¸Ë©M°t¸m¡@485
27.3.5¡@PMP´¡¥ó¤¶²Ð©M³¡¸p¡@486
27.3.6¡@Zabbix WebºÝ¾Þ§@¡@489
27.4¡@©Ê¯àÂå¥Íorzdba¡@491
27.4.1¡@orzdba¦w¸Ë¡@491
27.4.2¡@orzdba¨Ï¥Î¡@492
27.5¡@¤pµ²¡@492
²Ä¡@28³¹ MySQL±`¨£°ÝÃD©MÀ³¥Î§Þ¥©¡@493
28.1¡@§Ñ°OMySQLªºroot±K½X¡@493
28.2¡@¼Æ¾Ú¥Ø¿ýºÏ½LªÅ¶¡¤£¨¬ªº°ÝÃD¡@494
28.3¡@mysql.sock¥á¥¢¦Z¦p¦ó³s±µ¼Æ¾Ú®w¡@495
28.4¡@±qmysqldump¤å¥ó©â¨ú»Ý­n«ì´_ªºªí¡@496
28.5¡@¨Ï¥Îinnobackupex³Æ¥÷«ì´_³æªí¡@497
28.6¡@¤ÀªRBINLOG¡A§ä¥X¼gªº¼öÂIªí¡@498
28.7¡@¦b½uDDL¡@499
28.8¡@¤pµ²¡@502
²Ä¡@29³¹ ¦Û°Ê¤Æ¹Bºû¨t²Îªº¶}µo¡@503
29.1¡@MySQL¦Û°Ê¤Æ¹Bºû­I´º¡@503
29.2¡@CMDB¨t²Î·f«Ø¡@504
29.2.1¡@CMDB¼Æ¾Ú®w¡@504
29.2.2¡@§å¶qºÞ²z¨t²Î¡@505
29.2.3¡@¦Z»OAPI¡@511
29.3¡@¥ô°È½Õ«×¨t²Î¡@515
29.3.1¡@Celery¦w¸Ë¡@515
29.3.2¡@Celery¥ô°È³¡¸p¡@516
29.3.3¡@FlowerºÊ±±¡@518
29.4¡@«È¤áºÝ·f«Ø¡@519
29.4.1¡@Vue.js²¤¶¡@519
29.4.2¡@Vue¶µ¥Ø·f«Ø¡@520
29.5¡@¦Û°Ê¤Æ¹Bºû¥­»O¹ê¾Ô¡@525
29.5.1¡@·f«ØCMDB¡@525
29.5.2¡@·f«Ø¥ô°È½Õ«×¥­»O¡@528
29.5.3¡@·f«Ø«È¤áºÝ¡@529
29.5.4¡@¶µ¥Øºt¥Ü¡@532
29.6¡@¤pµ²¡@532
²Ä¤­³¡¤À¡@¬[ºc½g
²Ä30³¹¡@MySQL´_¨î¡@534
30.1¡@´_¨î·§­z¡@534
30.1.1¡@´_¨î¤¤ªº¦UÃþ¤å¥ó¡@536
30.1.2¡@3ºØ´_¨î¤è¦¡¡@537
30.1.3¡@´_¨îªº4ºØ±`¨£¬[ºc¡@540
30.2¡@´_¨î·f«Ø¡@543
30.2.1¡@²§¨B´_¨î¡@543
30.2.2¡@¦h½uµ{´_¨î¡@547
30.2.3¡@¼W±j¥b¦P¨B´_¨î¡@553
30.3¡@GTID¡]Global Transaction Identifier¡^¡@558
30.3.1¡@®æ¦¡»P¦sÀx¡@558
30.3.2¡@gtid_purged¡@561
30.3.3¡@´_¨î·f«Ø¡@565
30.3.4¡@¥D±q¤Á´«¡@571
30.3.5¡@±`¨£°ÝÃD¡@572
30.4¡@¥D­n´_¨î±Ò°Ê¿ï¶µ¡@576
30.4.1¡@log-slave-updates¡@576
30.4.2¡@read-only/super_read_only¡@576
30.4.3¡@«ü©w´_¨îªº¼Æ¾Ú®w©ÎªÌªí¡@577
30.4.4¡@slave-skip-errors¡@579
30.5¡@¤é±`ºÞ²zºûÅ@¡@579
30.5.1¡@¬d¬Ý±q®w´_¨îª¬ºA©M¶i«×¡@579
30.5.2¡@¥D±q´_¨î°ÝÃD¶°ÀA¡@580
30.5.3¡@¦h¥D´_¨î®Éªº¦Û¼WªøÅܶq¨R¬ð°ÝÃD¡@582
30.5.4¡@¦p¦ó´£°ª´_¨îªº©Ê¯à¡@584
30.6¡@¤pµ²¡@588
²Ä31³¹¡@°ª¥i¥Î¬[ºc¡@589
31.1¡@MHA¬[ºc¡@589
31.1.1¡@¦w¸Ë³¡¸pMHA¡@591
31.1.2¡@À³¥Î³s±µ°t¸m¡@598
31.1.3¡@¦Û°Êfailover¡@605
31.1.4¡@ºôµ¸°ÝÃDIJµoªºfailover¾Þ§@¡@614
31.1.5¡@¤â°Êfailover¡@614
31.1.6¡@¦b½u¶i¦æ¤Á´«¡@615
31.1.7¡@­×´_ÌX±¼ªºMaster¡@617
31.2¡@MGR¬[ºc¡@617
31.2.1¡@¦w¸Ë³¡¸pMGR¡@618
31.2.2¡@ºÊ±±¡@625
31.2.3¡@primary¦¨­û¤Á´«¡@626
31.2.4¡@­«­n¯S©Ê¡@628
31.2.5¡@±`¨£°ÝÃD¡@629
31.3¡@InnoDB Cluster¡@636
31.3.1¡@¦w¸Ë³¡¸p¡@637
31.3.2¡@ªì©l¤ÆMySQL Router¡@642
31.3.3¡@¶°¸sMetadata¡@643
31.3.4¡@¶°¸s¦¨­û¨¤¦â¤Á´«¡@644
31.3.5¡@¶°¸s§R°£/¼W¥[¸`ÂI¡@646
31.3.6¡@­«·s¥[¤J¸`ÂI¡@648
31.4¡@¤pµ²¡@649
²Ä32³¹¡@MySQL¤¤¶¡¥ó¡@650
32.1¡@MySQL Router¡@650
32.1.1¡@MySQL Routerªº¦w¸Ë¡@651
32.1.2¡@MySQL Routerªºªì©l¤Æ¡@653
32.1.3¡@MySQL Routerµ¦²¤ÅçÃÒ¡@656
32.2¡@Cetus¬[ºc¡@658
32.2.1¡@Cetusªº¦w¸Ë°t¸m¡@659
32.2.2¡@Cetusªº¨Ï¥Î¡@670
32.2.3¡@Cetus¤é§Ó¤å¥ó¡@674
32.2.4¡@Cetusªº¦ZºÝºÞ²z¡@675
32.2.5¡@Cetusªº¸ô¥Ñµ¦²¤¡@678
32.2.6¡@±`¨£°ÝÃD¡@681
32.3¡@¤pµ²¡@682
§Ç¡G