Hello, For some time now, MySQL crashes once or twice a week pn my ISPC 3 server, sometimes more. I suspect it has something to do with the ibdata1 file size. It's on a 5 Go partition and is 3.4 Go big. I want to reduce this file's size, and found several procedures to do this, but wanted to check with the ISPC team if these are OK. For example , this one seems good to me : http://erikimh.com/how-to-shrink-an-ibdata1-file-with-minimal-mysql-downtime/. Can somebody check if it's safe to execute this procedure ? Besides, what would be ok parameters to prevent this file from growing endlessly (apart from the normal data feeding) ? Again, I found several articles about this, but am not sure if they're compatible with the ISPC setup. Thanks.
I guess this procedure should work. ISPCOnfig just uses mysql as a normal database, I dont see a way how a config could be incompatible except of changing the port or socket path, which would affect all your website cms systems as well.
