ngosangns Knowledge Base

#connection-pooling

  • Database Connection Pooling
    Explains why a database connection is an expensive OS process, how connection pools work, and how to size a pool using Little's Law, Kingman's formula, and the process-to-core ratio.
  • ProxySQL Connection Multiplexing
    How ProxySQL connection multiplexing lets many frontend connections share few MySQL backend connections, when it is disabled, and how to tune it.