# does make sense to tune innodb\_data\_file\_path if innodb\_file\_per\_table is active?

**URL:** <https://forums.percona.com/t/does-make-sense-to-tune-innodb-data-file-path-if-innodb-file-per-table-is-active/1452>\
**Category:** Other MySQL® Questions\
**Created:** [July 12, 2010, 3:41pm UTC](https://forums.percona.com/t/does-make-sense-to-tune-innodb-data-file-path-if-innodb-file-per-table-is-active/1452 "2010-07-12T15:41:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![gsosa](https://avatars.discourse-cdn.com/v4/letter/g/58f4c7/32.png) [@gsosa](https://forums.percona.com/u/gsosa)\
**Post date:** [July 12, 2010, 3:41pm UTC](https://forums.percona.com/t/does-make-sense-to-tune-innodb-data-file-path-if-innodb-file-per-table-is-active/1452/1 "2010-07-12T15:41:26Z")

</div>

Hello guys,

we recently switched all our tables to InnoDB.

I followed the basic instructions at [http://bit.ly/3pqQc](http://bit.ly/3pqQc) (mysqlperformanceblog) for the settings.

our server has:

- 600gb RAID1 15k disk
- 2 \* quad core
- 24gb of RAM

and this is my InnoDB configuration

# -------------------------------------------------------------------------------# ++++ InnoDB Parameters# -------------------------------------------------------------------------------# Generalinnodb\_data\_home\_dir = /var/lib/mysql/innodbinnodb\_log\_group\_home\_dir = /var/lib/mysql/innodb/logsinnodb\_file\_per\_tableinnodb\_data\_file\_path = ibdata1:100M:autoextendinnodb\_status\_file = ib\_statusinnodb\_autoextend\_increment = 10Minnodb\_support\_xa = 0innodb\_thread\_concurrency = 8innodb\_flush\_method = O\_DIRECTinnodb\_flush\_log\_at\_trx\_commit = 2# Memoryinnodb\_buffer\_pool\_size = 16Ginnodb\_additional\_mem\_pool\_size = 8Minnodb\_open\_files = 512# Logginginnodb\_log\_buffer\_size = 8Minnodb\_log\_file\_size = 256Minnodb\_log\_files\_in\_group = 2

the only parameter I’m not sure about is  
innodb\_data\_file\_path = ibdata1:100M:autoextend

but does it make sense to change that value given I have set innodb\_file\_per\_table on where each table will have it own tablespace?

thank you

---

<div class="post-metadata">

**Author:** ![yogesh77](https://avatars.discourse-cdn.com/v4/letter/y/f08c70/32.png) [@yogesh77](https://forums.percona.com/u/yogesh77)\
**Post date:** [July 17, 2010, 8:39am UTC](https://forums.percona.com/t/does-make-sense-to-tune-innodb-data-file-path-if-innodb-file-per-table-is-active/1452/2 "2010-07-17T08:39:20Z")

</div>

if you have innodb\_file\_per\_table on then changing value for parameter innodb\_data\_file\_path doesnt make any sense.

this parameter have significance only have you have single data file.

---

<div class="post-metadata">

**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\
**Post date:** [July 17, 2010, 11:56am UTC](https://forums.percona.com/t/does-make-sense-to-tune-innodb-data-file-path-if-innodb-file-per-table-is-active/1452/3 "2010-07-17T11:56:53Z")

</div>

Not exactly; read [http://www.mysqlperformanceblog.com/2010/06/10/reasons-for-r](http://www.mysqlperformanceblog.com/2010/06/10/reasons-for-r) un-away-main-innodb-tablespace/