MySQL Forums
Forum List  »  MySQL Workbench - Database Migration

Advanced Search
New Topic

Re: MySQL 4.1 to 5.1 large scale upgrade
Posted by: Rick James
Date: April 02, 2011 12:00PM

I'm eager to hear how things turn out.

Have you considered splitting the tables among a thousand databases?

Consider switching to InnoDB, with innodb_file_per_table=OFF. Then all the tables would be in a single (big) ibdata1 file. If you decide to convert to InnoDB, read
http://mysql.rjweb.org/doc.php/myisam2innodb
And note that the disk space will be 2x-3x more.

Hmmm... Even with InnoDB, you will still have a million .frm files.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
MySQL 4.1 to 5.1 large scale upgrade
Jcink Cink
March 21, 2011 08:00PM
Re: MySQL 4.1 to 5.1 large scale upgrade
Rick James
March 22, 2011 10:01PM
Re: MySQL 4.1 to 5.1 large scale upgrade
Jcink Cink
March 23, 2011 10:57AM
Re: MySQL 4.1 to 5.1 large scale upgrade
Rick James
March 23, 2011 07:36PM
Re: MySQL 4.1 to 5.1 large scale upgrade
Saniya Deshpande
April 01, 2011 12:15AM
Re: MySQL 4.1 to 5.1 large scale upgrade
Rick James
April 02, 2011 08:32AM
Re: MySQL 4.1 to 5.1 large scale upgrade
Jcink Cink
April 02, 2011 11:33AM
Re: MySQL 4.1 to 5.1 large scale upgrade
Rick James
April 02, 2011 12:00PM
Re: MySQL 4.1 to 5.1 large scale upgrade
Jcink Cink
April 02, 2011 02:34PM
Re: MySQL 4.1 to 5.1 large scale upgrade
Rick James
April 02, 2011 11:37PM
Re: MySQL 4.1 to 5.1 large scale upgrade
Jcink Cink
April 06, 2011 11:53AM
Re: MySQL 4.1 to 5.1 large scale upgrade
jack albente
August 12, 2011 08:31AM
Re: MySQL 4.1 to 5.1 large scale upgrade
yu haimei
April 18, 2011 03:21AM
Re: MySQL 4.1 to 5.1 large scale upgrade
yu haimei
April 18, 2011 03:16AM
Re: MySQL 4.1 to 5.1 large scale upgrade
tuan phan
May 19, 2011 06:52PM
Re: MySQL 4.1 to 5.1 large scale upgrade
jack albente
October 21, 2011 08:58AM
Re: MySQL 4.1 to 5.1 large scale upgrade
outman007 outman007
April 08, 2011 12:42AM
Re: MySQL 4.1 to 5.1 large scale upgrade
yu haimei
April 18, 2011 03:12AM
Re: MySQL 4.1 to 5.1 large scale upgrade
yu haimei
April 18, 2011 03:08AM
Re: MySQL 4.1 to 5.1 large scale upgrade
Leo Wang
May 07, 2011 02:41AM
Re: MySQL 4.1 to 5.1 large scale upgrade
bennet bamrung
May 11, 2011 11:27AM
MySQL 4.1 to 5.1 large scale upgrade
Randeep Mann
August 30, 2011 11:30PM
Re: MySQL 4.1 to 5.1 large scale upgrade
rakesh kushwaha
September 14, 2011 05:32AM


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.