4/7/2023 0 Comments Mysql optimizer scriptRecommendations -Ĭ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% 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. ![]() 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
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |