当前位置:论坛首页 > Linux面板 > 求助

MYSQL总是自动停止

发表在 Linux面板2018-7-7 13:41 [复制链接] 3 2578

我用的是阿里云1H2G的配置
为什么总是内存占满且mysql自动停止呢
使用道具 举报 只看该作者 回复
发表于 2018-7-7 15:19:30 | 显示全部楼层
啥版本的Mysql 看下mysql日志
使用道具 举报 回复 支持 反对
发表于 2018-7-8 10:30:38 | 显示全部楼层
write:          199804
delete            6539
update:          72587

Table status:
Opened tables:        658
Open tables:          111
Open files:            72
Open streams:           0

Alarm status:
Active alarms:   0
Max used alarms: 0
Next alarm time: 0

Memory status:
Non-mmapped space allocated from system: 76070912
Number of free chunks:                         662
Number of fastbin blocks:                 27
Number of mmapped regions:                 16
Space in mmapped regions:                 67121152
Maximum total allocated space:                 0
Space available in freed fastbin blocks: 1792
Total allocated space:                         12252080
Total free space:                         63818832
Top-most, releasable space:                 18424560
Estimated memory (with thread stack):    143192064



Events status:
LLA = Last Locked At  LUA = Last Unlocked At
WOC = Waiting On Condition  DL = Data Locked

Event scheduler status:
State      : INITIALIZED
Thread id  : 0
LLA        : n/a:0
LUA        : n/a:0
WOC        : NO
Workers    : 0
Executed   : 0
Data locked: NO

Event queue status:
Element count   : 0
Data locked     : NO
Attempting lock : NO
LLA             : init_queue:139
LUA             : init_queue:149
WOC             : NO
Next activation : never

Status information:

Current dir: /www/server/data/
Running threads: 0  Stack size: 262144
Current locks:
lock: 0x2b84cc015ff0:

lock: 0x2b84e402e0e0:

lock: 0x1cd5210:

lock: 0x1c336e0:

lock: 0x1c4e0d0:

lock: 0x1c17f30:

lock: 0x1c11580:

lock: 0x1c824f0:

lock: 0x1cc8710:

lock: 0x1c83a50:

lock: 0x1beb1b0:

lock: 0x2b84e8138cd0:

lock: 0x2b84e8019b60:

lock: 0x2b84f006f6d0:

lock: 0x2b84f0069cc0:

lock: 0x2b84f0062a60:

lock: 0x2b84f0048970:

lock: 0x2b84f004ec00:

lock: 0x2b84f002fb70:

lock: 0x2b84cc03f7a0:

lock: 0x2b84cc039e20:

lock: 0x2b84e429d130:

lock: 0x2b84e4299810:

lock: 0x2b84e4294060:

lock: 0x2b84e42909d0:

lock: 0x2b84e40098f0:

lock: 0x2b84e40156d0:

lock: 0x2b84e4028650:

lock: 0x2b84e4289530:

lock: 0x2b84e4030950:

lock: 0x2b84e4285ab0:

lock: 0x2b84e42828a0:

lock: 0x2b84e427ed30:

lock: 0x2b84e4279fe0:

lock: 0x2b84e4276960:

lock: 0x2b84e4273630:

lock: 0x2b84e426fe10:

lock: 0x2b84e426d260:

lock: 0x2b84e42654e0:

lock: 0x2b84e4262260:

lock: 0x2b84e425dd90:

lock: 0x2b84e425aae0:

lock: 0x2b84e4256280:

lock: 0x2b84e4252970:

lock: 0x2b84e424d530:

lock: 0x2b84e424a4f0:

lock: 0x2b84e4246450:

lock: 0x2b84e423f200:

lock: 0x2b84e423c0e0:

lock: 0x2b84e4238f70:

lock: 0x2b84e4235960:

lock: 0x2b84e4232310:

lock: 0x2b84e422b200:

lock: 0x2b84e4227ea0:

lock: 0x2b84e4224100:

lock: 0x2b84e4221100:

lock: 0x2b84e421de90:

lock: 0x2b84e42199d0:

lock: 0x2b84e402d2a0:

lock: 0x2b84e4150e70:

lock: 0x2b84e815eb00:

lock: 0x2b84e8120ce0:

lock: 0x2b84f41598d0:

lock: 0x2b84f41568d0:

lock: 0x2b84f4175d50:

lock: 0x2b84f419d560:

lock: 0x2b84f419a3a0:

lock: 0x2b84f4019f70:

lock: 0x2b84f406c360:

lock: 0x2b84f4008ca0:

lock: 0x2b84f417aa80:

lock: 0x2b84f4001810:

lock: 0x2b84cc006b00:

lock: 0x2b84cc011690:

lock: 0x2b84e006e860:

lock: 0x2b84e8026cf0:

lock: 0x2b84e0042d50:

lock: 0x2b84dc0179b0:

lock: 0x2b84f003a1d0:

lock: 0x2b84e409e190:

lock: 0x2b84e40335b0:

lock: 0x2b84e40d23f0:

lock: 0x2b84e410f1a0:

lock: 0x2b84e4073bf0:

lock: 0x2b84e4021620:

lock: 0x2b84e4021510:

lock: 0x2b84e40f8380:

lock: 0x2b84e40f8270:

lock: 0x2b84e40aeb60:

lock: 0x2b84e40f1560:

lock: 0x2b84e40ec2b0:

lock: 0x2b84e4069230:

lock: 0x2b84e40316c0:

lock: 0x2b84e405c2e0:

lock: 0x2b84e40a7900:

lock: 0x2b84e404efd0:

lock: 0x2b84e40a07c0:

lock: 0x2b84e4040be0:

lock: 0x2b84f4011660:

lock: 0x2b84f40132f0:


Key caches:
default
Buffer_size:      33554432
Block_size:           1024
Division_limit:        100
Age_limit:             300
blocks used:           264
not flushed:             0
w_requests:          76364
writes:              26364
r_requests:        1280289
reads:                 427


handler status:
read_key:       583652
read_next:     1262287
read_rnd         59151
read_first:      29421
write:          246778
delete           12139
update:          96060

Table status:
Opened tables:        819
Open tables:          128
Open files:           157
Open streams:           0

Alarm status:
Active alarms:   0
Max used alarms: 0
Next alarm time: 0

Memory status:
Non-mmapped space allocated from system: 79126528
Number of free chunks:                         658
Number of fastbin blocks:                 41
Number of mmapped regions:                 16
Space in mmapped regions:                 67121152
Maximum total allocated space:                 0
Space available in freed fastbin blocks: 2208
Total allocated space:                         12692096
Total free space:                         66434432
Top-most, releasable space:                 18389856
Estimated memory (with thread stack):    146247680



Events status:
LLA = Last Locked At  LUA = Last Unlocked At
WOC = Waiting On Condition  DL = Data Locked

Event scheduler status:
State      : INITIALIZED
Thread id  : 0
LLA        : n/a:0
LUA        : n/a:0
WOC        : NO
Workers    : 0
Executed   : 0
Data locked: NO

Event queue status:
Element count   : 0
Data locked     : NO
Attempting lock : NO
LLA             : init_queue:139
LUA             : init_queue:149
WOC             : NO
Next activation : never

Status information:

Current dir: /www/server/data/
Running threads: 0  Stack size: 262144
Current locks:
lock: 0x2b84e81340c0:

lock: 0x2b84e812db90:

lock: 0x2b84e801b600:

lock: 0x2b84e80155b0:

lock: 0x2b84e800e930:

lock: 0x2b84e81243c0:

lock: 0x2b84f002e000:

lock: 0x1c01220:

lock: 0x1c59cd0:

lock: 0x1c18a90:

lock: 0x1c3d2f0:

lock: 0x1c02d70:

lock: 0x1c2d9e0:

lock: 0x1c740c0:

lock: 0x1b804e0:

lock: 0x1c9b8a0:

lock: 0x1cf69d0:

lock: 0x1cedac0:

lock: 0x1c07b80:

lock: 0x2b84ec111000:

lock: 0x2b84ec0d9860:

lock: 0x2b84ec0e7ab0:

lock: 0x2b84ec0dea90:

lock: 0x2b84ec0fb810:

lock: 0x2b84ec0cfff0:

lock: 0x2b84ec0cfee0:

lock: 0x2b84ec0cdeb0:

lock: 0x2b84ec08d860:

lock: 0x2b84ec08d750:

lock: 0x2b84ec0a1650:

lock: 0x2b84ec004020:

lock: 0x2b84e006b7a0:

lock: 0x2b84e01572d0:

lock: 0x2b84e0150310:

lock: 0x2b84e009dc90:

lock: 0x2b84e0021870:

lock: 0x2b84e00032b0:

lock: 0x2b84e00b9180:

lock: 0x2b84e001edd0:

lock: 0x2b84e0142520:

lock: 0x2b84e00a6d60:

lock: 0x2b84e006c8d0:

lock: 0x2b84e00422a0:

lock: 0x2b84e0105100:

lock: 0x2b84e012cfa0:

lock: 0x2b84e0125000:

lock: 0x2b84e00e1100:

lock: 0x2b84e0146330:

lock: 0x2b84e00b0790:

lock: 0x2b84e407cf90:

lock: 0x2b84e4090100:

lock: 0x2b84e40a3440:

lock: 0x2b84e409c280:

lock: 0x2b84e4081b20:

lock: 0x2b84e4073090:

lock: 0x2b84e40b2850:

lock: 0x2b84e404e9f0:

lock: 0x2b84e404bce0:

lock: 0x2b84e407c650:

lock: 0x2b84e4079090:

lock: 0x2b84e40bb4e0:

lock: 0x2b84e4085f40:

lock: 0x2b84e4080470:

lock: 0x2b84e4034dc0:

lock: 0x2b84ec056fc0:

lock: 0x2b84ec051450:

lock: 0x2b84ec0688b0:

lock: 0x2b84e4095620:

lock: 0x2b84ec005360:

lock: 0x2b84ec04b800:

lock: 0xfc0780:

lock: 0xfc0cc0:

lock: 0xfc0d80:

lock: 0xfc0e40:

lock: 0xfc0840:

lock: 0xfc0900:

lock: 0xfc06c0:

lock: 0xfc0540:

lock: 0xfc0600:

lock: 0xfc0f00:

lock: 0xfc09c0:

lock: 0xfc0c00:

lock: 0xfc0b40:

lock: 0xfc0a80:

lock: 0xfc0300:

lock: 0xfc03c0:

lock: 0xfc0480:


Key caches:
default
Buffer_size:      33554432
Block_size:           1024
Division_limit:        100
Age_limit:             300
blocks used:           264
not flushed:             0
w_requests:          94788
writes:              37636
r_requests:        1804832
reads:                 573


handler status:
read_key:       870783
read_next:     1582464
read_rnd        102463
read_first:      45873
write:          298628
delete           18658
update:         123176

Table status:
Opened tables:       1000
Open tables:          128
Open files:            87
Open streams:           0

Alarm status:
Active alarms:   0
Max used alarms: 0
Next alarm time: 0

Memory status:
Non-mmapped space allocated from system: 79933440
Number of free chunks:                         662
Number of fastbin blocks:                 31
Number of mmapped regions:                 16
Space in mmapped regions:                 67121152
Maximum total allocated space:                 0
Space available in freed fastbin blocks: 1824
Total allocated space:                         12249632
Total free space:                         67683808
Top-most, releasable space:                 18424560
Estimated memory (with thread stack):    147054592
使用道具 举报 回复 支持 反对
发表于 2018-7-8 10:33:02 | 显示全部楼层
现在调整了一下性能 好多了
使用道具 举报 回复 支持 反对
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

紧急运维服务

响应时间:3分钟

问题处理方式:宝塔专家1对1服务

工作时间:工作日:9:00 - 18:30

宝塔专业团队为您解决服务器疑难问题

点击联系技术分析

工作时间:09:00至18:30

快速回复 返回顶部 返回列表