Control Web Panel

WebPanel => MySQL => Topic started by: missri on May 14, 2016, 10:58:29 AM

Title: Problem mysqld dwon more time
Post by: missri on May 14, 2016, 10:58:29 AM

i have Probelm witch centos web panel Myserver : mysql down more time
server info : 2,66ghs 4 core Cpu
ram 6 gb
Hard driver SSD 120
server down more tiem mysql error
Plz help me

Title: Re: Problem mysqld dwon more time
Post by: Sandeep on May 14, 2016, 02:15:37 PM

Did you checked the log ?
what error message you're getting

what is your mysql version ?

Title: Re: Problem mysqld dwon more time
Post by: missri on May 14, 2016, 02:55:22 PM

 MySQL version: 10.1.14-MariaDB

server down more tiem

on reboot server is working mysql
whts this problem ?

Title: Re: Problem mysqld dwon more time
Post by: Sandeep on May 14, 2016, 03:00:48 PM

what is the error message or you can post the error log here

or i need to access to your server to check it

Title: Re: Problem mysqld dwon more time
Post by: missri on May 15, 2016, 12:05:48 PM

haw to get fille error log ?
Log Files Location ? mysql

Title: Re: Problem mysqld dwon more time
Post by: missri on May 15, 2016, 12:27:56 PM

(http://zupimages.net/up/16/19/yq9g.png) this porblem view on panel
(http://zupimages.net/up/16/19/v96g.png) this problem on my web site
(http://zupimages.net/up/16/19/xl2h.png) on reboot server my web site is working
(http://zupimages.net/up/16/19/g9lx.png) is working in reboot server
this probem on mysql down more time

Title: Re: Problem mysqld dwon more time
Post by: Sandeep on May 15, 2016, 12:45:59 PM

when this happens most ?

when you restart the server, immediately you get this error message ?

Title: Re: Problem mysqld dwon more time
Post by: missri on May 15, 2016, 01:08:16 PM

When the work site, with time shows a problem in the passage of MySQL
on reboot server is working mysql

Title: Re: Problem mysqld dwon more time
Post by: Sandeep on May 15, 2016, 03:33:03 PM

Contact your host for this issue may be a vps ssd problem

Title: Re: Problem mysqld dwon more time
Post by: missri on May 17, 2016, 12:16:01 AM

error log
May 17 01:00:03 srv lfd[4371]: *Suspicious Process* PID:680 PPID:608 User:mysql Uptime:19156 secs EXE:/usr/sbin/mysqld CMD:/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/srv.vf-streaming.fr.err --pid-file=/var/lib/mysql/srv.vf-streaming.fr.pid
May 17 01:00:03 srv lfd[4371]: *User Processing* PID:680 Kill:0 User:mysql VM:789(MB) EXE:/usr/sbin/mysqld CMD:/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/srv.vf-streaming.fr.err --pid-file=/var/lib/mysql/srv.vf-streaming.fr.pid
May 17 01:00:03 srv lfd[4371]: *User Processing* PID:680 Kill:0 User:mysql Time:19156 EXE:/usr/sbin/mysqld CMD:/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/srv.vf-streaming.fr.err --pid-file=/var/lib/mysql/srv.vf-streaming.fr.pid
May 17 01:05:03 srv lfd[5092]: *Suspicious File* /tmp/apache-build/httpd-2.2.27/server/core.o [root:root (0:0)] - Linux Binary
May 17 02:00:04 srv lfd[9488]: *Suspicious Process* PID:680 PPID:608 User:mysql Uptime:22757 secs EXE:/usr/sbin/mysqld CMD:/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/srv.vf-streaming.fr.err --pid-file=/var/lib/mysql/srv.vf-streaming.fr.pid
May 17 02:00:04 srv lfd[9488]: *User Processing* PID:680 Kill:0 User:mysql VM:791(MB) EXE:/usr/sbin/mysqld CMD:/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/srv.vf-streaming.fr.err --pid-file=/var/lib/mysql/srv.vf-streaming.fr.pid
May 17 02:00:04 srv lfd[9488]: *User Processing* PID:680 Kill:0 User:mysql Time:22757 EXE:/usr/sbin/mysqld CMD:/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/srv.vf-streaming.fr.err --pid-file=/var/lib/mysql/srv.vf-streaming.fr.pid
May 17 02:05:05 srv lfd[10157]: *Suspicious File* /tmp/apache-build/httpd-2.2.27/server/core.o [root:root (0:0)] - Linux Binary
May 17 02:07:05 srv lfd[10429]: *Excessive Processes* User:missri Kill:0 Process Count:12
May 17 02:08:04 srv lfd[10806]: *User Processing* PID:10754 Kill:0 User:mysql VM:786(MB) EXE:/usr/sbin/mysqld CMD:/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/srv.vf-streaming.fr.err --pid-file=/var/lib/mysql/srv.vf-streaming.fr.pid

Title: Re: Problem mysqld dwon more time
Post by: Sandeep on May 17, 2016, 05:09:51 AM

use cloudflare security and check this is happening again or not.