InnoDB data files size

InnoDB data files size

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

		Unix Technical Forum > Database Server Software > MySQL
InnoDB data files size

#1 (permalink)

02-28-2008, 09:07 AM

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

« MAX_JOIN_SIZE | replace query »

Thread Tools
Show Printable Version Email this Page
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 vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

All times are GMT. The time now is 06:15 AM.