MySQL Forums
Forum List  »  Performance

Re: High memory used by MySQL
Posted by: Peter Brawley
Date: February 13, 2020 11:49AM

Formula used ...

innodb_buffer_pool_size +
innodb_ft_total_cache_size + innodb_additional_mem_pool_size + innodb_log_buffer_size + query_cache_size + tmp_table_size + key_buffer_size + max_connections * ( thread_stack + max( max_allowed_packet, net_buffer_length ) + net_buffer_length + read_buffer_size + read_rnd_buffer_size + sort_buffer_size + join_buffer_size )

[corrected]

There's code under "Optimisation cheatsheet" at https://www.artfulsoftware.com/infotree/mysqltips.php that produces most of the analysis I posted here.

The link to the MySQL mem use page didn't survive copy/paste, here it is: https://dev.mysql.com/doc/refman/8.0/en/memory-use.html



Edited 2 time(s). Last edit at 02/14/2020 11:05AM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
1191
February 12, 2020 02:45AM
808
February 12, 2020 11:41AM
638
February 13, 2020 09:24AM
Re: High memory used by MySQL
660
February 13, 2020 11:49AM
643
February 14, 2020 09:05AM
552
February 14, 2020 11:06AM
620
March 02, 2020 04:12AM
533
March 02, 2020 04:17PM
432
March 02, 2020 08:35PM
488
March 02, 2020 08:36PM
580
March 03, 2020 06:12AM
486
March 03, 2020 11:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.