Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » sizing innodb files
sizing innodb files [message #238] Mon, 09 October 2006 12:28 Go to next message
acristia is currently offline acristia
Messages: 2
Registered: October 2006
Junior Member
I am looking for some tips to correctly size the innodb tablespace.

The whole database is about 10GB and I couldn't really find which es better for MySQL/innodb tablespace (assuming one tablespace and not per table tablespace):
- un big innodb file
or
- several smaller innodb files (eg . 5 files x 2GB)

We are using AIX 5.3 (which support large filesystems) an MySQL 5.0.24.

Thanks in advance.

Alejandro.-
Report message to a moderator
Re: sizing innodb files [message #240 is a reply to message #238 ] Mon, 09 October 2006 12:50 Go to previous messageGo to next message
Peter is currently offline Peter
Messages: 405
Registered: August 2006
Senior Member
Super Guru
If you're not planning placing files on different partitions and if your file system supports files over 2GB in size I would go with single large file, it is generally more efficient for flushing dirty data pages.

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/
Report message to a moderator
Re: sizing innodb files [message #243 is a reply to message #238 ] Mon, 09 October 2006 15:33 Go to previous messageGo to next message
acristia is currently offline acristia
Messages: 2
Registered: October 2006
Junior Member
We are not planning placing files on different partitions because we are using raid 0+1.

So we will follow your suggestion , using a single file for the tablespace.

thanks.

Alejandro.-
Report message to a moderator
Re: sizing innodb files [message #1544 is a reply to message #238 ] Tue, 17 July 2007 19:28 Go to previous message
iyeat is currently offline iyeat
Messages: 1
Registered: July 2007
Junior Member
What about in the case of extremely large data files? We are using MySQL with innodb attached to a RAID device configured with RAID 5. Our data is approximately 300GB but is only going to grow larger. Would you still suggest going with one large file? Or would you break the files out into smaller sizes?

We currently have 40 4GB files configured in our setup, but are really looking for a formula that is optimal for our servers.

Thanks!

Caio

EDIT:

Server specs: MySQL 5.0.37 Mac OS X Server 10.4.10 on an Xserve with 16GB RAM attached to a 3TB Xserve RAID via fibre.

[Updated on: Tue, 17 July 2007 19:33]

Report message to a moderator
Previous Topic:Slow String field Select - what's responsible?
Next Topic:Is there a better way to page data than using LIMIT ?
Goto Forum:
  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Fri Jul 10 03:43:36 EDT 2009

Total time taken to generate the page: 0.01229 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.