Bureaucrats, confirmed, Administrators
4,558
edits
Changes
added tools and tuning reference links
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].
# MySQL Workbench is a great visual tool.# [https://github.com/major/MySQLTuner-perl/blob/master/INTERNALS.md MySQLTuner]# http://mysqlsandbox.net/index.html MySQL sandbox could be useful for playing around with multiple databases in development. == Tuning Reference ==# https://mariadb.com/kb/en/library/configuring-mariadb-for-optimal-performance# 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/2014/01/28/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/
[[Category:Database]]