AnsweredAssumed Answered

/var/lib/mysql disk space management

Question asked by Ben.Deutsch on Jun 19, 2017
Latest reply on Jun 26, 2017 by Ben.Deutsch

My innodb files are starting to get pretty large (80% of the mysql partition).  I'm thinking that I want to enable the innodb_file_per_table option (which is enabled by default for mysql version 5.6.6 and up where the gateway is using 5.5.53).  I found the /etc/my.cnf and noticed there was also a my.cnf.ssg (not used in the startup according to ps aufx | grep mysql).  so, now I have two questions; first can I add that option without breaking anything, and second do I have to add it to the second file (my.cnf.ssg) as well (which I'm guessing is a backup used for updating database configuration options in the patching process)?

I ask because I have seen manually editing some files causes issues (i.e. changing iptables breaks the gateway's ownership of it in policy manager, etc).

Outcomes