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

MYSQL 5.0 ÒÔÉÏ 8Сʱ³¬Ê±ÎÊÌâ


Ó¦ÓóÌÐòºÍÊý¾Ý¿â½¨Á¢Á¬½Ó£¬Èç¹û³¬¹ý8СʱӦÓóÌÐò²»È¥·ÃÎÊÊý¾Ý¿â£¬Êý¾Ý¿â¾Í¶ÏµôÁ¬½Ó ¡£ÕâʱÔٴηÃÎʾͻáÅ׳öÒì³££¬ÈçÏÂËùʾ£º
java.io.EOFException
    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1913)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2304)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2803)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
...
²éÁËһϷ¢ÏÖÓ¦ÓóÌÐòºÍmysqlÊý¾Ý¿â½¨Á¢Á¬½Ó£¬Èç¹û³¬¹ý8СʱӦÓóÌÐò²»È¥·ÃÎÊÊý¾Ý¿â£¬Êý¾Ý¿â¾Í¶ÏµôÁ¬½Ó ¡£ÕâʱÔٴηÃÎʾͻáÅ׳öÒì³£¡£
¹ØÓÚmysql×Ô¶¯¶Ï¿ªµÄÎÊÌâÑо¿½á¹ûÈçÏ£¬ÔÚmysqlÖÐÓÐÏà¹Ø²ÎÊýÉ趨£¬µ±Êý¾Ý¿âÁ¬½Ó¿ÕÏÐÒ»¶¨Ê±¼äºó£¬·þÎñÆ÷¾Í»á¶Ï¿ªµÈ´ý³¬Ê±µÄÁ¬½Ó£º
1¡¢Ïà¹Ø²ÎÊý£¬ºìÉ«²¿·Ö
mysql> show variables like '%timeout%';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| connect_timeout          | 5     |
| delayed_insert_timeout   | 300   |
| innodb_lock_wait_timeout | 50    |
| interactive_timeout      | 28800 |
| net_read_timeout         | 30    |
| net_write_timeout        | 60    |
| slave_net_timeout        | 3600 |
| wait_timeout             | 28800 |
+--------------------------+-------+        
ͬһʱ¼ä£¬ÕâÁ½¸ö²ÎÊýÖ»ÓÐÒ»¸öÆð×÷Óᣵ½µ×ÊÇÄĸö²ÎÊýÆð×÷Ó㬺ÍÓû§Á¬½Óʱָ¶¨µÄÁ¬½Ó²ÎÊýÏà¹Ø£¬È±Ê¡Çé¿öÏÂÊÇʹÓÃwait_timeout¡£ÎÒ½¨ÒéÊǽ«ÕâÁ½¸ö²ÎÊý¶¼Ð޸ģ¬ÒÔÃâÒýÆð²»±ØÒªµÄÂé·³¡£
2¡¢Ð޸IJÎÊý
ÕâÁ½¸ö²ÎÊýµÄĬÈÏÖµÊÇ8Сʱ(60*60*8=28800)¡£ÎÒ²âÊÔ¹ý½«ÕâÁ½¸ö²ÎÊý¸ÄΪ0£¬½á¹û³öÈËÒâÁÏ£¬ÏµÍ³×Ô¶¯½«Õâ¸öÖµÉèÖÃΪ1¡£»»¾ä»°Ëµ£¬²»Äܽ«¸ÃÖµÉèÖÃΪÓÀ¾Ã¡£


Ïà¹ØÎĵµ£º

Mysql5.1 for PHP

×¼±¸£ºÏÂÔØMysql5.1<mysql-essential-5.1.41-win32.msi>
°²×°£ºstep by step
²âÊÔ£º1.MySQL²âÊÔ
µã¿ªMySQL Command Line Client, ÊäÈ밲װʱ½¨Á¢µÄÃÜÂë¡£
mysql>show databases;
mysql>use <<database name>>;
mysql>show tables;
mysql>select * from <<table name>>;
......

MySQL Partition

×÷ÕߣºÀÏÍõ Èý¹úÑÝÒ忪ƪһÓïµÀÆÆ£ººÏ¾Ã±Ø·Ö£¡MySQLµÄʹÓÃÒàÊÇÈç´Ë£¬Ãæ¶ÔÓ¦ÓÃÖÐÔ½À´Ô½ÅÓ´óµÄÊý¾ÝÁ¿£¬×îʱ÷ֵĽâ¾ö·½°¸ÊÇShard£¬²»¹ýËüµÄ¸´ÔÓÐÔ²¢²»ÊÇÿ¸ö³ÌÐòÔ±¶¼ÄܼÝÔ¦µÄ£¬Èç¹û°Ñ¼Ü¹¹µÄÑݱä±È×÷ÉúÃüµÄ½ø»¯£¬ÄÇôShard¿ÉÒÔ¿´×öÊDz¸È鶯ÎºÜ¶à¼Ü¹¹×îºóÖ®ËùÒÔʧ°Ü£¬¾ÍÊÇÒòΪËüÃDz½×ÓÂõµÃÌ«´ó£¬Ïë´ÓԭʼÉúÃüÖ±½Ó½ø»¯³É²¸Èé¶ ......

CentOS LAMP»·¾³´î½¨ºÍ²âÊÔphpÓëmysqlµÄÁ¬½Ó


    * ÕªÒª£ºCentOS LAMP×÷Ϊ·þÎñÆ÷£¬²»°²×°²»ÐèÒªµÄ×é¼þ£¬ËùÒÔÔÚÑ¡Ôñ×é¼þµÄʱºò£¬²»ÒªÑ¡web·þÎñÆ÷£¬ÒòΪÎÒÃǺóÃæÒªÊÖ¶¯±àÒë°²×°¡£CentOS LAMPϵͳԼ¶¨RPM°üºÍÔ´Âë°ü´æ·ÅλÖÃ
    * ±êÇ©£ºCentOS LAMP
    *
      Oracle°ïÄú׼ȷ¶´²ì¸÷¸öÎïÁ÷ ......

MySQL ´¥·¢Æ÷ ´æ´¢¹ý³Ì Ò»µãСÓÃ

      Í¬ÊÂÀëÖ°£¬ÓÖÒ»¸öÒ»¸öÀÃ̯×ÓÒªÊÕÊ°¡£ÕâÀïÐÞÐÞ£¬ÄÇÀï²¹²¹¶¼Ã»Óо«Á¦À´Ð´µã¶«Î÷¡£
      Ã÷Ìì»Ø¼Ò£¬ÉÏÎçÕûÀíºÃÎĵµ¡£ÏÂÎç¾ö¶¨³éµãʱ¼ä£¬°Ñ×î½üµÄ¶«Î÷¾¡Á¿ÀíÒ»Àí¡£ºÜ¶àÁé¸Ð¶¼ÒѾ­ÒÅÍü¡£ÎÒÃÇ×ÜÔÚ²»¶ÏÃæ¶Ô£¬ËùÒÔÎÒÃDz»¶ÏÒÅÍü¡£¡¾syslog¡¢mysqlÓÅ»¯¡¢´¥·¢Æ÷¡¢´æ´¢ ......

MySql ´íÎó½â¾ö·½°¸

MySql Error Nr. 1045
¹Ø¼ü×Ö: error 1045
ÎÊÌâÃèÊö£º
Ò»¸ö¿Í»§µÄ·þÎñÆ÷£¨windows£©ÉÏÒѾ­×°ÁËÒ»¸öphp+apache+mysql£¬ÏÖÔÚÐèÒªÔÚÕą̂·þÎñÆ÷ÉÏÔÙ×°Ò»¸ö֪ʶ¿âϵͳ£¬
Êý¾Ý¿âÒ²ÊÇʹÓõÄmysql£¬È»ºó°²×°Ò»¸öеÄmysql£¬Ê¹ÓÃÁËеĶ˿ںͷþÎñÃû£¬
°²×°×îºóÒ»²½Ìáʾ“Error Nr. 1045 ......”£¬½øÈëMySQL Comm ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ