system table space vs file per table space
Hi,
There are some issues on my mysql servers.
I just changed the configuration for innodb table space from system table spaces to file per table spaces.
In results, CPU usage get higher than before.
There are 30 patitining tables. The size of each table is about 200GB.
Total size is about over 6TB.
I want to know how to reduce the usage of cpu.
which one is better for performance between system table spaces and file per table spaces ?
Subject
Views
Written By
Posted
system table space vs file per table space
1376
March 27, 2015 12:35AM
677
March 28, 2015 03:36PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.