ÕýÔڲ鿴: ¹Ø¼ü×Ö mysql µÄËÑË÷½á¹û ( ¹² 72 Ìõ¼Ç¼ µÚ3Ò³/¹²8Ò³ )
MySQL Êý¾Ý¿âÐÔÄÜÓÅ»¯Ö®SQLÓÅ»¯
×¢£ºÕâƪÎÄÕÂÊÇÒÔMySQLΪ±³¾°£¬ºÜ¶àÄÚÈÝͬʱÊÊÓÃÓÚÆäËû¹ØϵÐÍÊý¾Ý¿â£¬ÐèÒªÓÐһЩË÷Òý֪ʶΪ»ù´¡ÓÅ»¯Ä¿±ê¼õÉÙIO´ÎÊýIOÓÀÔ¶ÊÇÊý¾Ý¿â×îÈÝÒ×Æ¿¾±µÄµØ·½£¬ÕâÊÇÓÉÊý¾Ý¿âµÄÖ°ÔðËù¾ö¶¨µÄ£¬´ó²¿·ÖÊý¾Ý¿â²Ù×÷Öг¬¹ý90%µÄʱ¼ä¶¼ÊÇIO²Ù×÷ËùÕ¼Óõģ¬¼õÉÙIO´ÎÊýÊÇSQLÓÅ»¯ÖÐÐèÒªµÚÒ»ÓÅÏÈ¿¼ÂÇ£¬µ±È»£¬Ò²ÊÇÊÕЧ×îÃ÷ÏÔµÄÓÅ»¯ÊֶΡ£½µµÍCPU¼ÆËã³ýÁËIOÆ¿¾±Ö®Í⣬SQLÓÅ»¯ÖÐÐèÒª¿¼ÂǵľÍÊÇCPUÔËËãÁ¿µÄÓÅ»¯ÁË¡£orderby,groupb...
À¸Ä¿£ºMysql ÔĶÁ£º367 ÆÀÂÛ£º0 ÈÕÆÚ£º2013-03-19 17:08:18 http://122.114.238.25/article-15279.html
MySQLÊý¾Ý¿âÐÔÄÜÓÅ»¯£º´æ´¢ÒýÇæÑ¡Ôñ
MySQLµÄ´æ´¢ÒýÇæ¿ÉÄÜÊÇËùÓйØϵÐÍÊý¾Ý¿â²úÆ·ÖÐ×î¾ßÓÐÌØÉ«µÄÁË£¬²»½ö¿ÉÒÔͬʱʹÓöàÖÖ´æ´¢ÒýÇ棬¶øÇÒÿÖÖ´æ´¢ÒýÇæºÍMySQLÖ®¼äʹÓòå¼þ·½Ê½ÕâÖַdz£ËɵÄñîºÏ¹Øϵ¡£ÓÉÓÚ¸÷´æ´¢ÒýÇ湦ÄÜÌØÐÔ²îÒì½Ï´ó£¬ÕâƪÎÄÕÂÖ÷ÒªÊǽéÉÜÈçºÎÀ´Ñ¡ÔñºÏÊʵĴ洢ÒýÇæÀ´Ó¦¶Ô²»Í¬µÄÒµÎñ³¡¾°¡£MyISAMÌØÐÔ²»Ö§³ÖÊÂÎñ£ºMyISAM´æ´¢ÒýÇæ²»Ö§³ÖÊÂÎñ£¬ËùÒÔ¶ÔÊÂÎñÓÐÒªÇóµÄÒµÎñ³¡¾°²»ÄÜʹÓÃ±í¼¶Ëø¶¨£ºÆäËø¶¨»úÖÆÊÇ±í¼¶Ë÷Òý£¬ÕâËäÈ»¿ÉÒÔÈÃËø¶¨µÄʵÏÖ
À¸Ä¿£ºMysql ÔĶÁ£º378 ÆÀÂÛ£º0 ÈÕÆÚ£º2013-03-19 15:28:40 http://122.114.238.25/article-15278.html
MysqlËø±í»úÖÆ,Êý¾Ý¿â¸ºÔØѹÁ¦²àÃæ½âÎö
ΪÁ˸ø¸ß²¢·¢Çé¿öϵÄmysql½øÐиüºÃµÄÓÅ»¯£¬ÓбØÒªÁ˽âÒ»ÏÂmysql²éѯ¸üÐÂʱµÄËø±í»úÖÆ¡£Ò»¡¢¸ÅÊöMySQLÓÐÈýÖÖËøµÄ¼¶±ð£ºÒ³¼¶¡¢±í¼¶¡¢Ðм¶¡£MyISAMºÍMEMORY´æ´¢ÒýÇæ²ÉÓõÄÊÇ±í¼¶Ëø£¨table-levellocking£©£»BDB´æ´¢ÒýÇæ²ÉÓõÄÊÇÒ³ÃæËø£¨page-levellocking£©£¬µ«Ò²Ö§³Ö±í¼¶Ëø£»InnoDB´æ´¢ÒýÇæ¼ÈÖ§³ÖÐм¶Ëø£¨row-levellocking£©£¬Ò²Ö§³Ö±í¼¶Ëø£¬...
À¸Ä¿£ºMysql ÔĶÁ£º419 ÆÀÂÛ£º0 ÈÕÆÚ£º2013-03-19 14:41:11 http://122.114.238.25/article-15277.html
Can't create a new thread (errno 11) ½â¾ö°ì·¨ mysqlÎÞ·¨Á¬½Ó
ÎÊÌâµÄÏÖÏ󣺴íÎóÐÅÏ¢£ºERROR1135(00000):Can'tcreateanewthread(errno11);ifyouarenotoutofavailablememory,youcanconsultthemanualforapossibleOS-dependentbÔÒò·ÖÎö£ººÍmysql±¾Éíû¹Øϵ²Ù×÷ϵͳÁ¬½ÓÊý̫У£¨±ÈÈçcentos6ĬÈϵÄmaxuserprocessÖ»ÓÐ1024¸ö¡£µ±mysqlprocess´óÓÚÕâ¸öֵʱ¾Í»á³öÏÖC...
À¸Ä¿£ºMysql ÔĶÁ£º2727 ÆÀÂÛ£º0 ÈÕÆÚ£º2013-02-22 14:46:30 http://122.114.238.25/article-15274.html
MYSQLÊý¾Ý¿âÖ®²åÈ뼫ÏÞ
1¡¢Èç¹ûͬʱ´Óͬһ¸ö¿Í»§¶Ë²åÈëºÜ¶àÐУ¬Ê¹Óú¬¶à¸öVALUEµÄINSERTÓï¾äͬʱ²åÈ뼸ÐС£Õâ±ÈʹÓõ¥ÐÐINSERTÓï¾ä¿ì(ÔÚijЩÇé¿öÏ¿켸±¶)¡£Èç¹ûÄãÕýÏòÒ»¸ö·Ç¿Õ±íÌí¼ÓÊý¾Ý£¬¿ÉÒÔµ÷½Úbulk_insert_buffer_size±äÁ¿£¬Ê¹Êý¾Ý²åÈë¸ü¿ì¡£²Î¼û5.3.3½Ú£¬¡°·þÎñÆ÷ϵͳ±äÁ¿¡±¡£2¡¢Èç¹ûÄã´Ó²»Í¬µÄ¿Í»§¶Ë²åÈëºÜ¶àÐУ¬ÄÜͨ¹ýINSERTDELAYEDÓï¾ä¼Ó¿ìËٶȡ£²Î¼û13.2.4½Ú£¬¡°INSERTÓï·¨¡±¡£3¡¢ÓÃMyIS...
À¸Ä¿£ºMysql ÔĶÁ£º1976 ÆÀÂÛ£º0 ÈÕÆÚ£º2013-02-20 23:48:33 http://122.114.238.25/article-15273.html
nginxʵÏÖmysqlµÄ¸ºÔؾùºâ
1.ÏÂÔØmoduleÄ£¿éÏÂÔصØÖ·£ºhttp://www.2cto.com/uploadfile/2012/0908/20120908102658486.zip$wget'http://nginx.org/download/nginx-1.2.1.tar.gz'$tar-xzvfnginx-1.2.1.tar.gz$cdnginx-1.2.1/$patch-p1
À¸Ä¿£ºMysql ÔĶÁ£º3068 ÆÀÂÛ£º0 ÈÕÆÚ£º2013-02-07 18:20:49 http://122.114.238.25/article-15269.html
ÀûÓÃKeepalived+mysql¹¹½¨¸ß¿ÉÓÃMySQLË«Ö÷×Ô¶¯ÇÐת
¹ØÓÚMySQL-HA£¬Ä¿Ç°ÓжàÖÖ½â¾ö·½°¸£¬±ÈÈçheartbeat¡¢drbd¡¢mmm¡¢¹²Ïí´æ´¢£¬µ«ÊÇËüÃǸ÷ÓÐÓÅȱµã¡£heartbeat¡¢drbdÅäÖýÏΪ¸´ÔÓ£¬ÐèÒª×Ô¼ºÐ´½Å±¾²ÅÄÜʵÏÖMySQL×Ô¶¯Çл»£¬¶ÔÓÚ²»»á½Å±¾ÓïÑÔµÄÈËÀ´Ëµ£¬ÕâÎÞÒÉÊÇÒ»ÖÖÄÔÁÑÎÊÌ⣻¶ÔÓÚmmm£¬Éú²ú»·¾³ÖкÜÉÙÓÐÈËÓã¬ÇÒmmm¹ÜÀí¶ËÐèÒªµ¥¶ÀÔËÐÐһ̨·þÎñÆ÷ÉÏ£¬ÒªÊÇÏëʵÏָ߿ÉÓ㬾͵öÔmmm¹ÜÀí¶Ë×öHA£¬ÕâÑùÎÞÒÉÓÖÔö
À¸Ä¿£ºLinux ÔĶÁ£º11524 ÆÀÂÛ£º0 ÈÕÆÚ£º2013-02-07 14:16:33 http://122.114.238.25/article-15266.html
Àí½âMySQL¡ª¡ª²¢ÐÐÊý¾Ý¿âÓë·ÖÇø(Partition)
ÔÎÄ£ºhttp://www.cnblogs.com/hustcat/archive/2009/12/24/1631674.html1¡¢²¢ÐÐÊý¾Ý¿â1.1¡¢²¢ÐÐÊý¾Ý¿âµÄÌåϵ½á¹¹²¢ÐлúµÄ³öÏÖ£¬´ßÉúÁ˲¢ÐÐÊý¾Ý¿âµÄ³öÏÖ£¬²»¶Ô£¬Ó¦¸ÃÊǹØϵÔËËã±¾À´¾ÍÊǸ߶ȿɲ¢Ðеġ£¶ÔÊý¾Ý¿âϵͳÐÔÄܵĶÈÁ¿Ö÷ÒªÓÐÁ½ÖÖ·½Ê½£º(1)ÍÌÍÂÁ¿(Throughput)£¬ÔÚ¸ø¶¨µÄʱ¼ä¶ÎÀïËùÄÜÍê³ÉµÄÈÎÎñÊýÁ¿£»(2)ÏìӦʱ¼ä(Responsetime)£¬µ¥
À¸Ä¿£ºMysql ÔĶÁ£º2253 ÆÀÂÛ£º0 ÈÕÆÚ£º2013-02-01 18:10:22 http://122.114.238.25/article-15262.html
Àí½âMySQL¡ª¡ª¸´ÖÆ(Replication)
ÔÎÄ£ºhttp://www.cnblogs.com/hustcat/archive/2009/12/19/1627525.html1¡¢¸´ÖƸÅÊö1.1¡¢¸´Öƽâ¾öµÄÎÊÌâÊý¾Ý¸´ÖƼ¼ÊõÓÐÒÔÏÂһЩÌص㣺(1)Êý¾Ý·Ö²¼(2)¸ºÔØƽºâ(loadbalancing)(3)±¸·Ý(4)¸ß¿ÉÓÃÐÔ(highavailability)ºÍÈÝ´í1.2¡¢¸´ÖÆÈçºÎ¹¤×÷´Ó¸ß²ãÀ´¿´£¬¸´ÖÆ·Ö³ÉÈý²½£º(1)master½«¸Ä±ä¼Ç¼µ½¶þ½øÖÆÈÕÖ¾(binary...
À¸Ä¿£ºMysql ÔĶÁ£º1933 ÆÀÂÛ£º0 ÈÕÆÚ£º2013-02-01 18:09:27 http://122.114.238.25/article-15261.html
Àí½âMySQL¡ª¡ªË÷ÒýÓëÓÅ»¯
ÔÎÄ£ºhttp://www.cnblogs.com/hustcat/archive/2009/10/28/1591648.htmlдÔÚÇ°Ã棺Ë÷Òý¶Ô²éѯµÄËÙ¶ÈÓÐ×ÅÖÁ¹ØÖØÒªµÄÓ°Ï죬Àí½âË÷ÒýÒ²ÊǽøÐÐÊý¾Ý¿âÐÔÄܵ÷ÓŵÄÆðµã¡£¿¼ÂÇÈçÏÂÇé¿ö£¬¼ÙÉèÊý¾Ý¿âÖÐÒ»¸ö±íÓÐ10^6Ìõ¼Ç¼£¬DBMSµÄÒ³Ãæ´óСΪ4K£¬²¢´æ´¢100Ìõ¼Ç¼¡£Èç¹ûûÓÐË÷Òý£¬²éѯ½«¶ÔÕû¸ö±í½øÐÐɨÃ裬×µÄÇé¿öÏ£¬Èç¹ûËùÓÐÊý¾ÝÒ³¶¼²»ÔÚÄڴ棬ÐèÒª¶ÁÈ¡10^4¸öÒ³Ã棬Èç...
À¸Ä¿£ºPHP´úÂë ÔĶÁ£º1870 ÆÀÂÛ£º0 ÈÕÆÚ£º2013-02-01 18:08:44 http://122.114.238.25/article-15260.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ÃüÁî