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.

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL 4.1 to 5.1 large scale upgrade
April 02, 2011 12:00PM


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.