InnoDB data files size

This is a discussion on InnoDB data files size within the MySQL Database forums, part of the Database Forums category; Hello, I was wondering, is there any difference, performance wise, between having 1 big data file instead of a few ...

		Usenet Forums > Database Forums > MySQL Database
InnoDB data files size

LinkBack

Thread Tools

Search this Thread

Display Modes

#1 (permalink)

02-08-2007

Renaud

Posts: n/a

InnoDB data files size

Hello,

I was wondering, is there any difference, performance wise, between
having 1 big data file instead of a few small ones? eg (10x25GB vs.
1x250GB, or even using innodb_file_per_table)
Are there special cases it would matter?
Is there a best practice?

I cannot find anything about that in the docs, nor in various mysql
tuning papers.

Regards,
Renaud

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are Off [IMG] code is Off HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

All times are GMT +1. The time now is 03:45 AM.