My server is slow
Hi group,
I'm having problems with my server.
My server from one moment to another, is down (a few seconds) but is Recurrent.
When I see the htop, the CPU have a 60% - 80% but the customer says that the system is slow.
Do you recommend upgrade my plan to have more cpu?
Using nodebalancer would improve?
What problems are there to configure NodeBalancer?
Thank you for your answers.
4 Replies
There are many reasons why your server could be running slow. It could be due to a breach or attempted breach, the web application(s) you are running are resource intensive, a configuration issue, too many visitors at the server which an upgrade would help.
As far as the CPU that doesn’t say much.
How much memory are you using? Are you using half or more of the swap space?
What distro are you running?
Are you regularly updating it?
Are checking any logs for errors?
Etc.
How much memory are you using?
12GB/32GB
Are you using half or more of the swap space?
0MB/1024MB
What distro are you running?
Centos 7
Are you regularly updating it?
No
Are checking any logs for errors?
Yes, mysqld.log
When I restart the service I see the following error
2018-11-15 05:58:44 1268 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)
2018-11-15 05:58:44 1268 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 862)
Ok take a look at the following link. It looks like the max connections you set for MySQL are being reached. https://stackoverflow.com/questions/32760202/buffered-warning-changed-limits-max-connections-214-requested-800
Thanks @LouWestin
I increased the capacity of the server and performed the configuration of the variable and all OK.
Now, I see something strange in the htop and I do not know if it is normal or how to check that log.
PID USER PRI NI VIRT RES SHR S CPU% MEM% TIME+
3630 mysql 20 0 13.2 8356M 14148 S 47.0 13.0 1h35:05
Command
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
The same information is repeated over 100 times in the htop.
When I order by MEM%, these are he firts results.