ÈçºÎÐÞ¸´Ë𻵵ÄMySQLÊý¾Ý±í
¶Ïµç»ò·ÇÕý³£¹Ø»ú¶øµ¼ÖÂMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)Êý¾Ý¿â³öÏÖ´íÎóÊǷdz£³£¼ûµÄÎÊÌâ¡£ÓÐÁ½ÖÖ·½·¨£¬Ò»ÖÖ·½·¨Ê¹ÓÃMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)µÄcheck tableºÍrepair table µÄsqlÓï¾ä£¬ÁíÒ»ÖÖ·½·¨ÊÇʹÓÃMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ÌṩµÄ¶à¸ömyisamchk, isamchkÊý¾Ý¼ì²â»Ö¸´¹¤¾ß¡£Ç°ÕßʹÓÃÆðÀ´±È½Ï¼ò±ã¡£ÍƼöʹÓá£
1. check table ºÍ repair table
µÇ½MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ) ÖÕ¶Ë£º
MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ) -uxxxxx -p dbname
> check table tabTest;
Èç¹û³öÏֵĽá¹û˵StatusÊÇOK£¬Ôò²»ÓÃÐÞ¸´£¬Èç¹ûÓÐError£¬¿ÉÒÔÓãº
> repair table tabTest;
½øÐÐÐÞ¸´£¬ÐÞ¸´Ö®ºó¿ÉÒÔÔÚÓÃcheck tableÃüÁîÀ´½øÐмì²é¡£ÔÚа汾µÄphpMyAdminÀïÃæÒ²¿ÉÒÔʹÓÃcheck/repairµÄ¹¦ÄÜ¡£
2. myisamchk, isamchk
ÆäÖÐmyisamchkÊÊÓÃÓÚMYISAMÀàÐ͵ÄÊý¾Ý±í£¬¶øisamchkÊÊÓÃÓÚISAMÀàÐ͵ÄÊý¾Ý±í¡£ÕâÁ½ÌõÃüÁîµÄÖ÷Òª²ÎÊýÏàͬ£¬Ò»°ãеÄϵͳ¶¼Ê¹ÓÃMYISAM×÷ΪȱʡµÄÊý¾Ý±íÀàÐÍ£¬ÕâÀïÒÔmyisamchkΪÀý×Ó½øÐÐ˵Ã÷¡£µ±·¢ÏÖij¸öÊý¾Ý±í³öÏÖÎÊÌâʱ¿ÉÒÔʹÓãº
myisamchk tablename.MYI
½øÐмì²â£¬Èç¹ûÐèÒªÐÞ¸´µÄ»°£¬¿ÉÒÔʹÓãº
myisamchk -of tablename.MYI
¹ØÓÚmyisamchkµÄÏêϸ²ÎÊý˵Ã÷£¬¿ÉÒԲμûËüµÄʹÓðïÖú¡£ÐèҪעÒâµÄʱÔÚ½øÐÐÐÞ¸Äʱ±ØÐëÈ·±£MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)·þÎñÆ÷ûÓзÃÎÊÕâ¸öÊý¾Ý±í£¬±£ÏÕµÄÇé¿öÏÂÊÇ×îºÃÔÚ½øÐмì²âʱ°ÑMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)·þÎñÆ÷Shutdownµô¡£
£££££££££££££££££££££££££££££
ÁíÍâ¿ÉÒÔ°ÑÏÂÃæµÄÃüÁî·ÅÔÚÄãµÄrc.localÀïÃæÆô¶¯MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)·þÎñÆ÷ǰ£º
[ -x /tmp/MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ).sock ] && /pathtochk/myisamchk -of /DATA_DIR/*/*.MYI
ÆäÖеÄ/tmp/MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ).sockÊÇMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)¼àÌýµÄSockÎļþλÖ㬶ÔÓÚʹÓÃRPM°²×°µÄÓû§Ó¦¸ÃÊÇ/var/lib/MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)/MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ).sock£¬¶ÔÓÚʹÓÃÔ´Âë°²×°ÔòÊÇ/tmp/MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ).sock¿ÉÒÔ¸ù¾Ý×Ô¼ºµÄʵ¼ÊÇé¿ö½øÐбä¸ü£¬¶øpathtochkÔòÊÇmyisamchkËùÔÚµÄλÖã¬DATA_DIRÊÇÄãµÄMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)Êý¾Ý¿â´æ·ÅµÄλÖá£
ÐèҪעÒâµÄʱ£¬Èç¹ûÄã´òËã°ÑÕâÌõÃüÁî·ÅÔÚÄãµÄrc.localÀïÃæ£¬±ØÐëÈ·ÈÏÔÚÖ´ÐÐÕâÌõÖ¸ÁîʱMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)·þÎñÆ÷±ØÐëûÓÐÆô¶¯£¡
¼ì²âÐÞ¸´ËùÓÐÊý¾Ý¿â(±í)
MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)c
Ïà¹ØÎĵµ£º
°²×°apache + mysql + discuz +php
apache http://www.apache.org/
mysql http://dev.mysql.com/downloads/
MySQL GUI Tools http://dev.mysql.com/downloads/gui-tools/5.0.html
php &n ......
MySQL´´½¨¹ØÁª±í¿ÉÒÔÀí½âΪÊÇÁ½¸ö±íÖ®¼äÓиöÍâ¼ü¹ØÏµ£¬µ«ÕâÁ½¸ö±í±ØÐëÂú×ãÈý¸öÌõ¼þ
1.Á½¸ö±í±ØÐëÊÇInnoDBÊý¾ÝÒý ......
MySQLÂý²éѯ¼Ç¼ÈÕÖ¾¶ÔÓÚ¸ú×ÙMySQL¸ºÔص÷ÓÅÎÊÌâºÜÓÐÓô¦£¬ÆäʵÆôÓÃMySQLµÄÂý²éѯÈÕÖ¾ºÜ¼òµ¥,Ö»ÐèÒªÔÚMySQLµÄÅäÖÃÎļþÀïÌí¼Ólog-slow-queriesºÍlong_query_timeÁ½¸ö²ÎÊý¼´¿É¡£
WindowsÏ¿ªÆôMySQLÂý²éѯ
MySQLÔÚWindowsϵͳÖеÄÅäÖÃÎļþÒ»°ãÊÇÊÇmy.iniÕÒµ½[mysqld]ÏÂÃæ¼ÓÉÏ
log-slow-queries = F:\MySQL\log\mysqls ......
ÏÂÃæµÄÊÇMySQL°²×°µÄͼ½â:¡¡¡¡
Ë«»÷ÔËÐГsetup.exe”£¬³öÏÖÈçϽçÃæ£º
mysql°²×°Ïòµ¼Æô¶¯£¬°´“Next”¼ÌÐø
Ñ¡Ôñ°²×°ÀàÐÍ£¬ÓГTypical£¨Ä¬ÈÏ£©”¡¢“Complete£¨ÍêÈ«£©”¡¢“Custom£¨Óû§×Ô¶¨Ò壩”Èý¸öÑ¡ÏÎÒÃÇÑ¡Ôñ“Custom”£¬Óиü¶àµÄÑ¡ÏҲ· ......
µÚÒ»¡¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þ¡¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µÚÈý¡ ......