I have a decent number of tables (around 100 ~ 150 ish), some of them are really chunky. The total db is close to 40 gb.
Cheers Manoj ----- Original Message ----- From: "Rafal Kedziorski" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 19, 2005 4:57 PM Subject: Re: MySQL 4.015 Vs MySQL 4.1.x > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
