Professional Web Applications Themes

severe load problems, too many connections - MySQL

hi, on an apache 1.3.37/mysql 3.23.49 server we often experience a slowdown and we get random "Too many connections" errors from the MySQL-server. The problem goes away for a short time when I restart the apache (apparently not when restarting mysql). I tried to use mtop to find out what's causing this, but I see nothing special. Is there something that often causes these "too many connections" errors? thanks, -- Felix Natter...

  1. #1

    Default severe load problems, too many connections

    hi,

    on an apache 1.3.37/mysql 3.23.49 server we often experience a slowdown and
    we get random "Too many connections" errors from the MySQL-server. The
    problem goes away for a short time when I restart the apache (apparently not
    when restarting mysql).

    I tried to use mtop to find out what's causing this, but I see nothing
    special. Is there something that often causes these "too many connections"
    errors?

    thanks,

    --
    Felix Natter
    Felix Natter Guest

  2. #2

    Default Re: severe load problems, too many connections

    Felix Natter wrote:
    > hi,
    >
    > on an apache 1.3.37/mysql 3.23.49 server we often experience a slowdown and
    > we get random "Too many connections" errors from the MySQL-server. The
    > problem goes away for a short time when I restart the apache (apparently not
    > when restarting mysql).
    >
    > I tried to use mtop to find out what's causing this, but I see nothing
    > special. Is there something that often causes these "too many connections"
    > errors?
    >
    > thanks,
    >
    Not closing the connections when you're done with them? For instance,
    if you're using PHP, its garbage collector will clean them up, but not
    necessarily immediately. And if the server is loaded, it may be a while
    before connections are closed.

    Or maybe you're just getting a heavy load and you're working the poor
    server too hard.

    Sounds like you need to do some digging into what the server is doing.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    [email]jstucklexattglobal.net[/email]
    ==================
    Jerry Stuckle Guest

  3. #3

    Default Re: severe load problems, too many connections

    Felix Natter <fnattergmx.net> wrote:
    >
    > on an apache 1.3.37/mysql 3.23.49 server we often experience a slowdown and
    > we get random "Too many connections" errors from the MySQL-server. The
    > problem goes away for a short time when I restart the apache (apparently not
    > when restarting mysql).
    >
    > I tried to use mtop to find out what's causing this, but I see nothing
    > special. Is there something that often causes these "too many connections"
    > errors?
    Not enough information. Running out of connections (default: 200) is in
    most cases a symptom, not the problem itself. Probably an overloaded
    machine, leading to a congestion situation. Of course you could raise
    the connection limit, but very probably this would make things worse,
    not better.

    You need monitoring. The minimum would be to turn on the -> slow query
    log to log SQL statements taking too long. Probably you want some kind
    of performance monitoring (think: sar) for the whole server as well.


    XL
    --
    Axel Schwenke, Senior Software Developer, MySQL AB

    Online User Manual: [url]http://dev.mysql.com/doc/refman/5.0/en/[/url]
    MySQL User Forums: [url]http://forums.mysql.com/[/url]
    Axel Schwenke Guest

Similar Threads

  1. FTP Connections Problems
    By lmelendez_jr_UK in forum Macromedia Contribute Connection Administrtion
    Replies: 4
    Last Post: September 27th, 12:10 PM
  2. Problems adding connections
    By larryuk in forum Macromedia Contribute Connection Administrtion
    Replies: 0
    Last Post: April 22nd, 05:36 PM
  3. Problems with OLE DB Connections
    By PBurks in forum Dreamweaver AppDev
    Replies: 2
    Last Post: February 24th, 07:35 PM
  4. Access connections problems
    By Stefan in forum ASP
    Replies: 1
    Last Post: August 25th, 10:10 PM
  5. Multiple connections problems
    By Ron in forum Macromedia Dreamweaver
    Replies: 1
    Last Post: July 12th, 11:32 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139