Is there any tool that allows you to check what db settings can be optimized in a server?

• MySQLTuner-perl

  22 8,627 8.5 Perl

  MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.

There are tools like MySQLTuner that suggests changes to do in the configuration to optimize some things, based on status variables and buffers usage. I suppose that it is the short answer you are searching for.

• awesome-mysql-performance

  10 461 4.4

  🔥 A curated list of awesome links related to MySQL / MariaDB / Percona performance tuning

  

But the best tool is understanding how the different part of the system and usage affects performance, and decide how to proceed based on information that might or not be in the database server itself. There are optimizations that go to hardware, OS, replication, database structure/indexes, frequently done queries, and probably more. And you need to take into account that the database and the system around it is not static, in particular how you use it, so some in production monitoring may be helpful. There are plenty of articles and presentations that tells you which variables and settings you should focus on depending on how you use the db (this could be an starting list), do some frequent queries analysis, and even use some good mysql monitoring like PMM that could give you more hints.

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

Suggest a related project