FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » General » Database discussions » Tip for mysql
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Tip for mysql [message #1794] Mon, 22 April 2002 21:36 Go to next message
JayЩ~ is currently offline  JayЩ~   United States
Messages: 37
Registered: April 2002
Location: Florida, USA
Karma: 0
Member
add to buddy list
ignore all messages by this user
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 #1801 is a reply to message #1794] Mon, 22 April 2002 22:03 Go to previous messageGo to next message
hackie is currently offline  hackie   Canada
Messages: 177
Registered: January 2002
Karma: 0
Senior Member
Core Developer
add to buddy list
ignore all messages by this user

Ya sure that wasn't the mutex overspin problem with glibc+mysql?

cc intelligence.c -o intelligence
$ ./intelligence
Segmentation fault
Re: Tip for mysql [message #1860 is a reply to message #1801] Tue, 23 April 2002 17:07 Go to previous messageGo to next message
JayЩ~ is currently offline  JayЩ~   United States
Messages: 37
Registered: April 2002
Location: Florida, USA
Karma: 0
Member
add to buddy list
ignore all messages by this user
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 #1873 is a reply to message #1860] Tue, 23 April 2002 19:18 Go to previous messageGo to next message
hackie is currently offline  hackie   Canada
Messages: 177
Registered: January 2002
Karma: 0
Senior Member
Core Developer
add to buddy list
ignore all messages by this user

JayЩ~ wrote on Tue, 23 April 2002 5:07 PM

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.


basically, do you compile mysql yourself, or use the binary provided by the mysql guys?


cc intelligence.c -o intelligence
$ ./intelligence
Segmentation fault
Re: Tip for mysql [message #1875 is a reply to message #1873] Tue, 23 April 2002 19:33 Go to previous messageGo to next message
JayЩ~ is currently offline  JayЩ~   United States
Messages: 37
Registered: April 2002
Location: Florida, USA
Karma: 0
Member
add to buddy list
ignore all messages by this user
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 19:51 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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 Smile

That means you are not affected by the problem hackie mentioned.


FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Next Topic: binding mysql to localhost (I/O)
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 12 22:47:29 EST 2017

Total time taken to generate the page: 0.00723 seconds