The plugin highs up my cpu 50% because of this plugin, could you please solve it?
Here are the images:
My normal cpu-

The high cpu-

Please

Can you try to run this: https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl ?

It will tell you if MySQL needs some tuning (cache, table open, etc) which can improves your CPU usage. Since I use a lot of keys /foreign keys it may improve performance quite a bit.

how do I run that?

It's a perl script, just wget it then do perl mysqltuner.pl
On Apr 14, 2016 11:49 PM, "elpedriyo" [email protected] wrote:

how do I run that?

—
You are receiving this because you commented.
Reply to this email directly or view it on GitHub
#95 (comment)

and do you recommend me to execute it when I have the cpu more than 50% because of mysql?

I also where monitoring task in mysql and I saw it is the select process from your plugin the problem, but I am going to run this now, to see what can I do

I got this when cpu was fine:

let me see now with it high

Ok, the other image when the cpu was up was the same

The script only asks that the mysql server has been running for more than
24h.
On Apr 14, 2016 11:58 PM, "elpedriyo" [email protected] wrote:

and do you recommend me to execute it when I have the cpu more than 50%
because of mysql?

—
You are receiving this because you commented.
Reply to this email directly or view it on GitHub
#95 (comment)

Ok, so then with the results you see, do you recommed something for optimizing this?
Because when your plugin launches the select query my cpu goes up to a 100% sometimes and this is horrible for all servers on the machine :/

Also it tells that the plugin is not closing mysql connections properly :/

Yeah well the script use the mysql stats it sees so having a large pool of data (aka at least 24h running) will provide somewhat accurate informations. Then we will see what is causing the issues. Sometimes a default MySQL config isn't enough for some workloads.

Ok, so then tomorrow I will paste you again what I see.
Another thing, at the startup of my servers I have always an error from craftconomy, could you please solve that?

Also when I introduce table_cache value mysql do not start again, I do not know if it is compatible with mysql 5.7

@greatman It is the same, the performance continue going bad when the plugin performs this:

Could you simply optimize the command?

The problem persists, it is a problem with the select function of the plugin every 3 or 4 minutes each time. Do not know why the plugin is making select function each 3 or 4 mintues

Ok, any solution, could you fix it?

I continue having the same problems

is this issue is fixed in latest version?