Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ......

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

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

mySqlÊý¾Ý¿âÁ¬½Ó

Class.forName("com.mySQL.jdbc.Driver");
   String strUrl="jdbc:mysql://localhost:3306/stu?useUnicode=true&characterEncoding=GB2312";
   String strUser="nuey";
   String strPassword="password";
   Connection conn=DriverManager.getCon ......

MySQL Master/SlaveÊý¾Ý¿â¶Áд²Ù×÷Àà

Êý¾Ý¿â²Ù×÷ÀࣺDBCommon.class.php
//---------------------------------------------------------------------
// MySQL Master/SlaveÊý¾Ý¿â¶Áд²Ù×÷Àà
//
// ¿ª·¢×÷Õß: heiyeluren
// °æ±¾ÀúÊ·:
// 2006-09-20 »ù±¾µ¥Êý¾Ý¿â²Ù×÷¹¦ÄÜ, 25 ¸ö½Ó¿Ú
// 2007-07-30 Ö§³Öµ ......

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ºÅ