ÕýÔڲ鿴: ¹Ø¼ü×Ö mysql µÄËÑË÷½á¹û ( ¹² 72 Ìõ¼Ç¼ µÚ5Ò³/¹²8Ò³ )
½â¾öMySQL server has gone awayÎÊÌâ
Ó¦ÓóÌÐò£¨±ÈÈçPHP£©³¤Ê±¼äµÄÖ´ÐÐÅúÁ¿µÄMYSQLÓï¾ä¡£Ö´ÐÐÒ»¸öSQL£¬µ«SQLÓï¾ä¹ý´ó»òÕßÓï¾äÖк¬ÓÐBLOB»òÕßlongblob×ֶΡ£±ÈÈ磬ͼƬÊý¾ÝµÄ´¦Àí¡£¶¼ÈÝÒ×ÒýÆðMySQLserverhasgoneaway¡£½ñÌìÓöµ½ÀàËƵÄÇé¾°£¬MySQLÖ»ÊÇÀäÀäµÄ˵£ºMySQLserverhasgoneaway¡£´ó¸Åä¯ÀÀÁËһϣ¬Ö÷Òª¿ÉÄÜÊÇÒòΪÒÔϼ¸ÖÖÔÒò£ºÒ»ÖÖ¿ÉÄÜÊÇ·¢Ë͵ÄSQLÓï¾äÌ«³¤£¬ÒÔÖ³¬¹ýÁËmax_allowed_pack...
À¸Ä¿£ºPHP´úÂë ÔĶÁ£º722 ÆÀÂÛ£º0 ÈÕÆÚ£º2012-03-02 08:04:29 http://122.114.238.25/article-7980.html
MySQL¿ªÆô¶à¸ö¶Ë¿Ú¼°¿âĿ¼²Ù×÷Îĵµ
²âÊÔ£¬ÇÒÔöж˿Ú3307Ò»¡¢´´½¨ÐµĿâĿ¼¡¢³õʼ»¯Êý¾Ý¿â¡¢¸³È¨mkdir/usr/local/mysql/var_3307/usr/local/mysql/bin/mysql_install_db--datadir=/usr/local/mysql/var_3307chown-Rmysql:mysql/usr/local/mysql/var_3307¶þ¡¢´´½¨ÐµÄÅäÖÃÎļþvi/etc/my_3307.cnf¼ÓÈëÒÔÏÂÄÚ...
À¸Ä¿£ºLinux ÔĶÁ£º421 ÆÀÂÛ£º0 ÈÕÆÚ£º2011-12-27 12:24:03 http://122.114.238.25/article-6666.html
¶à¸öMySql·þÎñÆ÷Êý¾Ý¿âͬ²½µÄÅäÖÃÓï¾ä
ÔÚÎÒÃÇʹÓÃMySqlÊý¾Ý¿âʱ£¬ÓÐʱ»áÐèÒª½øÐжà¸öMySql·þÎñÆ÷Êý¾Ý¿âͬ²½µÄÅäÖã¬ÏÂÃæ¾ÍΪÄú½éÉܸù¦ÄܵÄʵÏÖ·½·¨£¬Ï£Íû¶ÔÄúÓÐËù°ïÖú¡£
À¸Ä¿£ºPHP´úÂë ÔĶÁ£º548 ÆÀÂÛ£º0 ÈÕÆÚ£º2011-12-15 10:22:07 http://122.114.238.25/article-6537.html
CentOS°²×°×î¿ìWeb·þÎñÆ÷cherokee MySQL PHP
CherokeeºÅ³ÆÊÇÄ¿Ç°×î¿ìµÄWeb·þÎñÆ÷Èí¼þ£¬CherokeeµÄ¹¦ÄÜ°üÀ¨Ö§³ÖFastCGI¡¢SCGI¡¢PHP¡¢CGI¡¢TLS¼°SSL¼ÓÃÜÁ¬½Ó£¬ÐéÄâÖ÷»ú£¬ÊÚȨÈÏÖ¤£¬ÊµÊ±±àÂ룬ÔØÈë¾ùºâ£¬ÓëApache¼æÈݵÄlogÎļþµÈµÈ¡£CherokeeÄÚº¬Ò»¸öÃûΪcherokee-adminµÄ¹¤¾ß£¬Ö´Ðкó£¬ÔÊÐí¹ÜÀíÔ±Ö±½Óͨ¹ýä¯ÀÀÆ÷½øÈëhttp://localhost:9090/¶ÔÆä½øÐйÜÀíºÍÅäÖᣱÈÈ磬¿ªÆô»ò¹Ø±Õ·þÎñÆ÷£¬
À¸Ä¿£º½¨Õ¾¾Ñé ÔĶÁ£º168 ÆÀÂÛ£º0 ÈÕÆÚ£º2011-11-17 07:00:50 http://122.114.238.25/article-5596.html
MySQLÓëNoSQL¡ª¡ªSQLÓëNoSQLµÄÈÚºÏ
дÕâһƪÄÚÈݵÄÔÒòÊÇMySQL5.6.2ͻȻÍƳöÁËmemcachedµÄ¹¦ÄÜ¡£NoSQLtoInnoDBwithMemcachedµÄ³öÏÖ£¬¿ÉÒÔ¿´³öNoSQL¶Ô¹ØϵÊý¾Ý¿âµÄÈ·²úÉúÁ˾޴óµÄÓ°Ï죬¸öÈ˾õµÃÕâÊÇÒ»¸ö·Ç³£´óµÄ½ø²½£¬¿ÉÒÔÈÿª·¢ÈËÔ±¸ü¼Ó·½±ãµÄʹÓÃNoSQLºÍ¹ØϵÊý¾Ý¿â¡£NoSQLÒ»°ã±»ÈÏΪÐÔÄܸßÓÚ¹ØϵÊý¾Ý¿â£¬ÄÇôֱ½ÓÔÚInnoDBÖ®ÉÏÌṩNoSQL¹¦Äܲ¢ºÍMySQL¹²´æÊÇ·ñÊÇÒ»¸ö¸üºÃµÄÑ¡ÔñÄØ£¿MySQLwithHandlerS...
À¸Ä¿£ºPHP´úÂë ÔĶÁ£º307 ÆÀÂÛ£º0 ÈÕÆÚ£º2011-11-11 07:53:05 http://122.114.238.25/article-5420.html
MySQL£ºÈÕÆÚº¯Êý¡¢Ê±¼äº¯Êý×ܽá
Ò»¡¢MySQL»ñµÃµ±Ç°ÈÕÆÚʱ¼äº¯Êý1.1»ñµÃµ±Ç°ÈÕÆÚ+ʱ¼ä£¨date+time£©º¯Êý£ºnow()mysql>selectnow();+---------------------+|now()|+---------------------+|2008-08-0822:20:46|+---------------------+³ýÁËnow()º¯ÊýÄÜ»ñµÃµ±Ç°µÄÈÕÆÚʱ¼äÍ⣬MySQLÖл¹ÓÐÏÂÃæµÄº¯Êý£ºcurrent_timestam...
À¸Ä¿£ºPHP´úÂë ÔĶÁ£º167 ÆÀÂÛ£º0 ÈÕÆÚ£º2011-11-11 07:42:42 http://122.114.238.25/article-5417.html
ProFTPd°²×°±Ê¼Ç Ö§³ÖMysqlÐéÄâÓû§ÈÏÖ¤ºÍQuotasÏÞ¶î
±¾½Ì³ÌÀ´Ô´ÓÚLinuxsir.org£¬ÓÉÓڽ̳ÌÒѾÊǼ¸ÄêÇ°µÄÁË£¬ÓкܶàÔ´¶¼ÒѾʧЧÁË£¬ÏÂÃæµÄ½Ì³ÌÔÚÔ´ºÍÆäËû·½ÃæºÍÔÎÄÓÐСµØ·½½øÐÐÁËÐ޸ġ£ÏµÍ³£ºCentOS5.5x86£¨·þÎñÆ÷»·¾³Ê¹ÓÃLNMP0.7ÅäÖã©ProFTPd°æ±¾£ºproftpd-1.3.0a.tar.gzÏÂÃæ¾Í¿ªÊ¼¶ÔCentOS°²×°ProFTPd·þÎñ¡£ProFtpd1.3.0aÏÂÔصØÖ·£ºftp://ftp.ch.proftpd...
À¸Ä¿£º½¨Õ¾¾Ñé ÔĶÁ£º181 ÆÀÂÛ£º0 ÈÕÆÚ£º2011-11-09 18:35:51 http://122.114.238.25/article-5360.html
½â¾öMysql(MyISAM)µÄ¶Áд»¥³âËøµÄÎÊÌâ
×î½üÒòΪÊý¾Ý¿â¶ÁµÄÇëÇóÔö¼Ó£¬³öÏÖÁ˱ȽÏÑÏÖصĶÁдËøÎÊÌ⣬ÓÉÓÚÖ÷´Ó·ÖÀ룬Ö÷·þÎñÆ÷ºÜ¿ìµÄÖ´ÐÐÍêÁËдÈëµÄ²Ù×÷£¬µ«´Ó¿âÓÉÓÚÓдóÁ¿µÄselectµÄ²éѯ£¬»á±»ÕâЩÀ´×ÔÖ÷¸¨Í¬²½µÄupdate,insertÑÏÖضÂÈû£¬×îºóÔì³ÉËùÓеÄMysql´Ó¿â¸ºÔØѸËÙÉÏÉý¡£ÓÉÓÚû°ì·¨ÔÚ¶ÌÆÚÄÚÔö¼Ó¶ÁµÄ·þÎñÆ÷£¬ËùÒÔ²ÉÈ¡¶ÔMysql½øÐÐÁËһЩÅäÖã¬ÒÔÎþÉüÊý¾ÝʵʱÐÔΪ´ú¼Û£¬À´»»È¡ËùÓзþÎñÆ÷µÄÉúÃü°²È«¡£ºÇºÇ£¬¾ßÌåÏà¹Øµ÷ÕûÒÔ¼°Ë¼Â·ÈçÏ£ºMyISAMÔÚ¶Á²Ù×÷Õ¼Ö÷µ¼µÄÇé¿öÏÂÊÇ
À¸Ä¿£ºPHP´úÂë ÔĶÁ£º421 ÆÀÂÛ£º0 ÈÕÆÚ£º2011-10-14 08:20:07 http://122.114.238.25/article-5326.html
MySQL ÐÔÄܼà¿Ø
Ò»£¬»ñÈ¡mysqlÓû§ÏµĽø³Ì×ÜÊýps-ef|awk'{print$1}'|grep"mysql"|grep-v"grep"|wc-1¶þ£¬Ö÷»úÐÔÄÜ״̬#uptime[root@~]#uptime13:05:52up53days,52min,1user,loadaverage:0.00,0.00,0.00Èý£¬CPUʹÓÃÂÊ#top»ò#vmstatËÄ£¬´ÅÅÌIOÁ¿#vmstat»ò#iostatÎ壬swap½ø³öÁ¿[ÄÚ´æ]#freeÁù£¬Êý¾Ý¿âÐÔÄÜ״̬...
À¸Ä¿£ºPHP´úÂë ÔĶÁ£º381 ÆÀÂÛ£º0 ÈÕÆÚ£º2011-10-14 08:07:54 http://122.114.238.25/article-5323.html
6¸öÓÐÓõÄMySQLÓï¾ä
½ñÌì¸ø´ó¼Ò½éÉÜÁùÌõ±È½ÏÓÐÓõÄMySQLµÄSQLÓï¾ä£¬¿ÉÄܺܶàÈ˶¼Í¨¹ýPHPÀ´ÊµÏÖÕâЩ¹¦ÄÜ¡£1.¼ÆËãÄêÊýÄãÏëͨ¹ýÉúÈÕÀ´¼ÆËãÕâ¸öÈËÓм¸ËêÁË¡£SELECTDATE_FORMAT(FROM_DAYS(TO_DAYS(now())-TO_DAYS(@dateofbirth)),'%Y')+0;2.Á½¸öʱ¼äµÄ²îÈ¡µÃÁ½¸ödatetimeÖµµÄ²î¡£¼ÙÉèdt1ºÍdt2ÊÇdatetimeÀàÐÍ£¬Æä¸ñʽΪ¡®yyyy-mm-ddhh:mm:ss¡¯£¬ÄÇôËüÃÇÖ®¼äËù²îµÄ...
À¸Ä¿£ºPHP´úÂë ÔĶÁ£º236 ÆÀÂÛ£º0 ÈÕÆÚ£º2011-10-10 23:07:04 http://122.114.238.25/article-5320.html
ÍƼöÐÅÏ¢
- linuxÃüÁîѧϰ±Ê¼Ç£¨11£©£ºnlÃüÁî
- MySQLË÷Òý±³ºóµÄÊý¾Ý½á¹¹¼°Ëã·¨ÔÀí
- mysql¿ª·¢ºÍÓÅ»¯µÄ36Ìõ¾ü¹æ
- mysql´¢´æʱ¼äÑ¡ÔñÔõÑùµÄ×Ö¶ÎÀàÐÍ
- ʹÓÃMySQL Proxy½â¾öMySQLÖ÷´Óͬ²½ÑÓ³Ù
- ¹ØÓÚmysql Ë÷ÒýµÄ×ܽá
- linuxÃüÁîѧϰ±Ê¼Ç£¨5£©£ºrmÃüÁî
- ¡¾ÊÓƵ²¥·Å¡¿JplayerÊÓƵ²¥·ÅÆ÷µÄʹÓÃ
- linuxÃüÁîѧϰ±Ê¼Ç£¨4£©£ºmkdirÃüÁî
- linuxÃüÁîѧϰ±Ê¼Ç£¨1£©£ºlsÃüÁî
ÈÈÃÅÐÅÏ¢
- nohup: redirecting stderr to stdou....
- ʹÓÃlog_formatΪNginx·þÎñÆ÷ÉèÖøüÏêϸµÄÈÕÖ¾¸ñʽ
- jquery easyUI--dataGrid-Json
- ÀûÓÃKeepalived+mysql¹¹½¨¸ß¿ÉÓÃMySQLË«Ö÷×Ô¶....
- [Ô´´]·ÂGoogle Reader¡¢ÐÂÀË΢²©¡¢ÌÚѶ΢²©µ....
- Nginx+keepalivedʵÏÖ¸ºÔؾùºâºÍË«»úÈȱ¸¸ß¿ÉÓÃ
- jqueryʵÏÖÒ³Ãæ¼ÓÔؽø¶ÈÌõ
- Rolling cURL: PHP²¢·¢×î¼Ñʵ¼ù
- codeigniter ·ÓÉÖÕ¼«ÓÅ»¯(url rewrite)
- linuxÏÂÉèÖÃsshÎÞÃÜÂëµÇ¼
×î½ü¸üÐÂ
- PHP»ñÈ¡Óû§µÄÕæʵIP£¬²¢ÅжÏÊÇ·ñÄÚÍøIP
- ²éÕÒ²¢É¾³ý.svnĿ¼Îļþ
- redis ÆßÖÖÊý¾ÝÀàÐ͵ÄʹÓó¡¾°
- linux ÏÂÎļþ¸´ÖƵ½windowsÏÂÂÒÂëµÄ½â¾ö°ì·¨
- PHP ´íÎóÈÕÖ¾ error_log
- mysqlµÄsql_modeºÏÀíÉèÖÃ
- nginx³öÏÖ502 upstream sent too big he....
- linuxÏÂsudoÅäÖÃÏê½â
- linuxÃüÁîѧϰ±Ê¼Ç£¨15£©£ºtailÃüÁî
- linuxÃüÁîѧϰ±Ê¼Ç£¨14£©£ºheadÃüÁî