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

²úÆ· °²×°ÖÐµÄ MySql ÂÌ»¯½Ì³Ì

    ×î½üÊÕµ½·´À¡£¬ºÜ¶à¿Í»§Á¬MySql¶¼ÎÞ·¨ÕýÈ·°²×°¡£ÊÕµ½ÈÎÎñ£¬Òª½«MySql´òµ½²úÆ·ÖУ¬ºÍ²úÆ·Ò»Æð°²×°ºÍÐ¶ÔØ£¬À­¿ª¼Ü
ʽ¸É°É£¬Ã»·¨×Ó¡£
    Ñо¿Ò»Õ󣬷¢ÏÖ½«°²×°ºÃµÄMySqlÎļþ¼ÐCopyµ½ÆäËüµçÄÔÉÏ£¬ÔÙ½â¾öºÃÁ½¸öÎÊÌâÓ¦¸Ã¾Í¿ÉÒԺͰ²×°°æÒ»ÑùÕý³£Ê¹Óá£
1.Copyµ½ÁËÆäËüµçÄÔÉϵIJ»Í¬Ä¿Â¼£¬Ó¦¸ü¸ÄMysqlµÄÅäÖÃ.
2.½«MySql×¢²á³ÉwindowsµÄϵͳ·þÎñ.
    ÏÂÃæ£¬¾ÍÈÃÎÒ˵һÏÂÎÊÌâµÄ½â¾ö֮·
1.¾­Ñо¿ÖªµÀ£¬MysqlµÄ±¾µØÂ·¾¶ÅäÖÃÐÅÏ¢ÊÇ´æÔÚmy.iniÎļþϵġ£ÔÚmy.iniÖеÄ[mysqld]·¢ÏÖbasedir="C:/Program Files/MySQL/MySQL Server 5.0"¼°datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/",È·¶¨Õâ¾ÍÊÇ
°²×°Ö®ºóÒª¸ü¸ÄµÄµØ·½¡£
2.¾­¹ý¶à´ÎʵÑ飬ÔÚMySQL/MySQL Server 5.0µÄbinĿ¼ÏÂÖ´ÐÐ,ÏÂÃæÕâDOCÃüÁ
mysqld-nt --install MySQL --defaults-file="bin\my.ini"
¾Í¿ÉÒÔ½«MySQLÕý³£µÄ×¢²áwindowsµÄϵͳ·þÎñ.
Ö´ËmysqlµÄ×Ô°²×°¾Í½²½âÍê±Ï£¬¿´ÆðÀ´ºÜ¼òµ¥£¬²»¹ý¹ý³Ì»¹ÊǺܼèÐÁµÄ¡£ÖÁÓÚÈçºÎºÍ²úÆ·Ò»Æð°²×°ºÍÐ¶ÔØ,²¢²»ÓëÔ­ÓеÄ
MySqlÓгåÍ»£¬ºóÃæ»á¼ÌÐø½éÉÜ


Ïà¹ØÎĵµ£º

mysql Êý¾ÝÀàÐÍvarchar ×ÓжàÉÙ

  ×òÌìÉè¼ÆÊý¾Ý¿â±íµÄʱºò£¬ÒòΪʹÓÃvarchar²úÉúÁËÒìÒ飬½á¹ûÒ»²é·¢ÏÖÎÒÃÇÁ½¸öË­¶¼Ã»´í¡£
   MySQLÊý¾Ý¿âµÄvarcharÀàÐÍÔÚ4.1ÒÔϵİ汾ÖеÄ×î´ó³¤¶ÈÏÞÖÆÎª255£¬ÆäÊý¾Ý·¶Î§¿ÉÒÔÊÇ0~255»ò1~255£¨¸ù¾Ý²»Í¬°æ±¾Êý¾Ý¿âÀ´
¶¨£©¡£
  
ÔÚMySQL5.0ÒÔÉϵİ汾ÖУ¬varcharÊý¾ÝÀàÐ͵ij¤¶ÈÖ§³Öµ½ÁË65535£¬Ò ......

Óà OPTIMIZE TABLE ÓÅ»¯ mysql ±í


Óà OPTIMIZE TABLE ÓÅ»¯ mysql ±í
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:gangzhong
REPAIR TABLE `table_name` ÐÞ¸´±í OPTIMIZE TABLE `table_name` ÓÅ»¯±í myisamchk table.MYI ÐÞ¸´Ë÷Òý REPAIR TABLE ÓÃÓÚÐÞ¸´±»ÆÆ»µµÄ±í¡£ myisamchk TABLE.MYI ÓÃÓÚÐÞ¸´±»ÆÆ»µµÄË÷ÒýÎļþ¡£ OPTIMIZE TABLE ÓÃÓÚ»ØÊÕÏÐÖõÄÊý¾Ý ......

mysql alter Óï¾äÓ÷¨,Ìí¼Ó¡¢Ð޸ġ¢É¾³ý×ֶεÈ


 Ô´µØÖ·: http://www.pcppc.cn/shujuku/mysql/shujuku_163919.html
 
 
ÄúÕýÔÚ¿´µÄMySQL½Ì³ÌÊÇ:MySQLÊý¾Ý¿âѧϰ±Ê¼Ç¡£
¡¡¡¡MySQLÊý¾Ý¿âѧϰ±Ê¼Ç 
(ʵÑé»·¾³:Redhat9.0,MySQL3.23.54) 
¸ÙÒª£º 
Ò»£¬Á¬½ÓMySQL 
¶þ£¬MySQL¹ÜÀíÓëÊÚȨ 
Èý£¬Êý¾Ý¿â¼òµ¥²Ù×÷ 
ËÄ, ......

tomcat 6.0 + mysql + jndi Êý¾Ý¿âÁ¬½Ó³ØÅäÖÃ

1¡¢Ð½¨¶¯Ì¬webÏîÄ¿¡£
2¡¢Ìí¼Ójar°ü
    ½«mysql jdbcÇý¶¯Ìí¼Óµ½tomcat°²×°Ä¿Â¼ÏµÄlibĿ¼¡£
3¡¢ÔÚMETA-INFÏÂÌí¼Ócontent.xmlÎļþ¡£ÄÚÈÝÈçÏ£º
<?xml version="1.0" encoding="UTF-8"?>
<Context reloadable="true" crossContext="true">
<!-- Default set of monitored resources - ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ