Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New Coder
    Join Date
    Jan 2011
    Location
    Space
    Posts
    19
    Thanks
    1
    Thanked 0 Times in 0 Posts

    MySQL server settings.

    My MySQL server is currently set to all default settings:

    Key buffer size: Default
    Maximum packet size: Default
    Sort buffer size: Default
    Network buffer size: Default
    MyISAM sort buffer size: Default
    Tables to cache: Default
    Maximum number of connections: Default

    The website has around 5,500 members online at once at it's daily peak, many of which using automated software for whatever reason, causing the database to give this error at random times:

    "Can't connect to MySQL server on '0.0.0.0' (99)"
    [Example IP]

    I assume this is a problem with the handling of the cache and users so I was just wondering, based on the statistics, what the best settings for the MySQL database should be?
    If it's some other problem I overlooked, then a resolution to that would be very appreciated too.
    Last edited by Celestial; 07-06-2011 at 03:20 PM. Reason: Resolved.

  • #2
    Rockstar Coder
    Join Date
    Jun 2002
    Location
    USA
    Posts
    9,074
    Thanks
    1
    Thanked 328 Times in 324 Posts
    If memory serves error 99 means you have exhausted all your outgoing TCP ports. Meaning you have too many connections. What is your website coded in? PHP?

    A couple solutions you can look at:
    1) Use a persistent connection
    2) Lower the connection timeout value
    OracleGuy

  • #3
    New Coder
    Join Date
    Jan 2011
    Location
    Space
    Posts
    19
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by oracleguy View Post
    If memory serves error 99 means you have exhausted all your outgoing TCP ports. Meaning you have too many connections. What is your website coded in? PHP?

    A couple solutions you can look at:
    1) Use a persistent connection
    2) Lower the connection timeout value
    Yeah it's all done in PHP.
    Thanks, I'll look into that.

    Oh, forgot to mention, this error comes up every so often aswell:

    Lost connection to MySQL server at 'reading initial communication packet', system error: 110
    Last edited by Celestial; 07-05-2011 at 05:26 PM.


  •  

    Posting Permissions

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