mysqlÉÏÏÞÎÊÌâ
ÇëÎÊһϴó¼ÒÓÐûÓÐÈËÅäÖùýmysqlµÄiniµÄÅäÖÃÎļþ£¬ÏÖÔÚÎÒÓÐÒ»¸öÎÊÌâ¾ÍÊÇ.ÏÖÔÚ±íÖÐ35ÍòÌõµÄÊý¾Ý²éѯ³öÀ´ÊÇûÓÐÎÊÌâµÄ£¬µ«Êǵ±Êý¾Ý¿â´ïµ½°ÙÍòÒÔÉÏÊý¾Ý¾Í²éѯ²»³öÀ´ÁË£¬£¨Ç°ÌáÊÇͬÑùµÄÌõ¼þÀ´×öÕâÁ½´ÎÊý¾Ý²éѯ²Ù×÷¡££©
select * from table where field like '%±±¾©%';
ÎÒÏÖÔÚÊý¾Ý¿âµÄĬÈÏÅäÖÃÊÇʹÓÃmy.iniĬÈϵÄÅäÖã¬ÊDz»ÊÇÏñÕâÑùµÄ°ÙÍòÒÔÉϵÄÊý¾Ý²éѯµÃÓÃmy-large.iniÀ´×öÒ»ÏÂÅäÖÃѽ£¿£¿ÏÈлÁË¡£
SQL code:
show create table tb1_name;
ALTER TABLE tbl_name MAX_ROWS=xxx AVG_ROW_LENGTH=yyy;
Õ⻹Ҫ¿´Ä㱨µÄ´íÊÇʲô´í
SQL code:
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
ÊÔ×Ŷ¼µ÷´óÒ»µã
my-large.ini µÄÈ·ÊÇÖ÷ÒªÕë¶Ô´óÐÍÊý¾ÝÁ¿µÄ£¬Äã¿ÉÒÔ»ùÓÚÕâ¸öµÄ»ù´¡Éϸù¾Ýʵ¼Ê½øÐÐÐÞ¸Ä
µ±Êý¾Ý¿â´ïµ½°ÙÍòÒÔÉÏÊý¾Ý¾Í²éѯ²»³öÀ´ÁË
------------------------------------
ÄãÕâ¸ö²é²»³öÀ´ÊÇʲô¸ÅÄîÄØ£¿
ÊDzéѯÔÚÒ»Ö±ÔËÐУ¬»¹ÊÇÔËÐÐÍêºóû½á¹ûÏÔʾ£¿
35ÍòµÄÊý¾Ý¿ÉÒÔ²éѯ³öÀ´Êý¾ÝûÓÐÎÊÌ⣬µ«Êǵ±Êý¾ÝÁ¿´ïµ½°ÙÍòÒÔºóÖ»Äܲéѯ³öÒ»Ìõ¼Ç¼³öÀ´£¬ÎÒÓÿͻ§¶Ë¹¤¾ßÖ´
Ïà¹ØÎÊ´ð£º
ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿
ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺
<?php
$conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......
MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
¾ÍÕÒÒ»±¾ºÜ»ù´ ......