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

mysqlµÄCR_COMMANDS_OUT_OF_SYNC´íÎó

mysqlÖ´ÐÐsqlÓï¾äʱÓÐʱ»á³öÏÖCR_COMMANDS_OUT_OF_SYNC´íÎó£¨2014£©
ÌáʾÓïΪ
commands out of sync; you can't run this command now
ÍøÉ϶Դ˴íÎóµÄÃèÊöºÜÉÙ£¬¶øÇÒûÓиø³ö½â¾ö·½·¨¡£
ÆäʵÕâÊÇÒòΪÉÏÒ»¸ösqlÖ´Ðзµ»ØÁ˶à¸ö½á¹û¼¯£¬µ«Ã»Óаѽá¹û¶¼È¡³öÀ´£¬¾ÍÖ´ÐÐÁËеÄsqlÓï¾ä£¬¾Í»á²úÉúÕâ¸ö´íÎó¡£
Ó¦ÔÚsqlÓï¾äÖ´Ðкó
ÓÃmysql_store_result(&ninghao79);È¡³ö½á¹û¼¯£¬
È»ºóÓÃmysql_next_result(&ninghao79);¼ì²éÊÇ·ñÓÐÊ£Óà½á¹û¼¯£¬
Èç¹ûÓоÍÔÙÓÃmysql_store_result(&ninghao79);°ÑÊ£Óà½á¹û¼¯È¡³öÀ´¡£
ÕâÑù¾ÍÄܽâ¾öCR_COMMANDS_OUT_OF_SYNC´íÎóÁË¡£
ת×Ô£ºhttp://blog.sina.com.cn/s/blog_4e45516601000b9x.html


Ïà¹ØÎĵµ£º

MySQL Master/SlaveÊý¾Ý¿â¶Áд²Ù×÷Àà

Êý¾Ý¿â²Ù×÷ÀࣺDBCommon.class.php
//---------------------------------------------------------------------
// MySQL Master/SlaveÊý¾Ý¿â¶Áд²Ù×÷Àà
//
// ¿ª·¢×÷Õß: heiyeluren
// °æ±¾ÀúÊ·:
// 2006-09-20 »ù±¾µ¥Êý¾Ý¿â²Ù×÷¹¦ÄÜ, 25 ¸ö½Ó¿Ú
// 2007-07-30 Ö§³Öµ ......

MySQLÖеÄCREATE VIEWÓï·¨

CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
    VIEW view_name [(column_list)]
    AS select_statement
    [WITH [CASCADED | LOCAL] CHECK OPTION]
¸ÃÓï¾äÄÜ´´½¨ÐµÄÊÓͼ£¬Èç¹û¸ø¶¨ÁËOR REPLACE×Ӿ䣬¸ÃÓï¾ä»¹ÄÜÌæ»»ÒÑÓеÄÊÓͼ¡£select_st ......

Îå¸ö³£ÓÃMySQLͼÐλ¯¹ÜÀí¹¤¾ß

MySQLÊÇÒ»¸ö·Ç³£Á÷ÐеÄСÐ͹ØϵÐÍÊý¾Ý¿â¹ÜÀíϵͳ£¬2008Äê1ÔÂ16ºÅ±»Sun¹«Ë¾ÊÕ¹º¡£Ä¿Ç°MySQL±»¹ã·ºµØÓ¦ÓÃÔÚInternetÉϵÄÖÐСÐÍÍøÕ¾ÖС£ÓÉÓÚÆäÌå»ýС¡¢Ëٶȿ졢×ÜÌåÓµÓгɱ¾µÍ£¬ÓÈÆäÊÇ¿ª·ÅÔ´ÂëÕâÒ»Ìص㣬Ðí¶àÖÐСÐÍÍøվΪÁ˽µµÍÍøÕ¾×ÜÌåÓµÓгɱ¾¶øÑ¡ÔñÁËMySQL×÷ΪÍøÕ¾Êý¾Ý¿â¡£
1¡¢phpMyAdmin£¨http://www.phpmyadmin.net/£©
......

Nagios£º¼à¿ØMysql·þÎñÆ÷

ʱ¼ä£º2009-03-12 12:38:24  À´Ô´£ºLinuxÁªÃË
  ×÷Õߣº
 À´Ô´£ºit168.com
   
    ×÷ÕߣºÌïÒÝ(sery@163.com)
    Ë×»°Ëµ£º¹¤ÓûÉÆÆäÊ£¬±ØÏÈÀûÆäÆ÷.Òª×öºÃϵͳ¹ÜÀí,ʹ×Ô¼ºµÄ¹¤×÷¸üÇáËɸüÓÐЧµÄ»°£¬Ò»¸öºÃµÄ¼à¿Ø¹¤¾ßÊDZز»¿ÉÉÙµÄÁË¡£ÔÚÕâÀïÎÒÏò ......

Ò»´ÎNginx+PHP+MysqlµÄ²¢·¢²âÊÔ¾­Àú

 Ò»´ÎNginx+PHP+MysqlµÄ²¢·¢²âÊÔ¾­Àú
  Ò»¡¢Ó²¼þ»·¾³
      CPU:4ºËIntel(R) Xeon(R) CPU           E5504  @ 2.00GHz
      6GÄڴ棬120GÓ²ÅÌ
  ¶þ¡¢Èí¼þ»·¾³
     L ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ