I want to increase Max-connection upto 1000 .How much RAM is required current 4GB RAM with Max-connection 500 ...

If any formula please share to me


1 Answer 1


This is an interesting read for How MySQL uses memory

We have, Global Buffers: key_buffer_size, innodb_buffer_pool_size, innodb_additional_mem_pool_size, innodb_log_buffer_size, query_cache_size


Per Thread Buffers: read_buffer_size, read_rnd_buffer_size, sort_buffer_size, join_buffer_size, thread_stack, max_allowed_packet, net_buffer_length

To calculate present status you can download procedure here and just run it from MySQL.

I guess we can formulate number of Threads (nT) = ( R - GB ) / PTB


R - Ram

GB - Global Buffers

PTB - Per Thread Buffers

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.