hi all,
i have the next question. In mysql, i have just one file, ibdata1, to storage all data, index, ecc, of all tables InnoDB of all databases that i have in my instance of mysql.
Can I to separate each database in mode that each database have your own ibdata1 file, maybe in differents disk or differents server ??

i am thinking to use innodb_file_per_table. In terms of performance, is it a good idea???

thx in advance

Hi, AFAIK InnoDB by design uses single file to hold all data. It is not possible to have file per table set up (like MyISAM).

Thanks and sorry for providing incorrect information. All the best!

Hi Alan22,
sorry but it is possible. Please you refer this link