By type
[38;5;6mmariadb [38;5;5m06:52:29.58 [0m
[38;5;6mmariadb [38;5;5m06:52:29.60 [0m[1mWelcome to the Bitnami mariadb-galera container[0m
[38;5;6mmariadb [38;5;5m06:52:29.63 [0mSubscribe to project updates by watching [1mhttps://github.com/bitnami/bitnami-docker-mariadb-galera[0m
[38;5;6mmariadb [38;5;5m06:52:29.67 [0mSubmit issues and feature requests at [1mhttps://github.com/bitnami/bitnami-docker-mariadb-galera/issues[0m
[38;5;6mmariadb [38;5;5m06:52:29.70 [0m
[38;5;6mmariadb [38;5;5m06:52:29.73 [0m[38;5;2mINFO [0m ==> ** Starting MariaDB setup **
[38;5;6mmariadb [38;5;5m06:52:29.95 [0m[38;5;2mINFO [0m ==> Validating settings in MYSQL_*/MARIADB_* env vars
[38;5;6mmariadb [38;5;5m06:52:30.30 [0m[38;5;2mINFO [0m ==> Initializing mariadb database
[38;5;6mmariadb [38;5;5m06:52:30.33 [0m[38;5;5mDEBUG[0m ==> Ensuring expected directories/files exist
[38;5;6mmariadb [38;5;5m06:52:30.53 [0m[38;5;2mINFO [0m ==> Updating 'my.cnf' with custom configuration
[38;5;6mmariadb [38;5;5m06:52:30.62 [0m[38;5;2mINFO [0m ==> Setting user option
[38;5;6mmariadb [38;5;5m06:52:30.71 [0m[38;5;5mDEBUG[0m ==> Setting user to 'policy_user' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m06:52:30.90 [0m[38;5;2mINFO [0m ==> Setting wsrep_node_name option
[38;5;6mmariadb [38;5;5m06:52:30.92 [0m[38;5;5mDEBUG[0m ==> Setting wsrep_node_name to 'onap-policy-mariadb-0' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m06:52:30.95 [0m[38;5;2mINFO [0m ==> Setting wsrep_node_address option
[38;5;6mmariadb [38;5;5m06:52:30.97 [0m[38;5;5mDEBUG[0m ==> Setting wsrep_node_address to '10.233.70.3' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m06:52:31.28 [0m[38;5;2mINFO [0m ==> Setting wsrep_sst_auth option
[38;5;6mmariadb [38;5;5m06:52:31.30 [0m[38;5;5mDEBUG[0m ==> Setting wsrep_sst_auth to 'mariabackup:Woc74ZuP' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m06:52:31.37 [0m[38;5;2mINFO [0m ==> Persisted data detected. Restoring
[38;5;6mmariadb [38;5;5m06:52:31.61 [0m[38;5;2mINFO [0m ==> ** MariaDB setup finished! **
[38;5;6mmariadb [38;5;5m06:52:32.01 [0m[38;5;2mINFO [0m ==> ** Starting MariaDB **
[38;5;6mmariadb [38;5;5m06:52:32.07 [0m[38;5;2mINFO [0m ==> Setting previous boot
2022-04-22 6:52:32 0 [Warning] WSREP: option --wsrep-causal-reads is deprecated
2022-04-22 6:52:32 0 [Warning] WSREP: --wsrep-causal-reads=ON takes precedence over --wsrep-sync-wait=0. WSREP_SYNC_WAIT_BEFORE_READ is on
2022-04-22 6:52:32 0 [Note] /opt/bitnami/mariadb/sbin/mysqld (mysqld 10.5.8-MariaDB-log) starting as process 1 ...
2022-04-22 6:52:32 0 [Note] WSREP: Loading provider /opt/bitnami/mariadb/lib/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1
2022-04-22 6:52:32 0 [Note] WSREP: wsrep_load(): loading provider library '/opt/bitnami/mariadb/lib/libgalera_smm.so'
2022-04-22 6:52:32 0 [Note] WSREP: wsrep_load(): Galera 4.7(rXXXX) by Codership Oy loaded successfully.
2022-04-22 6:52:32 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration.
2022-04-22 6:52:32 0 [Note] WSREP: Found saved state: f3997baa-c1f9-11ec-ab6b-f686f1728580:252, safe_to_bootstrap: 1
2022-04-22 6:52:32 0 [Note] WSREP: GCache DEBUG: opened preamble:
Version: 2
UUID: f3997baa-c1f9-11ec-ab6b-f686f1728580
Seqno: 1 - 252
Offset: 1280
Synced: 1
2022-04-22 6:52:32 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: f3997baa-c1f9-11ec-ab6b-f686f1728580, offset: 1280
2022-04-22 6:52:32 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/134217752 bytes) complete.
2022-04-22 6:52:32 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (134217752/134217752 bytes) complete.
2022-04-22 6:52:32 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 1-252
2022-04-22 6:52:32 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/138480 bytes) complete.
2022-04-22 6:52:32 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (138480/138480 bytes) complete.
2022-04-22 6:52:32 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 0/252 locked buffers
2022-04-22 6:52:32 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): free space: 134079248/134217728
2022-04-22 6:52:32 0 [Note] WSREP: Passing config to GCS: base_dir = /bitnami/mariadb/data/; base_host = 10.233.70.3; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /bitnami/mariadb/data/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; p
2022-04-22 6:52:32 0 [Note] WSREP: Service thread queue flushed.
2022-04-22 6:52:32 0 [Note] WSREP: ####### Assign initial position for certification: f3997baa-c1f9-11ec-ab6b-f686f1728580:252, protocol version: -1
2022-04-22 6:52:32 0 [Note] WSREP: Start replication
2022-04-22 6:52:32 0 [Note] WSREP: Connecting with bootstrap option: 1
2022-04-22 6:52:32 0 [Note] WSREP: Setting GCS initial position to f3997baa-c1f9-11ec-ab6b-f686f1728580:252
2022-04-22 6:52:32 0 [Note] WSREP: protonet asio version 0
2022-04-22 6:52:32 0 [Note] WSREP: Using CRC-32C for message checksums.
2022-04-22 6:52:32 0 [Note] WSREP: backend: asio
2022-04-22 6:52:32 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2022-04-22 6:52:32 0 [Warning] WSREP: access file(/bitnami/mariadb/data//gvwstate.dat) failed(No such file or directory)
2022-04-22 6:52:32 0 [Note] WSREP: restore pc from disk failed
2022-04-22 6:52:32 0 [Note] WSREP: GMCast version 0
2022-04-22 6:52:32 0 [Note] WSREP: (c8af93bd-ad76, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2022-04-22 6:52:32 0 [Note] WSREP: (c8af93bd-ad76, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2022-04-22 6:52:32 0 [Note] WSREP: EVS version 1
2022-04-22 6:52:32 0 [Note] WSREP: gcomm: bootstrapping new group 'galera'
2022-04-22 6:52:32 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery
2022-04-22 6:52:32 0 [Note] WSREP: EVS version upgrade 0 -> 1
2022-04-22 6:52:32 0 [Note] WSREP: PC protocol upgrade 0 -> 1
2022-04-22 6:52:32 0 [Note] WSREP: Node c8af93bd-ad76 state prim
2022-04-22 6:52:32 0 [Note] WSREP: view(view_id(PRIM,c8af93bd-ad76,1) memb {
c8af93bd-ad76,0
} joined {
} left {
} partitioned {
})
2022-04-22 6:52:32 0 [Note] WSREP: save pc into disk
2022-04-22 6:52:32 0 [Note] WSREP: gcomm: connected
2022-04-22 6:52:32 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2022-04-22 6:52:32 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2022-04-22 6:52:32 0 [Note] WSREP: Opened channel 'galera'
2022-04-22 6:52:32 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
2022-04-22 6:52:32 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: c8b10d39-c208-11ec-8924-4f06d5a05b04
2022-04-22 6:52:32 0 [Note] WSREP: STATE EXCHANGE: sent state msg: c8b10d39-c208-11ec-8924-4f06d5a05b04
2022-04-22 6:52:32 1 [Note] WSREP: Starting rollbacker thread 1
2022-04-22 6:52:32 0 [Note] WSREP: STATE EXCHANGE: got state msg: c8b10d39-c208-11ec-8924-4f06d5a05b04 from 0 (onap-policy-mariadb-0)
2022-04-22 6:52:32 0 [Note] WSREP: Quorum results:
version = 6,
component = PRIMARY,
conf_id = 0,
members = 1/1 (joined/total),
act_id = 252,
last_appl. = 252,
protocols = 2/10/4 (gcs/repl/appl),
vote policy= 0,
group UUID = f3997baa-c1f9-11ec-ab6b-f686f1728580
2022-04-22 6:52:32 0 [Note] WSREP: Flow-control interval: [16, 16]
2022-04-22 6:52:32 0 [Note] WSREP: Restored state OPEN -> JOINED (253)
2022-04-22 6:52:32 0 [Note] WSREP: Member 0.0 (onap-policy-mariadb-0) synced with group.
2022-04-22 6:52:32 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 253)
2022-04-22 6:52:32 2 [Note] WSREP: Starting applier thread 2
2022-04-22 6:52:32 2 [Note] WSREP: ####### processing CC 253, local, ordered
2022-04-22 6:52:32 2 [Note] WSREP: Process first view: f3997baa-c1f9-11ec-ab6b-f686f1728580 my uuid: c8af93bd-c208-11ec-ad76-b60bf2b47f0b
2022-04-22 6:52:32 2 [Note] WSREP: Server onap-policy-mariadb-0 connected to cluster at position f3997baa-c1f9-11ec-ab6b-f686f1728580:253 with ID c8af93bd-c208-11ec-ad76-b60bf2b47f0b
2022-04-22 6:52:32 2 [Note] WSREP: Server status change disconnected -> connected
2022-04-22 6:52:32 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-22 6:52:32 2 [Note] WSREP: ####### My UUID: c8af93bd-c208-11ec-ad76-b60bf2b47f0b
2022-04-22 6:52:32 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: no
2022-04-22 6:52:32 0 [Note] WSREP: Service thread queue flushed.
2022-04-22 6:52:32 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1
2022-04-22 6:52:32 2 [Note] WSREP: REPL Protocols: 10 (5)
2022-04-22 6:52:32 2 [Note] WSREP: ####### Adjusting cert position: -1 -> 253
2022-04-22 6:52:32 0 [Note] WSREP: Service thread queue flushed.
2022-04-22 6:52:32 2 [Note] WSREP: ================================================
View:
id: f3997baa-c1f9-11ec-ab6b-f686f1728580:253
status: primary
protocol_version: 4
capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
final: no
own_index: 0
members(1):
0: c8af93bd-c208-11ec-ad76-b60bf2b47f0b, onap-policy-mariadb-0
=================================================
2022-04-22 6:52:32 2 [Note] WSREP: Server status change connected -> joiner
2022-04-22 6:52:32 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-22 6:52:32 2 [Note] WSREP: Server status change joiner -> initializing
2022-04-22 6:52:32 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-22 6:52:32 0 [Warning] The parameter innodb_file_format is deprecated and has no effect. It may be removed in future releases. See https://mariadb.com/kb/en/library/xtradbinnodb-file-format/
2022-04-22 6:52:32 0 [Warning] The parameter innodb_log_files_in_group is deprecated and has no effect.
2022-04-22 6:52:32 0 [Note] InnoDB: Using Linux native AIO
2022-04-22 6:52:32 0 [Note] InnoDB: Uses event mutexes
2022-04-22 6:52:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-04-22 6:52:32 0 [Note] InnoDB: Number of pools: 1
2022-04-22 6:52:32 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-04-22 6:52:32 0 [Note] mysqld: O_TMPFILE is not supported on /opt/bitnami/mariadb/tmp (disabling future attempts)
2022-04-22 6:52:32 0 [Note] InnoDB: Initializing buffer pool, total size = 2147483648, chunk size = 134217728
2022-04-22 6:52:32 0 [Note] InnoDB: Completed initialization of buffer pool
2022-04-22 6:52:32 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-04-22 6:52:33 0 [Note] InnoDB: 128 rollback segments are active.
2022-04-22 6:52:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-04-22 6:52:33 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-04-22 6:52:39 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-04-22 6:52:39 0 [Note] InnoDB: 10.5.8 started; log sequence number 332619; transaction id 629
2022-04-22 6:52:39 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-04-22 6:52:39 0 [Note] InnoDB: Loading buffer pool(s) from /bitnami/mariadb/data/ib_buffer_pool
/opt/bitnami/mariadb/sbin/mysqld, Version: 10.5.8-MariaDB-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /opt/bitnami/mariadb/tmp/mysql.sock
Time Id Command Argument
2022-04-22 6:52:39 0 [Note] Server socket created on IP: '0.0.0.0'.
2022-04-22 6:52:39 0 [Warning] 'proxies_priv' entry '@% root@onap-policy-mariadb-0' ignored in --skip-name-resolve mode.
2022-04-22 6:52:39 0 [Note] WSREP: wsrep_init_schema_and_SR 0x0
2022-04-22 6:52:39 0 [Note] WSREP: Server initialized
2022-04-22 6:52:39 0 [Note] WSREP: Server status change initializing -> initialized
2022-04-22 6:52:39 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-22 6:52:39 2 [Note] WSREP: Bootstrapping a new cluster, setting initial position to 00000000-0000-0000-0000-000000000000:-1
2022-04-22 6:52:39 7 [Note] WSREP: Starting applier thread 7
2022-04-22 6:52:39 6 [Note] WSREP: Starting applier thread 6
2022-04-22 6:52:39 5 [Note] WSREP: Recovered cluster id f3997baa-c1f9-11ec-ab6b-f686f1728580
2022-04-22 6:52:39 0 [Note] Reading of all Master_info entries succeeded
2022-04-22 6:52:39 0 [Note] Added new Master_info '' to hash table
2022-04-22 6:52:39 0 [Note] /opt/bitnami/mariadb/sbin/mysqld: ready for connections.
Version: '10.5.8-MariaDB-log' socket: '/opt/bitnami/mariadb/tmp/mysql.sock' port: 3306 Source distribution
2022-04-22 6:52:39 2 [Note] WSREP: Server status change initialized -> joined
2022-04-22 6:52:39 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-22 6:52:39 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-22 6:52:39 10 [Note] WSREP: Starting applier thread 10
2022-04-22 6:52:39 2 [Note] WSREP: Lowest cert index boundary for CC from group: 253
2022-04-22 6:52:39 2 [Note] WSREP: Min available from gcache for CC from group: 1
2022-04-22 6:52:39 2 [Note] WSREP: Server onap-policy-mariadb-0 synced with group
2022-04-22 6:52:39 2 [Note] WSREP: Server status change joined -> synced
2022-04-22 6:52:39 2 [Note] WSREP: Synchronized with group, ready for connections
2022-04-22 6:52:39 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-22 6:52:39 0 [Note] InnoDB: Buffer pool(s) load completed at 220422 6:52:39
# Time: 220422 6:52:43
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 11 Schema: QC_hit: No
# Query_time: 0.003272 Lock_time: 0.003124 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610363;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 12 Schema: QC_hit: No
# Query_time: 0.006460 Lock_time: 0.006288 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610363;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 12 Schema: QC_hit: No
# Query_time: 0.002454 Lock_time: 0.002261 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610363;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 6:52:44
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 11 Schema: QC_hit: No
# Query_time: 0.398055 Lock_time: 0.397899 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610364;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 6:52:53
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 15 Schema: QC_hit: No
# Query_time: 0.004349 Lock_time: 0.004220 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610373;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 16 Schema: QC_hit: No
# Query_time: 0.004193 Lock_time: 0.004080 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610373;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 16 Schema: QC_hit: No
# Query_time: 0.004491 Lock_time: 0.004363 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610373;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 15 Schema: QC_hit: No
# Query_time: 0.007516 Lock_time: 0.007328 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610373;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 19 Schema: QC_hit: No
# Query_time: 0.000281 Lock_time: 0.000158 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610373;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 19 Schema: QC_hit: No
# Query_time: 0.000212 Lock_time: 0.000141 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610373;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 6:53:03
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 20 Schema: QC_hit: No
# Query_time: 0.000965 Lock_time: 0.000573 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610383;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 21 Schema: QC_hit: No
# Query_time: 0.000269 Lock_time: 0.000187 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610383;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 21 Schema: QC_hit: No
# Query_time: 0.000303 Lock_time: 0.000211 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610383;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 20 Schema: QC_hit: No
# Query_time: 0.000483 Lock_time: 0.000341 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610383;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 6:53:13
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 25 Schema: QC_hit: No
# Query_time: 0.000820 Lock_time: 0.000562 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610393;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 24 Schema: QC_hit: No
# Query_time: 0.000573 Lock_time: 0.000350 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610393;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 25 Schema: QC_hit: No
# Query_time: 0.013267 Lock_time: 0.012321 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610393;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 24 Schema: QC_hit: No
# Query_time: 0.000592 Lock_time: 0.000422 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610393;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 6:53:23
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 28 Schema: QC_hit: No
# Query_time: 0.008659 Lock_time: 0.008529 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610403;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 28 Schema: QC_hit: No
# Query_time: 0.000200 Lock_time: 0.000136 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610403;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 29 Schema: QC_hit: No
# Query_time: 0.000209 Lock_time: 0.000126 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610403;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 29 Schema: QC_hit: No
# Query_time: 0.000177 Lock_time: 0.000119 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610403;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220422 6:53:24
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 32 Schema: QC_hit: No
# Query_time: 0.000491 Lock_time: 0.000381 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610404;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 32 Schema: QC_hit: No
# Query_time: 0.000365 Lock_time: 0.000262 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610404;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 6:53:33
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 33 Schema: QC_hit: No
# Query_time: 0.000644 Lock_time: 0.000469 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610413;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 33 Schema: QC_hit: No
# Query_time: 0.000322 Lock_time: 0.000249 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610413;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 34 Schema: QC_hit: No
# Query_time: 0.000456 Lock_time: 0.000337 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610413;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220422 6:53:34
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 34 Schema: QC_hit: No
# Query_time: 0.566487 Lock_time: 0.565382 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610414;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 6:53:43
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 37 Schema: QC_hit: No
# Query_time: 0.000434 Lock_time: 0.000280 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610423;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 38 Schema: QC_hit: No
# Query_time: 0.004223 Lock_time: 0.004024 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610423;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 37 Schema: QC_hit: No
# Query_time: 0.000373 Lock_time: 0.000292 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610423;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 38 Schema: QC_hit: No
# Query_time: 0.000406 Lock_time: 0.000277 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610423;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 6:53:53
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 41 Schema: QC_hit: No
# Query_time: 0.003312 Lock_time: 0.003202 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610433;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 42 Schema: QC_hit: No
# Query_time: 0.000439 Lock_time: 0.000296 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610433;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 41 Schema: QC_hit: No
# Query_time: 0.001098 Lock_time: 0.000674 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610433;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 42 Schema: QC_hit: No
# Query_time: 0.000849 Lock_time: 0.000764 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610433;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 6:53:54
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 44 Schema: QC_hit: No
# Query_time: 0.000478 Lock_time: 0.000320 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610434;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 44 Schema: QC_hit: No
# Query_time: 0.000387 Lock_time: 0.000256 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610434;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 6:54:03
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 46 Schema: QC_hit: No
# Query_time: 0.000241 Lock_time: 0.000122 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610443;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 47 Schema: QC_hit: No
# Query_time: 0.002066 Lock_time: 0.001990 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610443;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 47 Schema: QC_hit: No
# Query_time: 0.000281 Lock_time: 0.000201 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610443;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 46 Schema: QC_hit: No
# Query_time: 0.000372 Lock_time: 0.000286 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610443;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 6:54:13
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 50 Schema: QC_hit: No
# Query_time: 0.000391 Lock_time: 0.000158 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610453;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 51 Schema: QC_hit: No
# Query_time: 0.002667 Lock_time: 0.001467 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610453;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 50 Schema: QC_hit: No
# Query_time: 0.000433 Lock_time: 0.000266 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610453;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 51 Schema: QC_hit: No
# Query_time: 0.000689 Lock_time: 0.000446 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610453;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 6:54:23
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 55 Schema: QC_hit: No
# Query_time: 0.000288 Lock_time: 0.000192 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610463;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 55 Schema: QC_hit: No
# Query_time: 0.000154 Lock_time: 0.000098 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610463;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 54 Schema: QC_hit: No
# Query_time: 0.002069 Lock_time: 0.002005 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610463;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 54 Schema: QC_hit: No
# Query_time: 0.000254 Lock_time: 0.000186 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610463;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 6:54:24
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 58 Schema: QC_hit: No
# Query_time: 0.000699 Lock_time: 0.000533 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610464;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 58 Schema: QC_hit: No
# Query_time: 0.000629 Lock_time: 0.000424 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610464;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 6:54:33
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 59 Schema: QC_hit: No
# Query_time: 0.000414 Lock_time: 0.000305 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610473;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 60 Schema: QC_hit: No
# Query_time: 0.000316 Lock_time: 0.000238 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610473;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 60 Schema: QC_hit: No
# Query_time: 0.000438 Lock_time: 0.000297 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610473;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 59 Schema: QC_hit: No
# Query_time: 0.000281 Lock_time: 0.000193 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610473;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 6:54:43
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 63 Schema: QC_hit: No
# Query_time: 0.000930 Lock_time: 0.000724 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610483;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 64 Schema: QC_hit: No
# Query_time: 0.000764 Lock_time: 0.000571 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610483;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 64 Schema: QC_hit: No
# Query_time: 0.005012 Lock_time: 0.004838 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610483;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 63 Schema: QC_hit: No
# Query_time: 0.006928 Lock_time: 0.006596 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610483;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 6:54:53
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 67 Schema: QC_hit: No
# Query_time: 0.000479 Lock_time: 0.000309 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610493;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 68 Schema: QC_hit: No
# Query_time: 0.012647 Lock_time: 0.012549 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610493;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 68 Schema: QC_hit: No
# Query_time: 0.008618 Lock_time: 0.008550 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610493;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 67 Schema: QC_hit: No
# Query_time: 0.000511 Lock_time: 0.000309 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610493;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 6:54:54
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 71 Schema: QC_hit: No
# Query_time: 0.000516 Lock_time: 0.000388 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610494;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 71 Schema: QC_hit: No
# Query_time: 0.000368 Lock_time: 0.000284 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610494;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 6:55:03
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 72 Schema: QC_hit: No
# Query_time: 0.000395 Lock_time: 0.000283 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610503;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 73 Schema: QC_hit: No
# Query_time: 0.000443 Lock_time: 0.000322 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610503;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 72 Schema: QC_hit: No
# Query_time: 0.000306 Lock_time: 0.000206 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610503;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 73 Schema: QC_hit: No
# Query_time: 0.000953 Lock_time: 0.000752 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610503;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 6:55:13
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 76 Schema: QC_hit: No
# Query_time: 0.007704 Lock_time: 0.007524 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610513;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 76 Schema: QC_hit: No
# Query_time: 0.000847 Lock_time: 0.000619 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610513;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 77 Schema: QC_hit: No
# Query_time: 0.013419 Lock_time: 0.006799 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650610513;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 77 Schema: QC_hit: No
# Query_time: 0.000322 Lock_time: 0.000262 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650610513;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;