E107 and Lagging mySQL Queries.

[TrixxRI]

I am having some recurring mySQL issues, with inconsistent query times, I am currently working with e107 for a CMS. As part of our evaluation we are finding that the same page sometimes returns in a reasonable amount of time, other times it is extremely long.

Three results are below for the same page, which has the default initial content only.
Result 1: Render time: 26.9296 sec, 26.7613 of that for queries.
Result 2: Render time: 0.2363 sec, 0.0535 of that for queries.
Result 3: Render time: 24.6483 sec, 24.2186 of that for queries.

Any suggestions.

[Croc Hunter]

As users Trixx we can only suggest you optimize your database and e107 settings or find dedicated host as we don't have enough server access to answer your question directly. You might get a better response asking someone who has access, email support via OPS.

[TrixxRI]

Croc, if I had a constant flow of database traffic, I would agree about finding a dedicated host, however, this is pretty much the ONLY active database interaction. If the query takes 0.02 seconds to run one time, that same query with the same dataset should take about the same amount of time every time based on the same server conditions. When it spikes up past 90 seconds, that is a 450,000% jump.

I was speaking to a support rep when the below page stats were gathered. After they spoke with 2nd level, I got the stock "it's a shared platform" response. I suggested the support person check the pages in question, and he was expecting some massive page with tons of queries, he was in shock as this was a bare bones page, and he saw the nominal query around .2 seconds, some as low as .02 and he witnessed one as high as 24 seconds.

So I guess my reason for originally posting was to see Am I Alone or what.

10:03 AM 1/29/2009
Render time: 34.9434 sec, 34.3294 of that for queries.
Render time: 51.9872 sec, 50.4921 of that for queries.
Render time: 92.7724 sec, 92.4397 of that for queries.

[IanS]

Maybe you can state the mysql server you're using. If you're using the username form, PM dbrazzell with the info for checking.

[Dbrazzell]

Im curious about this one. TrixxRI can you pm me your domain or user name.

I put a test install of e107 on my account and it all ran rather smoothly. I suspect there is some aspect of of your site thats customized and is clashing badly with our servers. If I take a look at it I might be able to find a solution for you.

[TrixxRI]

PM Sent

[shultas]

Hey there-

I am wondering if you ever had your problem resolved, and if so, what the problem was?

I just submitted a support ticket for this same exact problem. Some times the access to the database (whether through a small web page to print out a few tables of data, or through phpMyAdmin) is incredibly fast (almost instant), other times I get lag between 30-90 seconds. It'll just sit there waiting for the page to load forever, then finally it will go.

I've been working no less than 10 hours a day on my site for two weeks straight and I'm noticing this lag happens about 25% of the time! (It's insanely annoying when you want to make a small update to one field in a table with < 3k of data and it takes 30 seconds, then another 30 to refresh your page!)

Wondering if you got this resolved? And my tables and site is bare bones too, it simply displays the first name, last name and email address of 10 people on the page!

[IanS]

I would suggests you raise a support ticket, and PM the details of the domain to dbrazzell.

Issues were identified with a MySql server, and rectified.