[root@vmi456419 ~]# cat /www/server/data/*.err
2020-11-21 18:35:48 0 [Note] InnoDB: Using Linux native AIO
2020-11-21 18:35:48 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-11-21 18:35:48 0 [Note] InnoDB: Uses event mutexes
2020-11-21 18:35:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-11-21 18:35:48 0 [Note] InnoDB: Number of pools: 1
2020-11-21 18:35:48 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-11-21 18:35:48 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2020-11-21 18:35:48 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
2020-11-21 18:35:48 0 [Note] InnoDB: Completed initialization of buffer pool
2020-11-21 18:35:48 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-11-21 18:35:48 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-11-21 18:35:48 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-11-21 18:35:48 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-11-21 18:35:48 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2020-11-21 18:35:48 0 [Note] InnoDB: Waiting for purge to start
2020-11-21 18:35:48 0 [Note] InnoDB: 10.4.15 started; log sequence number 60974; transaction id 21
2020-11-21 18:35:48 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2020-11-21 18:35:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-11-21 18:35:48 0 [Note] InnoDB: Buffer pool(s) load completed at 201121 18:35:48
2020-11-21 18:35:48 0 [Note] Server socket created on IP: '::'.
2020-11-21 18:35:48 0 [Note] Reading of all Master_info entries succeeded
2020-11-21 18:35:48 0 [Note] Added new Master_info '' to hash table
2020-11-21 18:35:48 0 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '10.4.15-MariaDB-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
2020-11-21 18:35:54 0 [Note] /www/server/mysql/bin/mysqld (initiated by: unknown): Normal shutdown
2020-11-21 18:35:54 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-11-21 18:35:54 0 [Note] InnoDB: FTS optimize thread exiting.
2020-11-21 18:35:54 0 [Note] InnoDB: Starting shutdown...
2020-11-21 18:35:54 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2020-11-21 18:35:54 0 [Note] InnoDB: Buffer pool(s) dump completed at 201121 18:35:54
2020-11-21 18:35:55 0 [Note] InnoDB: Shutdown completed; log sequence number 60983; transaction id 22
2020-11-21 18:35:55 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-11-21 18:35:55 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

2020-11-21 18:35:56 0 [Note] InnoDB: Using Linux native AIO
2020-11-21 18:35:56 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-11-21 18:35:56 0 [Note] InnoDB: Uses event mutexes
2020-11-21 18:35:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-11-21 18:35:56 0 [Note] InnoDB: Number of pools: 1
2020-11-21 18:35:56 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-11-21 18:35:56 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2020-11-21 18:35:56 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
2020-11-21 18:35:56 0 [Note] InnoDB: Completed initialization of buffer pool
2020-11-21 18:35:56 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-11-21 18:35:56 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-11-21 18:35:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-11-21 18:35:56 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-11-21 18:35:56 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2020-11-21 18:35:56 0 [Note] InnoDB: Waiting for purge to start
2020-11-21 18:35:56 0 [Note] InnoDB: 10.4.15 started; log sequence number 60983; transaction id 21
2020-11-21 18:35:56 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2020-11-21 18:35:56 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-11-21 18:35:56 0 [Note] InnoDB: Buffer pool(s) load completed at 201121 18:35:56
2020-11-21 18:35:56 0 [Note] Server socket created on IP: '::'.
2020-11-21 18:35:56 0 [Note] Reading of all Master_info entries succeeded
2020-11-21 18:35:56 0 [Note] Added new Master_info '' to hash table
2020-11-21 18:35:56 0 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '10.4.15-MariaDB-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
2020-11-21 18:36:02 10 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2020-11-21 18:36:04 0 [Note] mysqld: Aria engine: starting recovery
recovered pages: 0% 61% 100% (0.0 seconds); tables to flush: 1 0
(0.0 seconds); 
2020-11-21 18:36:04 0 [Note] mysqld: Aria engine: recovery done
2020-11-21 18:36:04 0 [Note] InnoDB: Using Linux native AIO
2020-11-21 18:36:04 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-11-21 18:36:04 0 [Note] InnoDB: Uses event mutexes
2020-11-21 18:36:04 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-11-21 18:36:04 0 [Note] InnoDB: Number of pools: 1
2020-11-21 18:36:04 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-11-21 18:36:04 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2020-11-21 18:36:04 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
2020-11-21 18:36:04 0 [Note] InnoDB: Completed initialization of buffer pool
2020-11-21 18:36:04 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-11-21 18:36:04 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=60983
2020-11-21 18:36:05 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-11-21 18:36:05 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-11-21 18:36:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-11-21 18:36:05 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-11-21 18:36:05 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2020-11-21 18:36:05 0 [Note] InnoDB: Waiting for purge to start
2020-11-21 18:36:05 0 [Note] InnoDB: 10.4.15 started; log sequence number 60992; transaction id 21
2020-11-21 18:36:05 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2020-11-21 18:36:05 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-11-21 18:36:05 0 [Note] InnoDB: Buffer pool(s) load completed at 201121 18:36:05
2020-11-21 18:36:05 0 [Note] Recovering after a crash using mysql-bin
2020-11-21 18:36:05 0 [Note] Starting crash recovery...
2020-11-21 18:36:05 0 [Note] Crash recovery finished.
2020-11-21 18:36:05 0 [Note] Server socket created on IP: '::'.
2020-11-21 18:36:05 0 [Note] Reading of all Master_info entries succeeded
2020-11-21 18:36:05 0 [Note] Added new Master_info '' to hash table
2020-11-21 18:36:05 0 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '10.4.15-MariaDB-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
2020-11-21 18:36:05 9 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2020-11-21 18:36:06 0 [Note] /www/server/mysql/bin/mysqld (initiated by: unknown): Normal shutdown
2020-11-21 18:36:06 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-11-21 18:36:06 0 [Note] InnoDB: FTS optimize thread exiting.
2020-11-21 18:36:06 0 [Note] InnoDB: Starting shutdown...
2020-11-21 18:36:06 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2020-11-21 18:36:06 0 [Note] InnoDB: Buffer pool(s) dump completed at 201121 18:36:06
2020-11-21 18:36:07 0 [Note] InnoDB: Shutdown completed; log sequence number 61010; transaction id 22
2020-11-21 18:36:07 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-11-21 18:36:07 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

2020-11-21 18:36:09 0 [Note] InnoDB: Using Linux native AIO
2020-11-21 18:36:09 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-11-21 18:36:09 0 [Note] InnoDB: Uses event mutexes
2020-11-21 18:36:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-11-21 18:36:09 0 [Note] InnoDB: Number of pools: 1
2020-11-21 18:36:09 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-11-21 18:36:09 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2020-11-21 18:36:09 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
2020-11-21 18:36:09 0 [Note] InnoDB: Completed initialization of buffer pool
2020-11-21 18:36:09 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-11-21 18:36:09 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-11-21 18:36:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-11-21 18:36:09 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-11-21 18:36:09 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2020-11-21 18:36:09 0 [Note] InnoDB: Waiting for purge to start
2020-11-21 18:36:09 0 [Note] InnoDB: 10.4.15 started; log sequence number 61010; transaction id 21
2020-11-21 18:36:09 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2020-11-21 18:36:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-11-21 18:36:09 0 [Note] InnoDB: Buffer pool(s) load completed at 201121 18:36:09
2020-11-21 18:36:09 0 [Note] Server socket created on IP: '::'.
2020-11-21 18:36:09 0 [Note] Reading of all Master_info entries succeeded
2020-11-21 18:36:09 0 [Note] Added new Master_info '' to hash table
2020-11-21 18:36:09 0 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '10.4.15-MariaDB-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
2020-11-21 18:36:10 9 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2020-11-21 18:38:17 15 [Warning] Aborted connection 15 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-11-21 18:38:17 16 [Warning] Aborted connection 16 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-11-21 18:38:29 24 [Warning] Aborted connection 24 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-11-21 18:38:29 25 [Warning] Aborted connection 25 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-11-21 18:41:03 33 [Warning] Aborted connection 33 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-11-21 18:41:03 34 [Warning] Aborted connection 34 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-11-21 18:41:29 42 [Warning] Aborted connection 42 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-11-21 18:41:29 43 [Warning] Aborted connection 43 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)

Status information:

Current dir: /www/server/data/
Running threads: 5  Cached threads: 2  Stack size: 299008

Key caches:
default
Buffer_size:     134217728
Block_size:           1024
Division_limit:        100
Age_threshold:         300
Partitions:              0
blocks used:         69629
not flushed:             0
w_requests:        6407991
writes:              86318
r_requests:       20150289
reads:                  67


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

Table status:
Opened tables:        300
Open tables:           15
Open files:            33
Open streams:           0

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

Memory status:
Non-mmapped space allocated from system: 94834688
Number of free chunks:                   531
Number of fastbin blocks:                39
Number of mmapped regions:               10
Space in mmapped regions:                345436160
Maximum total allocated space:           0
Space available in freed fastbin blocks: 2496
Total allocated space:                   35293280
Total free space:                        59541408
Top-most, releasable space:              46112
Estimated memory (with thread stack):    442363904
Global memory allocated by server:       341640008
Memory allocated by threads:             140040



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             : drop_schema_events:389
LUA             : drop_schema_events:391
WOC             : NO
Next activation : never
2020-11-21 18:48:04 0 [Note] /www/server/mysql/bin/mysqld (initiated by: unknown): Normal shutdown
2020-11-21 18:48:04 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-11-21 18:48:04 0 [Note] InnoDB: FTS optimize thread exiting.
2020-11-21 18:48:04 0 [Note] InnoDB: Starting shutdown...
2020-11-21 18:48:04 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2020-11-21 18:48:04 0 [Note] InnoDB: Buffer pool(s) dump completed at 201121 18:48:04
2020-11-21 18:48:06 0 [Note] InnoDB: Shutdown completed; log sequence number 94614622; transaction id 1835
2020-11-21 18:48:06 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-11-21 18:48:06 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

2020-11-21 10:48:33 0 [Note] InnoDB: Using Linux native AIO
2020-11-21 10:48:33 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-11-21 10:48:33 0 [Note] InnoDB: Uses event mutexes
2020-11-21 10:48:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-11-21 10:48:33 0 [Note] InnoDB: Number of pools: 1
2020-11-21 10:48:33 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-11-21 10:48:33 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2020-11-21 10:48:33 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M
2020-11-21 10:48:33 0 [Note] InnoDB: Completed initialization of buffer pool
2020-11-21 10:48:33 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-11-21 10:48:34 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-11-21 10:48:34 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-11-21 10:48:34 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-11-21 10:48:34 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2020-11-21 10:48:34 0 [Note] InnoDB: Waiting for purge to start
2020-11-21 10:48:34 0 [Note] InnoDB: 10.4.15 started; log sequence number 94614622; transaction id 1837
2020-11-21 10:48:34 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2020-11-21 10:48:34 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-11-21 10:48:34 0 [Note] Server socket created on IP: '::'.
2020-11-21 10:48:34 0 [Note] Reading of all Master_info entries succeeded
2020-11-21 10:48:34 0 [Note] Added new Master_info '' to hash table
2020-11-21 10:48:34 0 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '10.4.15-MariaDB-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
2020-11-21 10:48:34 9 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2020-11-21 10:48:34 0 [Note] InnoDB: Buffer pool(s) load completed at 201121 10:48:34
[root@vmi456419 ~]#

