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
155 views
asked Mar 15, 2016 in Q2A Core by Jonatan
edited Mar 15, 2016 by Scott

After several difficulties, I managed to run the query 

SHOW PROCESSLIST

 

And this was the result:

(This is the result of a single query.)

http://imgur.com/7WTCVft

http://imgur.com/6mlgXG5

http://imgur.com/WaEJejL

http://imgur.com/N077NtB

http://imgur.com/Jlag5yt

http://imgur.com/mWJSuSI

 

Plugins:

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
reCAPTCHA
Q2AM Next Previous Questions
Theme: SnowFlat

 

You can help?

Q2A version: 1.7
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.

...