mysqlµÄslow queryÖеÄÒ»¸öÏÖÏó
ÔÚmysqlµÄslow query logÖУ¬¿ÉÄÜ´æÔÚÀàËÆÕâÑùµÄÌØÊâ¼Ç¼£º
# Time: 100127 23:17:01
# User@Host: root[root] @ [127.0.0.1]
# Query_time: 18446744073709.351562 Lock_time: 0.000129 Rows_sent: 1 Rows_examined: 11030
SET timestamp=1264663021;
SELECT dummy.id AS dummy_id
from dummy
WHERE dummy.id = 1;
×¢Òâµ½ÆäÖÐQuery_time·Ç³£´ó£¨18446744073709.351562£©£¬³öÏÖÕâÖÖÏÖÏóµÄÔÒò¿ÉÄÜÊÇmysql·þÎñÆ÷»á¶¨Ê±´Ótime serverУ׼ʱ¼ä£¬¶ø²éѯǡºÃÔÚУ׼ʱ¼äʱ½øÐУ¬ÓÚÊÇQuery_time³ÉÁ˸ºÊý¡£¶ÔÓÚ32λϵͳ£¬¿ÉÄÜÊÇ4294967296×óÓÒµÄÒ»¸öÖµ£¬¶ø¶ÔÓÚ64λϵͳ£¬ÔòÊÇ18446744073709551616×óÓÒµÄÒ»¸öÖµ¡£
Ïà¹ØÎĵµ£º
À´Ô´:Ô¹ⲩ¿Í ºËÐÄÌáʾ£ºMySQLµÄ¹ÜÀíά»¤¹¤¾ß·Ç³£¶à£¬³ýÁËϵͳ×Ô´øµÄÃüÁîÐйÜÀí¹¤¾ßÖ®Í⣬»¹ÓÐÐí¶àÆäËûµÄͼÐλ¯¹ÜÀí¹¤¾ß£¬ÕâÀïÎÒ½éÉÜÎå¸öÎÒ¾³£Ê¹ÓõÄMySQLͼÐλ¯¹ÜÀí¹¤¾ß£¬¹©´ó¼Ò²Î¿¼¡£ MySQLÊÇÒ»¸ö·Ç³£Á÷ÐеÄСÐ͹ØϵÐÍÊý¾Ý¿â¹ÜÀíϵͳ£¬2008Äê1ÔÂ16ºÅ±»Sun¹«Ë¾ÊÕ¹º¡£Ä¿Ç°MySQL±»¹ã·ºµØÓ¦ÓÃÔÚInternet ......
Oracle,MySQL,MSSQL ServerºÍAccessÊý¾Ý¿âµÄͳ¼Æº¯Êý
ÎÒÃÇÔÚ±à³ÌÖг£ÓõÄͳ¼Æº¯ÊýÓмÆÊý,ÇóºÍ,Çó×î´óÖµ,Çó×îСֵ,Çóƽ¾ù,·½²îºÍ±ê×¼²î.
·½²î(Variance)
·½²îÊDZê׼ƫ²îµÄƽ·½¡£×éÖеÄÖµ£¬ÓëËüÃÇƽ¾ùÖµÖ®¼äÆ«Àë³Ì¶ÈµÄ¶ÈÁ¿¡£
±ê׼ƫ²î(Standard Deviation)
Ò»¸ö²ÎÊý£¬Ö¸³öÒ»ÖÖ·½Ê½£¬Ò»¸ö¸ÅÂʺ¯ÊýÒÔÕâÖÖ·½Ê½·Ö²¼ÔÚƽ¾ùÖµ¸ ......
±¾µØ°²×°WordPressʹÓÃxamppÎÞ·¨Æô¶¯apacheºÍmysqlµÄ½â¾ö·½·¨
½ñÌ쿪ʼװ±¾µØ²âÊÔÓõÄWordPress£¬Ñ¡Ôñxampp¼¯³É°ü¡£¿ÉÊÇ°²×°¾Í³öÎÊÌâÁË¡£
apacheºÍMySQLÀÏ°²×°Ê§°Ü£¬ºÜÊǾÀ½á···
°Ù¶ÈGoogleÁËÒ»ÍíÉÏÖÕÓÚµ·¹ÄºÃÁË¡£
ÏÂÃæÀ´ËµËµÎÒÊÇÔõô½â¾öµÄ£¬ºÍÌùÒ»·Ý¹ØÓÚÕâ¸öÎÊÌâµÄһƪÎÄÕ¡£
Ê×ÏÈ°²×°Ä¿Â¼²»¿É ......
²âÊÔ»·¾³£ºUbuntu 9.10 + MySQL 5.1.37-1ubuntu5
Ubuntu ÔÚÆô¶¯¹ÜÀí init.d
ÀïÃæ¹ØÓÚ MySQL µÄÃüÁîÓУº
/etc/init.d/mysql start|stop|restart|reload|force-reload|status
ÀýÈçÖØÆôMySQL·þÎñ£ºsudo /etc/init.d/mysql restart
......
grant replication slave on *.* to backup@192.168.188.128 identified by "123456";
grant replication slave on *.* to backup@192.168.188.8 identified by "123456";
service mysql stop
server_id = 1
log-bin = mysql-bin
log-error=mysql-error
master-host = 192.168.188.8
master-user = ba ......