IT/Software/Database Applications/mysql config: Difference between revisions

Access restrictions were established for this page. If you see this message, you have no access to this page.

Latest revision as of 18:13, 6 February 2020

Put config modifications here.

Revision as of 16:48, 6 February 2020 (view source) 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...") Tag: Visual edit		Latest revision as of 18:13, 6 February 2020 (view source) Nathan (talk \| contribs) No edit summary Tag: Visual edit
Line 1:		Line 1:
	~~As you may know we have had the issue of our web apps freezing up when a mysql dump is running.~~		Put config modifications here.

	~~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~~.