liunx mysql错误日志_帮我看看mysql错误日志

本帖最后由 Wye 于 2017-8-18 16:16 编辑

帮我看看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:

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