¹¹½¨¸ßÐÔÄܵÄMYSQLÊý¾Ý¿â(¶þ) °ÑÄÇЩƿ¾±¸øÕÒ³öÀ´
Ò»¡¢´ÓÄÄÀïÈëÊÖ
µ±Ò»Ì¨MYSQL·þÎñÆ÷´î½¨Íê³É²¢¿ÉÒÔÕý³£ÔËÐÐʱ£¬ÊDz»ÊÇÎÒÃǵĽŲ½¾ÍÍ£Ö¹ÁË£¬×ÔÒÔΪ¿ÉÒÔ¿ªÊ¼Ê¹ÓÃÁË£¬¶ÔרҵÈËÊ¿À´ËµÆäʵ»¹ÐèÒª¸ü¶àµÄÏà¹ØÓÅ»¯ºÍÉèÖá£ÔõôȥÓÅ»¯£¿ÔõôȥÉèÖã¿Ê×ÏÈÎÒÃǵÃÕÒµ½ËüµÄÆ¿¾±£¬ÎÒÏÖÔÚËùÁ˽âµÄÓÐÁ½ÖÖ·½·¨£¬Ò»ÊÇ»ù×¼²âÊÔ£¬¶þ¾ÍÊdzÌÐò·ÖÎö£¬ËûÃÇÓÐ×ÅÃÜÇеÄÁªÏµ£¬ÒòΪÓÐʱÊÇÒ»ÑùµÄ¡£Í¨¹ý¶ÔÄãµÄMYSQLÐÔÄÜ×ö»ù×¼²âÊÔ£¬²éÕÒÄDz¿·Ö´æÔÚÎÊÌâÐèÒªÓÅ»¯£¬ÄDz¿·ÖÔòÔËÐÐÕý³££¬Ïà·´³ÌÐò·ÖÎöÔò°ïÖúÎÒÃÇͳ¼ÆMYSQLÔËÐеĻ¨·Ñʱ¼äºÍÏûºÄ×ÊÔ´¡£»»¾ä»°Ëµ£º»ù×¼²âÊÔÊÇMYSQLµÄ¸÷ÏîÊÇ·ñ·¢»Ó³ö×î´óµÄÐÔÄÜ£¬³ÌÐò·ÖÎöÔòÊÇΪʲôMYSQLµÄÕâ¸öÑ¡Ïî»áÕ¼Óøü¶àµÄÐÔÄÜ¡£
¶þ¡¢»ù×¼²âÊÔ
Õë¶ÔMYSQLµÄ»ù×¼²âÊÔÓÐÁ½ÖÖ²âÊÔ·½·¨£¬Ò»¸öÊÇÕûվʽ²âÊÔ£¬ÁíÒ»¸öÔòÊǵ¥Ò»×é¼þ²âÊÔ¡£Õûվʽ²âÊÔ°üÀ¨³ýMYSQLÒÔÍâµÄÆäËûºÍMYSQLËù¹ÜÀíµÄ³ÌÐò£¬ÈçWEB³ÌÐò£¬²Ù×÷ϵͳ£¬´ÅÅÌI/OµÈµÈ¡£µ¥Ò»×é¼þÊÇרÃÅÕë¶ÔMYSQL×öµÄ²âÊÔ£¬°üÀ¨Ôöɾ¸Ä²éËٶȲâÊÔ£¬²»Í¬´æ´¢ÒýÇæ²âÊԵȵȡ£ÏÂÃæÎÒÃǽ«½éÉܼ¸¿îÏà¹ØµÄ»ù×¼²âÊÔ¹¤¾ß£º
1¡¢http_load(Õûվʽ²âÊÔ)
http_loadÊÇÔËÐÐÔÚlinux²Ù×÷ϵͳÉϵÄÒ»¸öÕë¶ÔÍøÕ¾×öѹÁ¦²âÊԵĿªÔ´¹¤¾ß¡£
ÏÂÔصØÖ·£ºhttp://www.acme.com/software/http_load/http_load-12mar2006.tar.gz
http_loadÒÔ²¢Ðи´Óõķ½Ê½ÔËÐвâÊÔÍøÕ¾·þÎñÆ÷µÄÍÌÍÂÁ¿ºÍ¸ºÔØ£¬Ëü¿ÉÒÔÒÔµ¥¸ö½ø³ÌÈ¥ÔËÐУ¬ÕâÑù²»»á¸ãËÀÄãµÄ¿Í»§¶Ë£¬ÕâÒ²ÊǺʹ󲿷ÖѹÁ¦²âÊÔ¹¤¾ßËù²»Í¬µÄÒ»µã£¬»¹ÓÐËü»¹¿ÉÒÔ²âÊÔhttpsÒ³Ãæ¡£
¿ªÊ¼°²×°£º
#wget http://www.acme.com/software/http_load/http_load-12mar2006.tar.gz
# tar xvzf http_load-12mar2006.tar.gz
# cd http_load-12mar2006
# make
Ê×ÏÈ´´½¨Ò»¸öurls.txtÎļþ£¬ÀïÃæ¼ÓÈëÒª²âÊÔµÄURLµØÖ·£¬ÒÔ»»Ðзָî,ÕâÀïÐèҪעÒâÒ»µã¾ÍÊÇÒòΪÎÒÃǽ²µÄÊDzâÊÔMYSQL£¬ËùÒÔÄãµÄÒ³ÃæÒ»¶¨Òª´æÔÚMYSQLµÄ²Ù×÷Óï¾ä£¬¶øÇÒÒª·ûºÏÄãµÄ±ê×¼ÍøÕ¾µÄÊý¾ÝÁ¿£¬ÈçÏ£º
http://killker.com/blog/index.php
http://killker.com/blog/?p=114
http://killker.com/blog/?p=102
ÏÖÔÚÎÒÃÇ¿ªÊ¼²âÊÔÿÃëËùÄܳÐÊܵÄÒ³Ãæ·ÃÎÊÁ¿£¨ÍÌÍÂÁ¿£¬µ¥Î»Ê±¼äÄÚµÄÊÂÎï´¦ÀíÄÜÁ¦£©
#./http_load -paraller 5 -fetches 100 urls.txt
ÒÔÉÏÃüÁîÒâ˼ÊÇͬʱʹÓÃ5¸ö½ø³Ì£¬Ëæ»ú
Ïà¹ØÎĵµ£º
³£³£Óöµ½´óÊý¾ÝÁ¿Æµ·±¶ÁдÊƱػᵼÖ·þÎñÆ÷µÄÐÔÄÜϽµ¡£ÏÂÃæ¼Ç¼һ϶ÔmysqlµÄÓÅ»¯ÅäÖÃ
1.Ê×ÏȹرÕauto commit¡£
2.¶ÔÓÚÊý¾Ý±íʹÓÃInnoDB¡£
3.¹Ø±ÕÍâ¼üÔ¼Êø¡£
4.²ÉÓöàÖµ²åÈë“INSERT INTO ±íÃû VALUES (1,2), (5,5), ...;” Èç¹ûÓдóÁ¿²¢·¢¿ÉÒÔÓøü¸ÄINSERT INTOΪ INSERT DELAYED INTO¿ÉÒÔÔڳ̶ÈÉϽ⾠......
Ò»¡£ mysql.data.dll¿½±´µ½binÏÂÃæ²¢ÒýÓÃÒ»ÏÂ
using MySql.Data.MySqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string myConnectionString ......
1¡¢´´½¨Ò»¸öÊý¾Ý¿â
create database Êý¾Ý¿âÃû
2¡¢´´½¨Ò»¸öÊý¾Ý±í
create table Êý¾Ý±íÃû(
×Ö¶ÎÃû ÀàÐÍ(³¤¶È),
×Ö¶ÎÃû ÀàÐÍ(³¤¶È),
×Ö¶ÎÃû ÀàÐÍ(³¤¶È),
×Ö¶ÎÃû ÀàÐÍ(³¤¶È),
......
×Ö¶ÎÃû ÀàÐÍ(³¤¶È)
);
3¡¢²é¿´Êý¾Ý±í½á¹¹
describe Êý¾Ý±íÃû;
4¡¢²åÈëÒ»ÌõмǼ
insert into Êý¾Ý±íÃû values(Öµ1,Öµ2,....Öµn ......
½øÈëcmd
===================
1.µ¼³öÊý¾Ý¿â£¨sql½Å±¾£©
mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
¡¡¡¡mysqldump -u root -p db_name > test_db.sql
¡¡¡¡2.mysqlµ¼³öÊý¾Ý¿âÒ ......
¼ÇÏÂЩlinuxÏÂmysqlµÄ²Ù×÷£¬ÒÔ±ãÒÔºó²é¿´£º
1. Æô¶¯£¬¹Ø±Õmysql£º
Æô¶¯£ºsudo /etc/init.d/mysql start
¹Ø±Õ£º/usr/bin/mysqladmin -uroot -p shutdown
2.ÏÔʾ ±í½á¹¹£º
describe:tableName
3.±¸·Ý£º
Ö»±¸·Ý±í½á¹¹£ºmysqldump -d -uroot -p DataBase TableName> xxx.sql
±¸·Ý±í½á¹¹ºÍÊý¾Ý£ºmysqldump -uro ......