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ÍòµÄÊý¾Ý¿ÉÒÔ²éѯ³öÀ´Êý¾ÝûÓÐÎÊÌ⣬µ«Êǵ±Êý¾ÝÁ¿´ïµ½°ÙÍòÒÔºóÖ»Äܲéѯ³öÒ»Ìõ¼Ç¼³öÀ´£¬ÎÒÓÿͻ§¶Ë¹¤¾ßÖ´
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º
Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£
Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......
¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä
idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿
1 nike 100 ϵͳʱ¼ä
2 nike 300 &n ......
Ôõô²¶×½µ½´íÎó½øÐÐroolback
DELIMITER $$
DROP PROCEDURE IF EXISTS `test`.`transaction`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `transaction`()
BEGIN
set autocommit = 0;
......
ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......