Handling Many Connections

• Understand MySQL's memory usage

  • Global Variables
    • MyISAM key buffer, InnoDB buffer pool
  • Per-thread variables
    • Sort buffer, record buffer, join buffer, etc.

• Number of connections vs. Active connections

• The wait_timeout is your friend

• Connection pooling may be helpful

• Some thread libraries use limits ~1024