MySQL Adventures: Reduce MySQL Memory Utilization With ProxySQL Multiplexing
In our previous post, we explained about how max_prepared_statement_count can bring production down . This blog is the continuity of that post. If you can read that blog from the below link.
We had set the max_prepared_stmt_count to 20000. But after that, we were facing the below error continuously.
Can't create more than max_prepared_stmt_count statements (current value: 20000)
We tried to increase it to 25000, 30000 and finally 50000. But unfortunately, we can’t fix it …[Read more]