Thank you.
I have made some tests, and I have inserted 10000 records in a MyISAM table,
in a InnoDB table, and in an InnoDB table using a transaction.
I have seen that the insert in an InnoDB table without using a transaction
takes much much more than in a MyISAM table.
I knew that it will take much time, but not so much.
For inserting those 10000 records in the MyISAM table it took 11 - 12
seconds.
For inserting them in the InnoDB table, it took 206 - 220 seconds!
When inserting those records in the InnoDB table using a single transaction,
it also took 11 - 12 seconds, just like in case of using MyISAM.
I have a table that is accessed very often and in the same time new records
are added often, and I have read that for this type of table, InnoDB is
prefered.
So maybe I will try changing the table to InnoDB, to see if it really works
faster.
Octavian
----- Original Message -----
From: "Rolando Edwards" <[EMAIL PROTECTED]>
To: "Octavian Rasnita" <[EMAIL PROTECTED]>
Cc: <mysql@lists.mysql.com>
Sent: Thursday, March 22, 2007 3:40 PM
Subject: Re: comparing storing engines
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]
