Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2005
    Location
    Montreal, PQ
    Posts
    355

    MySQL Max possible connections?

    I'm currently using MySQL 4.1.12 for Windows 2003, and I need to know how much possible connections can MySQL achieve? I'm currently around 650. I'm having 4 new servers online, and that will bring my total concurrent connections to 1000+.

    Anyone knows how high it can go?
    Servers proudly hosted at... WebNX (10) - Netelligent (6)
    Also enjoying services from DreamHost, Hyperspin
    (#) indicates number of servers - 16 total

  2. #2
    Join Date
    Dec 2004
    Location
    New York, NY
    Posts
    10,574
    http://dev.mysql.com/doc/refman/5.1/...nnections.html

    Officially;

    The maximum number of connections MySQL can support depends on the quality of the thread library on a given platform. Linux or Solaris should be able to support 500-1000 simultaneous connections, depending on how much RAM you have and what your clients are doing. Static Linux binaries provided by MySQL AB can support up to 4000 connections.

  3. #3
    Join Date
    Feb 2005
    Location
    Montreal, PQ
    Posts
    355
    Thanks for the link. However it doesn't mention anything about Windows. I've tried setting the maxconnections to 1500, but MySQL wouldn't start. Right now I have it set 1200.
    Servers proudly hosted at... WebNX (10) - Netelligent (6)
    Also enjoying services from DreamHost, Hyperspin
    (#) indicates number of servers - 16 total

  4. #4
    Join Date
    Nov 2002
    Location
    WebHostingTalk
    Posts
    8,878
    * Moved to Technical and Security Issues...

    Sirius
    I support the Human Rights Campaign!
    Moving to the Tampa, Florida area? Check out life in the suburbs in Trinity, Florida.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •