MySQL InnoDB optimization

Question

Does having separate file for each table improve InnoDB performance in MySQL. Are there any such performance tuning tips for MySQL

Jaydee · Accepted Answer · 2010-09-29 11:20:35Z

2

"Using multiple tablespaces can be beneficial to users who want to move specific tables to separate physical disks or who wish to restore backups of single tables quickly without interrupting the use of other InnoDB tables."

So any speed bump may be dependent upon the architecture of your system and how good it is at parallel reads and writes. If you keep everything on the same disk then I wouldn't have thought that it makes much difference.

answered Sep 29, 2010 at 11:20

Jaydee

4,1481 gold badge21 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mindas · Accepted Answer · 2010-09-29 16:39:00Z

1

Have a look at these articles:

http://mtocker.livejournal.com/42180.html

http://www.bigdbahead.com/?p=57

It turns out that there is a small performance penalty for having data in many files, unless you are running some exotic file system which has high overhead on working with large files. I have experienced something similar with DRBD, however I haven't done enough investigation to claim this officially.

I personally go for separate files whenever I can, especially for bigger schemas.

answered Sep 29, 2010 at 16:39

mindas

26.8k15 gold badges103 silver badges158 bronze badges

Collectives™ on Stack Overflow

MySQL InnoDB optimization

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related