mysql ÐÔÄܲâÊÔ
mysql ÐÔÄܲâÊÔ
»úÆ÷ÅäÖÃ
drivers : mysql odbc 3.51
program : vb 6.0
database : mysql 4.01. nt
member : 256 ddr
cpu : 1.2g
²âÊÔÊý¾ÝÁ¿Îª14w ,200w
select ²âÊÔ!
µÚÒ»¸ö²âÊÔ
select count(*) from tbl_outgoing_log ;
ºÜ¶ÌµÄʱ¼ä ²»ÓÃÍøÂçµÄÇé¿öÏ£¨0.00sec£©
mysql => 0sec
vb =>0ms~10ms
1000 ´ÎµÄ²âÊÔ0.679ms
200w
mysql => 0sec
vb =>0ms~10ms
1000 ´ÎµÄ²âÊÔ0.679ms
µÚ¶þ¸ö²âÊÔ
select count(*) from tbl_outgoing_log where adate <"20050301";
14w
mysql => 1790ms
vb =>1769ms
200w
vb =>124,219
µÚÈý¸ö²âÊÔ
select count(*) from tbl_outgoing_log where id <100000000;
14w
mysql => 113ms
vb=>91.842ms
200w
vb=>1452
²âÊԵĽá¹û¸æËßÎÒÃÇ Ó°ÏìËٶȵķ½ÃæÓÐÈçÏÂ
1.where Ìõ¼þ
2.Ìõ¼þµÄ±È½ÏµÄʱºò£¬×Ö¶ÎÀàÐÍÓкܴóµÄÇø±ð ûÓÐË÷ÒýµÄÇé¿öÏ ËÙ¶È midiumint >int > char > varchr > datatime
²åÈë1000Ìõ 7910MS
²åÈë500,000 318,728ms 0.637456 ms/record
²âÊÔupdate
ÔÚÿÓÐË÷ÒýµÄÇé¿öÏÂ
200w 114154ms
ÓÐË÷ÒýµÄÇé¿öÏÂ
200w
ÓÐË÷ÒýµÄÇé¿öÏÂ
30~150ms
²âÊÔdelete 1723523
245,813ms
¿´ÆðÀ´ËٶȻ¹²»´í,200wµÄÊý¾ÝÔÚÕâÑùµÄÇé¿öÏÂ30msÒò¸Ã²»»áÓÐʲôÎÊÌ⣡
ÕâÊÇûÓÐÈκÎÓÅ»¯µÄÇé¿öϵIJâÊÔÊý¾Ý£¬Ã÷ÌìѹÁ¦²âÊÔһϿ´¿´£¡
Ïà¹ØÎĵµ£º
MySQL ÖÐÎÄÏÔʾÂÒÂë
Èç¹ûÄãÓöµ½ÂÒÂëÎÊÌ⣬¿ÉÒÔ´ÓÏÂÃ漸¸öÎÊÌâÖð²½¼ì²é£º
£¨1£©¼ì²éÄãµÄÎļþ´æ´¢±àÂëÊÇ·ñºÍ meta ÉùÃ÷µÄÒ»Ö£¬¼ÙÈçÄãµÄÎļþÊÇ°´ÕÕ utf-8 ±àÂë´æ´¢£¬µ«ÊÇ meta È´ÉùÃ÷Ϊ gb2312 £¬½«µ¼ÖÂÂÒÂë¡£
½â¾ö°ì·¨£º½«Ò³Ãæ´æ´¢±àÂëºÍ meta ÉùÃ÷±£³ÖÒ»Ö¡£ÓüÇʱ¾ ......
DAT_E,TIM_E,DAT_ETIME,TIM_ESTAMP,Y_EAR
MySQLÖ§³Ö¶àÖÖ¸ñʽ»¯·½Ê½£¬²åÈëʱ¿ÉÒÔÊÇ×Ö·û´®£¬¿ÉÒÔʹÊý×Ö¡£
MySQL´ú±í×Ö·û´®µÄ·½Ê½ÓÐÁ½ÖÖ£¬Ò»Êǵ¥ÒýºÅ£¬ÁíÒ»ÖÖÊÇË«ÒýºÅ¡£
ÓÖÒ»´ÎÌύʧ°Ü£¬¿´À´CSDNµÄBUG»¹ÊǺܴóµÄ¡£
ÔÒò»ù±¾È·¶¨£¬ÊÇÒòΪDATE£¬TIME£¬DATETIME£¬TIMESTAMP£¬YEARΪMySQLÊý¾ÝµÄ¹Ø¼ü×Ö£¬Ò²ÊÇÆäËûÊý¾Ý¿âµÄ¹Ø¼ü× ......
×÷Õߣº°½Ê¿Î°
Mysql ÓõÄÊÇLinux (non RPM packages)
Ò»¡¢½«mysql-5.5.0-m2-linux-i686-glibc23.tar.gzÏÂÔص½/home/ikmb ²¢ÔÚµ±Ç°Ä¿Â¼½âѹ£»
……..
mysql-5.5.0-m2-linux-i686-glibc23/data/mysql/
mysql-5.5.0-m2-linux-i686-glibc23/data/test/
…………
¶þ¡¢´´½¨MySQL×飬 ......
LinuxϵݲװÓëÅäÖÃ
Èç¹ûËù°²×°µÄLinuxϵͳûÓÐÄÚÖõÄMySQL£¬±ÊÕß½¨ÒéÔÚLinuxÖÐʹÓÃRPM°üÀ´°²×°MySQL£¬Í¬ÑùÕâÒ²ÊÇMySQL¹Ù·½ÌṩµÄ½¨Òé¡£±ÊÕß½Ó´¥×î¶àµÄLinuxϵͳÊÇRadhatµÄ“½üÇ×”£ºCentOS£¬ÓÉÓÚCentOS½Ïеİ汾¶¼ÄÚÖÃÁËMySQL£¬Òò´ËÔÚ°²×°ÏµÍ³Ê±¾Í½«MySQL°²×°²¢×¢²áΪϵͳ·þÎñ£¬Ê¡È¥Á˲»ÉÙ¹¤×÷Á¿£¬´Ë´¦Ò²¾Í²» ......