List:General Discussion« Previous MessageNext Message »
From:Ken Menzel Date:March 6 2003 2:19pm
Subject:Re: very slow mysql server, help please
View as plain text  
Hi William,
   Sleeping processes are the result of persisitant connections and
should not slow down your server.  As to why you server is "so slow"
you will have to provide specific examples of what is slow.  We reach
speeds of 600 queries per second on slower hardware.  Also please
indicated languages used for examples and versions of FreeBSD, MySQL
and PHP (if you use PHP).

Also there are many tunable parameters
(http://www.mysql.com/doc/en/Server_parameters.html) I recommend Paul
Dubois Book on MySQL
http://www.amazon.com/exec/obidos/tg/detail/-/0735712123/qid=104696018
6/sr=1-4/ref=sr_1_4/103-5030472-7439844?v=glance&s=books

Best of Luck,
Ken
----- Original Message -----
From: "William Wang" <wwang@stripped>
To: <mysql@stripped>
Sent: Wednesday, March 05, 2003 10:11 PM
Subject: very slow mysql server, help please


>
> Hi All:
> I have three web server (DUAL 1.4 G MHZ, 1G RAM) connect to one
mysql
> database server (DUAL 2.2 G MHZ, 2 G RAM), SSL accelerator and a
load
> balancer. All those servers are FreeBSD. For some reason, mysql
server can
> be easily max out without many users. Also there are many processes
in
> sleep (some of them has been put in sleep for over 3000 seconds.)
>
> My database has nearly 140 tables, but there are less than 10000
recorders.
> Database file size is about 3M. One of the table has a BLOB field
(Hold
> some images for my web server.). I am using mysql_pconnect() (Of
cause, I
> tried mysql_connect(), but it's does not make big different.).
>
> Question 1: Does sleeping processes slow down database server?
> Question 2: Any ideas, why is the database so slow?
>
> Any suggestions?
>
> Thanks in advance and for Reading my message.
>
> William
>
>
> --------------------------------------------------------------------
-
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread134079@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-kenm=icarz.com@stripped>
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
>
>

Thread
very slow mysql server, help pleaseWilliam Wang6 Mar
  • Re: very slow mysql server, help pleaseKen Menzel6 Mar
  • Re: very slow mysql server, help pleaseJohn Wards6 Mar
    • RE: very slow mysql server, help pleaseWilliam Wang7 Mar