Innodb_data_file_path for zabbix

[GeorgeKup]

Do not tell me if setting this parameter to MySQL performance can be of any value:

innodb_data_file_path

on the Internet describe different meanings:

innodb_data_file_path = ibdata1: 128M; ibdata2: 128M: autoextend: max: 4096M

innodb_data_file_path = ibdata1: 1G

innodb_data_file_path = ibdata1: 10M: autoextend

innodb_data_file_path = / data / ibdata1: 2000M; / data / ibdata2: 2000M / data / ibdata3: 100M: autoextend: max: 2000M

Does it make any sense if the innodb_file_per_table = 1 parameter is set at the same time to set the innodb_data_file_path parameter?

[tim.mooney]

This question really is about MySQL and/or MariaDB, not Zabbix. I think you might get better results if you ask the question on the MySQL or Percona forums.