Recommendations -Ĭontrol warning line(s) into /var/log/mysql/error.log fileĬontrol error line(s) into /var/log/mysql/error.log file Semi synchronous replication Slave: Not Activated Semi synchronous replication Master: Not Activated No replication slave(s) for this server. InnoDB log waits: 0.00% (0 waits / 10 writes) InnoDB Write log efficiency: 98.44% (632 hits/ 642 total) InnoDB Read buffer efficiency: 94.53% (13840 hits/ 14641 total) Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances Number of InnoDB Buffer Pool Chunk : 1 for 1 Buffer Pool Instance(s) Ratio InnoDB log file size / InnoDB Buffer pool size (75 %): 48.0M * 2/128.0M should be equal 25%
![mysql optimizer script mysql optimizer script](https://www.sqlmanager.net/sites/default/files/assets/images/studio/my/my-studio-sql-formatter-tumb2.png)
![mysql optimizer script mysql optimizer script](https://image.slidesharecdn.com/mysqloptimizeroverview2016-160501145319/95/mysql-optimizer-overview-11-638.jpg)
InnoDB buffer pool / data size: 128.0M/16.0K Cannot calculate MyISAM index size - re-run script as root user Key buffer used: 18.2% (3M used / 16M cache) Binlog cache memory access: 0% (0 Memory / 0 Total) Table locks acquired immediately: 100% (4 immediate / 4 locks) Table cache hit rate: 56% (104 open / 185 opened) Thread cache hit rate: 92% (1 created / 13 connections) Temporary tables created on disk: 0% (0 on disk / 4 total) Query cache have been removed in MySQL 8 name resolution is active : a reverse name resolution is made for each new connection and can reduce performance Highest usage of available connections: 0% (1/151) Overall possible memory usage with other process is compatible with memory available Maximum possible memory usage: 349.4M (17.64% of installed RAM) Maximum reached memory usage: 177.1M (8.94% of installed RAM) Total buffers: 176.0M global + 1.1M per thread (151 max threads) Binary logging is enabled (GTID MODE: OFF) Skipped due to unsupported feature for MySQL 8 No stat updates during querying INFORMATION_SCHEMA. Data in InnoDB tables: 16.0K (Tables: 1) Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA 2 shutdown(s) detected in /var/log/mysql/error.log 4 start(s) detected in /var/log/mysql/error.log var/log/mysql/error.log contains 3 error(s). var/log/mysql/error.log contains 6 warning(s). Log file /var/log/mysql/error.log is smaller than 32 Mb Log file /var/log/mysql/error.log is not empty Log file /var/log/mysql/error.log is readable. Log file /var/log/mysql/error.log exists Currently running unsupported MySQL version 8.0.23-0ubuntu0.20.04.1 Logged in using credentials from Debian maintenance account. Skipped version check for MySQLTuner script > Run with '-help' for additional options and output filtering > Bug reports, feature requests, and downloads at You will get an output similar to this: mysqltuner Then enter root as the username and the MySQL root password.
![mysql optimizer script mysql optimizer script](https://image.slidesharecdn.com/mysqloptimizeroverview2016-160501145319/95/mysql-optimizer-overview-49-638.jpg)
#MYSQL OPTIMIZER SCRIPT INSTALL#
The mysqltuner High-Performance MySQL Tuning Script is available as a package on Debian 10 and Ubuntu 20.04, install it with at: sudo apt install mysqltunerįor other Distributions, download and install mysqltuner as described below: cd /usr/local/binĬhmod +x mysqltuner Optimize MySQL Performance