มีใครลอง XtraDB หรือยังครับ
http://www.mysqlperformanceblog.com/2008/12/16/announcing-percona-xtradb-storage-engine-a-drop-in-replacement-for-standard-innodb/
เห็นเค้าบอกว่าประสิทธิภาพ จะดีกว่า InnoDB ของ MySQL ในเครื่อง Server ที่มี 4 Core ขึ้นไป
อ. เห็นเป็นอย่างไรบ้างครับ
ผมกำลังจะทดสอบกับ slave
จะทดสอบแบบ ที่ติดตั้ง mysql ไปแล้ว โดยคำแนะนำตามนี้
-------------------------------------------------------------------------------------
8.2.1. Installing the Binary InnoDB Plugin Dynamically on Unix or Linux
For Unix and Linux systems, use the following procedure to dynamically install the InnoDB Plugin:
1. Download, extract and install the suitable MySQL executable for your server platform and operating system from the MySQL website. Be sure to use a 32-bit or 64-bit version as appropriate for your hardware and operating system.
2. Make sure the MySQL server is not running. You do a “slow” shutdown by issuing the following command before performing the shutdown:
SET GLOBAL innodb_fast_shutdown=0;
3. Download and extract the files for the InnoDB Plugin from the InnoDB Plugin download page, which indicates the names of corresponding InnoDB Plugin and MySQL archive files. At this time, the InnoDB Plugin has not been compiled or tested with the Intel C Compiler (icc), so you should use a version of MySQL compiled with the GNU Compiler Collection (gcc).
4. Copy the file ha_innodb.so to the folder where MySQL looks for plugins, which is generally the lib/plugin subdirectory of the directory specified by basedir where the MySQL server is installed.
5. Start the MySQL server while it is configured to skip loading InnoDB and to make MyISAM the default storage engine. This can be done by editing the option file my.cnf to contain these two lines:
skip_innodb
default_storage_engine=MyISAM
Alternatively, you can use the equivalent options on the MySQL command line:
mysqld --skip-innodb --default-storage-engine=MyISAM …
6. Install the InnoDB Plugin and the new InnoDB Information Schema tables, all of which are implemented in ha_innodb.so. You should use the following commands:
INSTALL PLUGIN INNODB SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_TRX SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_LOCKS SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_LOCK_WAITS SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_CMP SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_CMP_RESET SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_CMPMEM SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_CMPMEM_RESET SONAME 'ha_innodb.so';
Note that the above commands are provided with the InnoDB Plugin in an SQL script (install_innodb_plugins.sql). See the MySQL Manual section on INSTALL PLUGIN Syntax for information on how these commands work.
---------------------------------------------------------------------------------------
โดยผมเริ่มตั้งแต่ข้อ 4
ผมตรวจสอบ show plugin; แล้ว เป็นดังนี้
mysql> show plugin;
+------------+--------+----------------+---------+---------+
| Name | Status | Type | Library | License |
+------------+--------+----------------+---------+---------+
| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
| ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL |
| CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
| InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
+------------+--------+----------------+---------+---------+
เจ๊ง ..หรือ เจ๋ง จะมาบอกครับ
ขอให้ผมโชคดีครับ