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

ÈçºÎÑ¡ÔñºÏÊʵÄmysql´æ´¢ÒýÇæ

    ÔÚÑ¡Ôñ´æ´¢ÒýÇæÊ±£¬Ó¦¸ù¾ÝÓ¦ÓÃÌØµãÑ¡ÔñºÏÊʵĴ洢ÒýÇæ£¬¶ÔÓÚ¸´ÔÓµÄÓ¦ÓÃϵͳ¿ÉÒÔ¸ù¾Ýʵ¼ÊÇé¿öÑ¡Ôñ¶àÖÖ´æ´¢ÒýÇæ½øÐÐ×éºÏ¡£
ÏÂÃæÊdz£Óô洢ÒýÇæµÄÊÊÓû·¾³¡£
¡ñMyISAM:ĬÈϵÄMysql²å¼þʽ´æ´¢ÒýÇæ¡£Èç¹ûÓ¦ÓÃÊÇÒÔ¶ÁдºÍ²åÈë²Ù×÷ΪÖ÷£¬Ö»ÓкÜÉÙ¸üкÍɾ³ý²Ù×÷£¬²¢ÇÒ¶ÔÊÂÎñÍêÕûÐÔ£¬²¢·¢ÐÔÒªÇó²»ÊǺܸߣ¬ÄÇôѡÔñÕâ¸ö´æ´¢ÒýÇæ·Ç³£Êʺϵġ£MyISAMÊÇÔÚWeb£¬Êý¾Ý²Ö´¢ºÍÆäËûÓ¦Óû·¾³ÏÂ×î¾­³£Ê¹ÓõĴ洢ÒýÇæÖ®Ò»
¡ñInnoDB:ÓÃÓÚÊÂÎñ´¦ÀíÓ¦ÓóÌÐò£¬Ö§³ÖÍâ¼ü¡£Èç¹ûÓ¦ÓöÔÊÂÎñµÄÍêÕûÐÔÓбȽϸߵÄÒªÇó£¬ÔÚ²¢·¢Ìõ¼þÏÂÒªÇóÊý¾ÝµÄÒ»ÖÂÐÔ£¬Êý¾Ý²Ù×÷³ýÁ˲åÈëºÍ²éѯÒÔÍ⣬»¹°üÀ¨ºÜ¶àµÄ¸üкÍɾ³ý²Ù×÷£¬ÄÇôinnoDB´æ´¢ÒýÇæÓ¦¸ÃÊDZȽϺÏÊʵÄÑ¡Ôñ¡£InnoDB´æ´¢ÒýÇæ³ýÁËÓÐЧµÄ½µµÍÓÉÓÚɾ³ýºÍ¸üе¼ÖµÄËø¶¨£¬»¹¿ÉÒÔÈ·±£ÊÂÎñµÄÍêÕûÌá½»£¨commit£©ºÍ»Ø¹ö£¨rollback£©£¬¶ÔÓÚÀàËÆ¼Æ·Ñϵͳ»òÕß²ÆÎñϵͳµÈ¶ÔÊý¾Ý׼ȷÐÔÒªÇó¸ßµÄϵͳ£¬InnoDBÊDZȽϺÏÊʵÄÑ¡Ôñ¡£
¡ñMEMORY£º½«ËùÓÐÊý¾Ý±£´æÔÚÄÚ´æÖУ¬ÔÚÐèÒª¿ìµÝ¶¨Î»¼Ç¼ºÍÆäËûÀàËÆÊý¾ÝµÄ»·¾³Ï£¬¿ÉÌṩ¼«¿ìµÄ·ÃÎÊ¡£MEMORY µÄȱÏÝÊǶԱíµÄ´óСÓÐÏÞÖÆ£¬Ì«´óµÄ±íÎÞ·¨cacheÔÚÄÚ´æÖУ¬Æä´ÎÊÇҪȷ±£±íµÄÊý¾Ý¿ÉÒÔ»Ö¸´£¬Êý¾Ý¿âÒì³£ÖÕÖ¹ºǫ́±íµÄÊý¾Ý¿ÉÒÔ»Ö¸´µÄ£¬MEMORYÖÐͨ³£ÓÃÓÚ¸üв»Ì«Æµ·±µÄС±í£¬ÓÃÓÚ¿ìËٵõ½·ÃÎʽá¹û¡£
¡ñMERGE£ºÓÃÓÚ½«Ò»ÏµÁеÈͬµÄMyISAM±íÒÔÂß¼­·½Ê½×éºÏÔÚÒ»Æð£¬²¢×÷Ϊ¶ÔÏóÒýÓÃËûÃÇ£¬MERGE±íµÄÓеãÔÚÓÚ¿ÉÒÔÍ»ÆÆ¶Ôµ¥¸öMyISAM±í´óСµÄÏÞÖÆ£¬²¢Í¨¹ý½«²»Í¬µÄ±í·Ö²¼ÔÚ¶à¸ö´ÅÅÌÉÏ£¬¿ÉÒÔÓÐЧµÄ¸ÄÉÆMERGE±íµÄ·ÃÎÊЧÂÊ¡£Õâ¶ÔÓëÖîÈçÊý¾Ý²Ö´¢µÈVLDB»·¾³Ê®·ÖÊʺϡ£


Ïà¹ØÎĵµ£º

mysql alter Óï¾äÓ÷¨,Ìí¼Ó¡¢Ð޸ġ¢É¾³ý×ֶεÈ


 Ô´µØÖ·: http://www.pcppc.cn/shujuku/mysql/shujuku_163919.html
 
 
ÄúÕýÔÚ¿´µÄMySQL½Ì³ÌÊÇ:MySQLÊý¾Ý¿âѧϰ±Ê¼Ç¡£
¡¡¡¡MySQLÊý¾Ý¿âѧϰ±Ê¼Ç 
(ʵÑé»·¾³:Redhat9.0,MySQL3.23.54) 
¸ÙÒª£º 
Ò»£¬Á¬½ÓMySQL 
¶þ£¬MySQL¹ÜÀíÓëÊÚȨ 
Èý£¬Êý¾Ý¿â¼òµ¥²Ù×÷ 
ËÄ, ......

phpmyadminÁ¬½Ó¶à¸öMySQLÊý¾Ý¿â


ÔÚphpmyadminµÄ¸ùĿ¼Ï½¨Á¢config.inc.php
дÈëÈçÏ´úÂ룺
<?php
//phpmyadmin ÅäÖÃÎļþ
//±¾µØMySQLÊý¾Ý¿â
$i=1;
$cfg['Servers'][$i]['host']          =
'localhost';
$cfg['Servers'][$i]['user']          ......

MySQLÊý¾ÝÀàÐÍÓ뽨¿â²ßÂÔµÄÏêϸ½âÎö

´ËÎÄÕÂÖ÷ÒªÃèÊöµÄÊÇMySQLÊý¾ÝÀàÐÍÓ뽨¿â²ßÂÔµÄÏêϸ½âÎö£¬ÎÒÃÇ´ó¼Ò¶¼ÖªµÀÎÞÂÛÊÇÔÚ²»ÊշѵÄÊý¾Ý¿â¿Õ¼ä»òÕßÊÇ´óÐ͵ĵç×ÓÉÌÎñÍøÕ¾£¬ÆäºÏÀíµÄÉè¼Æ±í½á¹¹¡¢³ä·ÖÀûÓÿռäÊÇÊ®·Ö±ØÒªµÄ¡£
¡¡¡¡Õâ¾ÍÒªÇóÎÒÃǶÔÊý¾Ý¿âϵͳµÄ³£ÓÃMySQLÊý¾ÝÀàÐÍÓгä·ÖµÄÈÏʶ¡£ÏÂÃæÎҾͽ«ÎÒµÄÒ»µãÐĵÃд³öÀ´¸ú´ó¼Ò·ÖÏí¡£
¡¡¡¡Ò»¡¢MySQLÊý¾ÝÀàÐÍÖ®Êý×ÖÀàÐ ......

½«ÈÕÖ¾ÎļþдÈëMySqLÖÐ

Ê×ÏȽ¨Ò»¸ö¹¤³Ì£¬×¼±¸ºÃÒ»¸ölog4jµÄjar°üºÍÁ¬½ÓMySqLµÄÇý¶¯°ü¡£ÅäÖÃÈçÏ£º
ÐÞ¸Älog4j.propertiesÎļþ£º
######## #´Ë¾äΪ¶¨ÒåÃûΪstdoutµÄÊä³ö¶ËÊÇÄÄÖÖÀàÐÍ£¬¿ÉÒÔÊÇ
#org.apache.log4j.ConsoleAppender£¨¿ØÖÆÌ¨£©£¬
#org.apache.log4j.FileAppender£¨Îļþ£©£¬
#org.apache.log4j.DailyRollingFileAppender£¨Ã¿Ìì²úÉúÒ» ......

Ò»¸ö mysql server ÉϵÄС¼¼ÇÉ

ת×Ôhttp://www.linuxbyte.org/yi-ge-mysql-server-shang-de-xiao-ji-qiao.html
ÔÚmy.cnf µÄ mysql ¶Ë Ìí¼ÓÈçÏÂÉèÖÃ
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
prompt="(\u:mysql1@linuxbyte.org \R:\m)[\d]: "
»á²úÉúÈçÏÂЧ¹û:
root@ubuntu:/home/hew# mysql -u hew -p
Enter pass ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ