innodb_data_file_path

[george_zabbix]

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

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

[lorraine.pocklington]

Hello @george_zabbix 
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. 
Here are some links:

• https://www.percona.com/resources/webinars
• A really old post but might give some insight onto process of evaluation https://www.percona.com/blog/2014/11/14/optimizing-mysql-zabbix/ 
• https://www.percona.com/resources/ebooks/practical-mysql-performance-optimization-section-1

See how you get on?