List:General Discussion« Previous MessageNext Message »
From:<vishal Date:January 7 2004 10:51am
Subject:Re: MySQL+Apache Optimization
View as plain text  
Hello all,

Guys Where will i Find out If Mysql database is Optimized or Not, I have
read the Documentation given on Mysql.com and also checked the database
which tells that It has been Optimized well, Actually When I See the Mysql
processlists it put all the Update Statement and Select Count(col1) from
table name statements, Only one table is Heavily used.
I also thought of Killing Mysql connections after a Specific time, where
will i configure that ???

Thanks for any comments.

Vishal.

----- Original Message -----
From: "MySQL User Bob" <my5ql@stripped>
To: <vishal@stripped>; <mysql@stripped>
Sent: Wednesday, January 07, 2004 3:25 PM
Subject: Re: MySQL+Apache Optimization


> Questions -  Number of queries sent to the server.
> See http://www.mysql.com/doc/en/SHOW_STATUS.html for more info
>
>
> MySQL user
>
> >From: <vishal@stripped>
> >To: <mysql@stripped>
> >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: <vishal@stripped>
> >To: <mysql@stripped>
> >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 _" <my5ql@stripped>
> > > To: <mysql@stripped>
> > > 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/mysql?unsub=1
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:
> >http://lists.mysql.com/mysql?unsub=1
> > >
> > >
> > >
> > >
> >
> >
> >
> >--
> >MySQL General Mailing List
> >For list archives: http://lists.mysql.com/mysql
> >To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> >
>
> _________________________________________________________________
> It's fast, it's easy and it's free. Get MSN Messenger today!
> http://www.msn.co.uk/messenger
>
>
>
>


Thread
MySQL+Apache Optimizationmy5ql _7 Jan
  • Re: MySQL+Apache Optimizationvishal7 Jan
  • Re: MySQL+Apache Optimizationvishal7 Jan
Re: MySQL+Apache OptimizationMySQL User Bob7 Jan
  • Re: MySQL+Apache Optimizationvishal7 Jan