Maximum connection to mysql database?

Discussion in 'MySQL' started by virtualmisc, Feb 10, 2010.

  1. #1
    How do I change maximum connection to mysql database and maximim user connection to mysql?
     
    virtualmisc, Feb 10, 2010 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    Change the max_connections directive in your php.ini/php.cnf file.
     
    jestep, Feb 10, 2010 IP
  3. koko5

    koko5 Active Member

    Messages:
    394
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    70
    #3
    Hi,

    You can do it with a query too:
    
    SET GLOBAL MAX_CONNECTIONS=1001;
    
    Code (markup):
    Regards
    Edit: This query must be executed once when your mysql server starts.
     
    Last edited: Feb 10, 2010
    koko5, Feb 10, 2010 IP