mysql question - GoFuckYourself.com

grumpy · 03-07-2002, 02:06 PM

Anybody here has some knowledge of tuning a mysql server?
When the server gets a bit busy it seems that most of the sessions get locked. Machine has double PIII 800 512 meg of ram
Hits when it gets locked around an 200 hits a minute

AdultWire · 03-07-2002, 02:14 PM

What do you mean by locked? What is the effect of this "lock" -- I have some experience with mysql. (I serve about 2.5 million mysql generated pages per day -- off one box)

Lane · 03-07-2002, 02:55 PM

maybe you set the limit for number of connections too low? also dont use persistent connections, they do nothing but waste mysql resources..

grumpy · 03-07-2002, 03:06 PM

Adultwire
Thanks a lot...that helped ( until now :-)

AdultWire · 03-07-2002, 03:06 PM

The persistant thing wastes resources if you're running php as a CGI, but if you're running it as a module, it can do some good. Seems the problem here is slow table updates/no indexes.

AdultWire · 03-07-2002, 03:48 PM

Definately msg me or icq me and let me know if the problem is solved during peak hours tommorow.

The Hun · 03-08-2002, 01:14 AM

Use PostgresQL, that goes slow on many request, but doesn't die like MySQL does. MySQL is unsuitable for things like counters and such, especially when you start doing bigger numbers

03-07-2002, 02:06 PM	#1
grumpy Too lazy to set a custom title Join Date: Jan 2002 Location: Holland Posts: 9,870	mysql question Anybody here has some knowledge of tuning a mysql server? When the server gets a bit busy it seems that most of the sessions get locked. Machine has double PIII 800 512 meg of ram Hits when it gets locked around an 200 hits a minute __________________ Don't let greediness blur your vision \| You gotta let some shit slide icq - 441-456-888

03-07-2002, 02:14 PM	#2
AdultWire Confirmed User Join Date: Feb 2002 Location: Toronto, ON Posts: 962	What do you mean by locked? What is the effect of this "lock" -- I have some experience with mysql. (I serve about 2.5 million mysql generated pages per day -- off one box) __________________ SIG TOO BIG! Maximum 120x60 button and no more than 3 text lines of DEFAULT SIZE and COLOR. Unless your sig is for a GFY top banner sponsor, then you may use a 624x80 instead of a 120x60.

03-07-2002, 02:55 PM	#3
Lane Will code for food... Join Date: Apr 2001 Location: Buckeye, AZ Posts: 8,496	maybe you set the limit for number of connections too low? also dont use persistent connections, they do nothing but waste mysql resources.. __________________

03-07-2002, 03:06 PM	#4
grumpy Too lazy to set a custom title Join Date: Jan 2002 Location: Holland Posts: 9,870	Adultwire Thanks a lot...that helped ( until now :-) __________________ Don't let greediness blur your vision \| You gotta let some shit slide icq - 441-456-888

03-07-2002, 03:06 PM	#5
AdultWire Confirmed User Join Date: Feb 2002 Location: Toronto, ON Posts: 962	The persistant thing wastes resources if you're running php as a CGI, but if you're running it as a module, it can do some good. Seems the problem here is slow table updates/no indexes. __________________ SIG TOO BIG! Maximum 120x60 button and no more than 3 text lines of DEFAULT SIZE and COLOR. Unless your sig is for a GFY top banner sponsor, then you may use a 624x80 instead of a 120x60.

03-07-2002, 03:48 PM	#6
AdultWire Confirmed User Join Date: Feb 2002 Location: Toronto, ON Posts: 962	Definately msg me or icq me and let me know if the problem is solved during peak hours tommorow. __________________ SIG TOO BIG! Maximum 120x60 button and no more than 3 text lines of DEFAULT SIZE and COLOR. Unless your sig is for a GFY top banner sponsor, then you may use a 624x80 instead of a 120x60.

03-08-2002, 01:14 AM	#7
The Hun Confirmed User Join Date: Jan 2001 Location: The Netherlands Posts: 1,207	Use PostgresQL, that goes slow on many request, but doesn't die like MySQL does. MySQL is unsuitable for things like counters and such, especially when you start doing bigger numbers