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)
Ïà¹ØÎĵµ£º
-static 13%
--with-client-ldflags=-all-static
--with-mysqld-ldflags=-all-static
¾²Ì¬Á´½ÓÌá¸ß13%ÐÔÄÜ
Unix Socket 7.5%
--with-unix-socket path=/usr/local/mysql/tmp/mysql.sock
ʹÓÃunixÌ×½Ó×ÖÁ´½ÓÌá¸ß7.5%ÐÔÄÜ£¬ËùÒÔÔÚwindowsÏÂmysqlÐÔÄܿ϶¨²»ÈçunixÏÂÃæ
--enab ......
Oracle 8 資ÁÏ庫º¯Ê½庫
OCIDefineByName
讓 SELECT Ö¸Áî¿ÉʹÓà PHP 變數¡£
語·¨: boolean OCIDefineByName(int stmt, string ColumnName, mixed &variable, int [type]);
傳»ØÖµ: ²¼ÁÖÖµ
º¯Ê½種類: 資ÁÏ庫¹¦ÄÜ
內È ......
1¡¢Ñ¡È¡×îÊÊÓõÄ×Ö¶ÎÊôÐÔ
MySQL
¿ÉÒԺܺõÄÖ§³Ö´óÊý¾ÝÁ¿µÄ´æÈ¡£¬µ«ÊÇÒ»°ã˵À´£¬Êý¾Ý¿âÖеıíԽС£¬ÔÚËüÉÏÃæÖ´ÐеIJéѯҲ¾Í»áÔ½¿ì¡£Òò´Ë£¬ÔÚ´´½¨±íµÄʱºò£¬ÎªÁË»ñµÃ¸üºÃµÄÐÔÄÜ£¬ÎÒÃÇ¿ÉÒÔ½«
±íÖÐ×ֶεĿí¶ÈÉèµÃ¾¡¿ÉÄÜС¡£ÀýÈ磬ÔÚ¶¨ÒåÓÊÕþ±àÂëÕâ¸ö×Ö¶Îʱ£¬Èç¹û½«ÆäÉèÖÃΪCHAR(255),ÏÔÈ»¸øÊý¾Ý¿âÔö¼ÓÁ˲»±ØÒªµÄ¿Õ¼ä£¬É ......
MySQL Cluster
is a technology that enables
clustering of in-memory databases in a shared-nothing system. The
shared-nothing architecture allows the system to work with very
inexpensive hardware, and with a minimum of specific requirements
for hardware or software.
......