mysql±íÁªºÏunionÓÅ»¯Îª±íÁ¬½Ójoin
»°ËµÖ®Ç°ÓÃphpдµÄÒ»¸öͳ¼ÆÅܵúúõģ¬Í»È»Ò»Ìì²»³öÊý¾ÝÁË£¬×·ÆäÔÒò³öÔÚsqlÓï¾äÉÏ£¬ÓÉÓÚÊý¾ÝÁ¿Ôö´ó¼ÓÉÏ·þÎñÆ÷ÀϾɣ¬ÔËÐÐsqlÓï¾äµÄʱºò³öÏÖÄÚ´æ²»×ãµÄÌáʾ£¬Ëì¾ö¶¨ÓÅ»¯sqlÓï¾äʹÆä²»²úÉúÁÙʱ±í¡£ÐèÇóÇåÎú£¬ÏÂÃæ¾ÙÀý˵Ã÷£º
ÔsqlÓï¾ä£º
SELECT COUNT( DISTINCT md5 ) from active AS a
WHERE a.md5 in ( select md5 from alive_20091220 union
select md5 from alive_20091221 union
select md5 from alive_20091222 union
select md5 from alive_20091223 )
ÓÅ»¯ºóµÄsqlÓï¾ä£º
SELECT COUNT( DISTINCT a.md5 ) from active AS a
LEFT OUTER JOIN alive_20091220 AS b ON a.md5 = b.md5
LEFT OUTER JOIN alive_20091221 AS c ON a.md5 = c.md5
LEFT OUTER JOIN alive_20091222 AS d ON a.md5 = d.md5
LEFT OUTER JOIN alive_20091223 AS e ON a.md5 = e.md5
Ïà¹ØÎĵµ£º
Galera ÊÇÒ»Ì×ÔÚ MySQL InnoDB ÉÏÃæÊµÏÖ Multi-master ÇÒ synchronous replication µÄϵ統¡£
¸Ã°æ±¾ÐÞ¸´ÁË9¸öbug£¬Ö÷ÒªÊÇ´¦Àí DDL ºÍ DML µÄ²¢·¢ÎÊÌ⣬ÁíÍâ»ù×¼MySQL°æ±¾Éý¼¶µ½ 5.1.41 ¡£
ÏÂÔØµØÖ·£º http://www.codership.com/en/downloads/galera
......
Ê×ÏÈÈ¥MySQL¹ÙÍøÏÂÔØMySQL connector/C++
http://dev.mysql.com/downloads/connector/cpp/1.0.html
ÏÂÔØµÚ¶þ¸ö°ü£¬windows32λ·Ç°²×°°æ£¨¸öÈ˾õµÃÕâ¸ö°ü¸É¾»£©¡£Ä¿Ç°µÄ°æ±¾ÊÇConnector/C++ 1.0.5¡£
Windows (x86, 32-bit), ZIP Archive
(mysql-connector-c++-noinstall-1.0.5-win32.zip)
½«Õû¸ö°ü½âѹµ½ÏîÄ¿Îļþ¼Ðϵ ......
±¸·ÝMySQLÊý¾Ý¿âµÄÃüÁî
mysqldump -hhostname -uusername -ppassword databasename > backupfile.sql
±¸·ÝMySQLÊý¾Ý¿âΪ´øÉ¾³ý±íµÄ¸ñʽ
±¸·ÝMySQLÊý¾Ý¿âΪ´øÉ¾³ý±íµÄ¸ñʽ£¬Äܹ»Èøñ¸·Ý¸²¸ÇÒÑÓÐÊý¾Ý¿â¶ø²»ÐèÒªÊÖ¶¯É¾³ýÔÓÐÊý¾Ý¿â¡£
mysqldump -–add-drop-table -uusername -ppassword databasename > backu ......
֮ǰ£¬Ò»Ö±À§ÄպܾõÄMySQLµÄÎÊÌâÒòΪÓÐÁËtcmallocºóµÃÒÔ½â¾ö¡£
ÎÊÌâÊÇ£ºÍøÕ¾·ÃÎÊÁ¿²»¸ß£¬¸ß·åʱ²¢·¢ÊýÔÚ300-400Ö®¼ä¡£CPU±È½Ï¸ß£¬ÔÚ30-80%Ö®¼ä²¨¶¯µÃÀ÷º¦£¬Ê¹ÓÃtopÃüÁî¿ÉÒÔ¿´µ½ÊÇmysql½ø³Ìµ¼Ö£¬Í¬Ê±ÓÃiostatºÍsar²é¿´iowaitÖµºÜ¸ßÔÚ20-30Ö®¼ä¡£
µ«ÊÇϵͳ»¹¿ÉÒÔÎȶ¨ÔËÐУ¬È»ºóÖÜÆÚÐԵijöÏÖswap·ÖÇøÕ¼ÓÃÂÊÅÊÉý£¬Ö±½Óµ¼Ö ......