David,
At 03:28 PM 8/25/2009, David Taveras wrote:
Hello,
We have a BSD box with the following installed:
mysql-client-5.0.77 multithreaded SQL database (client)
mysql-server-5.0.77 multithreaded SQL database (server)
p5-DBD-mysql-4.010 MySQL drivers for the Perl DBI
php5-mysql-5.2.8 mysql database access extensions for php5
We are experiencing intermittent slowdowns on the queries made with PHP to
mysql to the point where pages take a lot of time to load, upon further
investigation with mytop we observe that it only keep an average of 1-2
simultenaous threads and a query time of avg 2-3 seconds.
That is extremely slow. Look at your slow query log to see which queries
are slow. You can post them here and maybe someone can help you to optimize
the query.
How much memory does the server have? How large are the tables?
During which the mysqld process reaches 99% continously for minutes.
We have repaired and optimized the tables, and the DB is 200mb. The storage
engine is MyISAM.
I understand that further optimization can be done to my.cnf , that has been
done a lot but with the same results.. andbefore I go to that path again my
question is:
Iam wondering what other tools exist to load test the mysql daemon, or how
to better debug this situation... more tools must exist out there? Perhaps
there must be a PHP/DB that I can load... and run a stress test like you
would test network issues with speedtest.net just a thought.. I know you
dont compare apples to oranges.
Thanks
David
Take a look at MONyog from http://webyog.com/en/. It will monitor the
MySQL server. They have a trial download available.
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
