FUDforum: Database discussions

Home » General » Database discussions » Tip for mysql

Show: Today's Messages :: Polls :: Message Navigator

Tip for mysql [message #1794]

Tue, 23 April 2002 01:36

JayÐ©~

Messages: 37
Registered: April 2002
Location: Florida, USA

Karma:

Member

I ran into errors that would actually lock up my Linux servers, never thought that would happen, and it turned out that the amount of traffic we were generating was using every available connection for mysql. Mysql qould just go in an endless loop waiting for a connection to free up. This is what I had to do.

In your boot script, I use a plain startup script called startup in init.d, add these entries

echo 65536 > /proc/sys/fs/file-max
echo 8192 > /proc/sys/fs/dquot-max
echo 1024 > /proc/sys/fs/super-max

Then in your /etc/my.cnf add

[safe_mysqld]
open-files-limit=8192

This should allow 8192 connections and files. It's worked for me with no problems anymore. Only one side effect I have seen is XWindows seems to be even more slow than before, then again XWindows is a resource hog.

Picture the daffodil. And while you do that, I'll be over here going through your stuff.

Report message to a moderator

[Message index]

		Tip for mysql By: JayÐ©~ on Tue, 23 April 2002 01:36
		Re: Tip for mysql By: hackie on Tue, 23 April 2002 02:03
		Re: Tip for mysql By: JayÐ©~ on Tue, 23 April 2002 21:07
		Re: Tip for mysql By: hackie on Tue, 23 April 2002 23:18
		Re: Tip for mysql By: JayÐ©~ on Tue, 23 April 2002 23:33
		Re: Tip for mysql By: Ilia on Tue, 23 April 2002 23:51

Next Topic:

binding mysql to localhost (I/O)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 04:12:23 GMT 2024

Total time taken to generate the page: 0.04022 seconds