my site has been suspended by my host (shared hosting via siteground) due to the following:
"...the problem was exactly due to very slow SQL queries which are in turn slowing down the whole service"
My site info:
PHP Built on: Linux [url removed, login to view] 188.8.131.52-grsec-sg2 #6 SMP Fri Feb 20 02:45:11 CST 2009 i686
Database Version: 5.0.91mm-log
Database Collation: utf8_general_ci
PHP Version: 5.2.9
Web Server: Apache/[url removed, login to view] (Unix) mod_gzip/[url removed, login to view] mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/184.108.40.20635.SR1.2 mod_ssl/[url removed, login to view] OpenSSL/0.9.8e-fips-rhel5 PHP-CGI/0.5
Web Server to PHP interface: cgi
Joomla! Version: Joomla! [url removed, login to view] Stable [ Wojmamni Ama Mamni ] 05-November-2009 04:00 GMT
User Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_5; en-US) AppleWebKit/534.13 (KHTML, like Gecko) Chrome/[url removed, login to view] Safari/534.13
with debug turned on the following is typical of a page load:
Application afterLoad: 0.000 seconds, 0.24 MB
Application afterInitialise: 0.044 seconds, 2.50 MB
Application afterRoute: 0.086 seconds, 4.23 MB
Application afterDispatch: 0.579 seconds, 11.20 MB
Application afterRender: 0.749 seconds, 14.32 MB
1207 queries logged
I also noticed 989 legacy queries logged
I have upgraded to Virtuemart 1.7, used phpMyadmin to optimise tables and tried turning off SEF to help the problem, but whilst it has improved the queries is still too high.
Once this is resolved I will also be looking to move hosting to a cloud provider (not SITEGROUND!) and also have 6 other sites. Therefore potential for additional work, but for now need this fixing ASAP.