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.
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.
Type: | Discussion |
---|---|
Status: | Archived |
"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.