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

ÈçºÎÐÞ¸´Ë𻵵Ä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 + 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´´½¨¹ØÁª±í

 
MySQL´´½¨¹ØÁª±í¿ÉÒÔÀí½âΪÊÇÁ½¸ö±íÖ®¼äÓиöÍâ¼ü¹ØÏµ£¬µ«ÕâÁ½¸ö±í±ØÐëÂú×ãÈý¸öÌõ¼þ
                                1.Á½¸ö±í±ØÐëÊÇInnoDBÊý¾ÝÒý ......

Mysql Âý²éѯÆôÓÃ

 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 5.0°²×°Í¼½â

ÏÂÃæµÄÊÇMySQL°²×°µÄͼ½â:¡¡¡¡
Ë«»÷ÔËÐГsetup.exe”£¬³öÏÖÈçϽçÃæ£º 
mysql°²×°Ïòµ¼Æô¶¯£¬°´“Next”¼ÌÐø
Ñ¡Ôñ°²×°ÀàÐÍ£¬ÓГTypical£¨Ä¬ÈÏ£©”¡¢“Complete£¨ÍêÈ«£©”¡¢“Custom£¨Óû§×Ô¶¨Ò壩”Èý¸öÑ¡ÏÎÒÃÇÑ¡Ôñ“Custom”£¬Óиü¶àµÄÑ¡ÏҲ· ......

MYSQLÃüÁת£©

µÚÒ»¡¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þ¡¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µÚÈý¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ