Slow MySQL Queries

Permalink Browser Info Environment
I'm getting a lot of log entries in mysql_slow_queries and Traffic & Statistics seems to account for most of them.

The website has gotten really slow with some pages taking over a minute to display.

How can I turn Traffic & Statistics off to see if that makes a difference.

One log file is attached. I have hundreds more if you need them.

1 Attachment

Type: Discussion
Status: Archived
waterfeller
View Replies:
Tony replied on at Permalink Reply
Tony
are you on a shared server? looking at that log, it looks like a really really simple query that's happening, just inserting a single row into a table:

"INSERT INTO TonyStatsVisits SET
traffic_visit_id= 11705 ,
session_id= '0_24.193.82.158_v87nb2ocj7p25p3cissha3r2i0',
cookies_off_id= '0_24.193.82.158_Windows_firefox_19',
ip= '24.193.82.158',
host_name= 'cpe-nyc.res.rr.com',
users_id= 0 ,
book_id= 0 ,
referrer_url= '',
search_terms= '',
resolution= '1920 x 956',
platform= 'Windows',
browser= 'firefox',
browser_version= '19',
flash_version= 11 ,
returning_visit_count= 1 ,
created= 1363705348 ,
modified= 1363705348"

On a normal database that should take a tiny fraction of a second. so there's got to be something else happening with your server. My guess is that the database is overloaded or misconfigured, thrashing from too many calls, and that's causing the script to run slow. if the database or harddisk is being shared with other websites then your best bet is to do a hosting upgrade.
ConcreteCMS replied on at Permalink Reply
ConcreteCMS
Attention: Since there has been no activity on this issue for two weeks, this issue has been automatically archived.

To re-open this issue, reply to this message.

concrete5 Environment Information

Browser User-Agent String

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You have not specified a license for this support ticket. You must have a valid license assigned to a support ticket to request a refund.