MySQL Client / Benchmarking Tool

Question

I have a site hosted on a godaddy.com Linux shared hosting plan. We recently switched to a Joomla CMS so that the sales department could edit the site without breaking any of my css. The problem is now that each page takes about 4-6 seconds to load. I can load large static images just fine, so that only leaves SQL as the other culprit. Each page only executes 6 SQL queries. And its hard to believe that each query would take a full half second or more.

So now I'm looking for a Good SQL client or even a benchmarking script to try and narrow down the problem. I want to compare their SQL4 server vs their SQL5 server for instance.

What would be a good program to test various speeds and directly interact with the database?

Edit: The site is http://www.cfrinc.net if you want to see the slowness for yourself.

Answer 1

Use general_log_file and/or slow_query_log_file in MySQL options.

You can also log queries right into the database if you set log_output to TABLE.

Answer 2

I would also recommend looking at mysqlslap. We've used this where I work to benchmark several of our DBs.

Answer 3

How have you benchmarked the Joomla PHP stack? If it's a low-quality host (I know nothing about GoDaddy aside from their Super Bowl ads), the PHP may be running slow or you may be slow loading up the required files.

Answer 4

You tried enabling Cache? Administrator...Global Settings. That usually improves your site.