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

mysqlÖ÷´ÓÊý¾Ý¿âͬ²½ºÍ×Ö·û¼¯ÎÊÌâ

1.mysqlÖ÷´ÓÊý¾Ý¿âͬ²½ÎÊÌâ
 
ÔÚʹÓÃmysql 5.0 Ö÷´ÓÊý¾Ý¿âͬ²½Ê±Óöµ½ÎÊÌâһЩÎÊÌ⣺
ÔÚÖ÷´ÓÊý¾Ý¿âͬ²½Ê±£¬ÎÒÃÇ¿ÉÄÜ»áÑ¡ÔñÄÄЩÊý¾Ý¿âÒªÇóͬ²½£¬¶øÄÇЩÊý¾Ý¿âºöÊÓ£¬ÕâÁ½¸ö¹¦ÄÜÊÇ¿¿/etc/my.cnfÎļþÖеÄÁ½¸ö¼üÃû binlog_do_db ºÍ binlog_ignore_db À´ÊµÏÖµÄ
binlog_do_db = ÌîдÐèҪͬ²½µÄÊý¾Ý¿â£¬¶à¸öÊý¾Ý¿âÔòÓÑ£¬’¸ô¿ª
binlog_ignore_db = Ìîд²»Ðèͬ²½µÄÊý¾Ý¿â£¬¶à¸öÊý¾Ý¿âÓà ‘£¬’¸ô¿ª
Ö÷Êý¾Ý¿â¶ÁÈ¡¼üÖµ£¬¿ÉÑ¡ÔñÉú³ÉÊý¾Ý¿âÈÕÖ¾Îļþ¡£´Ó·þÎñÆ÷¸ù¾ÝÖ÷·þÎñÆ÷ÈÕÖ¾ÎļþÀ´¸üÐÂ×Ô¼ºµÄÊý¾Ý¿â
 
ÀíÂÛÉÏÕâЩ¶¼ÊÇ¿ÉÐеģ¬È»¶øÊµ¼ÊʵÏÖÖлáÓöµ½Ò»Ð©ÎÊÌ⣬ÎÊÌâÈçÏ£º
´ÓÖÕ¶ËÓà mysql -u -p Á¬½ÓmysqlÊý¾Ý¿â£¬Ö÷·þÎñÆ÷Ö´ÐÐÊý¾Ý¿â²Ù×÷£¬ÔÚbinlog_do_db·¶Î§ÄÚµÄÊý¾Ý¿â¶¼»á×öÈÕÖ¾¼Ç¼£¬Ê¹ÓÃmysqlÌṩµÄapiº¯ÊýÓóÌÐòÁ¬½ÓÊý¾Ý¿âÖ´ÐÐsqlÓï¾äȱ²»Ð´ÈëÈÕÖ¾
¼¸¾­ÖÜת²âÊÔ£¬ÖÕÓÚ·¢ÏÖ½«binlog_ignore_dbÈ¥µô£¬¶øÇÒÊÇÁ¬¼üÃûÒ»Æð×¢Ê͵ô£¬ÕâʱºòÖ÷´ÓÊý¾Ý¿âͬ²½·½¿É³É¹¦£¬APIº¯Êý½øÐеÄÊý¾Ý¿â²Ù×÷¿ÉÒÔдÈëÈÕÖ¾ÁË
 
Õâ²»ÖªÊǹٷ½bug£¬»¹ÊÇ×Ô¼ºÄÄ·½ÃæÅäÖÃÊý¾Ý¿â´íÎó¡£½â¾ö·½°¸Ä¿Ç°ÎªÖ¹Ö»ÏÞÓÚ´Ë¡£
                                                                                                                    £¨Ç®³Â£©
 2.mysql×Ö·û¼¯ÎÊÌâ
Êý¾Ý¿âÁ´½ÓÃüÁîÐÐÖÐÊäÈë
show variables like 'char%';
µÃµ½ÒÔϽá¹û
+--------------------------+----------------------------+
| Variable_name                | Value              &


Ïà¹ØÎĵµ£º

MySQL³£ÓÃÖ¸ÁºÏ


¼ÇÁËһЩÓà Windows µÄÃüÁîÐÐÀ´²Ù×÷ MySQL µÄÖ¸Áî¡£
ÕªÒª
Á¬½á MySQL
->mysql -u username -p
username ÊÇÄãµÄÕʺÅÃû³Æ¡£
Ô¶³ÌÁ¬½á
->mysql -h hostname -u username -p
hostname ÊÇ MySQL Ö÷»úµÄÃû³Æ¡£
ÏÔʾȫ²¿µÄÊý¾Ý¿â
SHOW DATABASES;
mysql ÊÇ MySQL ÓÃÀ´´¢´æÕʺźÍȨÏÞµÄÊý¾Ý¿â£¬²»ÄÜɾ³ý¡£
Ñ¡Ôñ ......

½â¾ömysqlÊý¾Ý¿âÖÐÎÄÂÒÂëÎÊÌâ

½â¾öÂÒÂë×îºÃµÄ·½·¨ÊÇÔÚÏîÄ¿Éè¼ÆÖ®³õ£¬Í³Ò»ËùÓеÄ×Ö·û¼¯£¬ÀýÈçÒ³Ãæ¡¢request¶ÔÏóÒÔ¼°Êý¾Ý¿âµÈµÈ¡£
Ò»¡¢ ¼¸ÖÖ³£¼ûµÄÂÒÂëÏÖÏó£º
1¡¢Ò³ÃæÂÒÂë
    µ¥´¿µÄÒ³ÃæÂÒÂëÊǺܺýâ¾öµÄ£¬Ö»ÒªÐÞ¸ÄÍ·²¿ÊʺϵÄ×Ö·û¼¯¼´¿É£¬Èç¹ûÒ³ÃæÖÐÎÄÏÔʾÂÒÂ룬Äã¿ÉÒÔ°Ñ×Ö·û¼¯ÐÞ¸ÄΪ£ºgb2312»ògbk¡£
2¡¢Ò³ÃæÖ®¼ä´«µÝµÄ²ÎÊýÊÇÂÒÂë ......

sqliteºÍpdo mysqlµÄÊý¾Ý¿â²Ù×÷

½ñÌìµÄѧϰÄÚÈÝÊÇsqliteºÍPDO mysql¡£
ÓÃ×Ô¼ºµÄ»°ËµËµÁ½¸ö¶«Î÷°É£º
sqliteËãÊÇÒ»ÖÖ²»ÏµÍ³µÄÊý¾Ý¿â´æ´¢·½Ê½£¬ËüµÄ´æ·Å¸ñʽÊÇÒ»¸ö.dbºó׺µÄÎļþ£¬ÔÚphpÖÐËü´æ·ÅÔÚµ±Ç°µÄĿ¼Ï£¬Ã²ËƲ»ÓÃÓû§ÃûÃÜÂ룬°²È«ÐԽϵͣ¬È´±È½Ï·½±ã¡£PHP5ÖÐ×Ô´øµÄһЩϵͳº¯Êý£¬¶¼ÊÇÒÔsqlite_¿ªÍ·µÄ¡£
PDOÈ«³ÆPHP Data Object£¬¹ËÃû˼Òå¾ÍÊÇPHPµÄÒ ......

MySQLÓï¾äÓÅ»¯µÄ»ù±¾Ô­Ôò

MySQLÓï¾äÓÅ»¯µÄ»ù±¾Ô­Ôò£º 
¡ô1¡¢Ê¹ÓÃË÷ÒýÀ´¸ü¿ìµØ±éÀú±í¡£ 
ȱʡÇé¿öϽ¨Á¢µÄË÷ÒýÊÇ·ÇȺ¼¯Ë÷Òý£¬µ«ÓÐʱËü²¢²»ÊÇ×î¼ÑµÄ¡£ÔÚ·ÇȺ¼¯Ë÷ÒýÏ£¬Êý¾ÝÔÚÎïÀíÉÏËæ»ú´æ·ÅÔÚÊý¾ÝÒ³ÉÏ¡£ºÏÀíµÄË÷ÒýÉè¼ÆÒª½¨Á¢ÔÚ¶Ô¸÷ÖÖ²éѯµÄ·ÖÎöºÍÔ¤²âÉÏ¡£Ò»°ãÀ´Ëµ£º 
a.ÓдóÁ¿Öظ´Öµ¡¢ÇÒ¾­³£Óз¶Î§²éѯ£¨ > ,< £¬> =,< ......

[ÔÓ¼Ç] ÐÂÄêÎïÓï&¹ØÓÚMysqlÒýÇæÐÔÄܲâÊÔ

æµµÄ2009ÖÕÓÚ¹ýÈ¥£¬Ò²ÖÕÓÚ°ÑÈËÉú´óÊÂæÍêÁË£¬»Øµ½Õý³£µÄ¹¤×÷Éú»îÖÐÀ´¡£2010¶ÔÎÒÀ´ËµÓ¦¸ÃÊdzäÂúÐÂÆÚÍûµÄÒ»Ä꣬ÐÂµÄÆõ»ú¾ÍÔÚÑÛǰ£¬¼ÓÓÍŬÁ¦°É~
ÁíÍâ×¼±¸12¸öÔÂÖ®ºóÔÙÀ´×ܽáһϽñÄêµÄÖØ´óʼǣ¬ºÇºÇ~
˳±ã¿´µ½Ò»¸öMysqlµÄ²âÊÔÎÄÕ£¬¸Ð¾õ»¹ÂúÓвο¼¼ÛÖµµÄ£¬ÓÚÊǼǼÏÂÀ´ÒÔ±ã²Î¿¼¡£
ÒÔÏÂÊÇÒ»¸öMySQLÖÐMyISAMÒýÇæÓëInnoDBÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ