Hi, I’m on MySQL PS and I’m just going through the process of tuning my database which is quite large and uses InnoDb tables. There are a number of configuration options in MySQL that affect performance and I was wondering if PS customers were able to use their own configuration settings (like we can with PHP & php.ini)?
In particular, I’m currently looking at the possibility of increasing MySQL’s innodb_buffer_pool_size because after running a diagnostic script, I can see that this is currently set way too low (280MB) and is being max’d out. (I have tables with over 25 million rows).
I’d also like to experiment with a few other settings, but we don’t seem to have access to the server at that kind of level to be able to make these kind of changes.