3 ms·

What did you do to address the mysql connection problem?

• nvivo 8y ago
  I ended up reducing the number of clients. In my case I had a thousand servers, and I was able to change the application structure and merge them into a dozen big application servers. Now with connection pooling each server has less than 100 connections. As a more permanent solution for scaling, I'm moving out of mysql into something more distributed.
  • kolzeq 8y ago
    Or you can have move to mariadb, using configuration "thread_handling=pool-of-threads" to enable threadpool that is exactly the solution. (MySQL have that only for "entreprise" version)
  • ngrilly 8y ago
    Something more distributed like what?