| Tip for mysql [message #1794] |
Tue, 23 April 2002 01:36  |
JayЩ~
Messages: 37
Registered: April 2002
Location: Florida, USA
Karma: 0
|
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.
|
|
|
|
|
|
| Re: Tip for mysql [message #1860 is a reply to message #1801] |
Tue, 23 April 2002 21:07  |
JayЩ~
Messages: 37
Registered: April 2002
Location: Florida, USA
Karma: 0
|
Member |
|
|
| hackie wrote on Mon, 22 April 2002 10:03 PM |
Ya sure that wasn't the mutex overspin problem with glibc+mysql?
|
I really don't know hackie. I applied that tip and since then it hasn't occured again. I'v heard about that problem before but I don't know how it acts to really know. I do know it would lock my servers up everytime and you would see it in the log file that it couldn't connect.
Picture the daffodil. And while you do that, I'll be over here going through your stuff.
|
|
|
|
|
|
| Re: Tip for mysql [message #1875 is a reply to message #1873] |
Tue, 23 April 2002 23:33 |
JayЩ~
Messages: 37
Registered: April 2002
Location: Florida, USA
Karma: 0
|
Member |
|
|
| hackie wrote on Tue, 23 April 2002 7:18 PM |
basically, do you compile mysql yourself, or use the binary provided by the mysql guys?
|
I used the binary from them. Good or bad?
Picture the daffodil. And while you do that, I'll be over here going through your stuff.
|
|
|
|
| Re: Tip for mysql [message #1877 is a reply to message #1875] |
Tue, 23 April 2002 23:51 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
| JayЩ~ wrote on Tue, 23 April 2002 7:33 PM |
| hackie wrote on Tue, 23 April 2002 7:18 PM |
basically, do you compile mysql yourself, or use the binary provided by the mysql guys?
|
I used the binary from them. Good or bad?
|
Good 
That means you are not affected by the problem hackie mentioned.
FUDforum Core Developer
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]