Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

CentOSÏÂMySql 5.0.xµÄ°²×°¡¢ÓÅ»¯¼°°²È«ÉèÖÃ

 groupadd mysql
н¨Ò»¸öÃûΪmysqlµÄÓû§×é
useradd -g mysql mysql
ÔÚmysqlÓû§×éÏÂн¨Ò»¸öÃûΪmysqlµÄÓû§
gunzip ½âѹÏÂÔØµ½µÄ.gzÎļþ
cd mysql-VERSION
½øÈë½âѹºóµÄĿ¼
CFLAGS="-O3 -mcpu=pentium4" CXX=gcc CXXFLAGS="-O3 -march=pentium4 -felide-constructors -fno-exceptions -fno-rtti" ./configu ......

mysql°²×°Í¼½â½Ì³Ì 5.1(ת)

mysql°²×°Í¼½â½Ì³Ì 5.1
2009Äê03ÔÂ01ÈÕ ÐÇÆÚÈÕ 23:51
×ªÔØÇë×¢Ã÷³ö´¦:http://hi.baidu.com/herdff/blog/item/6e6b4bcf6132f90b93457e14.html
±¾½Ì³ÌÒÔMysql 5.1°æ±¾ÎªÀý£¬¸ü¸ß°æ±¾°²×°¹ý³ÌÓë´ËÀàËÆ¡£ÔĶÁǰ£¬ÇëÏÂÔØ5.1£¬ÏÂÔØµØÖ·£ºwww.mysql.com
°²×°¹ý³ÌÓëÆäËüWindows°²×°³ÌÐòÒ»Ñù£¬Ê×ÏȳöÏÖµÄÊǰ²×°Ïòµ¼»¶Ó­½çÃæ
Ö ......

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

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

MYSQL LAST_INSERT_ID()

LAST_INSERT_ID
×Ô¶¯·µ»Ø×îºóÒ»¸ö INSERT »ò UPDATE ²Ù×÷Ϊ AUTO_INCREMENT ÁÐÉèÖõĵÚÒ»¸ö·¢ÉúµÄÖµ. ²Î¿¼ÕâÀï
The ID that was generated is maintained in the server on a per-connection basis.
LAST_INSERT_IDÊÇ»ùÓÚµ¥¸öconnectionµÄ, ²»¿ÉÄܱ»ÆäËüµÄ¿Í»§¶ËÁ¬½Ó¸Ä±ä¡£
¿ÉÒÔÓà SELECT LAST_INSERT_ID(); ²éѯLAST ......

Ò»´Î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ºÅ