Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 alter Óï¾äÓ÷¨,Ìí¼Ó¡¢Ð޸ġ¢É¾³ý×ֶεÈ

À´Ô´£ºhttp://www.blogjava.net/Alpha/archive/2007/07/23/131912.html 
//Ö÷¼ü549830479
alter table tabelname add new_field_id int(5) unsigned default 0 not null auto_increment ,add primary key (new_field_id);
//Ôö¼ÓÒ»¸öÐÂÁÐ549830479
alter table t2 add d timestamp;
alter table infos add ......

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'
µ½ÍøÉ ......

CÓïÑÔÁ¬½ÓmysqlÊý¾Ý¿â£¬¶ÁÈ¡mysqlÄÚÈÝ

 //linuxϱàÒëg++ $(mysql_config --cflags)  ***.cpp  $(mysql_config --libs)
/*mysqlÊý¾Ý¿âÖбíµÄÄÚÈÝ
mysql> select * from maindb;
+------------------+---------+-------------+---------+----------+---------------------+---------------------+---------------------+------------------- ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ