mysqlÉèÖûº´æ´óС
set global query_cache_size=10; ûÎÊÌâ
set global query_cache_size=4000; Óо¯¸æ
set global query_cache_size=400000; ûÎÊÌâ
ÊÇʲôÔÒò£¿ÉèÖôóСºÍʲôÓйØÏµ£¿
¾¯¸æ ÐÅÏ¢ÊÇʲô£¿
ÉèÖôóСºÍÓò»ÓÃÁÙʱ±íÓйØ
Ïà¹ØÎÊ´ð£º
Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º
Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£
Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......
MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
¾ÍÕÒÒ»±¾ºÜ»ù´ ......
ͨ¹ýMySQLDriverCS·ÃÎÊmysqlµÄÁÙʱ±íÔõô·ÃÎʵÄѽ
ËÖªµÀѽ£¡°ÝÍС£
Ã²ËÆÒª×°ÉÏmysql È»ºóÌí¼Ó¸ö×é¼þ¶«Î÷²ÅÐÐ ×Ô¼ºÊÔÊÔ
²»Óõİɣ¬Ö»ÒªÔÚÏîÄ¿ÀïÃæÌí¼ÓMySQLDriverCS.dll¾Í¿ÉÒÔÁ˰¡¡£Ö÷ÒªµÄÎÊÌâÊÇ ......