New answers tagged

2

Such a tool would be almost completely worthless in practical use. max_connections has nothing to do with performance. It's a safety mechanism to prevent a runaway application from making so many connections that the server becomes overwhelmed. The value makes absolutely no difference unless you are using that many connections. It is also a value that ...


-2

I have been using mysqltuner.pl from mysqltuner.com for years. It's not automatic, it analyses and makes recommendations. Good for part time dba's like me.


0

Im not sure about a script but you can build your own based on MySQL recommendations and good practices shared by experts here: InnoDB Buffer Pool Hit Rate How much memory do I need for innodb buffer pool? Optimal Number of MySQL InnoDB Buffer Pool Instances Making sense of INNODB buffer pool stats How to clear/flush mysql innodb buffer pool? MySQL ...



Top 50 recent answers are included