My site at bioneural.net (WordPress) has been horrendously slow. I have Mint and WordPress in separate databases. My host (mt) suggested I move my SQL databases into their GridContainer and use the tools therein to try and root out the cause of slowness and then optimize my installation. I ran the Query Analyzer which detects all queries taking > 1 sec and if found two, both of which seem to concern Mint:
1 Query
Total time: 3, Average time: 3
Taking 3 seconds to complete
Rows analyzed 27839
use dbXXX_mint;
SELECT resource
, resource_title
, resource_checksum
, COUNT(resource_checksum) AS total
FROM mint_visit
WHERE XXX=XXX
AND resource NOT LIKE ‘XXX’
GROUP BY resource_checksum
ORDER BY total DESC LIMIT XXX;
use db32398_mint;
SELECT resource
, resource_title
, resource_checksum
, COUNT(resource_checksum) AS total
FROM mint_visit
WHERE 1=1
AND resource NOT LIKE ‘http://bioneural.net/’
GROUP BY resource_checksum
ORDER BY total DESC LIMIT 6;
1 Query
Total time: 3, Average time: 3
Taking 3 seconds to complete
Rows analyzed 27839
SELECT resource
, resource_title
, resource_checksum
, COUNT(resource_checksum) AS total
FROM mint_visit
WHERE XXX=XXX
AND resource NOT LIKE ‘XXX’
GROUP BY resource_checksum
ORDER BY total DESC LIMIT XXX;
SELECT resource
, resource_title
, resource_checksum
, COUNT(resource_checksum) AS total
FROM mint_visit
WHERE 1=1
AND resource NOT LIKE ‘http://bioneural.net/’
GROUP BY resource_checksum
ORDER BY total DESC LIMIT 6;
I really have no idea what to make of this. Are (mt) therefore suggesting that I can’t run Mint if I want decide site performance on their (gs) product? Any advice much appreciated.
Cheers, Bruce
