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

MySQLÖ®¶¯Ì¬±íÌØÕ÷

Èç¹ûÒ»¸öMyISAM±í°üº¬Èκοɱ䳤¶ÈÁУ¨VARCHAR, BLOB»òTEXTDynamic£©£¬»òÕßÈç¹ûÒ»¸ö±í±»ÓÃROW_FORMAT=DYNAMICÑ¡ÏîÀ´´´½¨£¬¶¯Ì¬´æ´¢¸ñʽ±»Ê¹Óá£
 
Õâ¸ö¸ñʽ¸üΪ¸´ÔÓÒ»µã£¬ÒòΪÿÐÐÓÐÒ»¸ö±íÃ÷ÐÐÓж೤µÄÍ·¡£µ±Ò»¸ö¼Ç¼ÒòΪ¸üеĽá¹û±»±äµÃ¸ü³¤£¬¸Ã¼Ç¼Ҳ¿ÉÒÔÔÚ³¬¹ýÒ»¸öλÖô¦½áÊø¡£
 
Äã¿ÉÒÔʹÓÃOPTIMIZE TABLE»òmyisamchkÀ´¶ÔÒ»¸ö±íÕûÀíËéƬ¡£Èç¹ûÔÚÒ»¸ö±íÖÐÓÐÄãƵ·±·ÃÎÊ»ò¸Ä±äµÄ¹Ì¶¨³¤¶ÈÁУ¬±íÖÐÒ²ÓÐһЩ¿É±ä³¤¶ÈÁУ¬½öΪ±ÜÃâËéƬ¶ø°ÑÕâЩ¿É±ä³¤¶ÈÁÐÒƵ½ÆäËü±í¿ÉÄÜÊÇÒ»¸öºÃÖ÷Òâ¡£
 
¶¯Ì¬¸ñʽ±íµÄÒ»°ãÌØÕ÷£º
 
·         ³ýÁ˳¤¶ÈÉÙÓÚ4µÄÁÐÍ⣬ËùÓеÄ×Ö·û´®ÁÐÊǶ¯Ì¬µÄ¡£
 
·         ÔÚÿ¸ö¼Ç¼ǰÃæÊÇÒ»¸öλͼ£¬¸Ãλͼ±íÃ÷ÄÄÒ»Áаüº¬¿Õ×Ö·û´®£¨¶ÔÓÚ×Ö·û´®ÁУ©»òÕß0£¨¶ÔÓÚÊý×ÖÁУ©¡£×¢Ò⣬Õâ²¢²»°üÀ¨°üº¬NULLÖµµÄÁС£Èç¹ûÒ»¸ö×Ö·ûÁÐÔÚÍÏÒ·¿Õ¼äÒƳýºó³¤¶ÈΪÁ㣬»òÕßÒ»¸öÊý×ÖÁÐΪÁãÖµ£¬ÕⶼÔÚλͼÖбê×¢ÁËÇÒÁв»±»±£´æµ½´ÅÅÌ¡£ ·Ç¿Õ×Ö·û´®±»´æΪһ¸ö³¤¶È×Ö½Ú¼Ó×Ö·û´®µÄÄÚÈÝ¡£
 
·         ͨ³£±È¹Ì¶¨³¤¶È±íÐèÒª¸üÉٵĴÅÅ̿ռ䡣
 
·         ÿ¸ö¼Ç¼½öʹÓñØÐè´óСµÄ¿Õ¼ä¡£¾¡¹ÜÈç´Ë£¬Èç¹ûÒ»¸ö¼Ç¼±ä´ó£¬Ëü¾Í°´ÐèÒª±»·Ö¿ª³É¶àƬ£¬Ôì³É¼Ç¼ËéƬµÄºó¹û¡£±ÈÈ磬ÄãÓÃÀ©Õ¹Ðг¤¶ÈµÄÐÅÏ¢¸üÐÂÒ»ÐУ¬¸ÃÐоͱäµÃÓÐËéƬ¡£ÔÚÕâÖÖÇé¿öÏ£¬Äã¿ÉÒÔʱ²»Ê±ÔËÐÐOPTIMIZE TABLE»òmyisamchk -rÀ´¸ÄÉÆÐÔÄÜ¡£¿ÉʹÓÃmyisamchk -eiÀ´»ñÈ¡±íµÄͳ¼ÆÊý¾Ý¡£
 
·         ¶¯Ì¬¸ñʽ±íÔÚ±ÀÀ£ºóÒª±È¾²Ì¬¸ñʽ±í¸üÄÑÖؽ¨£¬ÒòΪһ¸ö¼Ç¼¿ÉÄܱ»·ÖΪ¶à¸öËéƬÇÒÁ´½Ó£¨ËéƬ£©¿ÉÄܱ»¶ªÊ§¡£
 
·         ¶¯Ì¬³ß´ç¼Ç¼ÆÚÍûµÄÐ㤶ÈÓÃÏÂÁбí´ïʽÀ´¼ÆË㣺
 
·                3
·                + (number of columns + 7) / 8
·                + (nu


Ïà¹ØÎĵµ£º

MySQL 6 ÂÌÉ«¾«¼òBAT°æ

 
¹Ø¼ü×Ö: mysql6 mysql6ÏÂÔØ
×÷ΪһÃû¿ª·¢ÈËÔ±,ÎÒ¶ÔÂÌɫСÈí¼þÇéÓжÀÖÓ,ÒòΪÓÃÆðÀ´·½±ã¿ì½ÝÂï,±ãÓÚЯ´ø,Ò×ÓÚÔÚÑÝʾϵͳÖÐʹÓÃ,¿ª·¢Ê±¿ÉÁ¢¼´½øÈë״̬. £¨ÔÚ¸½¼þÖУ©
ÒÔÏÂÊÇÏêϸ˵Ã÷:
MySQL 6 ÂÌÉ«¾«¼ò°æ(BAT°æ±¾)
        MySQL 6 Ö§³ÖÍâ¼ü,ÊÓͼ´æ´¢¹ý³Ì,ÊÂÎñµÈ¹¦ÄÜ(ÂÌÉ«¾« ......

MysqlÓÅ»¯·½°¸Ö®Ë÷ÒýµÄʹÓÃ

 
Ë÷ÒýÓÃÓÚ¿ìËÙÕÒ³öÔÚij¸öÁÐÖÐÓÐÒ»Ìض¨ÖµµÄÐС£²»Ê¹ÓÃË÷Òý£¬MySQL±ØÐë´ÓµÚ1Ìõ¼Ç¼¿ªÊ¼È»ºó¶ÁÍêÕû¸ö±íÖ±µ½ÕÒ³öÏà¹ØµÄÐС£±íÔ½´ó£¬»¨·ÑµÄʱ¼äÔ½¶à¡£Èç¹û±íÖвéѯµÄÁÐÓÐÒ»¸öË÷Òý£¬MySQLÄÜ¿ìËÙµ½´ïÒ»¸öλÖÃÈ¥ËÑÑ°µ½Êý¾ÝÎļþµÄÖм䣬ûÓбØÒª¿´ËùÓÐÊý¾Ý¡£Èç¹ûÒ»¸ö±íÓÐ1000ÐУ¬Õâ±È˳Ðò¶ÁÈ¡ÖÁÉÙ¿ì100±¶¡£×¢ÒâÈç¹ûÄãÐèÒª·ÃÎÊ ......

MySqlÖд´½¨ÊÓͼ

 
CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
    VIEW view_name [(column_list)]
    AS select_statement
    [WITH [CASCADED | LOCAL] CHECK OPTION]
¸ÃÓï¾äÄÜ´´½¨ÐµÄÊÓͼ£¬Èç¹û¸ø¶¨ÁËOR REPLACE×Ӿ䣬¸ÃÓï¾ä»¹ÄÜÌæ»»ÒÑÓеÄÊÓͼ¡£s ......

ubuntu °²mysql install dbʱ³öÁËÎÊÌâ

ÕâÁ½ÌìÎÒ×°ÁËUBUNTU £¬ÔÚ±àÒë°²×°MYSQLµÄʱºòûÓгöʲôÎÊÌ⣬
µ½scripts/mysql_install_db --user=mysql
ÕâÒ»²½Ê±£¬µÃµ½ÈçÏ´íÎó
FATAL ERROR: Can't find mysqld. Please specify your installation
directory with the '--basedir=' option.
FATAL ERROR: Could not find SQL file '/fill_help_tables.sql'
µ½ÍøÉ ......

MySQLÖеÄCREATE VIEWÓï·¨

CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
    VIEW view_name [(column_list)]
    AS select_statement
    [WITH [CASCADED | LOCAL] CHECK OPTION]
¸ÃÓï¾äÄÜ´´½¨ÐµÄÊÓͼ£¬Èç¹û¸ø¶¨ÁËOR REPLACE×Ӿ䣬¸ÃÓï¾ä»¹ÄÜÌæ»»ÒÑÓеÄÊÓͼ¡£select_st ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ