Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MySQL¶¯Ô±14000ÈËÇ©Ãû·´¶Ô¼×¹ÇÎÄSun½»Ò×

¾Ý¹úÍâýÌ屨µÀ£¬MySQLÊý¾Ý¿âµÄ¿ª·¢ÕßMichael WideniusÒÔ¼°²¿·ÖÏà¹ØÈËÊ¿½üÈÕÏòÅ·ÖÞ¡¢ÖйúÓë¶íÂÞ˹µÄ¼à¹Ü»ú¹¹Ìá½»Á˶Լ׹ÇÎÄ-Sun½»Ò׵ķ´¶ÔÒâ¼û£¬ÓдóÔ¼14000ÈËÔÚ¸ÃÒâ¼ûÉÏÇ©×Ö±íʾËûÃǶԴËÊÕ¹ºµÄ·´¶Ô¡£Å·ÃËίԱ»á´ËÇ°Ôø·´¶Ô¼×¹ÇÎÄÊÕ¹ºSun£¬µ«Õâһ¢¶ÏÉó²é»ú¹¹ÔÚ12ÔÂÓֳƣ¬¶Ô´Ë½»Ò×´ï³ÉÒ»¸öÂúÒâµÄ½á¹û±íʾÀÖ¹Û¡£Å·ÃËίԱ»á½«ÔÚ1ÔÂ27 ÈÕ×îÖÕ¾ö¶¨ÊÇ·ñ·ÅÐÐÕâÒ»½»Òס£
WindeniusÔÚÖÜÒ»Ïò¸÷¹ú¼à¹Ü»ú¹¹Ìá½»ÁËÕâ·Ý´øÓÐÇ©ÃûµÄÒâ¼û¡£ÔÚ¼×¹ÇÎĶÔÅ·Ã˱íʾÊÕ¹ºSun²»»áÓ°ÏìÕý³£¾ºÕùºó£¬ÕâÃû¿ª·¢Õß±ãÔÚÍøÕ¾·¢ÆðÁËÒ»Ïî·´¶Ô´Ë½»Ò׵Ļ¡£
·´Â¢¶ÏÂÉʦÔø±íʾ£¬ÈôÄÜ»ñµÃ´ó¹«Ë¾µÄÖ§³Ö£¬±ã»áÓ°ÏìÒ¡°Ú²»¶¨µÄ¼à¹Ü»ú¹¹×ö³ö¾ö¶¨¡£
MySQLÊÇÊý¾Ý¿âÊг¡µÄºó½øÈëÕߣ¬¸ÃÊг¡ÓÉIT¹«Ë¾¼×¹ÇÎÄ¡¢IBMÓë΢ÈíÕ¼Áì¡£MySQLµÄ½øÈëÀ­µÍÁËÊý¾Ý¿â²úÆ·µÄ¼Û¸ñ£¬Ò²¶¯Ò¡ÁËÕâЩ¾ÞÍ·¹«Ë¾µÄͳÖεØλ¡£
WideniusÊÇÓÐÃûµÄ¿ªÔ´Èí¼þ¿ª·¢Õߣ¬ËûÈ¥Äê´ÓSun¹«Ë¾´ÇÖ°£¬´´½¨ÁË×Ô¼ºµÄÊý¾Ý¿â¹«Ë¾Monty Program Ab¡£¶øSun¹«Ë¾ÔÚ2008Äê³â×Ê10ÒÚÃÀÔªÂòÏÂÁËMySQL¡£
WideniusÔÚÌá½»µÄÒâ¼ûÊéÖгƣ¬“Ç©ÃûÕß²»ÏàÐż׹ÇÎÄ»áÉÆ´ýMySQL¡£”Ëû±íʾ½«¼ÌÐø·´¶Ô¸Ã½»Ò×Ö±ÖÁ×îÖÕ½á¹û³ö¯¡£
Ç©Ãû»î¶¯µÄ·¢ÆðÈ˳ƣ¬Óг¬¹ý5000Ãû¸öÈË¿ª·¢ÕßÔÚ·´¶ÔÒâ¼ûÊéÉÏÇ©ÊðÁË×Ô¼ºµÄÃû×Ö£¬»¹ÓÐ3000¸öÇ©ÃûÀ´×ÔÄÇЩʹÓÃMySQLµÄ¹«Ë¾Óë»ú¹¹¹ÍÔ±¡£
ÕâЩǩÃûÔÚ·´¶Ô»î¶¯¿ªÊ¼µÄÒ»ÖÜÄÚÊÕ¼¯Íê³É£¬²¢±»Ìá½»ÖÁÅ·ÃËίԱ»á¡¢Å·ÖÞÒé»á¼°Å·ÃË27¸ö³ÉÔ±¹úµÄ¢¶ÏÉó²é»ú¹¹¡£»î¶¯·¢ÆðÕß»¹ÏòÖйúÉÌÎñ²¿Óë¶íÂÞ˹Áª°î·´Â¢¶Ï´¦Ìá½»ÁËÕâЩǩÃû¡£
24СʱҽÉúÔÚÏß×Éѯ


Ïà¹ØÎĵµ£º

MySQLÓÅ»¯

µØÖ·£º http://imysql.cn/taxonomy/term/1?page=1
[InnoDBϵÁÐ] -- innodb±íÈçºÎ¸ü¿ìµÃµ½count(*)½á¹û£ºhttp://imysql.cn/2008_06_24_speedup_innodb_count
[InnoDBϵÁÐϵÁÐ] -- ´óÊý¾ÝÁ¿µÄµ¼³öµ¼Èë·½·¨±È½Ï£º
http://imysql.cn/2007_10_15_large_innodb_table_export_import
[MySQLÓÅ»¯°¸Àý]ϵÁÐ -- DISABLE/ENABLE K ......

linux mysqlÅäÖÃ


жÔØmysql
1¡¢²éÕÒÒÔÇ°ÊÇ·ñ×°ÓÐmysql
ÃüÁrpm -qa|grep -i mysql
¿ÉÒÔ¿´µ½mysqlµÄÁ½¸ö°ü£º
mysql-4.1.12-3.RHEL4.1
mysqlclient10-3.23.58-4.RHEL4.1
2¡¢É¾³ýmysql
ɾ³ýÃüÁrpm -e --nodeps °üÃû
( rpm -ev mysql-4.1.12-3.RHEL4.1 )
3¡¢É¾³ýÀÏ°æ±¾mysqlµÄ¿ª·¢Í·ÎļþºÍ¿â
ÃüÁrm -fr /usr/lib/mysql
r ......

mysqlÊý¾Ý¿â·¶Ê½Ïê½â

ÔÚÉè¼Æ¹ØϵÊý¾Ý¿âʱÊÇÒª×ñÊØÒ»¶¨µÄ¹æÔòµÄ¡£ÓÈÆäÊÇÊý¾Ý¿âÉè¼Æ·¶Ê½ÏÖ¼òµ¥½éÉÜ1NF£¨µÚÒ»·¶Ê½£©£¬2NF£¨µÚ¶þ·¶Ê½£©£¬3NF£¨µÚÈý·¶Ê½£©ºÍBCNF£¬ÁíÓеÚËÄ·¶Ê½ºÍµÚÎ巶ʽÁôµ½ÒÔºóÔÙ½éÉÜ¡£ÔÚÄãÉè¼ÆÊý¾Ý¿â֮ʱ£¬ÈôÄÜ·ûºÏÕ⼸¸ö·¶Ê½£¬Äã¾ÍÊÇÊý¾Ý¿âÉè¼ÆµÄ¸ßÊÖ¡£
µÚÒ»·¶Ê½£¨1NF£©£ºÔÚ¹ØϵģʽRÖеÄÿһ¸ö¾ßÌå¹ØϵrÖУ¬Èç¹ûÿ¸öÊôÐÔÖµ¶¼Ê ......

ÓÃpythonÁ¬½ÓmysqlÊý¾Ý¿â


#
-*- encoding: gb2312 -*-
import
os, sys, string
import
MySQLdb
#
Á¬½ÓÊý¾Ý¿â
try
:
conn
=
MySQLdb.connect(host
=
'
localhost
'
,user
=
'
root
'
,passwd
=
'
xxxx
'
,db
=
'
test1
'
)
except
Exception, e:
print
e
sys.exit()
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ