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

MYSQL ÄÚ´æ»úÖÆ


¶ÔÓÚÈκÎÒ»¸öÊý¾Ý¿â¹ÜÀíϵͳÀ´Ëµ£¬ÄÚ´æµÄ·ÖÅäʹÓþø¶Ô¿ÉÒÔËãµÄÉÏÊÇÆäºËÐÄÖ®Ò»ÁË£¬ËùÒԺܶàÏ£Íû¸üΪÉîÈëÁ˽âijÊý¾Ý¿â¹ÜÀíϵͳµÄÈË£¬¶¼»áÏ£ÍûÒ»¿ú¾¿¾¹£¬ÎÒÒ²²»ÀýÍâ¡£   
  
´ÓÄÚ´æµÄʹÓ÷½Ê½MySQL Êý¾Ý¿âµÄÄÚ´æʹÓÃÖ÷Òª·ÖΪÒÔÏÂÁ½Àà   
  
  
Ï̶߳ÀÏíÄÚ´æ    
È«¾Ö¹²ÏíÄÚ´æ   
  
Ï̶߳ÀÏíÄÚ´æ   
  
ÔÚ MySQL ÖУ¬Ï̶߳ÀÏíÄÚ´æÖ÷ÒªÓÃÓÚ¸÷¿Í»§¶ËÁ¬½ÓÏ̴߳洢¸÷ÖÖ²Ù×÷µÄ¶ÀÏíÊý¾Ý£¬ÈçÏß³ÌÕ»ÐÅÏ¢£¬·Ö×éÅÅÐò²Ù×÷£¬Êý¾Ý¶Áд»º³å£¬½á¹û¼¯ÔÝ´æµÈµÈ£¬¶øÇÒ´ó¶àÊý¿ÉÒÔͨ¹ýÏà¹Ø²ÎÊýÀ´¿ØÖÆÄÚ´æµÄʹÓÃÁ¿¡£   
  
Ïß³ÌÕ»ÐÅϢʹÓÃÄÚ´æ(thread_stack)£ºÖ÷ÒªÓÃÀ´´æ·Åÿһ¸öÏß³Ì×ÔÉíµÄ±êʶÐÅÏ¢£¬ÈçÏß³Ìid£¬Ïß³ÌÔËÐÐʱ»ù±¾ÐÅÏ¢µÈµÈ£¬ÎÒÃÇ¿ÉÒÔͨ¹ý thread_stack ²ÎÊýÀ´ÉèÖÃΪÿһ¸öÏß³ÌÕ»·ÖÅä¶à´óµÄÄÚ´æ¡£   
  
ÅÅÐòʹÓÃÄÚ´æ(sort_buffer_size)£ºMySQLÓôËÄÚ´æÇøÓò½øÐÐÅÅÐò²Ù×÷£¨filesort£©£¬Íê³É¿Í»§¶ËµÄÅÅÐòÇëÇó¡£µ±ÎÒÃÇÉèÖõÄÅÅÐòÇø»º´æ´óСÎÞ·¨Âú×ãÅÅÐòʵ¼ÊËùÐèÄÚ´æµÄʱºò£¬MySQL»á½«Êý¾ÝдÈë´ÅÅÌÎļþÀ´Íê³ÉÅÅÐò¡£ÓÉÓÚ´ÅÅ̺ÍÄÚ´æµÄ¶ÁдÐÔÄÜÍêÈ«²»ÔÚÒ»¸öÊýÁ¿¼¶£¬ËùÒÔsort_buffer_size²ÎÊý¶ÔÅÅÐò²Ù×÷µÄÐÔÄÜÓ°Ïì¾ø¶Ô²»¿ÉСÊÓ¡£   
  
Join²Ù×÷ʹÓÃÄÚ´æ(join_buffer_size)£ºÓ¦ÓóÌÐò¾­³£»á³öÏÖһЩÁ½±í£¨»ò¶à±í£©JoinµÄ²Ù×÷ÐèÇó£¬MySQLÔÚÍê³ÉijЩ Join ÐèÇóµÄʱºò£¨all/indexjoin£©£¬ÎªÁ˼õÉÙ²ÎÓëJoinµÄ“±»Çý¶¯±í”µÄ¶ÁÈ¡´ÎÊýÒÔÌá¸ßÐÔÄÜ£¬ÐèҪʹÓõ½ Join Buffer À´Ð­ÖúÍê³É Join²Ù×÷¡£µ± Join Buffer Ì«Ð¡£¬MySQL ²»»á½«¸Ã Buffer ´æÈë´ÅÅÌÎļþ£¬¶øÊÇÏȽ«Join BufferÖеĽá¹û¼¯ÓëÐèÒª JoinµÄ±í½øÐРJoin ²Ù×÷£¬È»ºóÇå¿Õ Join Buffer ÖеÄÊý¾Ý£¬¼ÌÐø½«Ê£ÓàµÄ½á¹û¼¯Ð´Èë´Ë BufferÖУ¬Èç´ËÍù¸´¡£ÕâÊƱػáÔì³É±»Çý¶¯±íÐèÒª±»¶à´Î¶ÁÈ¡£¬³É±¶Ôö¼Ó IO ·ÃÎÊ£¬½µµÍЧÂÊ¡£   
  
˳Ðò¶ÁÈ¡Êý¾Ý»º³åÇøʹÓÃÄÚ´æ(read_buffer_size)£ºÕⲿ·ÖÄÚ´æÖ÷ÒªÓÃÓÚµ±ÐèҪ˳Ðò¶ÁÈ¡Êý¾ÝµÄʱºò£¬ÈçÎÞ·¢Ê¹ÓÃË÷ÒýµÄÇé¿öϵÄÈ«±íɨÃ裬ȫË÷ÒýɨÃèµÈ¡£ÔÚÕâÖÖʱºò£¬MySQL°´ÕÕÊý¾ÝµÄ´æ´¢Ë³ÐòÒÀ´Î¶ÁÈ¡Êý¾Ý¿é£¬Ã¿´Î¶ÁÈ¡µÄÊý¾Ý¿ìÊ×ÏÈ»


Ïà¹ØÎĵµ£º

VCµ¥ÎļþÁ¬½ÓMYSQLʾÀý£¬¶ªµôlibmysql.dll.

ÍøÉϺܶàVCÁ¬½ÓmysqlµÄÀý×Ó¶¼ÊÇÒª´ø¸ölibmysql.dll²ÅÄÜÕý³£Ê¹Óõġ£
µ«ÓÐʱÎÒÃDz¢²»Ïë¶à´ø¸ölibmysql.dll£¬Ö»Ïëµ¥Îļþ¾ÍÄÜʹÓûòÕßÄãÊÇÒª
·â×°ÔÚÒ»¸ödllÎļþÀÕâʱÄãÒª¾ÍÓõ½mysqlclient.libÕâ¸ö¾²Ì¬¿âÁË¡£
ʾÀý´úÂëÈçÏ£¬ºÜºÜ¼òµ¥£¬¾Í²»¶à˵ÁË¡£
Ïà¹ØµÄmysqlÍ·Îļþ¼°¾²Ì¬¿â£º
http://download.csdn.net/source/1047 ......

jbpm4°²×°ÔÚÒÑÓеÄtomcatÓëmysqlÏÂ

1.JBPM4.3ÏÂÔØ(http://sourceforge.net/projects/jbpm)
2.ant°²×°:jBPMÏÂÔØ°üinstallĿ¼ÖÐÓÐÒ»¸öantµÄbuild.xmlÎļþ,ʹÓÃant -pÄã¿ÉÒÔ¿´µ½ËùÓеݲװ
    demo.setup.jboss£º°²×°jboss£¬°Ñjbpm°²×°µ½jbossÖУ¬ Æô¶¯jboss£¬´´½¨jbpmÊý¾Ý¿â±í½á¹¹£¬²¿ÊðʵÀý£¬¼ÓÔØʵÀýÉí·ÝÈÏÖ¤ÐÅÏ¢£¬ °²×°²¢Æô¶¯eclipse
&n ......

jbpm4°²×°ÔÚÒÑÓеÄtomcatÓëmysqlÏÂ

1.JBPM4.3ÏÂÔØ(http://sourceforge.net/projects/jbpm)
2.ant°²×°:jBPMÏÂÔØ°üinstallĿ¼ÖÐÓÐÒ»¸öantµÄbuild.xmlÎļþ,ʹÓÃant -pÄã¿ÉÒÔ¿´µ½ËùÓеݲװ
    demo.setup.jboss£º°²×°jboss£¬°Ñjbpm°²×°µ½jbossÖУ¬ Æô¶¯jboss£¬´´½¨jbpmÊý¾Ý¿â±í½á¹¹£¬²¿ÊðʵÀý£¬¼ÓÔØʵÀýÉí·ÝÈÏÖ¤ÐÅÏ¢£¬ °²×°²¢Æô¶¯eclipse
&n ......

MySQL COUNT SUM

 select
count(*) as mcount ,
left(create_time,10) as ptime ,
count(if(receive_msg is null,id,null)) as nullcount ,
count(if(receive_msg = '1',receive_msg,null)) as apfcount ,
count(if(receive_msg = '2',receive_msg,null)) as dttcount ,
count(if(receive_msg = '3',receive_ms ......

¹ØÓÚMySQL±íÉè¼ÆÓ¦¸Ã×¢ÒâµÄÎÊÌâ

¹ØÓÚMySQL±íÉè¼ÆÓ¦¸Ã×¢ÒâµÄÎÊÌâ
ת×Ô http://blog.chinaunix.net/u/29134/showart_1316574.html
1¡¢É÷ÖØÑ¡Ôñ±íÃû¡£
ÓÐÁ½ÖÖÑ¡Ôñ£º
°´ÕÕ¶àÊý¿ª·¢ÓïÑÔµÄÃüÃû¹æÔò¡£±ÈÈ磨myCustomer£©¡£
°´ÕÕ¶àÊý¿ªÔ´Ë¼ÏëÃüÃû¹æÔò¡£±ÈÈ磨my_customer£©¡£
°´ÕÕÔÛÃÇÖйúÈ˵Ä˼Ïë¡£±ÈÈ磨ÎҵĿͻ§£©¡£
µÚÒ»ÖÖÓиöȱµã£¬ºÜÈÝÒ×Íüµô´óдµÄ×Ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ