IT/Software/Database Applications/mysql config

From msgwiki

< IT‎ | Software‎ | Database Applications

Revision as of 16:48, 6 February 2020 by Nathan (talk | contribs) (Created page with "As you may know we have had the issue of our web apps freezing up when a mysql dump is running. It would appear that increasing the "key_buffer_size" to 512M in the file /etc...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

As you may know we have had the issue of our web apps freezing up when a mysql dump is running.

It would appear that increasing the "key_buffer_size" to 512M in the file /etc/mysql/mysql.conf.d/mysqld.cnf greatly reduces the impact on usability of the sites while running a dump.

Retrieved from "https://msgwiki.msgeducation.com/index.php?title=IT/Software/Database_Applications/mysql_config&oldid=421"