MySQL Memory Allocation - Everything MySQL2024-03-29T14:18:04Zhttp://everythingmysql.ning.com/forum/topics/mysql-memory-allocation?commentId=3993569%3AComment%3A45&x=1&feed=yes&xn_auth=noI like it better than mine gi…tag:everythingmysql.ning.com,2009-09-07:3993569:Comment:452009-09-07T04:11:05.000ZChrishttp://everythingmysql.ning.com/profile/Chris
I like it better than mine given that yours explains a bit more and that max_connections * 2 is not the multiplier for the whole equation.
I like it better than mine given that yours explains a bit more and that max_connections * 2 is not the multiplier for the whole equation. Chris,
Good formula! I use a…tag:everythingmysql.ning.com,2009-09-07:3993569:Comment:432009-09-07T04:10:34.000ZSarah Sproehnlehttp://everythingmysql.ning.com/profile/SarahSproehnle
Chris,<br />
<br />
Good formula! I use a similar one, generally this:<br />
innodb_buffer_pool_size +<br />
key_buffer_size +<br />
query_cache_size +<br />
(max_connections * (192k + sort_buffer_size + read_buffer_size + tmp_table_size)) +<br />
32M<br />
<br />
Note: 192k is the approximate thread size. The 32M accounts for the binaries and some other settings that I didn't add into the formula. Of course there are plenty of things that aren't being accounted for that *could* get used, but this formula gives a pretty good estimate of worse case…
Chris,<br />
<br />
Good formula! I use a similar one, generally this:<br />
innodb_buffer_pool_size +<br />
key_buffer_size +<br />
query_cache_size +<br />
(max_connections * (192k + sort_buffer_size + read_buffer_size + tmp_table_size)) +<br />
32M<br />
<br />
Note: 192k is the approximate thread size. The 32M accounts for the binaries and some other settings that I didn't add into the formula. Of course there are plenty of things that aren't being accounted for that *could* get used, but this formula gives a pretty good estimate of worse case ram usage. Here is a formula that I alwa…tag:everythingmysql.ning.com,2009-09-07:3993569:Comment:162009-09-07T03:44:54.000ZChrishttp://everythingmysql.ning.com/profile/Chris
Here is a formula that I always use:<br />
innodb_buffer_pool_size<br />
+ key_buffer<br />
+ max_connections * (join_buffer + sort_buffer + read_buffer + binlog_cache_size)<br />
+ max_connections * 2<br />
---------------------<br />
= TOTAL RAM MYSQL CAN USE<br />
<br />
Note: this is a general formula so make sure you do you do-diligence for your system before you plug all the numbers into production.
Here is a formula that I always use:<br />
innodb_buffer_pool_size<br />
+ key_buffer<br />
+ max_connections * (join_buffer + sort_buffer + read_buffer + binlog_cache_size)<br />
+ max_connections * 2<br />
---------------------<br />
= TOTAL RAM MYSQL CAN USE<br />
<br />
Note: this is a general formula so make sure you do you do-diligence for your system before you plug all the numbers into production. A simple, uneventful answer i…tag:everythingmysql.ning.com,2009-09-07:3993569:Comment:142009-09-07T03:44:40.000ZChrishttp://everythingmysql.ning.com/profile/Chris
A simple, uneventful answer is: <a href="http://dev.mysql.com/doc/refman/5.0/en/memory-use.html">http://dev.mysql.com/doc/refman/5.0/en/memory-use.html</a>
A simple, uneventful answer is: <a href="http://dev.mysql.com/doc/refman/5.0/en/memory-use.html">http://dev.mysql.com/doc/refman/5.0/en/memory-use.html</a>