帮我看看mysql错误日志

帮我看看mysql错误日志，这是什么问题？怎么解决？求帮助
170812 04:38:48 mysqld_safe Number of processes running now: 0
170812 04:38:48 mysqld_safe mysqld restarted
2017-08-12 04:38:48 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.6.32-log) starting as process 29825 ...
2017-08-12 04:38:49 29825 [Note] Plugin 'FEDERATED' is disabled.
2017-08-12 04:38:49 29825 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-08-12 04:38:49 29825 [Note] InnoDB: The InnoDB memory heap is disabled
2017-08-12 04:38:49 29825 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-08-12 04:38:49 29825 [Note] InnoDB: Memory barrier is not used
2017-08-12 04:38:49 29825 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-08-12 04:38:49 29825 [Note] InnoDB: Using Linux native AIO
2017-08-12 04:38:49 29825 [Note] InnoDB: Using CPU crc32 instructions
2017-08-12 04:38:49 29825 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-08-12 04:38:49 29825 [Note] InnoDB: Completed initialization of buffer pool
2017-08-12 04:38:49 29825 [Note] InnoDB: Highest supported file format is Barracuda.
2017-08-12 04:38:49 29825 [Note] InnoDB: Log scan progressed past the checkpoint lsn 384181656
2017-08-12 04:38:49 29825 [Note] InnoDB: Database was not shutdown normally!
2017-08-12 04:38:49 29825 [Note] InnoDB: Starting crash recovery.
2017-08-12 04:38:49 29825 [Note] InnoDB: Reading tablespace information from the .ibd files...
2017-08-12 04:38:49 29825 [Note] InnoDB: Restoring possible half-written data pages
2017-08-12 04:38:49 29825 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 384185700
2017-08-12 04:38:49 29825 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 3569393, file name mysql-bin.000025
2017-08-12 04:38:50 29825 [Note] InnoDB: 128 rollback segment(s) are active.
2017-08-12 04:38:50 29825 [Note] InnoDB: Waiting for purge to start
2017-08-12 04:38:50 29825 [Note] InnoDB: 5.6.32 started; log sequence number 384185700
2017-08-12 04:38:50 29825 [Note] Recovering after a crash using mysql-bin
2017-08-12 04:38:50 29825 [Note] Starting crash recovery...
2017-08-12 04:38:50 29825 [Note] Crash recovery finished.
2017-08-12 04:38:50 29825 [Note] Server hostname (bind-address): '*'; port: 3306
2017-08-12 04:38:50 29825 [Note] IPv6 is available.
2017-08-12 04:38:50 29825 [Note]   - '::' resolves to '::';
2017-08-12 04:38:50 29825 [Note] Server socket created on IP: '::'.
2017-08-12 04:38:50 29825 [Note] Event Scheduler: Loaded 0 events
2017-08-12 04:38:50 29825 [Note] [RDS Diagnose] /www/server/mysql/bin/mysqld is using 'bundled jemalloc' malloc library
2017-08-12 04:38:50 29825 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '5.6.32-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

Status information:

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

lock: 0x7fd0f0751360:

lock: 0x7fd0ea52ef60:

lock: 0x7fd0ea52bd60:

lock: 0x7fd0ea4b2760:

lock: 0x7fd0ea50d760:

lock: 0x7fd0eabf8160:

lock: 0x7fd0ea4aeb60:

lock: 0x7fd0ea9a3780:

lock: 0x7fd0ea5bbb60:

lock: 0x7fd0ea469b60:

lock: 0x7fd0ea49ff60:

lock: 0x7fd0ea93aa40:

lock: 0x7fd0ea93c0c0:

lock: 0x7fd0ea93bf80:

lock: 0x7fd0ea93be40:

lock: 0x7fd0ea93bd00:

lock: 0x7fd0ea93bbc0:

lock: 0x7fd0ea93ba80:

lock: 0x7fd0ea93b580:

lock: 0x7fd0ea93b440:

lock: 0x7fd0ea93b300:

lock: 0x7fd0ea93b1c0:

lock: 0x7fd0ea93b080:

lock: 0x7fd0ea93af40:

lock: 0x7fd0ea93ab80:

lock: 0x7fd0ea6632c0:

lock: 0x7fd0ea93a180:

lock: 0x7fd102db7540:

lock: 0x7fd0ea66d180:

lock: 0x7fd102db72c0:

lock: 0x7fd102db7180:

lock: 0x1419cc0:

lock: 0x1419c00:

lock: 0x1418e80:

lock: 0x1418dc0:

lock: 0x1418d00:

lock: 0x1419000:

lock: 0x1417680:

lock: 0x1419b40:

lock: 0x1417c80:

lock: 0x1417ec0:

lock: 0x1417bc0:

lock: 0x1417e00:

lock: 0x1417b00:

lock: 0x1417d40:

lock: 0x14181c0:

lock: 0x1418280:

lock: 0x1418340:

lock: 0x1417a40:

lock: 0x1417800:

lock: 0x1417980:

lock: 0x1417740:

lock: 0x14178c0:

lock: 0x1417f80:

lock: 0x1418040:

lock: 0x1418100:

lock: 0x1419840:

lock: 0x1419a80:

lock: 0x14199c0:

lock: 0x1419900:

lock: 0x1419540:

lock: 0x1419480:

lock: 0x14193c0:

lock: 0x1419300:

lock: 0x1419240:

lock: 0x14196c0:

lock: 0x1419180:

lock: 0x14190c0:

lock: 0x1419780:

lock: 0x1418f40:

lock: 0x1418b80:

lock: 0x1418c40:

lock: 0x1418ac0:

lock: 0x1418a00:

lock: 0x1418700:

lock: 0x1418940:

lock: 0x1418880:

lock: 0x1418640:

lock: 0x14187c0:

lock: 0x1418400:

lock: 0x14184c0:

lock: 0x1418580:

lock: 0x1419600:


Key caches:
default
Buffer_size:       4194304
Block_size:           1024
Division_limit:        100
Age_limit:             300
blocks used:            59
not flushed:             0
w_requests:           5022
writes:                  0
r_requests:          73409
reads:                 217


handler status:
read_key:      5501704
read_next:    26135410
read_rnd       2023571
read_first:       7309
write:         3818274
delete              60
update:         483369

Table status:
Opened tables:        425
Open tables:           32
Open files:            22
Open streams:           0

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

Memory status:
<malloc version="1">
<heap nr="0">
<sizes>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="0" size="0"/>
<system type="current" size="0"/>
<system type="max" size="0"/>
<aspace type="total" size="0"/>
<aspace type="mprotect" size="0"/>
</heap>
<total type="fast" count="0" size="0"/>
<total type="rest" count="0" size="0"/>
<total type="mmap" count="0" size="0"/>
<system type="current" size="0"/>
<system type="max" size="0"/>
<aspace type="total" size="0"/>
<aspace type="mprotect" size="0"/>
</malloc>



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

感觉是mysql配置文件空了或数据库目录权限不对
你可以分别输入以下命令查看

1. ll /etc/my.cnf

复制代码

1. ll /www/server

复制代码

河妖 发表于 2017-8-18 16:28
感觉是mysql配置文件空了或数据库目录权限不对
你可以分别输入以下命令查看

输入了
有时候mysql会挂掉，要手动启动

Wye 发表于 2017-8-18 16:37
输入了
有时候mysql会挂掉，要手动启动

是启动不了还是自动挂掉
如果是自动挂掉可能是你服务器内存不够了
请问你是多大内存装的啥版本的数据库

河妖 发表于 2017-8-18 16:47
是启动不了还是自动挂掉
如果是自动挂掉可能是你服务器内存不够了
请问你是多大内存装的啥版本的数据库 ...

是自动挂掉，1G内存，mysql alisql5.6

Wye 发表于 2017-8-18 16:49
是自动挂掉，1G内存，mysql alisql5.6

在linux工具箱弄个2G的swap分区

河妖 发表于 2017-8-18 18:28
在linux工具箱弄个2G的swap分区

好的，谢谢，已经设置了，观察几天看看

河妖 发表于 2017-8-18 18:28
在linux工具箱弄个2G的swap分区

老大，按你说的设置了，还是有mysql错误日志
请老大帮忙看看，谢谢

Status information:

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

lock: 0x7fdda3fa4540:

lock: 0x7fdda3fa4e00:

lock: 0x7fdda4323360:

lock: 0x7fdda3fa4b80:

lock: 0x7fdda3fa4f40:

lock: 0x7fdda3ffbf60:

lock: 0x7fdda3fa4680:

lock: 0x7fdda400f160:

lock: 0x7fdda3fa4400:

lock: 0x7fdda3fa42c0:

lock: 0x7fdda3f54dc0:

lock: 0x7fdda3fa4180:

lock: 0x7fdda3f54c80:

lock: 0x7fdda3f54b40:

lock: 0x7fdda3f54a00:

lock: 0x7fdda3f54780:

lock: 0x7fdda3f54500:

lock: 0x7fdda3f54640:

lock: 0x7fdda3e38b60:

lock: 0x7fdda412b760:

lock: 0x7fdda3f0a760:

lock: 0x7fdda40ec040:

lock: 0x7fdda40ebdc0:

lock: 0x7fdda40ebc80:

lock: 0x7fdda40ebb40:

lock: 0x7fdda40eba00:

lock: 0x7fdda40eb8c0:

lock: 0x7fdda3f54280:

lock: 0x1419cc0:

lock: 0x1419c00:

lock: 0x1418e80:

lock: 0x1418dc0:

lock: 0x1418d00:

lock: 0x1419000:

lock: 0x1417680:

lock: 0x1419b40:

lock: 0x1417c80:

lock: 0x1417ec0:

lock: 0x1417bc0:

lock: 0x1417e00:

lock: 0x1417b00:

lock: 0x1417d40:

lock: 0x14181c0:

lock: 0x1418280:

lock: 0x1418340:

lock: 0x1417a40:

lock: 0x1417800:

lock: 0x1417980:

lock: 0x1417740:

lock: 0x14178c0:

lock: 0x1417f80:

lock: 0x1418040:

lock: 0x1418100:

lock: 0x1419840:

lock: 0x1419a80:

lock: 0x14199c0:

lock: 0x1419900:

lock: 0x1419540:

lock: 0x1419480:

lock: 0x14193c0:

lock: 0x1419300:

lock: 0x1419240:

lock: 0x14196c0:

lock: 0x1419180:

lock: 0x14190c0:

lock: 0x1419780:

lock: 0x1418f40:

lock: 0x1418b80:

lock: 0x1418c40:

lock: 0x1418ac0:

lock: 0x1418a00:

lock: 0x1418700:

lock: 0x1418940:

lock: 0x1418880:

lock: 0x1418640:

lock: 0x14187c0:

lock: 0x1418400:

lock: 0x14184c0:

lock: 0x1418580:

lock: 0x1419600:


Key caches:
default
Buffer_size:       4194304
Block_size:           1024
Division_limit:        100
Age_limit:             300
blocks used:            66
not flushed:             0
w_requests:          22741
writes:                 18
r_requests:         125646
reads:                 139


handler status:
read_key:      4336294
read_next:    19410816
read_rnd       1839012
read_first:       7441
write:         3449260
delete              20
update:          17102

Table status:
Opened tables:        211
Open tables:           32
Open files:            16
Open streams:           0

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

Memory status:
<malloc version="1">
<heap nr="0">
<sizes>
<unsorted from="140590476177936" to="12333758" total="140590476178016" count="140590476178240"/>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="0" size="0"/>
<system type="current" size="0"/>
<system type="max" size="0"/>
<aspace type="total" size="0"/>
<aspace type="mprotect" size="0"/>
</heap>
<total type="fast" count="0" size="0"/>
<total type="rest" count="0" size="0"/>
<total type="mmap" count="0" size="0"/>
<system type="current" size="0"/>
<system type="max" size="0"/>
<aspace type="total" size="0"/>
<aspace type="mprotect" size="0"/>
</malloc>



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: 0x7fddaa07d360:

lock: 0x7fdda3f2ff60:

lock: 0x7fdda3f2e160:

lock: 0x7fdda428e760:

lock: 0x7fdda3f2f560:

lock: 0x7fdda3f2eb60:

lock: 0x7fdda3fa5300:

lock: 0x7fdda3fa60c0:

lock: 0x7fdda3fa5bc0:

lock: 0x7fdda3fa6200:

lock: 0x7fdda3fa7100:

lock: 0x7fdda3fa51c0:

lock: 0x7fdda3fa5f80:

lock: 0x7fdda40f0280:

lock: 0x7fdda3fa5a80:

lock: 0x7fdda3fa5800:

lock: 0x7fdda3e71b60:

lock: 0x7fddaf4c0b60:

lock: 0x7fddaf5c3160:

lock: 0x7fdda40f1180:

lock: 0x7fdda40f0f00:

lock: 0x7fdda40f0dc0:

lock: 0x7fdda40f0c80:

lock: 0x7fdda40f0a00:

lock: 0x7fdda40f08c0:

lock: 0x7fdda40f0780:

lock: 0x7fdda40f0640:

lock: 0x7fdda40f0500:

lock: 0x7fdda3fa7380:

lock: 0x7fdda3fa6c00:

lock: 0x7fdda3fa7880:

lock: 0x7fdda3fa7740:

lock: 0x1419cc0:

lock: 0x1419c00:

lock: 0x1418e80:

lock: 0x1418dc0:

lock: 0x1418d00:

lock: 0x1419000:

lock: 0x1417680:

lock: 0x1419b40:

lock: 0x1417c80:

lock: 0x1417ec0:

lock: 0x1417bc0:

lock: 0x1417e00:

lock: 0x1417b00:

lock: 0x1417d40:

lock: 0x14181c0:

lock: 0x1418280:

lock: 0x1418340:

lock: 0x1417a40:

lock: 0x1417800:

lock: 0x1417980:

lock: 0x1417740:

lock: 0x14178c0:

lock: 0x1417f80:

lock: 0x1418040:

lock: 0x1418100:

lock: 0x1419840:

lock: 0x1419a80:

lock: 0x14199c0:

lock: 0x1419900:

lock: 0x1419540:

lock: 0x1419480:

lock: 0x14193c0:

lock: 0x1419300:

lock: 0x1419240:

lock: 0x14196c0:

lock: 0x1419180:

lock: 0x14190c0:

lock: 0x1419780:

lock: 0x1418f40:

lock: 0x1418b80:

lock: 0x1418c40:

lock: 0x1418ac0:

lock: 0x1418a00:

lock: 0x1418700:

lock: 0x1418940:

lock: 0x1418880:

lock: 0x1418640:

lock: 0x14187c0:

lock: 0x1418400:

lock: 0x14184c0:

lock: 0x1418580:

lock: 0x1419600:


Key caches:
default
Buffer_size:       4194304
Block_size:           1024
Division_limit:        100
Age_limit:             300
blocks used:            66
not flushed:             0
w_requests:          37087
writes:                 42
r_requests:         173343
reads:                 251


handler status:
read_key:      5829894
read_next:    25568850
read_rnd       2515305
read_first:      11155
write:         4575180
delete              27
update:          24255

Table status:
Opened tables:        398
Open tables:           32
Open files:            20
Open streams:           0

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

Memory status:
<malloc version="1">
<heap nr="0">
<sizes>
<unsorted from="140590476177936" to="7" total="140590447037968" count="140590476178240"/>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="0" size="0"/>
<system type="current" size="0"/>
<system type="max" size="0"/>
<aspace type="total" size="0"/>
<aspace type="mprotect" size="0"/>
</heap>
<total type="fast" count="0" size="0"/>
<total type="rest" count="0" size="0"/>
<total type="mmap" count="0" size="0"/>
<system type="current" size="0"/>
<system type="max" size="0"/>
<aspace type="total" size="0"/>
<aspace type="mprotect" size="0"/>
</malloc>



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

@河妖 老大，帮忙看看，谢谢了

@河妖 老大，帮忙看看，谢谢了