永发信息网

mysql自动重启,大概半天时间就自动重启了

答案:2  悬赏:30  手机版
解决时间 2021-02-13 10:24
  • 提问者网友:富士山上尢
  • 2021-02-13 06:01
下面是日志文件:

170831 11:25:59 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170831 11:25:59 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 20615 ...
170831 11:25:59 InnoDB: The InnoDB memory heap is disabled
170831 11:25:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170831 11:25:59 InnoDB: Compressed tables use zlib 1.2.7
170831 11:25:59 InnoDB: Using Linux native AIO
170831 11:25:59 InnoDB: Initializing buffer pool, size = 128.0M
170831 11:25:59 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
170831 11:25:59 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
170831 11:25:59 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
170831 11:25:59 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
170831 11:25:59 InnoDB: Waiting for the background threads to start
170831 11:26:00 Percona XtraDB 5.5.49-MariaDB-38.0 started; log sequence number 0
170831 11:26:00 [Note] Plugin 'FEEDBACK' is disabled.
170831 11:26:00 [Note] Server socket created on IP: '0.0.0.0'.
170831 11:26:00 [Note] Event Scheduler: Loaded 0 events
170831 11:26:00 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.52-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
170831 15:33:57 [Warning] IP address '140.205.225.204' could not be resolved: Name or service not known
170831 15:38:39 [Warning] IP address '60.191.38.78' could not be resolved: Name or service not known
170831 17:02:38 [Warning] IP address '140.205.201.41' could not be resolved: Name or service not known
170831 17:05:13 [Warning] IP address '123.59.56.127' could not be resolved: Name or service not known
170831 21:02:37 mysqld_safe Number of processes running now: 0
170831 21:02:37 mysqld_safe mysqld restarted

经常就是自己关闭了mysql 需要开启服务器来启动mysql
最佳答案
  • 五星知识达人网友:慢性怪人
  • 2021-02-13 07:01
你好,电脑每隔一段时间就自动重启,可能有以下原因:
1,系统太薄弱,没有对系统漏洞及时打补丁
2,误操作删除了重要系统文件或非法关机造成系统文件丢失
3,感染了病毒,(安装杀毒软件,系统严重损坏的话要重装)
4,电源有问题,(电压不稳定或机箱电源损坏,电源60%的情况是风扇烧毁)
5,是否有超频,有的话去掉超频
6,主板电池击穿(更换电池)
7,CPU的温度过高(更换损坏的CPU风扇或其他)
8,机箱内积尘过多吸潮后导致高温静电打火(打开机箱除尘)
9,显卡或网卡的金手指接触不良(拔下从新插牢,有铜绿的话可以用橡皮擦掉)
希望能帮助到您。\(^o^)/~
全部回答
  • 1楼网友:長槍戰八方
  • 2021-02-13 08:15
1.启动:/etc/init.d/mysqld start 2.停止:/etc/init.d/mysqld stop 3.重启:/etc/init.d/mysqld restart 1.启动:/etc/init.d/mysql start 2.停止:/etc/init.d/mysql stop 3.重启:/etc/init.d/mysql restartwindows 1.点击“开始”->“运行”(快捷键win+r) 2.启动:输入 net stop mysql 3.停止:输入 net start mysql提示redhat linux 也支持service command, 启动:# service mysqld start
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
点此我要举报以上问答信息
大家都在看
推荐资讯