Hi,
I'm thinking too about switching to MySQL 4.1.x and if it better to user file per table.
How much tables and data have you in your db? And which performance you have?
Best Regards, Rafal
At 09:53 19.05.2005, ManojW wrote:
Dear All, I am using MySQL 4.0.15 on a Linux (RH9) for the past 18 months. All my tables are InnoDB and tend to be extremely large in nature (running in couple of millions, actually the ibdata files now stand at 40GB's). Typically, the database has fewer connections but those who connect use the database pretty heavily (basically for mathematical modelling purpose etc). Basically I am very happy with MySQL/InnoDB and I think the developers did an amazing at that.
With MySQL 4.1.x being stable for a while, I am wondering if I should upgrade from MySQL 4.0.15 to MySQL 4.1.x?
The pros of the migration are : 1) Ability to use prepared statements (avaliable from 4.1.x onwards) 2) Ability to perform nested queries.
On the cons side, the biggest factor is .....Migration ;-).
Based on your experiences, Could you kindly help me in making a better decision? Should I go ahead with the migration? If I do the migration, will it have any *significant impact* on the following factors:
1) Performance (Speed of execution etc) 2) Efficiency in terms of database size 3) New features/bug fixes that can potentially made your life easier after the migration.
I guess the performance factors is of my biggest concern. Everything equal, I don't want the speed to slow down If I go ahead with the migration ;-)
Your kind inputs please!!. Thank you in advance.
Cheers
Manoj
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
