Assuming you have a database, let's call it DAT1 which contain all MyISAM
tables,
you could make a copy of an entire database to DAT2
On <host2> create DAT2 using
CREATE DATABASE DAT2;
Then copy all data from DAT1 to DAT2 like this.
mysqldump -h<host2> -u... -p... --triggers --routines DAT1 | mysql -h<host2>
-u... -p... -DDAT2
Next, create a script that converts all tables into another storage engine.
mysql -h<host2> -u... -p... -A -e"SELECT CONCAT('ALTER TABLE ',table_name,'
ENGINE='InnoDB';') FROM information_schema.tables WHERE table_schema='DAT2';" >
conv_engine.sql
Now, execute the script.
mysql -h<host2> -u... -p... -A -DDAT2 < conv_engine.sql
rm conv_engine.sql
At this point, every table in DAT2 has the same data as DAT1 but all the tables
are InnoDB.
You can repeat this process for engines MEMORY, PBXT, or the upcoming Falcon in
MySQL 5.2.
Now you set up tests between DAT1 and DAT2 to compare how all queries behave:
SELECTs OUTER JOINS, VIEWs, ect.
Have fun.
----- Original Message -----
From: "Octavian Rasnita" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Wednesday, March 21, 2007 4:14:25 PM (GMT-0500) Auto-Detected
Subject: comparing storing engines
Hi,
Is there somewhere a speed comparison between the storage engines that can
be used in MySQL?
Thank you.
Octavian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
