MySQL Forums
Forum List  »  Performance

MyISAM / InnoDB in 4.1.7 vs 4.1.8
Posted by: Jose Luis Lopez
Date: September 20, 2005 06:29AM

Using MySQL 4.1.7 and JBoss 4.0.2, we executed some performance tests of our system.After having moved to MySQL 4.1.8, we repeated the same tests with our system and we had quite a worse results compared to the previous version.

With 4.1.7 all of our tables were MyISAM but two of them (the ones that were updated during the execution of the tests). But with MySQL 4.1.8, with the same database design, we had to have all the tables as InnoDB (due to the foreign keys, a referenced table had to be convered in InnoDB) it did not happen with MySQL 4.1.7 because it was possible to have an InnoDB table whereas its parent table could be MyISAM.
--> Is this enforcement a feature of MySQL 4.1.8 or are we doing something wrong ?

All of the InnoDB tables (15) have been created on a single database file.
-> Anybody knows if there is any documentation with recommendations about the improvement of the type of database, creating tables in different physical files, mysql's performance variable tuning, etc ?

Thanks in advance.
Joselu

Options: ReplyQuote


Subject
Views
Written By
Posted
MyISAM / InnoDB in 4.1.7 vs 4.1.8
1674
September 20, 2005 06:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.