Open main menu

Changes

→‎Tools: steps to use Percona Toolkit
Aside from [[mysqldump]], there are also mysqlcheck, mysql_upgrade and other [https://dev.mysql.com/doc/refman/5.7/en/programs-client.html client programs].
#[https://www.mysql.com/products/workbench/ MySQL Workbench ] is a great visual tool, but behind several obstacles and Oracles.#[https://dbeaver.io/ DBeaver]
#[https://github.com/major/MySQLTuner-perl/blob/master/INTERNALS.md MySQLTuner] by the aforementioned Major Hayden (he made a Python version too)
#[https://www.percona.com/software/database-tools/percona-toolkit Percona Toolkit] <code>wget <nowiki>https://downloads.percona.com/downloads/percona-toolkit/3.5.7/binary/redhat/8/x86_64/percona-toolkit-3.5.7-1.el8.x86_64.rpm</nowiki></code> <code>dnf install percona-toolkit-3.5.7-1.el8.x86_64.rpm</code> <code>pt-mysql-summary</code>
#http://mysqlsandbox.net/index.html MySQL sandbox could be useful for playing around with multiple databases in development.
#https://www.experts-exchange.com/questions/29060302/Tune-MySQL-to-32GB-RAM.html
#https://www.tecmint.com/mysql-mariadb-performance-tuning-and-optimization/
# https://www.percona.com/blog/10-mysql-performance-tuning-settings-after-installation/
#https://www.percona.com/blog/2016/10/12/mysql-5-7-performance-tuning-immediately-after-installation/
#https://www.percona.com/blog/2009/11/16/table_cache-negative-scalability/