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]
