0

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

0

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

and

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

Where,

R - Ram

GB - Global Buffers

PTB - Per Thread Buffers

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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