More Related Content
Viewers also liked (14)
Similar to ²Ñ²â³§²Ï³¢ºÍ±õ°¿(ÉÏ£© (20)
More from Feng Yu (16)
²Ñ²â³§²Ï³¢ºÍ±õ°¿(ÉÏ£©
- 2. 1. MySQLµÄÎļþ¼°½éÉÜ 2. Êý¾Ý·ÃÎÊÁ÷³Ì 3. Îļþ·ÃÎÊģʽ 4. Ó°ÏìioÐÐΪµÄһЩ²ÎÊýºÍÑ¡Ôñ²ßÂÔ
- 3. MySQLµÄÎļþ¼°½éÉÜ ÀàÐÍÃû³Æ ÎļþÃû Êý¾ÝÎļþ(datafile) *.frm *.ibd Êý¾Ý×Öµä Ibdata1¡¢ibdata2 ÊÂÎñÈÕÖ¾(redolog) Ib_logfile0¡¢ib_logfile1 »Ø¹öÈÕÖ¾(undolog) Ibdata ¹éµµÈÕÖ¾(binlog£© mysql-bin.000001~mysql- bin.xxxx ÖмÌÈÕÖ¾(relaylog) mysqld-relay-bin.xxxxxx ÆäËûÈÕÖ¾ slowlolg, errorlog,querylog
- 4. Êý¾Ý·ÃÎÊÁ÷³Ì Ò»¸ö¼òµ¥µÄ²éѯ select * from t where id>=( select id from t where k1=100 limit 100000,1) limit 2; ±í½á¹¹ CREATE TABLE `t` ( `id` int(11) NOT NULL, `k1` int(11) DEFAULT NULL, `data` char(100) DEFAULT NULL, PRIMARY KEY (`id`), KEY `k1` (`k1`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk;
- 5. Êý¾Ý·ÃÎÊÁ÷³Ì
- 6. Êý¾Ý·ÃÎÊÁ÷³Ì Ò»¸ö¼òµ¥µÄ¸üРinsert into t values(1, 100, ¡®abcd¡¯); ÉñÂíÊÇinsert buffer£¿¸úio ÓйØÂð
- 7. Îļþ·ÃÎÊģʽ 1) *.frm ±í¶¨ÒåÎļþ¡£·ÃÎÊÌص㣺¼«ÉٸĶ¯¡¢ÕûÌå·ÃÎÊ--ʲôģʽ×î Êʺϣ¿ 2) *ibd ±íÊý¾ÝÎļþ¡£·ÃÎÊÌص㣺´óÁ¿Ëæ»ú¶Áд--ʲôģʽ×îÊʺϣ¿ ÄÚ²¿Ê²Ã´Ñù£¿ ÔÚ´«Í³SASÅÌʱ´ú£¬Ôõô×î´ó»¯ÀûÓôÅÅÌÐÔÄÜ£¿ »»ÁËSSD/FUSIONIO ÒÔºóÄØ£¿ ¶ÔÓ¦µÄ²ßÂÔ´øÀ´µÄÊý¾Ý°²È«ÎÊÌâ----
- 8. Îļþ·ÃÎÊģʽ 3) ib_logfile* Redolog¡£ ·ÃÎÊ·½Ê½£ºË³Ðò¶Áд¡£ 512×Ö½Ú¶ÔÆëд¿ÉÒÔÁªÏ뵽ʲô£¿ 4)MySQL-bin Binlog¡£ ·ÃÎÊ·½Ê½£ºË³Ðò¶Áд¡£ Ϊʲô²ßÂÔÓëredolog²»Í¬£¿ 5)ibdata Êý¾Ý×ÖµäºÍ»Ø¹öÈÕÖ¾¡£·ÃÎÊ·½Ê½£ºËæ»ú¶Áд/˳Ðòд¡£²ßÂÔÓë Êý¾ÝÎļþÀàËÆ¡£
- 10. Ó°ÏìioÐÐΪµÄһЩ²ÎÊýºÍ²ÎÊý¶ÔioµÄÓ°Ïì innodb_file_per_table 1¡¢¿ØÖÆÊÇ·ñÿ¸ö±íÊý¾ÝÒ»¸öÎļþ 2¡¢ÍƼöÅäÖÃ1µÄÔÒò£¿ innodb_flush_log_at_trx_commit 1¡¢¿ØÖÆredo logµÄдÅÌ¡¢Ë¢Å̲ßÂÔ 2¡¢°²È«µÝÔöÊÇ0 ? 2 ? 1 3¡¢²»Í¬ÅäÖõķçÏպʹú¼Û sync_binlog 1¡¢¿ØÖÆbinlogË¢Å̲ßÂÔ 2¡¢°²È«µÝÔöÊÇ0 ?N ? 1 3¡¢²»Í¬ÅäÖõķçÏպʹú¼Û 4¡¢ÓëÉϸöÅäÖõIJî±ð£¬ÎªÊ²Ã´Ã»ÓпØÖÆдÅ̲ßÂÔ£¿ 5¡¢ Binlog_cache_use ºÍ Binlog_cache_disk_use
- 11. Ó°ÏìioÐÐΪµÄһЩ²ÎÊýºÍ²ÎÊý¶ÔioµÄÓ°Ïì innodb_flush_method 1¡¢¿ØÖÆdata»òlogµÄË¢Å̲ßÂÔ 2¡¢¿ÉÑ¡Öµ FSYNC O_DSYNC O_DIRECT LITTLESYNC NOSYNC 3¡¢Ò»°ãÉèÖÃO_DIRECT £¬Ò²²»¹»ÀíÏë ALL_O_DIRECT binlog_cache_size 1¡¢»¹Ã»ÓÐÌá½»µÄÊÂÎñ·Åcache 2¡¢´óÊÂÎñ£¿ 3¡¢Binlog_cache_use /Binlog_cache_disk_use
- 16. лл