mysqlç50çæ¬å51çæ¬çåºå«ï¼
ä¸ã5.0 å¢å äºStored proceduresãViewsãCursorsãTriggersãXA transactionsçæ¯æï¼å¢å äºINFORATION_SCHEMAç³»ç»æ°æ®åºã
äºã5.1 å¢å äºEvent schedulerï¼Partitioningï¼Pluggable storage engine API ï¼Row-based replicationãGlobal级å«å¨æä¿®æ¹general query logåslow query logçæ¯æã
MySQL 4.1/5.0/5.1/5.5/5.6åçæ¬ç主è¦åºå«
1ã4.1 å¢å äºåæ¥è¯¢çæ¯æï¼
å符éå¢å UTF-8ï¼
GROUP BYè¯å¥å¢å äºROLLUPï¼mysql.user表éç¨äºæ´å¥½ç
å å¯ç®æ³ã
2ã5.0 å¢å äºStored proceduresãViewsãCursorsãTriggersãXA transactionsçæ¯æï¼å¢å äºINFORATION_SCHEMAç³»ç»æ°æ®åºã
3ã5.1 å¢å äºEvent schedulerï¼Partitioningï¼Pluggable storage engine API ï¼Row-based replicationãGlobal级å«å¨æä¿®æ¹general query logåslow query logçæ¯æã
4ã5.5çæ°ç¹å¾
1)é»è®¤åå¨å¼ææ´æ¹ä¸ºInnoDB
2)æé«æ§è½åå¯æ©å±æ§
a. æé«äºé»è®¤çº¿ç¨å¹¶åæ°(innodb_thread_concurrency)
b. åå°è¾å
¥/è¾åºçº¿ç¨æ§å¶ï¼innodb_read_io_threadsãinnodb_write_io_threadsï¼
c. 主线ç¨è¾å
¥/è¾åºéçæ§å¶ï¼innodb_io_capacityï¼
d. æä½ç³»ç»å
ååé
ç¨åºä½¿ç¨æ§å¶(innodb_use_sys_malloc)
e. éåºæ§æ£åç´¢å¼(Hash Index)æ§å¶ï¼ç¨æ·å¯ä»¥å
³ééåºæ§æ£ååè½ã
f. æå
¥ç¼å²ï¼Insert Bufferingï¼æ§å¶ï¼ç¨æ·å¯ä»¥å
³éinnodbçæå
¥ç¼å²åè½ã
g. éè¿å¿«éå éç®æ³æé«å¯æ©å±æ§ï¼innodbä¸å¨ä½¿ç¨ä»£ç(posix)线ç¨,èæ¯ä½¿ç¨åççç¬ç«æä½æ¥å®æäºæ¥å读åéå®ã
h. æ¢å¤ç»æ交ï¼Restored Group Commitï¼
i. æé«æ¢å¤æ§è½
j. å¤ç¼å²æ± å®ä¾
k. å¤ä¸ªåæ»æ®µï¼Multiple Rollback Segmentsï¼,ä¹åçinnodbçæ¬æ大è½å¤ç1023个并åå¤çæä½ï¼ç°å¨mysql5.5å¯ä»¥å¤çé«è¾¾128Kç并åäºç©ï¼
l. Linuxç³»ç»åºæçå¼æ¥è¾å
¥/è¾åºï¼mysql5.5
æ°æ®åºç³»ç»ä¹æé«äº
linuxç³»ç»çè¾å
¥è¾åºè¯·æ±ç并åæ°ã
m. æ©å±ååç¼å²ï¼æ·»å äºå é¤ç¼å²åæ¸
é¤ç¼å²
n. æ¹åäº
æ¥å¿ç³»ç»äºæ¥ååç¬å·æ°ï¼Flushï¼å表äºæ¥
o. æ¹åæ¸
é¤ç¨åºè¿åº¦ï¼å¨mysql5.5ä¸æ¸
æ¥æä½çº¿ç¨æ¯ç¬ç«ç线ç¨ï¼å¹¶æ¯æ并åï¼å¯ä»¥ä½¿ç¨innodb_purge_treadsé
ç½®ã
p. æ¹åäºå¡å¤çä¸ç
å
æ°æ®éå®ãä¾å¦ï¼äºç©ä¸ä¸ä¸ªè¯å¥éè¦éä¸ä¸ªè¡¨ï¼ä¼å¨äºç©ç»ææ¶éæ¾è¿ä¸ªè¡¨ï¼èä¸æ¯å以åå¨è¯å¥ç»ææ¶éæ¾è¡¨ã
3)æé«å®ç¨æ§
a. ååæ¥å¤å¶ï¼Semi-synchronous Replicationï¼
b. å¤å¶Heartbeat
c. ä¸ç»§æ¥å¿èªå¨æ¢å¤ï¼Automatic Relay Log Recoveryï¼
d. æ ¹æ®æå¡å¨è¿æ»¤é¡¹å¤å¶ï¼Replication Per Server Filteringï¼
e. ä»æå¡å¨å¤å¶æ¯æçæ°æ®ç±»å转æ¢ï¼Replication Slave Side Data Type Conversionsï¼
4)æé«æ管çæ§åæç
a. 建ç«å¿«éç´¢å¼ï¼Faster Index Creationï¼
b. é«æçæ°æ®å缩ï¼Efficient Data Compressionï¼
c. 为大ç©ä»¶åå¯åé¿åº¦åæä¾é«æåå¨
d. å¢å äºINFORMATION_SCHEMA表ï¼æ°ç表æä¾äºä¸InnoDBå缩åäºå¡å¤çéå®æå
³çå
·ä½ä¿¡æ¯ã
5)æé«å¯ç¨æ§
a. é对SIGNAL/RESIGNALçæ°SQLè¯æ³
b. æ°ç表/ç´¢å¼ååºé项ãMySQL5.5å°è¡¨åç´¢å¼RANGåLISTååºèå´æ©å±å°äºéæ´æ°ååæ¥æï¼å¹¶å¢å äºå¨å¤ä¸ªåä¸ååºçè½åã
6)æ¹åæ£æµåè¯æ
Mysql5.5å¼å
¥äºä¸ç§æ°çæ§è½æ¶æ(performancn_shema,P_S),ç¨äºçæ§mysqlçæ§æå¡å¨è¿è¡æ¶çæ§è½ã
5ã5.6çæ°ç¹å¾ 1)InnoDBç°å¨å¯ä»¥éå¶å¤§é表æå¼çæ¶åå
åå ç¨è¿å¤çé®é¢ï¼æ¯å¦è¿éæå°çï¼(第ä¸æ¹å·²æè¡¥ä¸)
2)InnoDBæ§è½å 强ãå¦åækernel mutex;flushæä½ä»ä¸»çº¿ç¨å离;å¤ä¸ªperge线ç¨;大å
åä¼åç
3)InnoDBæ»éä¿¡æ¯å¯ä»¥è®°å½å° error æ¥å¿ï¼æ¹ä¾¿åæ
4)MySQL5.6æ¯æ延æ¶å¤å¶ï¼å¯ä»¥è®©slaveè·masterä¹é´æ§å¶ä¸ä¸ªæ¶é´é´éï¼æ¹ä¾¿ç¹æ®æ
åµä¸çæ°æ®æ¢å¤ã
5)表ååºåè½å¢å¼º
6)MySQLè¡çº§å¤å¶åè½å 强ï¼å¯ä»¥éä½ç£çãå
åãç½ç»çèµæºå¼éï¼åªè®°å½è½ç¡®å®è¡è®°å½çå段å³å¯ï¼
7)Binlogå®ç° crash-safe
8)å¤å¶äºä»¶éç¨crc32æ ¡éªï¼å¢å¼ºmaster/slave å¤å¶æ°æ®ä¸è´æ§
9)æ°å¢ log_bin_basename ï¼ä»¥åvariableséé¢æ²¡æbinlogä½ç½®ä¿¡æ¯ï¼å¯¹æ°æ®åºçç管å¾ä¸æ¹ä¾¿ï¼