Home > database >  Why one day 20 IP mysql crashes frequently? Tencent 2 h4g5m cloud
Why one day 20 IP mysql crashes frequently? Tencent 2 h4g5m cloud

Time:09-15

Such as topic, tired, WP Super Cache, Memcached is set, and new stations didn't flow, website hanging in there natural collapse, for bosses to help me see thanks, binary log had been closed, performance is set reasonable,

Here is just the collapse of the mysql error log

The Key caches:
The default
Buffer_size: 67108864
Block_size: 1024
Division_limit: 100
Age_limit: 300
Blocks 2:14
The not flushed: 0
W_requests: 326
Writes: 174
R_requests: 3672
Reads: 12


Handler status:
Read_key: 37591
Read_next: 17554
Read_rnd 3908
Read_first: 219
Write: 11527
Delete 1
Update: 3727

Table status:
The Opened tables: 58
The Open tables: 51
The Open files: 27
Open streams: 0

Alarm status:
The Active alarms: 0
Max 2 alarms: 0
The Next alarm time: 0

The Memory status:
Non - mmapped space allocated from the system: 36569088
The Number of free chunks: 345
Number of fastbin blocks: 55
Number of mmapped regions: 16
Space in mmapped regions: 145997824
The Maximum total allocated space: 0
Space available in freed fastbin blocks: 3680
The Total allocated space: 12922496
The Total free space: 23646592
Most Top -, releasable space: 3766864
Estimated the memory (with thread stack) : 182566912



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

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

The Event queue status:
Element count: 0
Data locked: NO
Attempting to lock: NO
LLA: init_queue: 139
LUA: init_queue: 149
WOC: NO
Next the activation: never
200503 18:28:04 [Note] the Plugin 'FEDERATED is disabled.
200503 18:28:04 InnoDB: The InnoDB heap memory is disabled
200503 18:28:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
200503 18:28:04 InnoDB: Compressed tables use zlib 1.2.11
200503 18:28:04 InnoDB: Using Linux native AIO
200503 18:28:04 InnoDB: Initializing buffer pool, size=256.0 M
InnoDB: mmap (274726912 bytes) failed; Errno 12
200503 18:28:04 InnoDB: Completed initialization of buffer pool
200503 18:28:04 InnoDB: Fatal error: always the allocate memory for the buffer pool
200503 18:28:04 [ERROR] Plugin 'InnoDB' init function returned ERROR.
200503 18:28:04 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
200503 18:28:04 [ERROR] Unknown/unsupported storage engine: InnoDB
[ERROR] 200503 18:28:04 Aborting

200503 18:28:04 [Note]/wwwrver/mysql/bin/mysqld: Shutdown complete

200503 19:14:46 [Note] the Plugin 'FEDERATED is disabled.
200503 19:14:46 InnoDB: The InnoDB heap memory is disabled
200503 19:14:46 InnoDB: Mutexes and rw_locks use GCC atomic builtins
200503 19:14:46 InnoDB: Compressed tables use zlib 1.2.11
200503 19:14:46 InnoDB: Using Linux native AIO
200503 19:14:46 InnoDB: Initializing buffer pool, size=256.0 M
200503 19:14:46 InnoDB: Completed initialization of buffer pool
200503 19:14:46 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint LSN 173949303
200503 19:14:46 InnoDB: the Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading in tablespace information from the. Ibd files...
InnoDB: Restoring possible half - written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned one log sequence number 175137706
200503 19:14:46 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20, 21, 22, 23 24 25, 26 and 27, 28, 29 30 31 32 33 34 35 36, 37, 38, 39, 40 and 41 and 42, 43 and 44 45 46 and 47 48 49 50 51 52 and 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
200503 19:14:46 InnoDB: Waiting for the background threads to start
200503 19:14:47 InnoDB: 5.5.62 started; The log sequence number 175137706
200503 19:14:47 [Note] Server hostname (bind - address) : '0.0.0.0'; Port: 3306
200503 19:14:47 [Note] - '0.0.0.0 resolves to' 0.0.0.0 ';
200503 19:14:47 [Note] Server socket created on IP: '0.0.0.0.
200503 19:14:47 [Note] Event Scheduler: the Loaded 0 events
200503 19:14:47 [Note]/wwwrver/mysql/bin/mysqld: ready for connections.
null
  • Related