By type
[38;5;6mmariadb [38;5;5m08:11:55.47 [0m
[38;5;6mmariadb [38;5;5m08:11:55.49 [0m[1mWelcome to the Bitnami mariadb-galera container[0m
[38;5;6mmariadb [38;5;5m08:11:55.54 [0mSubscribe to project updates by watching [1mhttps://github.com/bitnami/bitnami-docker-mariadb-galera[0m
[38;5;6mmariadb [38;5;5m08:11:55.56 [0mSubmit issues and feature requests at [1mhttps://github.com/bitnami/bitnami-docker-mariadb-galera/issues[0m
[38;5;6mmariadb [38;5;5m08:11:55.60 [0m
[38;5;6mmariadb [38;5;5m08:11:55.63 [0m[38;5;2mINFO [0m ==> ** Starting MariaDB setup **
[38;5;6mmariadb [38;5;5m08:11:55.86 [0m[38;5;2mINFO [0m ==> Validating settings in MYSQL_*/MARIADB_* env vars
[38;5;6mmariadb [38;5;5m08:11:56.40 [0m[38;5;2mINFO [0m ==> Initializing mariadb database
[38;5;6mmariadb [38;5;5m08:11:56.42 [0m[38;5;5mDEBUG[0m ==> Ensuring expected directories/files exist
[38;5;6mmariadb [38;5;5m08:11:56.59 [0m[38;5;2mINFO [0m ==> Updating 'my.cnf' with custom configuration
[38;5;6mmariadb [38;5;5m08:11:56.71 [0m[38;5;2mINFO [0m ==> Setting user option
[38;5;6mmariadb [38;5;5m08:11:56.74 [0m[38;5;5mDEBUG[0m ==> Setting user to 'my-user' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m08:11:56.80 [0m[38;5;2mINFO [0m ==> Setting wsrep_node_name option
[38;5;6mmariadb [38;5;5m08:11:56.84 [0m[38;5;5mDEBUG[0m ==> Setting wsrep_node_name to 'onap-mariadb-galera-0' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m08:11:56.91 [0m[38;5;2mINFO [0m ==> Setting wsrep_node_address option
[38;5;6mmariadb [38;5;5m08:11:56.94 [0m[38;5;5mDEBUG[0m ==> Setting wsrep_node_address to '10.233.70.176' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m08:11:57.19 [0m[38;5;2mINFO [0m ==> Setting wsrep_cluster_address option
[38;5;6mmariadb [38;5;5m08:11:57.24 [0m[38;5;5mDEBUG[0m ==> Setting wsrep_cluster_address to 'gcomm://mariadb-galera-headless.onap.svc.cluster.local' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m08:11:57.33 [0m[38;5;2mINFO [0m ==> Setting wsrep_sst_auth option
[38;5;6mmariadb [38;5;5m08:11:57.38 [0m[38;5;5mDEBUG[0m ==> Setting wsrep_sst_auth to 'mariabackup:psw26pAr' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m08:11:57.45 [0m[38;5;2mINFO [0m ==> Persisted data detected. Restoring
[38;5;6mmariadb [38;5;5m08:11:57.65 [0m[38;5;2mINFO [0m ==> ** MariaDB setup finished! **
[38;5;6mmariadb [38;5;5m08:11:58.02 [0m[38;5;2mINFO [0m ==> ** Starting MariaDB **
[38;5;6mmariadb [38;5;5m08:11:58.09 [0m[38;5;2mINFO [0m ==> Setting previous boot
2022-04-22 8:11:58 0 [Warning] WSREP: option --wsrep-causal-reads is deprecated
2022-04-22 8:11:58 0 [Warning] WSREP: --wsrep-causal-reads=ON takes precedence over --wsrep-sync-wait=0. WSREP_SYNC_WAIT_BEFORE_READ is on
2022-04-22 8:11:58 0 [Note] /opt/bitnami/mariadb/sbin/mysqld (mysqld 10.5.8-MariaDB-log) starting as process 1 ...
2022-04-22 8:11:58 0 [Note] WSREP: Loading provider /opt/bitnami/mariadb/lib/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1
2022-04-22 8:11:58 0 [Note] WSREP: wsrep_load(): loading provider library '/opt/bitnami/mariadb/lib/libgalera_smm.so'
2022-04-22 8:11:58 0 [Note] WSREP: wsrep_load(): Galera 4.7(rXXXX) by Codership Oy loaded successfully.
2022-04-22 8:11:58 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration.
2022-04-22 8:11:58 0 [Note] WSREP: Found saved state: 79a2c454-c1f7-11ec-b91f-32bb980eeb29:3427, safe_to_bootstrap: 0
2022-04-22 8:11:58 0 [Note] WSREP: GCache DEBUG: opened preamble:
Version: 2
UUID: 79a2c454-c1f7-11ec-b91f-32bb980eeb29
Seqno: 3225 - 3427
Offset: 15220984
Synced: 1
2022-04-22 8:11:58 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 79a2c454-c1f7-11ec-b91f-32bb980eeb29, offset: 15220984
2022-04-22 8:11:58 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/134217752 bytes) complete.
2022-04-22 8:11:58 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (134217752/134217752 bytes) complete.
2022-04-22 8:11:58 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 3225-3427
2022-04-22 8:11:58 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/241488 bytes) complete.
2022-04-22 8:11:58 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (241488/241488 bytes) complete.
2022-04-22 8:11:58 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 2/205 locked buffers
2022-04-22 8:11:58 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): free space: 133976744/134217728
2022-04-22 8:11:58 0 [Note] WSREP: Passing config to GCS: base_dir = /bitnami/mariadb/data/; base_host = 10.233.70.176; 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;
2022-04-22 8:11:58 0 [Note] WSREP: Service thread queue flushed.
2022-04-22 8:11:58 0 [Note] WSREP: ####### Assign initial position for certification: 79a2c454-c1f7-11ec-b91f-32bb980eeb29:3427, protocol version: -1
2022-04-22 8:11:58 0 [Note] WSREP: Start replication
2022-04-22 8:11:58 0 [Note] WSREP: Connecting with bootstrap option: 0
2022-04-22 8:11:58 0 [Note] WSREP: Setting GCS initial position to 79a2c454-c1f7-11ec-b91f-32bb980eeb29:3427
2022-04-22 8:11:58 0 [Note] WSREP: protonet asio version 0
2022-04-22 8:11:58 0 [Note] WSREP: Using CRC-32C for message checksums.
2022-04-22 8:11:58 0 [Note] WSREP: backend: asio
2022-04-22 8:11:58 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2022-04-22 8:11:58 0 [Warning] WSREP: access file(/bitnami/mariadb/data//gvwstate.dat) failed(No such file or directory)
2022-04-22 8:11:58 0 [Note] WSREP: restore pc from disk failed
2022-04-22 8:11:58 0 [Note] WSREP: GMCast version 0
2022-04-22 8:11:58 0 [Note] WSREP: (e192abb0-a08d, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2022-04-22 8:11:58 0 [Note] WSREP: (e192abb0-a08d, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2022-04-22 8:11:58 0 [Note] WSREP: EVS version 1
2022-04-22 8:11:58 0 [Note] WSREP: gcomm: connecting to group 'galera', peer 'mariadb-galera-headless.onap.svc.cluster.local:'
2022-04-22 8:11:58 0 [Note] WSREP: (e192abb0-a08d, 'tcp://0.0.0.0:4567') connection established to afdf4d1e-aedb tcp://10.233.71.227:4567
2022-04-22 8:11:58 0 [Note] WSREP: (e192abb0-a08d, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.233.67.111:4567
2022-04-22 8:11:58 0 [Note] WSREP: (e192abb0-a08d, 'tcp://0.0.0.0:4567') connection established to 93d72713-b82f tcp://10.233.67.111:4567
2022-04-22 8:11:59 0 [Note] WSREP: EVS version upgrade 0 -> 1
2022-04-22 8:11:59 0 [Note] WSREP: declaring 93d72713-b82f at tcp://10.233.67.111:4567 stable
2022-04-22 8:11:59 0 [Note] WSREP: declaring afdf4d1e-aedb at tcp://10.233.71.227:4567 stable
2022-04-22 8:11:59 0 [Note] WSREP: PC protocol upgrade 0 -> 1
2022-04-22 8:11:59 0 [Note] WSREP: Node 93d72713-b82f state prim
2022-04-22 8:11:59 0 [Note] WSREP: view(view_id(PRIM,93d72713-b82f,32) memb {
93d72713-b82f,0
afdf4d1e-aedb,0
e192abb0-a08d,0
} joined {
} left {
} partitioned {
})
2022-04-22 8:11:59 0 [Note] WSREP: save pc into disk
2022-04-22 8:11:59 0 [Note] WSREP: gcomm: connected
2022-04-22 8:11:59 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2022-04-22 8:11:59 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2022-04-22 8:11:59 0 [Note] WSREP: Opened channel 'galera'
2022-04-22 8:11:59 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 2, memb_num = 3
2022-04-22 8:11:59 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
2022-04-22 8:11:59 0 [Note] WSREP: STATE EXCHANGE: sent state msg: e296f1be-c213-11ec-b407-6e1c7bdfe15c
2022-04-22 8:11:59 0 [Note] WSREP: STATE EXCHANGE: got state msg: e296f1be-c213-11ec-b407-6e1c7bdfe15c from 0 (onap-mariadb-galera-1)
2022-04-22 8:11:59 0 [Note] WSREP: STATE EXCHANGE: got state msg: e296f1be-c213-11ec-b407-6e1c7bdfe15c from 1 (onap-mariadb-galera-2)
2022-04-22 8:11:59 1 [Note] WSREP: Starting rollbacker thread 1
2022-04-22 8:11:59 2 [Note] WSREP: Starting applier thread 2
2022-04-22 8:11:59 0 [Note] WSREP: STATE EXCHANGE: got state msg: e296f1be-c213-11ec-b407-6e1c7bdfe15c from 2 (onap-mariadb-galera-0)
2022-04-22 8:11:59 0 [Note] WSREP: Quorum results:
version = 6,
component = PRIMARY,
conf_id = 30,
members = 2/3 (joined/total),
act_id = 3428,
last_appl. = 3365,
protocols = 2/10/4 (gcs/repl/appl),
vote policy= 0,
group UUID = 79a2c454-c1f7-11ec-b91f-32bb980eeb29
2022-04-22 8:11:59 0 [Note] WSREP: Flow-control interval: [28, 28]
2022-04-22 8:11:59 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 3429)
2022-04-22 8:11:59 2 [Note] WSREP: ####### processing CC 3429, local, ordered
2022-04-22 8:11:59 2 [Note] WSREP: Process first view: 79a2c454-c1f7-11ec-b91f-32bb980eeb29 my uuid: e192abb0-c213-11ec-a08d-9b60a51dc004
2022-04-22 8:11:59 2 [Note] WSREP: Server onap-mariadb-galera-0 connected to cluster at position 79a2c454-c1f7-11ec-b91f-32bb980eeb29:3429 with ID e192abb0-c213-11ec-a08d-9b60a51dc004
2022-04-22 8:11:59 2 [Note] WSREP: Server status change disconnected -> connected
2022-04-22 8:11:59 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-22 8:11:59 2 [Note] WSREP: ####### My UUID: e192abb0-c213-11ec-a08d-9b60a51dc004
2022-04-22 8:11:59 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes
2022-04-22 8:11:59 0 [Note] WSREP: Service thread queue flushed.
2022-04-22 8:11:59 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1
2022-04-22 8:11:59 2 [Note] WSREP: State transfer required:
Group state: 79a2c454-c1f7-11ec-b91f-32bb980eeb29:3429
Local state: 79a2c454-c1f7-11ec-b91f-32bb980eeb29:3427
2022-04-22 8:11:59 2 [Note] WSREP: Server status change connected -> joiner
2022-04-22 8:11:59 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-22 8:11:59 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address '10.233.70.176' --datadir '/bitnami/mariadb/data/' --defaults-file '/opt/bitnami/mariadb/conf/my.cnf' --parent '1' --binlog 'mysql-bin' --mysqld-args --defaults-file=/opt/bitnami/mariadb/conf/my.cnf --basedir=/opt/bitnami/mariadb --datadir=/bitnami/mariadb/data --socket=/opt/bitnami/mariadb/tmp/mysql.sock --pid-file=/opt/bitnami/mariadb/tmp/mysqld.pid'
2022-04-22 8:11:59 0 [Note] WSREP: Joiner monitor thread started to monitor
2022-04-22 8:12:02 0 [Note] WSREP: (e192abb0-a08d, 'tcp://0.0.0.0:4567') turning message relay requesting off
WSREP_SST: [INFO] Streaming with xbstream (20220422 08:12:03.995)
WSREP_SST: [INFO] Using socat as streamer (20220422 08:12:04.115)
WSREP_SST: [INFO] Evaluating timeout -k 310 300 socat -u TCP-LISTEN:4444,reuseaddr stdio | mbstream -x; RC=( ${PIPESTATUS[@]} ) (20220422 08:12:05.183)
2022-04-22 8:12:05 2 [Note] WSREP: Prepared SST request: mariabackup|10.233.70.176:4444/xtrabackup_sst//1
2022-04-22 8:12:05 2 [Note] WSREP: ####### IST uuid:79a2c454-c1f7-11ec-b91f-32bb980eeb29 f: 3428, l: 3429, STRv: 3
2022-04-22 8:12:05 2 [Note] WSREP: IST receiver addr using tcp://10.233.70.176:4568
2022-04-22 8:12:05 2 [Note] WSREP: Prepared IST receiver for 3428-3429, listening at: tcp://10.233.70.176:4568
2022-04-22 8:12:05 0 [Note] WSREP: Member 2.0 (onap-mariadb-galera-0) requested state transfer from '*any*'. Selected 1.0 (onap-mariadb-galera-2)(SYNCED) as donor.
2022-04-22 8:12:05 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 3429)
2022-04-22 8:12:05 2 [Note] WSREP: Requesting state transfer: success, donor: 1
2022-04-22 8:12:06 0 [Note] WSREP: 1.0 (onap-mariadb-galera-2): State transfer to 2.0 (onap-mariadb-galera-0) complete.
2022-04-22 8:12:06 0 [Note] WSREP: Member 1.0 (onap-mariadb-galera-2) synced with group.
WSREP_SST: [INFO] xtrabackup_ist received from donor: Running IST (20220422 08:12:06.194)
WSREP_SST: [INFO] Galera co-ords from recovery: 79a2c454-c1f7-11ec-b91f-32bb980eeb29:3427 0 (20220422 08:12:06.257)
WSREP_SST: [INFO] Total time on joiner: 0 seconds (20220422 08:12:06.324)
WSREP_SST: [INFO] Removing the sst_in_progress file (20220422 08:12:06.443)
2022-04-22 8:12:06 3 [Note] WSREP: SST received
2022-04-22 8:12:06 3 [Note] WSREP: Server status change joiner -> initializing
2022-04-22 8:12:06 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-22 8:12:06 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 8:12:06 0 [Warning] The parameter innodb_log_files_in_group is deprecated and has no effect.
2022-04-22 8:12:06 0 [Note] InnoDB: Using Linux native AIO
2022-04-22 8:12:06 0 [Note] InnoDB: Uses event mutexes
2022-04-22 8:12:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-04-22 8:12:06 0 [Note] InnoDB: Number of pools: 1
2022-04-22 8:12:06 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-04-22 8:12:06 0 [Note] mysqld: O_TMPFILE is not supported on /opt/bitnami/mariadb/tmp (disabling future attempts)
2022-04-22 8:12:06 0 [Note] InnoDB: Initializing buffer pool, total size = 2147483648, chunk size = 134217728
2022-04-22 8:12:07 0 [Note] InnoDB: Completed initialization of buffer pool
2022-04-22 8:12:07 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 8:12:07 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 134217728 bytes
2022-04-22 8:12:09 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2022-04-22 8:12:09 0 [Note] InnoDB: New log file created, LSN=40728482
2022-04-22 8:12:10 0 [Note] InnoDB: 128 rollback segments are active.
2022-04-22 8:12:15 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-04-22 8:12:15 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-04-22 8:12:37 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-04-22 8:12:37 0 [Note] InnoDB: 10.5.8 started; log sequence number 0; transaction id 11655
2022-04-22 8:12:37 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-04-22 8:12:37 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 8:12:38 0 [Note] Server socket created on IP: '0.0.0.0'.
2022-04-22 8:12:38 0 [Warning] 'proxies_priv' entry '@% root@onap-mariadb-galera-0' ignored in --skip-name-resolve mode.
2022-04-22 8:12:38 0 [Note] InnoDB: Buffer pool(s) load completed at 220422 8:12:38
2022-04-22 8:12:38 0 [Note] WSREP: wsrep_init_schema_and_SR 0x0
2022-04-22 8:12:38 0 [Note] WSREP: Server initialized
2022-04-22 8:12:38 0 [Note] WSREP: Server status change initializing -> initialized
2022-04-22 8:12:38 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-22 8:12:38 3 [Note] WSREP: Server status change initialized -> joined
2022-04-22 8:12:38 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-22 8:12:38 3 [Note] WSREP: Recovered position from storage: 79a2c454-c1f7-11ec-b91f-32bb980eeb29:3427
2022-04-22 8:12:38 6 [Note] WSREP: Starting applier thread 6
2022-04-22 8:12:38 8 [Note] WSREP: Starting applier thread 8
2022-04-22 8:12:38 7 [Note] WSREP: Starting applier thread 7
2022-04-22 8:12:38 3 [Note] WSREP: Recovered view from SST:
id: 79a2c454-c1f7-11ec-b91f-32bb980eeb29:3371
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: -1
members(3):
0: 93d72713-c1f7-11ec-b82f-27f6231b217e, onap-mariadb-galera-1
1: afdf4d1e-c1f7-11ec-aedb-fea69f2b5665, onap-mariadb-galera-2
2: b61bdf0e-c210-11ec-b7c5-86c071f63561, onap-mariadb-galera-0
2022-04-22 8:12:38 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-22 8:12:38 10 [Note] WSREP: Recovered cluster id 79a2c454-c1f7-11ec-b91f-32bb980eeb29
2022-04-22 8:12:38 3 [Note] WSREP: SST received: 79a2c454-c1f7-11ec-b91f-32bb980eeb29:3427
2022-04-22 8:12:38 2 [Note] WSREP: Installed new state from SST: 79a2c454-c1f7-11ec-b91f-32bb980eeb29:3427
2022-04-22 8:12:38 0 [Note] WSREP: Joiner monitor thread ended with total time 39 sec
2022-04-22 8:12:38 2 [Note] WSREP: Receiving IST: 2 writesets, seqnos 3428-3429
2022-04-22 8:12:38 0 [Note] Reading of all Master_info entries succeeded
2022-04-22 8:12:38 0 [Note] Added new Master_info '' to hash table
2022-04-22 8:12:38 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 8:12:38 0 [Note] WSREP: ####### IST applying starts with 3428
2022-04-22 8:12:38 0 [Note] WSREP: ####### IST current seqno initialized to 3366
2022-04-22 8:12:38 0 [Note] WSREP: Receiving IST... 0.0% ( 0/64 events) complete.
2022-04-22 8:12:38 0 [Note] WSREP: IST preload starting at 3366
2022-04-22 8:12:38 0 [Note] WSREP: Service thread queue flushed.
2022-04-22 8:12:38 0 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:3365, protocol version: 5
2022-04-22 8:12:38 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-04-22 8:12:38 0 [Note] WSREP: ####### Adjusting cert position: 3369 -> 3370
2022-04-22 8:12:38 0 [Note] WSREP: Service thread queue flushed.
2022-04-22 8:12:38 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 3366
2022-04-22 8:12:38 0 [Note] WSREP: Min available from gcache for CC from preload: 3225
2022-04-22 8:12:38 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-04-22 8:12:38 0 [Note] WSREP: ####### Adjusting cert position: 3370 -> 3371
2022-04-22 8:12:38 0 [Note] WSREP: Service thread queue flushed.
2022-04-22 8:12:38 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 3366
2022-04-22 8:12:38 0 [Note] WSREP: Min available from gcache for CC from preload: 3225
2022-04-22 8:12:38 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-04-22 8:12:38 0 [Note] WSREP: ####### Adjusting cert position: 3427 -> 3428
2022-04-22 8:12:38 0 [Note] WSREP: Service thread queue flushed.
2022-04-22 8:12:38 0 [Note] WSREP: Lowest cert index boundary for CC from ist: 3366
2022-04-22 8:12:38 0 [Note] WSREP: Min available from gcache for CC from ist: 3225
2022-04-22 8:12:38 6 [Note] WSREP: ================================================
View:
id: 79a2c454-c1f7-11ec-b91f-32bb980eeb29:3428
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: -1
members(2):
0: 93d72713-c1f7-11ec-b82f-27f6231b217e, onap-mariadb-galera-1
1: afdf4d1e-c1f7-11ec-aedb-fea69f2b5665, onap-mariadb-galera-2
=================================================
2022-04-22 8:12:38 6 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-22 8:12:38 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-04-22 8:12:38 0 [Note] WSREP: ####### Adjusting cert position: 3428 -> 3429
2022-04-22 8:12:38 0 [Note] WSREP: Service thread queue flushed.
2022-04-22 8:12:38 0 [Note] WSREP: Lowest cert index boundary for CC from ist: 3366
2022-04-22 8:12:38 0 [Note] WSREP: Min available from gcache for CC from ist: 3225
2022-04-22 8:12:38 0 [Note] WSREP: Receiving IST...100.0% (64/64 events) complete.
2022-04-22 8:12:38 8 [Note] WSREP: ================================================
View:
id: 79a2c454-c1f7-11ec-b91f-32bb980eeb29:3429
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: 2
members(3):
0: 93d72713-c1f7-11ec-b82f-27f6231b217e, onap-mariadb-galera-1
1: afdf4d1e-c1f7-11ec-aedb-fea69f2b5665, onap-mariadb-galera-2
2: e192abb0-c213-11ec-a08d-9b60a51dc004, onap-mariadb-galera-0
=================================================
2022-04-22 8:12:38 8 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-22 8:12:38 2 [Note] WSREP: Draining apply monitors after IST up to 3429
2022-04-22 8:12:38 2 [Note] WSREP: IST received: 79a2c454-c1f7-11ec-b91f-32bb980eeb29:3429
2022-04-22 8:12:38 2 [Note] WSREP: Lowest cert index boundary for CC from sst: 3366
2022-04-22 8:12:38 2 [Note] WSREP: Min available from gcache for CC from sst: 3225
2022-04-22 8:12:38 0 [Note] WSREP: 2.0 (onap-mariadb-galera-0): State transfer from 1.0 (onap-mariadb-galera-2) complete.
2022-04-22 8:12:38 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 3429)
2022-04-22 8:12:38 0 [Note] WSREP: Member 2.0 (onap-mariadb-galera-0) synced with group.
2022-04-22 8:12:38 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 3429)
2022-04-22 8:12:38 7 [Note] WSREP: Server onap-mariadb-galera-0 synced with group
2022-04-22 8:12:38 7 [Note] WSREP: Server status change joined -> synced
2022-04-22 8:12:38 7 [Note] WSREP: Synchronized with group, ready for connections
2022-04-22 8:12:38 7 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
# Time: 220422 8:12:47
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 12 Schema: QC_hit: No
# Query_time: 0.003121 Lock_time: 0.001938 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615167;
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: 13 Schema: QC_hit: No
# Query_time: 0.004636 Lock_time: 0.004095 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615167;
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: 13 Schema: QC_hit: No
# Query_time: 0.000268 Lock_time: 0.000178 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615167;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:12:48
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 12 Schema: QC_hit: No
# Query_time: 0.014187 Lock_time: 0.008916 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615168;
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.003909 Lock_time: 0.003641 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615168;
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: 15 Schema: QC_hit: No
# Query_time: 0.008420 Lock_time: 0.007816 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615168;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:12:57
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 16 Schema: QC_hit: No
# Query_time: 0.000369 Lock_time: 0.000225 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615177;
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: 17 Schema: QC_hit: No
# Query_time: 0.008380 Lock_time: 0.007025 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615177;
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.001480 Lock_time: 0.001331 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615177;
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: 17 Schema: QC_hit: No
# Query_time: 0.005736 Lock_time: 0.005341 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615177;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:13:07
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 20 Schema: QC_hit: No
# Query_time: 0.000544 Lock_time: 0.000388 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615187;
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.000712 Lock_time: 0.000607 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615187;
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.012472 Lock_time: 0.011935 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615187;
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.001394 Lock_time: 0.000883 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615187;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:13:17
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 25 Schema: QC_hit: No
# Query_time: 0.000828 Lock_time: 0.000542 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615197;
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.008355 Lock_time: 0.008007 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615197;
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.004504 Lock_time: 0.004009 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615197;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
2022-04-22 8:13:17 26 [Warning] Access denied for user 'so_user'@'10.233.70.89' (using password: YES)
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 25 Schema: QC_hit: No
# Query_time: 0.000898 Lock_time: 0.000605 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615197;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:13:18
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 29 Schema: QC_hit: No
# Query_time: 0.014680 Lock_time: 0.014128 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615198;
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: 29 Schema: QC_hit: No
# Query_time: 0.003150 Lock_time: 0.002505 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615198;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:13:27
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 30 Schema: QC_hit: No
# Query_time: 0.000623 Lock_time: 0.000483 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615207;
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: 31 Schema: QC_hit: No
# Query_time: 0.000751 Lock_time: 0.000686 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615207;
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: 31 Schema: QC_hit: No
# Query_time: 0.003029 Lock_time: 0.001969 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615207;
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: 30 Schema: QC_hit: No
# Query_time: 0.014929 Lock_time: 0.013792 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615207;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:13:37
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 35 Schema: QC_hit: No
# Query_time: 0.000448 Lock_time: 0.000295 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615217;
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: 35 Schema: QC_hit: No
# Query_time: 0.004100 Lock_time: 0.003580 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615217;
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.000445 Lock_time: 0.000340 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615217;
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.002045 Lock_time: 0.001974 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615217;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220422 8:13:47
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 38 Schema: QC_hit: No
# Query_time: 0.008866 Lock_time: 0.008149 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615227;
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: 39 Schema: QC_hit: No
# Query_time: 0.006404 Lock_time: 0.005943 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615227;
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: 39 Schema: QC_hit: No
# Query_time: 0.003600 Lock_time: 0.002870 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615227;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
2022-04-22 8:13:47 40 [Warning] Access denied for user 'so_user'@'10.233.69.169' (using password: YES)
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 38 Schema: QC_hit: No
# Query_time: 0.008875 Lock_time: 0.008283 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615227;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:13:48
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 42 Schema: QC_hit: No
# Query_time: 0.009439 Lock_time: 0.008854 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615228;
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.000365 Lock_time: 0.000248 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615228;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:13:57
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 44 Schema: QC_hit: No
# Query_time: 0.002845 Lock_time: 0.002277 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615237;
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: 45 Schema: QC_hit: No
# Query_time: 0.004873 Lock_time: 0.004756 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615237;
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.000630 Lock_time: 0.000457 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615237;
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: 45 Schema: QC_hit: No
# Query_time: 0.006053 Lock_time: 0.005944 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615237;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:14:07
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 48 Schema: QC_hit: No
# Query_time: 0.000361 Lock_time: 0.000227 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615247;
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: 49 Schema: QC_hit: No
# Query_time: 0.000785 Lock_time: 0.000572 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615247;
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: 49 Schema: QC_hit: No
# Query_time: 0.001398 Lock_time: 0.001263 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615247;
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: 48 Schema: QC_hit: No
# Query_time: 0.000414 Lock_time: 0.000252 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615247;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:14:17
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 53 Schema: QC_hit: No
# Query_time: 0.000628 Lock_time: 0.000438 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615257;
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: 52 Schema: QC_hit: No
# Query_time: 0.000462 Lock_time: 0.000191 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615257;
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: 53 Schema: QC_hit: No
# Query_time: 0.002669 Lock_time: 0.002549 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615257;
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: 52 Schema: QC_hit: No
# Query_time: 0.014313 Lock_time: 0.013868 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615257;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:14:18
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 56 Schema: QC_hit: No
# Query_time: 0.005638 Lock_time: 0.005486 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615258;
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: 56 Schema: QC_hit: No
# Query_time: 0.016271 Lock_time: 0.016122 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615258;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:14:27
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 57 Schema: QC_hit: No
# Query_time: 0.001319 Lock_time: 0.001093 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615267;
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.014833 Lock_time: 0.014618 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615267;
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.005400 Lock_time: 0.005085 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615267;
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: 57 Schema: QC_hit: No
# Query_time: 0.000993 Lock_time: 0.000803 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615267;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:14:37
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 61 Schema: QC_hit: No
# Query_time: 0.000833 Lock_time: 0.000580 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615277;
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: 62 Schema: QC_hit: No
# Query_time: 0.000838 Lock_time: 0.000466 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615277;
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: 62 Schema: QC_hit: No
# Query_time: 0.010066 Lock_time: 0.009699 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615277;
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: 61 Schema: QC_hit: No
# Query_time: 0.018841 Lock_time: 0.018691 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615277;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:14:47
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 66 Schema: QC_hit: No
# Query_time: 0.000332 Lock_time: 0.000210 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615287;
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: 65 Schema: QC_hit: No
# Query_time: 0.000632 Lock_time: 0.000544 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615287;
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: 65 Schema: QC_hit: No
# Query_time: 0.000456 Lock_time: 0.000352 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615287;
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: 66 Schema: QC_hit: No
# Query_time: 0.002142 Lock_time: 0.001910 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615287;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:14:48
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 69 Schema: QC_hit: No
# Query_time: 0.000295 Lock_time: 0.000180 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615288;
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: 69 Schema: QC_hit: No
# Query_time: 0.000384 Lock_time: 0.000296 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615288;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:14:57
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 71 Schema: QC_hit: No
# Query_time: 0.018364 Lock_time: 0.018172 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615297;
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: 70 Schema: QC_hit: No
# Query_time: 0.018793 Lock_time: 0.018603 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615297;
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.000249 Lock_time: 0.000190 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615297;
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: 70 Schema: QC_hit: No
# Query_time: 0.000626 Lock_time: 0.000433 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615297;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:15:07
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 75 Schema: QC_hit: No
# Query_time: 0.000534 Lock_time: 0.000330 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615307;
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: 75 Schema: QC_hit: No
# Query_time: 0.000500 Lock_time: 0.000401 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615307;
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: 74 Schema: QC_hit: No
# Query_time: 0.000738 Lock_time: 0.000508 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615307;
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: 74 Schema: QC_hit: No
# Query_time: 0.001559 Lock_time: 0.000900 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615307;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:15:17
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 78 Schema: QC_hit: No
# Query_time: 0.001625 Lock_time: 0.000994 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615317;
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: 78 Schema: QC_hit: No
# Query_time: 0.000725 Lock_time: 0.000644 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615317;
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: 79 Schema: QC_hit: No
# Query_time: 0.011874 Lock_time: 0.011363 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615317;
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: 79 Schema: QC_hit: No
# Query_time: 0.003771 Lock_time: 0.002887 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615317;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220422 8:15:18
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 82 Schema: QC_hit: No
# Query_time: 0.000420 Lock_time: 0.000319 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615318;
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: 82 Schema: QC_hit: No
# Query_time: 0.000279 Lock_time: 0.000213 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615318;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:15:27
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 83 Schema: QC_hit: No
# Query_time: 0.000404 Lock_time: 0.000290 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615327;
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: 84 Schema: QC_hit: No
# Query_time: 0.000474 Lock_time: 0.000413 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615327;
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: 84 Schema: QC_hit: No
# Query_time: 0.003309 Lock_time: 0.003100 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615327;
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: 83 Schema: QC_hit: No
# Query_time: 0.004297 Lock_time: 0.004216 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615327;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:15:37
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 88 Schema: QC_hit: No
# Query_time: 0.000440 Lock_time: 0.000270 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615337;
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: 87 Schema: QC_hit: No
# Query_time: 0.000509 Lock_time: 0.000364 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615337;
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: 87 Schema: QC_hit: No
# Query_time: 0.000827 Lock_time: 0.000438 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615337;
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: 88 Schema: QC_hit: No
# Query_time: 0.000743 Lock_time: 0.000458 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615337;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:15:47
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 91 Schema: QC_hit: No
# Query_time: 0.000891 Lock_time: 0.000755 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615347;
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: 92 Schema: QC_hit: No
# Query_time: 0.000511 Lock_time: 0.000416 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615347;
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: 92 Schema: QC_hit: No
# Query_time: 0.000622 Lock_time: 0.000399 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615347;
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: 91 Schema: QC_hit: No
# Query_time: 0.002746 Lock_time: 0.000921 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615347;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:15:48
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 95 Schema: QC_hit: No
# Query_time: 0.000451 Lock_time: 0.000230 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615348;
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: 95 Schema: QC_hit: No
# Query_time: 0.000300 Lock_time: 0.000232 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615348;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:15:57
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 96 Schema: QC_hit: No
# Query_time: 0.000471 Lock_time: 0.000333 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615357;
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: 96 Schema: QC_hit: No
# Query_time: 0.000271 Lock_time: 0.000186 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615357;
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: 97 Schema: QC_hit: No
# Query_time: 0.007398 Lock_time: 0.007274 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615357;
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: 97 Schema: QC_hit: No
# Query_time: 0.011881 Lock_time: 0.011718 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615357;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:16:07
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 100 Schema: QC_hit: No
# Query_time: 0.000340 Lock_time: 0.000220 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615367;
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: 101 Schema: QC_hit: No
# Query_time: 0.004882 Lock_time: 0.004799 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615367;
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: 101 Schema: QC_hit: No
# Query_time: 0.000996 Lock_time: 0.000931 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615367;
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: 100 Schema: QC_hit: No
# Query_time: 0.000458 Lock_time: 0.000286 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615367;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:16:17
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 105 Schema: QC_hit: No
# Query_time: 0.004600 Lock_time: 0.004402 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615377;
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: 105 Schema: QC_hit: No
# Query_time: 0.000212 Lock_time: 0.000139 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615377;
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: 104 Schema: QC_hit: No
# Query_time: 0.019001 Lock_time: 0.018710 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615377;
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: 104 Schema: QC_hit: No
# Query_time: 0.000335 Lock_time: 0.000273 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615377;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220422 8:16:18
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 108 Schema: QC_hit: No
# Query_time: 0.000352 Lock_time: 0.000198 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615378;
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: 108 Schema: QC_hit: No
# Query_time: 0.000219 Lock_time: 0.000130 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615378;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:16:27
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 112 Schema: QC_hit: No
# Query_time: 0.003910 Lock_time: 0.003766 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615387;
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: 111 Schema: QC_hit: No
# Query_time: 0.000510 Lock_time: 0.000419 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615387;
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: 111 Schema: QC_hit: No
# Query_time: 0.000245 Lock_time: 0.000165 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615387;
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: 112 Schema: QC_hit: No
# Query_time: 0.000457 Lock_time: 0.000251 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615387;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:16:37
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 116 Schema: QC_hit: No
# Query_time: 0.014774 Lock_time: 0.014669 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615397;
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: 115 Schema: QC_hit: No
# Query_time: 0.000786 Lock_time: 0.000595 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615397;
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: 116 Schema: QC_hit: No
# Query_time: 0.001017 Lock_time: 0.000674 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615397;
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: 115 Schema: QC_hit: No
# Query_time: 0.001083 Lock_time: 0.000616 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615397;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:16:47
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 119 Schema: QC_hit: No
# Query_time: 0.000653 Lock_time: 0.000493 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615407;
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: 120 Schema: QC_hit: No
# Query_time: 0.000899 Lock_time: 0.000782 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615407;
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: 119 Schema: QC_hit: No
# Query_time: 0.000557 Lock_time: 0.000372 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615407;
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: 120 Schema: QC_hit: No
# Query_time: 0.000288 Lock_time: 0.000210 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615407;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:16:48
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 123 Schema: QC_hit: No
# Query_time: 0.000316 Lock_time: 0.000167 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615408;
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: 123 Schema: QC_hit: No
# Query_time: 0.000199 Lock_time: 0.000105 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615408;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:16:57
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 125 Schema: QC_hit: No
# Query_time: 0.000483 Lock_time: 0.000273 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615417;
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: 124 Schema: QC_hit: No
# Query_time: 0.001171 Lock_time: 0.000535 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615417;
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: 125 Schema: QC_hit: No
# Query_time: 0.000240 Lock_time: 0.000182 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615417;
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: 124 Schema: QC_hit: No
# Query_time: 0.008639 Lock_time: 0.008508 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615417;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:17:07
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 128 Schema: QC_hit: No
# Query_time: 0.000399 Lock_time: 0.000211 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615427;
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: 129 Schema: QC_hit: No
# Query_time: 0.008099 Lock_time: 0.008019 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615427;
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: 128 Schema: QC_hit: No
# Query_time: 0.000380 Lock_time: 0.000288 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615427;
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: 129 Schema: QC_hit: No
# Query_time: 0.001574 Lock_time: 0.001352 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615427;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:17:17
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 133 Schema: QC_hit: No
# Query_time: 0.004860 Lock_time: 0.004722 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615437;
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: 132 Schema: QC_hit: No
# Query_time: 0.000706 Lock_time: 0.000514 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615437;
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: 133 Schema: QC_hit: No
# Query_time: 0.000628 Lock_time: 0.000504 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615437;
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: 132 Schema: QC_hit: No
# Query_time: 0.002012 Lock_time: 0.001878 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615437;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:17:18
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 136 Schema: QC_hit: No
# Query_time: 0.000363 Lock_time: 0.000223 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615438;
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: 136 Schema: QC_hit: No
# Query_time: 0.001570 Lock_time: 0.001467 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615438;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:17:27
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 137 Schema: QC_hit: No
# Query_time: 0.000425 Lock_time: 0.000232 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615447;
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: 138 Schema: QC_hit: No
# Query_time: 0.000819 Lock_time: 0.000645 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615447;
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: 137 Schema: QC_hit: No
# Query_time: 0.020447 Lock_time: 0.019910 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615447;
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: 138 Schema: QC_hit: No
# Query_time: 0.000313 Lock_time: 0.000243 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615447;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:17:37
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 142 Schema: QC_hit: No
# Query_time: 0.000688 Lock_time: 0.000399 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615457;
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: 141 Schema: QC_hit: No
# Query_time: 0.003636 Lock_time: 0.003564 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615457;
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: 141 Schema: QC_hit: No
# Query_time: 0.001364 Lock_time: 0.001304 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615457;
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: 142 Schema: QC_hit: No
# Query_time: 0.007264 Lock_time: 0.007162 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615457;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:17:47
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 145 Schema: QC_hit: No
# Query_time: 0.007979 Lock_time: 0.007876 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615467;
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: 146 Schema: QC_hit: No
# Query_time: 0.000163 Lock_time: 0.000098 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615467;
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: 146 Schema: QC_hit: No
# Query_time: 0.000329 Lock_time: 0.000258 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615467;
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: 145 Schema: QC_hit: No
# Query_time: 0.001266 Lock_time: 0.001133 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615467;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:17:48
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 149 Schema: QC_hit: No
# Query_time: 0.000438 Lock_time: 0.000268 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615468;
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: 149 Schema: QC_hit: No
# Query_time: 0.000599 Lock_time: 0.000387 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615468;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:17:57
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 150 Schema: QC_hit: No
# Query_time: 0.000379 Lock_time: 0.000240 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615477;
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: 151 Schema: QC_hit: No
# Query_time: 0.000573 Lock_time: 0.000318 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615477;
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: 150 Schema: QC_hit: No
# Query_time: 0.000498 Lock_time: 0.000345 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615477;
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: 151 Schema: QC_hit: No
# Query_time: 0.000649 Lock_time: 0.000474 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615477;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:18:07
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 154 Schema: QC_hit: No
# Query_time: 0.000763 Lock_time: 0.000641 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615487;
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: 155 Schema: QC_hit: No
# Query_time: 0.000215 Lock_time: 0.000126 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615487;
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: 154 Schema: QC_hit: No
# Query_time: 0.000187 Lock_time: 0.000112 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615487;
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: 155 Schema: QC_hit: No
# Query_time: 0.000340 Lock_time: 0.000236 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615487;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:18:17
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 158 Schema: QC_hit: No
# Query_time: 0.000768 Lock_time: 0.000664 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615497;
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: 159 Schema: QC_hit: No
# Query_time: 0.005577 Lock_time: 0.005492 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615497;
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: 158 Schema: QC_hit: No
# Query_time: 0.007831 Lock_time: 0.004874 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615497;
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: 159 Schema: QC_hit: No
# Query_time: 0.000546 Lock_time: 0.000338 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615497;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:18:18
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 162 Schema: QC_hit: No
# Query_time: 0.000401 Lock_time: 0.000246 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615498;
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: 162 Schema: QC_hit: No
# Query_time: 0.000305 Lock_time: 0.000215 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615498;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
2022-04-22 8:18:21 163 [Warning] Access denied for user 'so_user'@'10.233.69.11' (using password: YES)
# Time: 220422 8:18:27
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 164 Schema: QC_hit: No
# Query_time: 0.000414 Lock_time: 0.000286 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615507;
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: 165 Schema: QC_hit: No
# Query_time: 0.000263 Lock_time: 0.000183 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615507;
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: 165 Schema: QC_hit: No
# Query_time: 0.010287 Lock_time: 0.010180 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615507;
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: 164 Schema: QC_hit: No
# Query_time: 0.013777 Lock_time: 0.013582 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615507;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:18:37
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 168 Schema: QC_hit: No
# Query_time: 0.014484 Lock_time: 0.014376 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615517;
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: 169 Schema: QC_hit: No
# Query_time: 0.015925 Lock_time: 0.015817 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615517;
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: 169 Schema: QC_hit: No
# Query_time: 0.004509 Lock_time: 0.004114 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615517;
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: 168 Schema: QC_hit: No
# Query_time: 0.001647 Lock_time: 0.001037 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615517;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:18:47
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 172 Schema: QC_hit: No
# Query_time: 0.005652 Lock_time: 0.005510 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615527;
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: 173 Schema: QC_hit: No
# Query_time: 0.002949 Lock_time: 0.002607 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615527;
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: 173 Schema: QC_hit: No
# Query_time: 0.002352 Lock_time: 0.001528 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615527;
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: 172 Schema: QC_hit: No
# Query_time: 0.004737 Lock_time: 0.004559 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615527;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:18:48
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 176 Schema: QC_hit: No
# Query_time: 0.006858 Lock_time: 0.006691 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615528;
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: 176 Schema: QC_hit: No
# Query_time: 0.001421 Lock_time: 0.000788 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615528;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220422 8:18:57
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 177 Schema: QC_hit: No
# Query_time: 0.007875 Lock_time: 0.007749 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615537;
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: 178 Schema: QC_hit: No
# Query_time: 0.000364 Lock_time: 0.000291 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650615537;
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: 177 Schema: QC_hit: No
# Query_time: 0.000375 Lock_time: 0.000185 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615537;
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: 178 Schema: QC_hit: No
# Query_time: 0.012272 Lock_time: 0.012108 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650615537;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;