High MySQL Cpu Usage

Hello, I Am Facing Problem With My Cwppro.

My MySql Is Using 90%+ Cpu Of My Vps. By That My Site Is Not Working Properly. I Check The Process List, MySql Usage Is High. It Is Always On Top. You Can See In Image :https://imgur.com/FmtVG6n.

Please Help Me.

you may want to make some edits in your mycnf file in the etc directory

This is just an example one and may need to be edited for your server.

example:  google it for changes

# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]
[mysqld]
default-storage-engine=MyISAM
innodb_file_per_table=1
max_allowed_packet=268435456
open_files_limit=10000
innodb_buffer_pool_size=134217728
query_cache_size = 268435456
query_cache_type=1
query_cache_limit=1048576
max_connections=250
join_buffer_size=8388608
thread_cache_size=16
local-infile=1

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

you should check with your system admin what is causing this high cpu usage

mysqladmin pr will show running queries.

Hey Thanks For Reply. You Mean I Have To Look For Mysql Queries Or What? I Am Not Advance, Will You Please Explain Little Bit More. I Will Be Very Thankful For Your Help.

You can open a ticket https://support.centos-webpanel.com/ for checking by sysadmins
Please note: there is paid support service.

Why should users who already PAY for CWP Pro version be also paying again for help from support?

I have to think that things in CWP are intentionally cocked up in order to force users to pay for support all the time.

You really have to stop doing that all eventually you will lose your client base to other more honest panel developers like Virtualmin. That would be a real shame because cwp is a nice looking panel.
Instead of paid support for CWP Pro, just increase yearly fee a bit...I would be quite happy to pay a little extra upfront for included support...but not $8 every time a cockup you make needs rectifying!

Please read my reply here http://forum.centos-webpanel.com/centos-7-problems/mysql-high-cpu-all-my-websites-are-down/msg25146/#msg25146 before accusing CWP.

The my.cnf file you posted is not properly optimizing mysql.

 :in 3 years of running virtualmin, do you know how many times I have alterred/edited the myconf file?

Zero

And that is my point.

Having a said that, the innodb buffer size seems rather large for one site on the server.
In relation to the rest of that file...The question is, how did it end up like that in the first place if the O.P didn't change it himself?(If he did fair enough, but if not, then how did it end up messed up in the first place?)

Don't get me wrong, I love this panel...it's a beautiful interface, unfortunately I just don't trust it enough for production websites at present. One example of why is little things like this thread. Another is the built in file manager still cannot list files in alphabetical order which doesnt inspire a great degree of faith in its programmers...If you cannot program the file manager interface to list files alphabetically what else can't you do???

Hi, are you using a single website or multiple websites?
You should look for two perspectives: MYSQL configurations and the codes being executed.
Try to figure out the proceses of those users who are active when your CPU is eaten up heavily. They might be trying too many queries and may not be closing the connections well in time.
Also, on your part, you can impose some limitations like number of allowed connections to MYSQL, buffer size of MYSQL Enginer like innoDB, etc. Imposing some limitations might help you out.
I hope this will help.

Thanks For The Reply. Is There Any Guide On Internet You Mention..............


And I Am Using Only One Website......

Why should users who already PAY for CWP Pro version be also paying again for help from support? ...

CWP PRO is different from CWP Support. We pay CWP PRO in order to support CWP. The support of CWP team is fast and great. I trust them over 3 years for One Time support tickets or monthly requests. It depends on the project.

If you have a site with load issues (as many of us face it) then a server specialist has to diagnose What is causing that. That is the service you need. CWP One time support ticket will definitely help you.

when someone makes a new account on my page, not every time I find in mysql this error, it is always the same, you can tell me what I can do, mysql falls in time out, and the page no longer works

what can i do to get rid of this error, can anyone help me?


thanks


[root@id ~]# mysqladmin pr
+------+------------------+-----------+------------------+---------+------+------------+----------------------------------------------------------------------------------                                                                    --------------------+----------+
| Id   | User             | Host      | db               | Command | Time | State      | Info                                                                                                                                                                     | Progress |
+------+------------------+-----------+------------------+---------+------+------------+----------------------------------------------------------------------------------                                                                    --------------------+----------+
| 1865 | adultwor_5u6476w | localhost | adultwor_adultwo | Query   | 165  | statistics | SELECT `u`.`id`, `u`.`username`, `u`.`userurl`, `u`.`unique_code`, `u`.`email`, `                                                                    u`.`data_nasterii`, | 0.000    |
| 1889 | adultwor_5u6476w | localhost | adultwor_adultwo | Sleep   | 144  |            |                                                                                                                                                                          | 0.000    |
| 1897 | adultwor_5u6476w | localhost | adultwor_adultwo | Sleep   | 144  |            |                                                                                                                                                                          | 0.000    |
| 1899 | adultwor_5u6476w | localhost | adultwor_adultwo | Sleep   | 143  |            |                                                                                                                                                                          | 0.000    |
| 1900 | root             | localhost |                  | Query   | 0    | init       | show processlist                                                                                                                                                         | 0.000    |
+------+------------------+-----------+------------------+---------+------+------------+----------------------------------------------------------------------------------                                                                    --------------------+----------+