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

MySQL Ëæ±Ê

1, MySQL profiling
 mysql> set profiling = 1;
 mysql> select count(*) from test;
 mysql> show profiles;
 mysql> show profile for query 1;
2,mysql ¼à¿Ø
http://bbs.linuxtone.org/thread-1854-1-1.html
http://code.google.com/p/mysql-cacti-templates/   -> High performance for mysql ×÷ÕßдµÄCactiÄ£°å


Ïà¹ØÎĵµ£º

ÔÚLinux»·¾³Ïµ¥»úÉÏʵÏÖMySQL5Ö÷´ÓÊý¾Ý¿âͬ²½¸´ÖÆ

1.°²×°MySQL£¨ÂÔ£©
2.Æô¶¯¶à¸öMySQL·þÎñÆ÷
    ҪʵÏÖÔÚµ¥»úÉÏÆô¶¯¶à¸öMySQL·þÎñÆ÷£¬ÓÐÁ½ÖÖ·½·¨£¬Ò»ÖÖÊÇÖ±½ÓʹÓÃmysqld_safeÀ´ÔËÐжà¸ö·þÎñÆ÷
µ±È»ÕâÑù·Ö±ð±à¼­ÅäÖÃÎļþ£¬¶øÇҹرշþÎñÆ÷µÄʱºòÒ²Òª¶ÁÈ¡ÅäÖÃÎļþ£¬ËùÒԱȽÏÂé·³£¬ÁíÒ»ÖÖ·½·¨ÊÇʹÓÃ
MySQLÌṩµ½¹¤¾ßmysqld_multi½Å±¾À´¹ÜÀí¶à¸ö·þÎñÆ÷£¬ÏÂÃæ ......

ÓÃMysql GUI tool Á´½Ó Mysql ´íÎó 2003 µÄ½â¾ö°ì·¨

½ñÌìÔÚUbuntuÏ°²×°ÁËmysql server£¬ È»ºóÊÔͼÔÚwinxpÏÂÃæÓÃMysql GUI toolÁ´½Ó£¬½á¹û×ÜÊÇʧ°Ü£¬ÏÔʾ´íÎóºÅΪ2003.
ÏÂÃæÊÇ̽Ë÷¹ý³Ì£º
1.Ê×ÏÈ»³ÒÉÊÇUbuntuÏÂÃæÓзÀ»ðǽ£¬ ÔÚwinxpÏÂÃæping¿ÉÒÔpingͨ£¬ UbuntuÏÂÃæÖ´ÐÐ "ufw status" ÏÔʾҲÊÇinactiveµÄ£»
˵Ã÷ºÍ·À»ðǽûÓйØϵ¡£
2. »³ÒÉmysql ûÓÐÆðÀ´£¬ ÔÚUbuntuÏÂÃæÖ´ ......

MysqlÖÐÎÄÂÒÂëÎÊÌâ


MysqlĬÈϵıàÂëÊÇlatin1£¬ËùÒÔͨ¹ýSqlyog»òÕßJava³ÌÐò¶ÁдÊý¾Ý¿âʱ£¬ÖÐÎĶ¼½«ÏÔʾΪÂÒÂ룬µ«ÔÚ¿ØÖÆ̨ͨ¹ýÃüÁîÐпÉÒÔÏÔʾÖÐÎÄ¡£
ÈçºÎ½â¾öÖÐÎÄÂÒÂëÎÊÌâÄØ£¬¸Ä±äMysqlϵͳµÄ±àÂ뷽ʽ£¬ÔÚMySqlĿ¼ÏµÄmy.iniÎļþÖеÄdefault-character-set=latin1¸ÄΪdefault-character-set=gbk(»òÆäËû),ÔÙÖØÆô·þÎñ¡£µ«ÈÔÈ»ÏÔʾΪÂÒÂ룬ԭÀ ......

ubuntuϸü¸ÄmysqlĬÈϱàÂë(×Ö·û¼¯)

 
°²×°mysql
sudo apt-get install mysql-server #Ö±½Ó×Ô¶¯»ñµÃ¿ÉÓð汾
Ò²¿ÉÒÔÕâÑùд
sudo apt-get install mysql-server-5.0 #°²×°mysql·þÎñÆ÷5.0°æ±¾
°²×°ºó
/etc/init.d/mysql start (stop) ΪÆô¶¯ºÍÍ£Ö¹·þÎñÆ÷
/etc/mysql/ Ö÷ÒªÅäÖÃÎļþËùÔÚλÖà my.cnf
/var/lib/mysql/ ·ÅÖõÄÊÇÊý¾Ý¿â±íÎļþ¼Ð£¬ÕâÀïµÄm ......

ÈçºÎÖ´ÐÐÒ»¸ömysqlµÄsql½Å±¾Îļþ


2009-12-08 18:53
sql½Å±¾ÊÇ°üº¬Ò»µ½¶à¸ösqlÃüÁîµÄsqlÓï¾ä£¬ÎÒÃÇ¿ÉÒÔ½«ÕâЩsql½Å±¾·ÅÔÚÒ»¸öÎı¾ÎļþÖУ¨ÎÒÃdzÆ֮Ϊ“sql½Å±¾Îļþ”£©£¬È»ºóͨ¹ýÏà¹ØµÄÃüÁîÖ´ÐÐÕâ¸ösql½Å±¾Îļþ¡£»ù±¾²½ÖèÈçÏ£º
1¡¢´´½¨°üº¬sqlÃüÁîµÄsql½Å±¾Îļþ
ÎļþÖаüº¬Ò»Ð©ÁеÄsqlÓï¾ä£¬Ã¿ÌõÓï¾ä×îºóÒÔ;½á⣬ÎļþÄÚÈÝʾÀýÈçÏ£º
--´´½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ