²`¤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ª©ªÀ | 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¥Dn±¦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³WS¤Æ¡@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¡@¥Dn´_¨î±Ò°Ê¿ï¶µ¡@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 |