Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Mysql¸´ÖƼ¼ÊõÖеÄÖ÷¼ü³åÍ»

Advanced MySQL Replication Techniques
http://dev.mysql.com/tech-resources/articles/advanced-mysql-replication.html
ÔÚ¶à¸ömasterÖи´ÖƵÄÎÊÌ⣬Ö÷ÒªÊÇ×ÔÔöÖ÷¼üÎÊÌâ¡£
¿ÉÒÔÓÃauto_increment_incrementºÍauto_increment_offset²ÎÊý½â¾ö
£¨1£©auto_increment_increment£º¿ØÖÆÔö³¤µÄ¼ä¸ô
£¨2£©auto_increment_offset£º¿ØÖÆAUTO_INCREMENTµÄ¿ªÊ¼Öµ
±ÈÈ磺ÓÐ5̨»úÆ÷¶¼×÷Ϊmaster£¬Ôò¿ÉÒÔÅäÖÃΪ£º
auto_increment_increment = 5
auto_increment_offset = N (µÚN̨»úÆ÷)
Òò´Ë£¬µÚһ̨»úÆ÷µÄÐòÁÐΪ£º1,6,11,…£»µÚ¶þ̨»úÆ÷µÄÐòÁÐΪ£º2,7,12,…£»µÚÈý̨»úÆ÷µÄÐòÁÐΪ£º3,8,13,…µÈµÈ


Ïà¹ØÎĵµ£º

PHPºÍMYSQLµÄ±àÂëÎÊÌâ

1 MYSQLÖеÄ×Ö·û¼¯¸ÅÄî
  MysqlµÄ×Ö·û¼¯ÀïÓÐÁ½¸ö¸ÅÄһ¸öÊÇ"Character set£¨×Ö·û¼¯£©"£¬ÁíÒ»¸öÊÇ"Collations"¡£
1.1 Collations
  Collations·­³ÉÖÐÎÄÊÇ"УÑé"£¬ÔÚÍøÒ³¿ª·¢µÄ¹ý³ÌÖУ¬Õâ¸ö´Ê»ã£¬Ö»ÔÚMysqlÀïʹÓã¬Ö÷Òª×÷ÓÃÊÇÖ¸µ¼Mysql¶Ô×Ö·ûµÄ±È½Ï£¬±ÈÈ磬 ASCII×Ö·û¼¯ÀCol ......

Fedora 8ÏÂÓÃYum°²×°Apache+PHP+MySQL»·¾³


fedora8 ÓÃyumÀ´¹ÜÀí°²×°Apache+PHP+MysqlµÄ»ù±¾°²×°¡£
1. °²×°Apahce, PHP, Mysql, ÒÔ¼°phpÁ¬½Ómysql¿â×é¼þ¡£
yum -y install httpd php mysql mysql-server php-mysql
2. ÅäÖÿª»úÆô¶¯·þÎñ
/sbin/chkconfig httpd on             [ÉèÖÃapache·þÎñÆ÷httpd·þÎñ¿ª»úÆô¶¯]
......

MySQL Archive Storage Engine

The MySQL 5.0 Archive Storage Engine
http://dev.mysql.com/tech-resources/articles/storage-engine.html
ÌØµã£º
1.²»Ö§³ÖÈκÎË÷Òý£¬µ«Ê¹Óòéѯ»º´æ
2.¸ù¾Ýmysql¹¤³ÌʦµÄ˵·¨£¬µ±±í´óС´ïµ½1.5Gʱ£¬±íɨÃèarchiveʱ¼äÉÙÓÚmyisam±í
3.Èç¹ûÄãÏë¸Ä±äÆäËû´æ´¢ÒýÇæµÄ±íµ½archiveÒýÇæ£¬ÇëÏÈdropÏÂÈκÎË÷Òý
4.myisam¿ÉÒÔÓ ......

MySQL Query Cache

A Practical Look at the MySQL Query Cache
http://dev.mysql.com/tech-resources/articles/mysql-query-cache.html
Êý¾Ý¿â»º´æ²ßÂÔ£º
£¨1£©»º´æ¾­³£±»Ê¹ÓõÄÊý¾Ý
£¨2£©»º´æ¾­³£Ö´ÐеÄSQLºÍ´æ´¢¹ý³Ì´úÂë
£¨3£©»º´æÊý¾Ý¿âÔªÊý¾ÝÐÅÏ¢£¬°üÀ¨£º¶ÔÏó½á¹¹»º´æ¡¢°²È«ÐÅÏ¢µÈ
mysqlÒýÇæËùʹÓõĻº´æ£º
£¨1£©myisam:key b ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ