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

MYSQLÒýÇæ¼òµ¥¶Ô±È

·þÎñÆ÷ÒµÎñÀàÐÍ¶Ô±È ÐÔÄÜÆ¿¾±
DB                   I/O´ÅÅÌ
ת·¢·þÎñÆ÷         Íø¿¨PPS
¶¯Ì¬WEBǰ̨         CPU
¾²Ì¬WEBǰ̨      Íø¿¨ £¨Á÷Á¿£©
 
ACIDÔ­Ôò
 
MYSQL ÒýÇæ
MYISAM  ±íËø    µÍ²¢·¢Ê¹Óà   ·Ç´ØINDEX
INNODB  ÐÐËø    ¸ß²¢·¢Ê¹Óà     ´ØINDEX
½¨±í£º
MYISAM  
  
°´»ñÈ¡µÄÖµÒ»¸ö¸ö´´½¨£¬²»»á½øÐÐÅÅÐò¡£Èç 1£¬aa;13,aa;11,aa ÊäÈ룬ÔÚÊý¾Ý±íÖÐΪ1£¬aa;13,aa;11,aaÈýÌõ¼Ç¼
INNODB   
 
½øÐÐÅÅÐòºó´´½¨¡£Èç 1£¬aa;13,aa;11,aa ÊäÈ룬ÔÚÊý¾Ý±íÖÐΪ1£¬aa;11,aa£¬13,aaÈýÌõ¼Ç¼
Ô­ÒòÊÇʲô£¿·Ç´ØINDEX¹ØÏµ
 
 
²éѯ
IDÊÇINDEX
MYISAM    
 
select count(*) from xxx;   ¿ì     
 ÒòΪÊÇͳ¼ÆÁ¿Áí´æÒ»¸öµØ·½£¬Ö±½Óȥȡֵ    
 select * from xxx where id>1;  Âý      
·Ç´ØINDEX¹ØÏµ£¬Ë÷ÒýKEY´æ·ÅÔÚÒ»¸ö½Úµã£¬Êý¾Ý·ÅÔÚÁíÒ»µØ·½£¬Í¨¹ýÖ¸Õë»ñÈ¡¡£
 select id from xxx where id>1; ¿ì        
Ö»¶ÁÈ¡Ë÷ÒýÁбí
INNODB  
   
select count(*) from xxx;   Âý      
Ò»ÐÐÐÐͳ¼Æ          
sleect * from xxx where id>1;  ¿ì     
´ØINDEX¹ØÏµ£¬Ë÷ÒýKEYºÍÊý¾Ý·ÅÔÚÒ»µØ·½¡£
select id from xxx where id>1;  Âý     
Ò»¸ö¸öÈ¥¶Á¡£
 
д¸ø×Ô¼º¿´£¬³õ²½Àí½â£¬Óдý¼ÓÇ¿£¬´íÎóÄÑÃâ¡£
ÈçºÎд±íÃû»òÕß×Ö¶ÎÃûÊDZäÁ¿µÄ²ÎÊý²éѯ£¿
declare @sql varchar(200) 
set @sql='select * from ' + @table_name
execute(@sql)


Ïà¹ØÎĵµ£º

Ö§³ÖMySqlÒ»°Ñ

ÒÔÏÂת×Ô Osss.cn Óʼþ£¬ÇëʹÓùý¡¢ÕýÔÚʹÓûòÕßÖ§³Ö¿ªÔ´µÄÅóÓÑÖ§³ÖÒ»ÏÂMySql£¬Ð»Ð»¡£

ҲϣÍû½ÌÓý²¿¡¢¿Æ¼¼²¿¸øÓèÖ±½ÓÖ§³Ö£¡


´ó¼ÒºÃ£º½ñÌì¿´µ½ÕâÔòÐÂÎÅ£¬Óë´ó¼Ò¹²Ïíһϣ¬MySQL´´Ê¼ÈËÏ£ÍûÖйúÉÌÎñ²¿ÄܽéÈëOracle&SunÊÕ¹º°¸£¬ºÃÏñ²¢Ã»ÓÐʵÖʽøÕ¹¡£¶ø¶íÂÞ˹Áª°î·´Â¢¶Ï»ú¹¹ÔÚÉÏÖÜÕ¹¿ªµ÷²é¡£Èç¹ûÐèÒªÉÌÎñ² ......

linux °²×° mysql rpm

ÔÚlinuxÏÂÃæ°²×°mysql£¬Ê×ÏàÒª¸ù¾Ý²Ù×÷ϵͳµÄ°æ±¾£¬Ñ¡Ôñ¶ÔÓ¦µÄmysqlµÄ°æ±¾£¬¹Ù·½ÍøÕ¾ÉÏÓзdz£Ã÷È·µÄ·ÖÀà
http://dev.mysql.com/downloads/
ÔÚÕâÀïÎÒʵÑéµÄ²Ù×÷ϵͳÊÇredhat linux
mysql ÓÃÁËÁ½¸ö°²×°°ü£¬Ò»¸öÊÇserver¶Ë£¬Ò»¸öÊÇclient,ÎÒÓõÄÊÇrpm°ü£¬°²×°µÄÖ¸Áî±È½Ï¼òµ¥¡£
MySQL-server-community-5.1.42-0.rhel4.i38 ......

MySQL Cluster Core Concepts


NDBCLUSTER
(also known as NDB
) is an in-memory
storage engine offering high-availability and data-persistence
features.

The NDBCLUSTER
storage engine can be
configured with a range of failover and load-balancing options,
but it is easiest t ......

MySQL Cluster Multi Computer How To


This section is a “How-To
” that describes the basics
for how to plan, install, configure, and run a MySQL Cluster.
Whereas the examples in
Chapter 3, MySQL Cluster Configuration
provide more in-depth
information on a variety of clustering options and co ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ