[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[cobalt-users] Re:MySQL Crashing server



At 10:47 AM -0500 2/7/03, ISEE Multimedia is rumored to have typed:

> It seems that MySQL or rather someones script using MySQL is spawning lots
> of connections and killing the server.
<snip>
> 1, Where are the MySQL logs located?

   Hit mysql.com and check section 4.9 of the manual, which discusses the
various logs you may have in your mysql/ directory.

> 2. How do you go about increasing the maximum connections and is this safe?

   Er...don't you want to REDUCE the maximum number of connections, so your
server doesn't crash? (If it crashes at max_connections's current settings,
how will _increasing_ it do you any good? Sounds to me like you want to slow
down this runaway script, not help it smash things...)

   Again, see mysql.com in the Documentation section, the Manual, and search
for max_connections.

          Charlie