Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.

At a time of slow on my site, these were the MySQL query. What is abnormal?

+1 vote
asked Mar 15, 2016 in Q2A Core by Jonatan
edited Mar 15, 2016 by Scott

After several difficulties, I managed to run the query 



And this was the result:

(This is the result of a single query.)









On site notifications
Widget Anywhere Plugin
Featured Questions 
FAQ Page
Basic Adsense
Q2A Embed
Event Logger
Example Page
Facebook Like Box
Mouseover Layer
My Followers Page
Q2AM Next Previous Questions
Theme: SnowFlat


You can help?

Q2A version: 1.7
commented Mar 15, 2016 by Scott
That's a lot of processes! I only have 1-2 on my site, but it's not the busiest time right now. Have you increased the number of MySQL processes you run?
commented Mar 15, 2016 by Jonatan
When there is no problem on the site, I see one or two processes to perform the query.
This data is when the error was happening and this large number of cases leaves my site unavailable.
I did not raise the number of processes yet, I'm afraid to be generated more queries and increase overhead.
commented Mar 20, 2016 by Jonatan
Scott, you see something wrong in the processes?
commented Mar 20, 2016 by Scott
To be honest I don't know. I checked my site in a busy time and there was still only 1-2 processes showing. So I don't know why you have so many. Are there other sites running on your server, or is it just the Q2A one?
commented Mar 20, 2016 by Jonatan
Hi Scott.
I have only my Q2A site on the server.
This does not always happen. That's what I find strange.
At certain times of great movement, the site is working well and with few queries. At other times there are few users but the site is unavailable.
I can not identify why this happens.

Please log in or register to answer this question.