Going by this : When should I think about upgrading our RDS MySQL instance based on memory usage? for max_connections to be set at 5000 concurrent users,how much should be the RAM capacity be ?
If I add per connection over head for 5000 users, as per what I set the values as shown below, I get :
[ read_buffer_size (0.125) MB + sort_buffer_size (2 MB) + join_buffer_size (2 MB) + read_rnd_buffer_size (1 MB) + thread_stack (0.25 MB) + binlog_cache_size (0.03125 MB) ] * 5000
= ~ 26 GB.
And as per my understanding, innodb_buffer_pool_size we normally give as 75% of RAM - for optimal performance.
So my question is, per connection over head (26 GB) + 75% of RAM = RAM, then RAM capacity should be ~ 104 GB ??
Can any one pls help me out on this.