Thread

I have a database problem.

I am hosted with expression engine

Ever since I was upgraded to the full commercial version and further upgraded to 1.7 my situation has further deteriorated

On my processes, i get the following code

SELECT DISTINCT (
t.entry_id
)
FROM exp_weblog_titles AS t
LEFT JOIN exp_weblogs ON t.weblog_id = e

with enough of them on the site, the processes lock and people can not access the site

I have adjusted code and fixed up code, but what was working before without a hitch and I was receiving over 40,000 page views a day, now gets stuck on a lot less traffic.

The other issue with it is this always happens between 9;30 am and 1:30 pm EST

Does anyone know anything about database code?

Thank you

Is this happening again? What’s unique about that time period? Extra traffic?

happened the last few days always at 9:30 plus or minus 30 min

no extra traffic

our traffic actually has been dropping more and more.

I have even reworked the front page to I believe lessen the database queries and make it shorter

bthom62,

Can you share what you have your homepage template with us please?
Do you have any add-ons installed?

no addons

the ads i have i have been running for years with no issues

having a hard time uploading an attached file

Error Message:  The file you are attempting to upload has invalid content for its MIME type.

I have tried .txt, .doc, .html

as a pdf, but in the conversion it said characters were replaced

This site is working fine for me. When it “hangs”, what are you experiencing? Just general slowness? White page? An error message?

As to your file uploading issue, you’re probably running into a false positive with XSS filtering. Can you try to either disable it or upload as a Superadmin?

the page will not load

an error message come across something about connection to server

I go to my database, check the process and se it is full with request and sometimes locked processes

This is the main one that shows up

“SELECT DISTINCT ( t.entry_id )FROM exp_weblog_titles AS t LEFT JOIN exp_weblogs ON t.weblog_id = e”, do you know what pages generate that query?

It seems to happen between 9:30 am and 1:30 pm (EST) most of the time

As far as uploading.  The site hanging knocks this out as well.

I and one other person log in as super admins and do all the posting.

bthom62,

Your homepage has 12 weblog:entries tags which is quite a lot of processing for a homepage. Can you drop a {total_queries} variable into that template somewhere and tell us what it displays when you visit the page?

Have you contacted EngineHosting yet? I would do this first and see what they say regarding your issue. At leas they can tell you what resource may be spiking around that time

I have been in touch with engine hosting off and on for 6 month about this.

They keep saying it is not about them, and that I should contact the forums for help.

On the entry tags, I use to have more , then changed to 1 tag ( with out the total queries thing.)

I asked the question recently about this.

2 days ago I put all the entry tags back in and since then the site has not hung (might be a coincidence)

When I log on and check my processes, there has been no long list of them.

I will figure out the total queries tag and try it this morning

Sounds good. 😊 We’ll be here.

no idea what I am to do or add

In the center section (content portion) of my front page I have 17 entry tags

Who, where and what do I do to make it one tag?

Hi bthom62,

{total_queries} is a global variable.
You can place it anywhere within the template that has all those entries. Let us know what the result is 😊

Best regards,
Barry

Barry

I do not understand

I know what a global variable is—more or less.

put i do not understand at all what I am supposed to do with total queries.

Example below

I have 17 such entries on my front page

<div class="entry"><a href="http://{path=" title="American Politics, Life, Freedom"><span>American Politics, Life, Freedom</span></a>

{exp:weblog:entries weblog="default_site" orderby="date" category="4|105|117|15" sort="desc" limit="10" disable="{disable_most}"}
<a href="http://canadafreepress.com/index.php/article/{entry_id}"><span>{title}</span></a>  {categories}{category_image} (<a href="http://canadafreepress.com/index.php/categories/C{category_id}"><span>{category_name}</span></a>){/categories}


{/exp:weblog:entries}</div>
<hr >

So at the beginning of the 17 entries do 1 put in one global variable ?

How do I eliminate the 17 div entry tags?