永发信息网

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

答案:2  悬赏:30  手机版
解决时间 2021-02-13 10:24
下面是日志文件:

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
最佳答案
你好,电脑每隔一段时间就自动重启,可能有以下原因:
1,系统太薄弱,没有对系统漏洞及时打补丁
2,误操作删除了重要系统文件或非法关机造成系统文件丢失
3,感染了病毒,(安装杀毒软件,系统严重损坏的话要重装)
4,电源有问题,(电压不稳定或机箱电源损坏,电源60%的情况是风扇烧毁)
5,是否有超频,有的话去掉超频
6,主板电池击穿(更换电池)
7,CPU的温度过高(更换损坏的CPU风扇或其他)
8,机箱内积尘过多吸潮后导致高温静电打火(打开机箱除尘)
9,显卡或网卡的金手指接触不良(拔下从新插牢,有铜绿的话可以用橡皮擦掉)
希望能帮助到您。\(^o^)/~
全部回答
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
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
关于跑步姿势的问题,懂田径的进
臻云至善综合服务店(茶光店)地址在什么地方,
子宫内膜厚度是多少才不会影响怀孕?
(11分)将长势一致、健壮的黄瓜幼苗随机均分
大竹县高穴国土所地址在哪,我要去那里办事
游乎网络地址有知道的么?有点事想过去
厚实网络地址好找么,我有些事要过去
厦门大学在安徽合肥多少分才能考上?
天欣驾校龙华分校(报名处)地址在什么地方,想
宝马x5 30.li和3.0si有何不同
现在是不是没有处女了
吉利车门主驾打不开,各位车友有了解这个问题
咫尺网络地址有知道的么?有点事想过去
有关的法律法规,结合本单位的具体情况,建立
来宾协和医院在什么地方啊,我要过去处理事情
推荐资讯
罗中旭的前老婆是谁
星级宾馆(荆门钟祥)地址好找么,我有些事要过
诺亚方舟影院在哪里啊,我有事要去这个地方
常州市武进马杭新益布厂地址在哪,我要去那里
酒店里服务员好,还是洗衣房里好
华辉汽车销售有限公司(邵阳洞口县慧创汽贸城
汤阴金大地农机有限公司怎么去啊,有知道地址
五六千块钱买辆摩托车在乡镇骑,综合各方面考
盐度是单位体积海水中含有可溶性盐类物质的多
谁知道射阳县文广局稽查科的潘伟的手机号码是
如图为肺换气及组织中气体交换示意图,请据图
本科学历,想成为证券分析师只能从拉客户做起
正方形一边上任一点到这个正方形两条对角线的
阴历怎么看 ?