ÕýÔڲ鿴: ¹Ø¼ü×Ö mysql µÄËÑË÷½á¹û ( ¹² 72 Ìõ¼Ç¼ µÚ4Ò³/¹²8Ò³ )
Àí½âMySQL¡ª¡ª¼Ü¹¹Óë¸ÅÄî
ÔÎÄ£ºhttp://www.cnblogs.com/hustcat/archive/2009/10/18/1585626.htmlдÔÚÇ°Ã棺×îÔç½Ó´¥µÄMySQLÊÇÔÚÈýÄêÇ°£¬ÄÇʱºòMySQL»¹ÊÇ4.x°æ±¾£¬ºÜ¶à¹¦Äܶ¼²»Ö§³Ö£¬±ÈÈ磬´æ´¢¹ý³Ì£¬ÊÓͼ£¬´¥·¢Æ÷£¬¸ü±ð˵·Ö²¼Ê½ÊÂÎñµÈ¸´ÔÓÌØÐÔÁË¡£µ«´Ó5.0(2005Äê10ÔÂ)¿ªÊ¼£¬MySQL½¥½¥²½ÈëÆóÒµ¼¶Êý¾Ý¿âµÄÐÐÁÐÁË£»¸´ÖÆ¡¢¼¯Èº¡¢·ÖÇø¡¢·Ö²¼Ê½ÊÂÎñ£¬ÕâЩ...
À¸Ä¿£ºPHP´úÂë ÔĶÁ£º1722 ÆÀÂÛ£º0 ÈÕÆÚ£º2013-02-01 18:08:06 http://122.114.238.25/article-15259.html
mysqlѹÁ¦²âÊÔ¹¤¾ßmysqlslapʹÓýéÉÜ
¹¤¾ßÔËÐзÖΪ4¸ö²½Ö裺´´½¨Êý¾Ý¿âºÍ±í²åÈëÊý¾ÝÖ´Ðвéѯ¸üеȲÙ×÷query£¨²âÊÔµÄÖ÷ÒªÄÚÈÝ£©ÒÔϳÆΪ²éѯɾ³ýÊý¾Ý¿â1.ʹÓÃ×Ô¶¯Éú³ÉµÄ½Å±¾²âÊÔmysqlslap--help¿ÉÒԲ鿴¾ßÌåµÄ²ÎÊýµÄÓ÷¨Àý×Ó£ºmysqlslap--concurrency=50,100,200--iterations=20--number-int-cols=4--number-char-cols=35--auto-generate-sql--auto-genera...
À¸Ä¿£ºLinux ÔĶÁ£º807 ÆÀÂÛ£º0 ÈÕÆÚ£º2013-01-21 18:35:56 http://122.114.238.25/article-15247.html
ʹÓÃmysql workbenchͼÐλ¯±¸·Ý»Ö¸´mysqlÊý¾Ý¿â
±¾ÎļòÒª½éÉÜÒ»¸ö¼òµ¥ºÃÓõÄͼÐνçÃ汸·Ý»Ö¸´mysqlÊý¾Ý¿âµÄ·½·¨£¬Ê¹ÓÃworkbenchͼÐνçÃæ½øÐÐmysqlÊý¾Ý¿â»Ö¸´±¸·Ý¡£¶ÔÄÇЩ²»Ï²»¶Ê¹ÓÃÃüÁîÐеÄÅóÓÑÏàÐÅÓаïÖú¡£ workbenchÊÇmysqlAB¹«Ë¾³öµÄÒ»¿î¿ÉÊÓ»¯²Ù×÷mysqlµÄ¹¤¾ß£¬¶ÔÓÚÏ°¹ßʹÓÃwindowsͼÐλ¯½çÃæ²Ù¿ØµÄÓû§À´Ëµ£¬ÕâÊÇÒ»¸ö·Ç³£ºÃµÄ¹¤¾ß¡£µ±È»»¹ÓÐÒ»¿î´ó¼ÒºÜÊìϤµÄ»ùÓÚä¯ÀÀÆ÷²Ù×÷µÄͼÐνçÃæ mysqlÊý¾Ý¿â²Ù×÷Èí¼þ--p...
À¸Ä¿£º½¨Õ¾¾Ñé ÔĶÁ£º184 ÆÀÂÛ£º0 ÈÕÆÚ£º2012-12-19 06:57:29 http://122.114.238.25/article-14999.html
MySQL¶àÏß³Ìͬ²½MySQL-Transfer½éÉÜ
ÔÎĵØÖ·£ºhttp://dinglin.iteye.com/blog/1581877Ò»¡¢¹ØÓÚTransferMySQL-Transefer£¨Ï³ÆTransfer£©ÊÇÒ»¸ö»ùÓÚMySQL+patchºóµÃµ½µÄÖ÷´Óͬ²½¹¤¾ß¡£ÆäÖ÷ҪĿµÄÊÇΪÁ˽â¾öÔÉú°æ±¾µÄÖ÷´Óͬ²½À´Ó¿âÊǵ¥Ïß³ÌapplyÖ÷¿âµÄbinlog£¬µ¼ÖµÄÑÓ³Ù¡£×î½üÍê³É²âÊԵİ汾½«multi-master(byP.Linux)ºÏ²¢µ½TransferÖв¢Õë
À¸Ä¿£ºPHP´úÂë ÔĶÁ£º989 ÆÀÂÛ£º0 ÈÕÆÚ£º2012-11-26 10:49:04 http://122.114.238.25/article-14434.html
CentOS ϵͳʵÏÖ×Ô¶¯±¸·ÝMYSQL ·¢ÍùÔ¶³ÌFTP
ÍøÕ¾×îÖØÒªµÄÊÇÊý¾Ý£¬¿ÉÃ÷ÌìÊÖ¶¯±¸·Ý»¹ÊÇÌ«·±ËöÁË£¬¶øÇÒÓÐʱºòÅÂÍü¼Ç£¬ÓÈÆäÊÇʹÓÃVPSµÄÅóÓÑ£¬Ëµ²»¶¨ÄÇÌìIDCÅÜ·Á˾ÍÍêµ°ÁË£¬ËùÒÔ½ñÌì¸ø´ó¼Ò×¼±¸Ò»¸ö×Ô¶¯±¸·ÝMYSQLÊý¾Ý¿âµÄ½Å±¾£¬ÍøÉÏÓв»ÉÙÀàËƵĽű¾£¬²»¹ý²âÊÔÁ˼¸¸ö²»ÊÇÕâ¸öÎÊÌâ¾ÍÊÇÄǸöÎÊÌ⣬Ҫ²»¾ÍÖ»Äܱ¸·Ýµ¥¸öÊý¾Ý¿âµ¼³öSQLÎļþ¡£·´Õý²»ÊÇÌرðÀíÏë¡£ÍíÉÏÑ¡ÔñÁËÆäÖÐÒ»¸ö²âÊÔÁË°ëÌìÎÞ·¨ÉÏ´«£¬·ÔÄ×ÊÁÏ×öÁËÒ»µãµãÐ޸ģ¬OKÁË£¬ÒÔÍêÈ«¿ÉÒÔÕý³£Ê¹ÓÃÁË£¬¾Í·ÖÏí³öÀ´¹©´ó¼Ò²Î¿¼°É
À¸Ä¿£º½¨Õ¾¾Ñé ÔĶÁ£º153 ÆÀÂÛ£º0 ÈÕÆÚ£º2012-10-23 06:58:59 http://122.114.238.25/article-13683.html
ÈçºÎÿÌì×Ô¶¯±¸·ÝMySqlÎļþ
Ëæ×ÅÊý¾Ý¿âÔÚÍøÕ¾½¨ÉèÖеIJ»¶ÏÓ¦Óã¬ÏÖÈç½ñ¾ø´ó¶àÊýÍøÕ¾ÒѾÀë²»¿ªÊý¾Ý¿âÖ§³ÖÁË£¬ÒòΪÊý¾Ý¿â²»½ö¿ÉÒÔ´æ´¢ÍøÕ¾ÄÚÈݵÈÐÅÏ¢£¬»¹¿ÉÒÔ´æ´¢Óû§Ìá½»µÄÐÅÏ¢¡£ÓÉÓÚÕâЩÐÅÏ¢·Ç³£±¦¹ó£¬Ò»µ©¶ªÊ§¼¸ºõÄÑÒÔÍì»Ø¡£ ËùÓÐÕ¾³¤²»½öҪעÒⱸ·Ý·þÎñÆ÷ÉϵÄÍøÒ³htmlÎļþ£¬Í¼Æ¬»òÕß³ÌÐò´úÂ룬»¹Òª¶ÔÊý¾Ý¿âÎļþÓÅÏȽøÐб¸·Ý¡£ ×î¼òµ¥µÄÊý¾Ý¿â±¸·Ý¿ÉÒÔͨ¹ýphpMyAdminÊÖ¶¯±¸·Ý²¢ÏÂÔØÎļþµ½Ö¸¶¨Î»Ö㬵«ÊǶÔÓÚÄÇЩÐèҪÿÌ켰ʱ±¸·Ý
À¸Ä¿£º½¨Õ¾¾Ñé ÔĶÁ£º146 ÆÀÂÛ£º0 ÈÕÆÚ£º2012-09-01 06:59:47 http://122.114.238.25/article-12823.html
Mysql Êý¾Ý¿âÖÐMysqlbinlogµÄʹÓÃ
1.binlogÈÕÖ¾´ò¿ª·½·¨ÔÚmy.cnfÕâ¸öÎļþÖмÓÒ»ÐУ¨WindowsΪmy.ini£©¡£#vi/etc/my.cnf[mysqld]log-bin=mysqlbin-log#Ìí¼ÓÕâÒ»ÐоÍokÁË=ºÅºóÃæµÄÃû×Ö×Ô¼º¶¨Òå°ÉÈ»ºóÎÒÃÇ¿ÉÒÔ¶ÔÊý¾Ý¿â×ö¼òµ¥µÄ²Ù×÷ºóµ½mysqlÊý¾ÝÎļþËùÔÚµÄĿ¼À´¿´binlogÎļþ¡£2.²é¿´×Ô¼ºµÄBINLOGµÄÃû×ÖÊÇʲôÃüÁî:showbinarylogsÒÔºóÿ´Î¶Ô±íµÄÏà¹Ø²Ù×÷ʱºò,Õâ¸öFile_size¶¼
À¸Ä¿£ºLinux ÔĶÁ£º297 ÆÀÂÛ£º0 ÈÕÆÚ£º2012-08-18 11:01:23 http://122.114.238.25/article-12535.html
·ÀÖ¹mysqlÓû§rootÃÜÂëÈõ¿ÚÁîµÄ¹¥»÷·½·¨
1¡¢Á¬½Óµ½¶Ô·½MYSQL·þÎñÆ÷mysql-uroot-h192.168.0.1mysql.exeÕâ¸ö³ÌÐòÔÚÄã°²×°ÁËMYSQLµÄµÄBINĿ¼ÖС£2¡¢ÈÃÎÒÃÇÀ´¿´¿´·þÎñÆ÷ÖÐÓÐЩʲôÊý¾Ý¿âmysql>showdatabases;MYSQLĬÈÏ°²×°Ê±»áÓÐMYSQL¡¢TESTÕâÁ½¸öÊý¾Ý¿â£¬Èç¹ûÄã¿´µ½ÓÐÆäËüµÄÊý¾Ý¿âÄÇô¾ÍÊÇÓû§×Ô½¨µÄÊý¾Ý¿â¡£3¡¢ÈÃÎÒÃǽøÈëÊý¾Ý¿âmysql>usetest;ÎÒÃǽ«»á½øÈëtestÊý¾Ý¿âÖС£4¡¢²é¿´ÎÒÃǽøÈëÊý...
À¸Ä¿£ºPHP´úÂë ÔĶÁ£º1057 ÆÀÂÛ£º0 ÈÕÆÚ£º2012-05-19 07:33:35 http://122.114.238.25/article-10383.html
Windows XPÏ°²×°ºÍÅäÖÃApache2.2.22·þÎñÆ÷+PHP5+Mysql5
Ëæ×ÅPHPÍøÕ¾µÄÁ÷ÐУ¬¹úÄÚÔ½À´Ô½¶àµÄÕ¾³¤Ê¹ÓÃphp¿ª·¢ÍøÕ¾»òÕßʹÓÃÏà¹ØµÄphp¿ªÔ´ÍøÕ¾£¨ÀýÈ磺DeDeCMS¡¢phpWind¡¢¿µÊ¢µÄDiscuz!¡¢wordpressµÈһЩĿǰ±È½ÏÁ÷ÐеĿªÔ´ÍøÕ¾£©£¬¶ÔÓÚһЩ¸Õ¿ªÊ¼½Ó´¥PHPÓïÑÔ»òÕ߸տªÊ¼½¨Á¢×Ô¼ºÕ¾µãµÄÈËÀ´Ëµ£¬ÔÚ±¾µØ²âÊÔphpÍøÕ¾ÎÞÒÉÊǼþ·Ç³£ÖØÒªµÄÊÂÇ飬ÒòΪÕâÑù¿ÉÒÔÔÚ±¾µØ×öÈô¸ÉµÄµ÷ÊÔ£¬¶ø²»ÓÃÈ¥µ£ÐÄÍøÂçÎÊÌâÒÔ¼°ÔËÓªÉÌÎÊÌâ¡£½ÓÏÂÀ´£¬±ÊÕß½«Wi...
À¸Ä¿£º½¨Õ¾¾Ñé ÔĶÁ£º143 ÆÀÂÛ£º0 ÈÕÆÚ£º2012-05-17 07:02:30 http://122.114.238.25/article-10336.html
MySQLÖ÷´Óʧ°Ü, ´íÎóGot fatal error 1236½â¾ö·½·¨
ÔÎÄ£ºhttp://ritto.blog.51cto.com/427838/735810ÓÉÓÚÖ÷·þÎñÆ÷ÒìÍâÖØÆô,µ¼Ö´ӱ¨´í,´íÎóÈçÏÂ:showslavestatus´íÎó:mysql>showslavestatus\GMaster_Log_File:mysql-bin.000288Read_Master_Log_Pos:627806304Relay_Log_File:mysql-relay-bin.000990Relay_Log_Po...
À¸Ä¿£ºPHP´úÂë ÔĶÁ£º310 ÆÀÂÛ£º0 ÈÕÆÚ£º2012-04-23 13:51:22 http://122.114.238.25/article-9615.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ÃüÁî