mysql.log

2018-05-21T10:30:45.905842Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-05-21T10:30:45.907883Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2018-05-21T10:30:45.908587Z 0 [Note] mysqld (mysqld 5.7.21) starting as process 73491 ...
2018-05-21T10:30:45.919278Z 0 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
2018-05-21T10:30:45.925278Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-05-21T10:30:45.925321Z 0 [Note] InnoDB: Uses event mutexes
2018-05-21T10:30:45.925328Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-05-21T10:30:45.925334Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-05-21T10:30:45.927012Z 0 [Note] InnoDB: Number of pools: 1
2018-05-21T10:30:45.928327Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-05-21T10:30:45.930328Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-05-21T10:30:45.942043Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-05-21T10:30:45.960953Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-05-21T10:30:45.963291Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 7919230
2018-05-21T10:30:45.963305Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 7919239
2018-05-21T10:30:45.963311Z 0 [Note] InnoDB: Database was not shutdown normally!
2018-05-21T10:30:45.963316Z 0 [Note] InnoDB: Starting crash recovery.
2018-05-21T10:30:46.133563Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-05-21T10:30:46.133589Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-05-21T10:30:46.133748Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-05-21T10:30:46.142250Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-05-21T10:30:46.142987Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-05-21T10:30:46.143001Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-05-21T10:30:46.143183Z 0 [Note] InnoDB: Waiting for purge to start
2018-05-21T10:30:46.196497Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 7919239
2018-05-21T10:30:46.196654Z 0 [Note] InnoDB: Loading buffer pool(s) from /usr/local/var/mysql/ib_buffer_pool
2018-05-21T10:30:46.198576Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-05-21T10:30:46.206071Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180521 18:30:46
2018-05-21T10:30:46.215553Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2018-05-21T10:30:46.215570Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2018-05-21T10:30:46.219173Z 0 [Warning] CA certificate ca.pem is self signed.
2018-05-21T10:30:46.219749Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2018-05-21T10:30:46.228573Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2018-05-21T10:30:46.228624Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2018-05-21T10:30:46.228669Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2018-05-21T10:30:46.318672Z 0 [Note] Event Scheduler: Loaded 0 events
2018-05-21T10:30:46.318786Z 0 [Note] mysqld: ready for connections.
Version: '5.7.21'  socket: '/tmp/mysql.sock'  port: 3306  Homebrew

Status information:

Current dir: /usr/local/var/mysql/
Running threads: 0  Stack size: 262144
Current locks:
lock: 0x7f8578954180:

lock: 0x7f85788f6780:

lock: 0x7f8578901780:

lock: 0x7f85788efb80:

lock: 0x7f85788dc780:

lock: 0x7f85788d5980:

lock: 0x7f85788c3780:

lock: 0x10a7df530:

lock: 0x10a7df458:

lock: 0x10a7df380:

lock: 0x10a7df2a8:

lock: 0x10a7df1d0:

lock: 0x10a7df0f8:

lock: 0x10a7df020:

lock: 0x10a7def48:

lock: 0x10a7dee70:

lock: 0x10a7dfb18:

lock: 0x10a7dc368:

lock: 0x10a7e0388:

lock: 0x10a7e02b0:

lock: 0x10a7e01d8:

lock: 0x10a7e0100:

lock: 0x10a7e0028:

lock: 0x10a7dff50:

lock: 0x10a7dfe78:

lock: 0x10a7dfda0:

lock: 0x10a7ddb08:

lock: 0x10a7df608:

lock: 0x10a7ddf40:

lock: 0x10a7dde68:

lock: 0x10a7ddd90:

lock: 0x10a7ddcb8:

lock: 0x10a7ddbe0:

lock: 0x10a7dfcc8:

lock: 0x10a7dfbf0:

lock: 0x10a7de378:

lock: 0x10a7de2a0:

lock: 0x10a7de1c8:

lock: 0x10a7de528:

lock: 0x10a7dbaf8:

lock: 0x10a7dfa40:

lock: 0x10a7dca28:

lock: 0x10a7dc7a0:

lock: 0x10a7dc950:

lock: 0x10a7dc6c8:

lock: 0x10a7dc878:

lock: 0x10a7dd1c0:

lock: 0x10a7dd0e8:

lock: 0x10a7dd010:

lock: 0x10a7dc290:

lock: 0x10a7dc1b8:

lock: 0x10a7dc5f0:

lock: 0x10a7dc0e0:

lock: 0x10a7dc518:

lock: 0x10a7dc008:

lock: 0x10a7dc440:

lock: 0x10a7dcf38:

lock: 0x10a7dce60:

lock: 0x10a7dcd88:

lock: 0x10a7dbf30:

lock: 0x10a7dbca8:

lock: 0x10a7dbe58:

lock: 0x10a7dbbd0:

lock: 0x10a7dbd80:

lock: 0x10a7dccb0:

lock: 0x10a7dcbd8:

lock: 0x10a7dcb00:

lock: 0x10a7df6e0:

lock: 0x10a7df968:

lock: 0x10a7df890:

lock: 0x10a7df7b8:

lock: 0x10a7deb10:

lock: 0x10a7dea38:

lock: 0x10a7de960:

lock: 0x10a7de888:

lock: 0x10a7de7b0:

lock: 0x10a7decc0:

lock: 0x10a7de6d8:

lock: 0x10a7de600:

lock: 0x10a7debe8:

lock: 0x10a7de450:

lock: 0x10a7de018:

lock: 0x10a7de0f0:

lock: 0x10a7dda30:

lock: 0x10a7dd958:

lock: 0x10a7dd5f8:

lock: 0x10a7dd880:

lock: 0x10a7dd7a8:

lock: 0x10a7dd520:

lock: 0x10a7dd6d0:

lock: 0x10a7dd448:

lock: 0x10a7dd370:

lock: 0x10a7dd298:

lock: 0x10a7ded98:


Key caches:
default
Buffer_size:       8388608
Block_size:           1024
Division_limit:        100
Age_limit:             300
blocks used:             3
not flushed:             0
w_requests:              0
writes:                  0
r_requests:              6
reads:                   3


handler status:
read_key:            6
read_next:           2
read_rnd             0
read_first:          8
write:               0
delete               0
update:              0

Table status:
Opened tables:        105
Open tables:           98
Open files:            14
Open streams:           0



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:96
LUA             : init_queue:104
WOC             : NO
Next activation : never
2018-05-21T12:32:54.002886Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 3451466ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-05-21T13:17:04.001916Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 775570ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-05-21T18:11:43.005268Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10801320ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-05-21T23:51:12.310153Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 20367195ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-05-22T01:31:22.004898Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 3892915ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-05-22T05:09:35.000899Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 3594156ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-05-22T05:41:28.001143Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 1661292ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-05-22T09:34:20.001025Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 140473ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)