# innodb\_data\_file\_path

**URL:** <https://forums.percona.com/t/innodb-data-file-path/7554>\
**Category:** Other MySQL® Questions\
**Created:** [April 20, 2020, 3:25am UTC](https://forums.percona.com/t/innodb-data-file-path/7554 "2020-04-20T03:25:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![george\_zabbix](https://avatars.discourse-cdn.com/v4/letter/g/91b2a8/32.png) [@george\_zabbix](https://forums.percona.com/u/george_zabbix)\
**Post date:** [April 20, 2020, 3:25am UTC](https://forums.percona.com/t/innodb-data-file-path/7554/1 "2020-04-20T03:25:27Z")

</div>

Which is recommended to set the parameter value for the best performance of a highly loaded database (zabbix):

```auto
innodb_data_file_path

```

or what this parameter may depend onVarious examples are described on the Internet:  
  
innodb\_data\_file\_path = ibdata1: 128M; ibdata2: 128M: autoextend: max: 4096M  
  
innodb\_data\_file\_path = ibdata1: 1Ginnodb\_data\_file\_path = ibdata1: 10M: autoextend  
  
innodb\_data\_file\_path = / data / ibdata1: 2000M; / data / ibdata2: 2000M / data / ibdata3: 100M: autoextend: max: 2000M

---

<div class="post-metadata">

**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\
**Post date:** [April 20, 2020, 11:28am UTC](https://forums.percona.com/t/innodb-data-file-path/7554/2 "2020-04-20T11:28:41Z")

</div>

Hello @george_zabbix&nbsp;   
Without knowing all about your application (which is out of scope for the open source forum), it’s hard to help on this one. However, there are lots of resources on the Percona blog, webinars, and e-books that could help you work through performance issues, including on benchmark testing etc.&nbsp;  
Here are some links:

- [https://www.percona.com/resources/webinars](https://www.percona.com/resources/webinars "Link: https://www.percona.com/resources/webinars")
- A really old post but might give some insight onto process of evaluation&nbsp;[https://www.percona.com/blog/2014/11/14/optimizing-mysql-zabbix/](https://www.percona.com/blog/2014/11/14/optimizing-mysql-zabbix/ "Link: https://www.percona.com/blog/2014/11/14/optimizing-mysql-zabbix/")&nbsp;
- [https://www.percona.com/resources/ebooks/practical-mysql-performance-optimization-section-1](https://www.percona.com/resources/ebooks/practical-mysql-performance-optimization-section-1 "Link: https://www.percona.com/resources/ebooks/practical-mysql-performance-optimization-section-1")

See how you get on?