Thread

every once and awhile the site hangs.  I can’t surf the site or post.

See Below

192.168.206.94:52648   XXXXXX   Query   0   Sorting result   SELECT DISTINCT (
t.entry_id
)
FROM exp_weblog_titles AS t
LEFT JOIN exp_weblogs ONt.weblog_id = e

I am running a commercial 1.6.9 version of the expression engine

Can anyone shed some light on what is happening.

Thanks

Hi bthom62,

Can you clarify which version of EE you are running please? The latest 1.x version is 1.7.0, released on 20101015. Are you using a persistent or non-persistent DB connection (Admin > System Preferences > Database Settings)? Is this a local server or a professionally hosted one that is behind some sort of proxy or load balancer?

Cheers

Greg

Hi Greg

I am hosted with engine hosting

I am on the commercial 1.6.9

Non persistant

Enable SQL Query Caching is turned off, should it be turned on?

bthom62,

I am on the commercial 1.6.9

Although not maybe not directly related to this issue it is recommended you update to EE1.7 as there was a security fix

Enable SQL Query Caching is turned off, should it be turned on?

With EngineHosting, caching is already done on your SQL server side so no need to turn it on.

Low and behold it is mostly me on the posting pages.

To confirm. Is this happening in the control panel when you are publishing or on the front end when you are viewing posts?

What extensions are add-ons do you have installed? Any third-party?

I have since found out that it is not doing it while i post. Engine hosting confirmed this.

I am running just the basic addons and extensions

I notice when I look at the processes in mysqlI see the same thing all the time and I checked my templates looking for anything somewhat related.

Below is a sample. 

I did notice one entry that was different

Kill
23558427
eh8133
192.168.206.95:60616
eh8133a
Query
0
statistics
SELECT DISTINCT (
t.entry_id
)
FROM exp_weblog_titles AS t
LEFT JOIN exp_weblogs ON t.weblog_id = e

I do not know, nor have I ever accessed statistics through my database

Thanks

Copying to tmp table
SELECT DISTINCT (
t.entry_id
)
FROM exp_weblog_titles AS t
LEFT JOIN exp_weblogs ON t.weblog_id = e
Kill
23558422
eh8133
192.168.206.96:57177
eh8133a
Query
0
Copying to tmp table
SELECT DISTINCT (
t.entry_id
)
FROM exp_weblog_titles AS t
LEFT JOIN exp_weblogs ON t.weblog_id = e
Kill
23558424
eh8133
192.168.206.97:36833
eh8133a
Query
0
Copying to tmp table
SELECT DISTINCT (
t.entry_id
)
FROM exp_weblog_titles AS t
LEFT JOIN exp_weblogs ON t.weblog_id = e
Kill
23558426
eh8133
192.168.206.94:58715
eh8133a
Query
1
Copying to tmp table
SELECT DISTINCT (
t.entry_id
)
FROM exp_weblog_titles AS t
LEFT JOIN exp_weblogs ON t.weblog_id = e
Kill
23558427
eh8133
192.168.206.95:60616
eh8133a
Query
0
statistics
SELECT DISTINCT (
t.entry_id
)
FROM exp_weblog_titles AS t
LEFT JOIN exp_weblogs ON t.weblog_id = e

You mention basic add-ons and extensions. What do you consider “basic”?

whatever came with the program. I have not (lack the experience) to add on addons

I noticed in the process function of mysql a line that interests me

it mentions statistics.  I am not running—to the best of my knowledge—any statistics on the site.

further, I have never tried to access statistics on the site. So who or what is?

Kill
23558427
eh8133
192.168.206.95:60616
eh8133a
Query
0
statistics
SELECT DISTINCT (
t.entry_id
)
FROM exp_weblog_titles AS t
LEFT JOIN exp_weblogs ON t.weblog_id = e

Brian, by default EE1.x has Tracking Preferences turned on.

See: Admin ›  System Preferences ›  Tracking Preferences

Also, please check your email. 😊

I checked thankyou

everything was turned off

So, you’re good, i.e. up and running? Just making sure.

No I am not okay or happy

I can find no answer as to why on occassions my site hangs. 

I get 40,000 page views a say and it does not appear to be a factor of busier traffic

mysql request for some reason back up , and then my site slow down.

the code i see in the processes screen of the mysql interface always sho the same thing, but no one seems to know why

Please check your email

bthom62,

I am suggesting you do a version update to EE1.7

This will make sure of no file corruption and bring everything up to date for you and let us troubleshoot from the same page

I will try to get this done over the next few days