Questions - Number of queries sent to the server. See http://www.mysql.com/doc/en/SHOW_STATUS.html for more info
MySQL user
From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: Re: MySQL+Apache Optimization Date: Wed, 7 Jan 2004 15:12:19 +0530
Hello ,
What are Questions in Mysql , I mean is there something know as Questions in
Mysql, I got a Script in PHP called as testload.php and it shows me this
output :
total processes are 55 Mysql Status is Uptime: 1839 Threads: 55 Questions: 175421 ==> What does this Stands For ??? Slow queries: 0 Opens: 142 Flush tables: 1 Open tables: 136 Queries per second avg: 95.389
Any comments will appreciated.
Thank you, Vishal.
----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 07, 2004 2:35 PM Subject: Re: MySQL+Apache Optimization
> Hello,
>
> Thank you for the Reply, I'll follow you suggestions and will post the
> results here, Also I use connect only and not aothers.
>
> Thank you again..... ;)
> Vishal.
>
> ----- Original Message -----
> From: "my5ql _" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, January 07, 2004 2:06 PM
> Subject: MySQL+Apache Optimization
>
>
> > >Can Anyone please tell me why I am not able to get the Load Down and
the
> > >site Load Faster.The server load is always above 5.00
> > >
> > >Thanks in Advance.
> > >
> > >Vishal.
> >
> > Try the following changes:
> >
> > Apache: Turn KeepAlives off + increase your MaxRequestsPerChild. Apache
is
> > probably spending too much time recreating httpd processes. (I presume
> > Apache & MySQL are running on the same box). Also are your using
> > mysql_connect() or pconnects?
> >
> > MySQL: Try increasing your table cache. Does your thread cache need to
be
> > that high? Maybe you should increase the thread concurrency first.
> According
> > to the my.cnf, you can increase this based on the amount of CPUs, you
> start
> > off by setting it to 24-32?
> >
> > Your max_connections settings is high and that will take up a fair
amount
> of
> > file descriptors. I suspect your table cache isn't big enough (try 2048
as
> a
> > starting point, see http://www.mysql.com/doc/en/Table_cache.html for
more
> > info)
> >
> > (Not intending to hijack this thread), but I'm going through a similar
> issue
> > with my Dual Xeon, 6GB RAM and RAID5 SCSI, but I'm running out of
> > file-descriptors and max_connections=520
> >
> > I hope my suggestions are useful and it'll be interesting to see whether
> > they help...
> >
> > httpd.conf
> > =======
> > KeepAlive Off
> > MaxRequestsPerChild 9000
> >
> > my.cnf
> > ======
> > [mysqld]
> > table_cache = 2048
> > thread_cache_size = 256
> > thread_concurrency= 32
> >
> > _________________________________________________________________
> > It's fast, it's easy and it's free. Get MSN Messenger today!
> > http://www.msn.co.uk/messenger
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
> >
> >
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
>
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
