Created
October 31, 2015 19:22
-
-
Save anonymous/c634011286c3a7a17959 to your computer and use it in GitHub Desktop.
status.txt
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
+--------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | |
| Type | Name | Status | | |
+--------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | |
| InnoDB | | | |
===================================== | |
2015-10-31 22:21:16 7ff153f1b700 INNODB MONITOR OUTPUT | |
===================================== | |
Per second averages calculated from the last 0 seconds | |
----------------- | |
BACKGROUND THREAD | |
----------------- | |
srv_master_thread loops: 11 srv_active, 0 srv_shutdown, 25242 srv_idle | |
srv_master_thread log flush and writes: 25248 | |
---------- | |
SEMAPHORES | |
---------- | |
OS WAIT ARRAY INFO: reservation count 44 | |
OS WAIT ARRAY INFO: signal count 44 | |
Mutex spin waits 517, rounds 959, OS waits 13 | |
RW-shared spins 30, rounds 900, OS waits 30 | |
RW-excl spins 1, rounds 30, OS waits 1 | |
Spin rounds per wait: 1.85 mutex, 30.00 RW-shared, 30.00 RW-excl | |
------------------------ | |
LATEST FOREIGN KEY ERROR | |
------------------------ | |
2015-10-31 22:15:37 7ff153f1b700 Error in foreign key constraint creation for table `dbmail`.`dbmail_auto_replies`. | |
A foreign key constraint of name `dbmail`.`user_idnr_fk` | |
already exists. (Note that internally InnoDB adds 'databasename' | |
in front of the user-defined constraint name.) | |
Note that InnoDB's FOREIGN KEY system tables store | |
constraint names as case-insensitive, with the | |
MySQL standard latin1_swedish_ci collation. If you | |
create tables or databases whose names differ only in | |
the character case, then collisions in constraint | |
names can occur. Workaround: name your constraints | |
explicitly with unique names. | |
------------ | |
TRANSACTIONS | |
------------ | |
Trx id counter 1021138 | |
Purge done for trx's n:o < 1021127 undo n:o < 0 state: running but idle | |
History list length 454 | |
LIST OF TRANSACTIONS FOR EACH SESSION: | |
---TRANSACTION 0, not started | |
MySQL thread id 9, OS thread handle 0x7ff153f1b700, query id 66 localhost root init | |
show engine innodb status | |
---TRANSACTION 1020931, not started | |
MySQL thread id 1, OS thread handle 0x7ff153fad700, query id 0 Waiting for background binlog tasks | |
-------- | |
FILE I/O | |
-------- | |
I/O thread 0 state: waiting for completed aio requests (insert buffer thread) | |
I/O thread 1 state: waiting for completed aio requests (log thread) | |
I/O thread 2 state: waiting for completed aio requests (read thread) | |
I/O thread 3 state: waiting for completed aio requests (read thread) | |
I/O thread 4 state: waiting for completed aio requests (read thread) | |
I/O thread 5 state: waiting for completed aio requests (read thread) | |
I/O thread 6 state: waiting for completed aio requests (write thread) | |
I/O thread 7 state: waiting for completed aio requests (write thread) | |
I/O thread 8 state: waiting for completed aio requests (write thread) | |
I/O thread 9 state: waiting for completed aio requests (write thread) | |
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , | |
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 | |
Pending flushes (fsync) log: 0; buffer pool: 0 | |
592 OS file reads, 638 OS file writes, 302 OS fsyncs | |
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s | |
------------------------------------- | |
INSERT BUFFER AND ADAPTIVE HASH INDEX | |
------------------------------------- | |
Ibuf: size 1, free list len 3, seg size 5, 0 merges | |
merged operations: | |
insert 0, delete mark 0, delete 0 | |
discarded operations: | |
insert 0, delete mark 0, delete 0 | |
0.00 hash searches/s, 0.00 non-hash searches/s | |
--- | |
LOG | |
--- | |
Log sequence number 292059682 | |
Log flushed up to 292059682 | |
Pages flushed up to 292059682 | |
Last checkpoint at 292059682 | |
Max checkpoint age 80826164 | |
Checkpoint age target 78300347 | |
Modified age 0 | |
Checkpoint age 0 | |
0 pending log writes, 0 pending chkp writes | |
154 log i/o's done, 0.00 log i/o's/second | |
---------------------- | |
BUFFER POOL AND MEMORY | |
---------------------- | |
Total memory allocated 137363456; in additional pool allocated 0 | |
Total memory allocated by read views 104 | |
Internal hash tables (constant factor + variable factor) | |
Adaptive hash index 2250336 (2213368 + 36968) | |
Page hash 139112 (buffer pool 0 only) | |
Dictionary cache 807188 (554768 + 252420) | |
File system 846928 (812272 + 34656) | |
Lock system 333592 (332872 + 720) | |
Recovery system 0 (0 + 0) | |
Dictionary memory allocated 252420 | |
Buffer pool size 8191 | |
Buffer pool size, bytes 134201344 | |
Free buffers 7490 | |
Database pages 699 | |
Old database pages 272 | |
Modified db pages 0 | |
Percent of dirty pages(LRU & free pages): 0.000 | |
Max dirty pages percent: 75.000 | |
Pending reads 0 | |
Pending writes: LRU 0, flush list 0, single page 0 | |
Pages made young 0, not young 0 | |
0.00 youngs/s, 0.00 non-youngs/s | |
Pages read 552, created 147, written 365 | |
0.00 reads/s, 0.00 creates/s, 0.00 writes/s | |
No buffer pool page gets since the last printout | |
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s | |
LRU len: 699, unzip_LRU len: 0 | |
I/O sum[0]:cur[0], unzip sum[0]:cur[0] | |
-------------- | |
ROW OPERATIONS | |
-------------- | |
0 queries inside InnoDB, 0 queries in queue | |
0 read views open inside InnoDB | |
0 RW transactions active inside InnoDB | |
0 RO transactions active inside InnoDB | |
0 out of 1000 descriptors used | |
Main thread process no. 983, id 140674116597504, state: sleeping | |
Number of rows inserted 0, updated 0, deleted 0, read 0 | |
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s | |
Number of system rows inserted 0, updated 0, deleted 0, read 0 | |
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s | |
---------------------------- | |
END OF INNODB MONITOR OUTPUT | |
============================ | |
| | |
+--------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment