Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2003
    Posts
    186

    maximum mysql connection

    hi guyz

    can u people tell me how to increase maximum mysql connection on the server?

    on my server right now may sites show too many mysql connections

    can you tell me the command which to run in root which will increase the maximum amount of mysql connection

    also tell me how to see the current amount of mysql connections so i can increase accordingly thanks

  2. #2
    Join Date
    Nov 2001
    Posts
    5,383
    pico /etc/my.cnf

    Assuming your running version 4

    [mysqld]
    set-variable = max_connections=1000
    query_cache_limit = 1M
    query_cache_size = 32M
    query_cache_type = 1

    If your not

    [mysqld]
    set-variable = max_connections=1000
    Clustered Hosting With Continuous Data Protection (CDP)
    http://www.solidinternet.com
    8 Years of hosting excellence!

  3. #3
    Join Date
    May 2003
    Posts
    90
    What would be a good setting (ie won't cause 80% load) for my server?

    I've got a

    P4 2.6, 512MB DDR.

    And what about for a:

    Dual Xeon 2.0, 1GB DDR

    Anyway for unlimited connections?

    Cheers
    Jack

  4. #4
    Join Date
    Nov 2001
    Posts
    5,383
    It depends on what version your running. Goto www.vbulletin.com/forum/ for tips on mysql tweaking.
    Clustered Hosting With Continuous Data Protection (CDP)
    http://www.solidinternet.com
    8 Years of hosting excellence!

  5. #5
    Join Date
    May 2003
    Posts
    90

    Thumbs up

    Woah, what a l337 forum!! Cheers!!

  6. #6
    Join Date
    Jun 2003
    Posts
    186
    thx it worked

    i have set it to 750

    it was 500 before

  7. #7
    Join Date
    Nov 2001
    Posts
    5,383
    Clustered Hosting With Continuous Data Protection (CDP)
    http://www.solidinternet.com
    8 Years of hosting excellence!

Posting Permissions

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