File: mysql-status-defer

package info (click to toggle)
percona-toolkit 3.2.1-1
  • links: PTS, VCS
  • area: main
  • in suites: bookworm, bullseye, forky, sid, trixie
  • size: 68,916 kB
  • sloc: perl: 241,287; sql: 22,868; sh: 19,746; javascript: 6,799; makefile: 353; awk: 38; python: 30; sed: 1
file content (380 lines) | stat: -rw-r--r-- 9,863 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
Aborted_clients 0 0
Aborted_connects 0 0
Binlog_cache_disk_use 1 1
Binlog_cache_use 4 4
Binlog_stmt_cache_disk_use 0 0
Binlog_stmt_cache_use 1 1
Bytes_received 3254928 3257215
Bytes_sent 3284914 3309052
Com_admin_commands 2 2
Com_assign_to_keycache 0 0
Com_alter_db 0 0
Com_alter_db_upgrade 0 0
Com_alter_event 0 0
Com_alter_function 0 0
Com_alter_procedure 0 0
Com_alter_server 0 0
Com_alter_table 0 0
Com_alter_tablespace 0 0
Com_analyze 0 0
Com_begin 1 1
Com_binlog 0 0
Com_call_procedure 0 0
Com_change_db 2 2
Com_change_master 0 0
Com_check 0 0
Com_checksum 1 1
Com_commit 2 2
Com_create_db 2 2
Com_create_event 0 0
Com_create_function 3 3
Com_create_index 0 0
Com_create_procedure 3 3
Com_create_server 0 0
Com_create_table 19 19
Com_create_trigger 6 6
Com_create_udf 0 0
Com_create_user 0 0
Com_create_view 7 7
Com_dealloc_sql 0 0
Com_delete 0 0
Com_delete_multi 0 0
Com_do 0 0
Com_drop_db 1 1
Com_drop_event 0 0
Com_drop_function 0 0
Com_drop_index 0 0
Com_drop_procedure 0 0
Com_drop_server 0 0
Com_drop_table 1 1
Com_drop_trigger 0 0
Com_drop_user 0 0
Com_drop_view 0 0
Com_empty_query 0 0
Com_execute_sql 0 0
Com_flush 0 0
Com_grant 0 0
Com_ha_close 0 0
Com_ha_open 0 0
Com_ha_read 0 0
Com_help 0 0
Com_insert 1059 1059
Com_insert_select 0 0
Com_install_plugin 0 0
Com_kill 0 0
Com_load 1 1
Com_lock_tables 0 0
Com_optimize 0 0
Com_preload_keys 0 0
Com_prepare_sql 0 0
Com_purge 0 0
Com_purge_before_date 0 0
Com_release_savepoint 0 0
Com_rename_table 0 0
Com_rename_user 0 0
Com_repair 0 0
Com_replace 0 0
Com_replace_select 0 0
Com_reset 0 0
Com_resignal 0 0
Com_revoke 0 0
Com_revoke_all 0 0
Com_rollback 1 1
Com_rollback_to_savepoint 0 0
Com_savepoint 0 0
Com_select 17 36
Com_set_option 12 12
Com_signal 0 0
Com_show_authors 0 0
Com_show_binlog_events 0 0
Com_show_binlogs 0 1
Com_show_charsets 0 0
Com_show_client_statistics 0 0
Com_show_collations 0 0
Com_show_contributors 0 0
Com_show_create_db 0 0
Com_show_create_event 0 0
Com_show_create_func 0 0
Com_show_create_proc 0 0
Com_show_create_table 0 0
Com_show_create_trigger 0 0
Com_show_databases 0 1
Com_show_engine_logs 0 0
Com_show_engine_mutex 0 0
Com_show_engine_status 1 2
Com_show_events 0 0
Com_show_errors 0 0
Com_show_fields 0 0
Com_show_function_status 0 0
Com_show_grants 0 0
Com_show_index_statistics 0 0
Com_show_keys 0 0
Com_show_master_status 0 1
Com_show_open_tables 0 0
Com_show_plugins 0 1
Com_show_privileges 0 0
Com_show_procedure_status 0 0
Com_show_processlist 0 1
Com_show_profile 0 0
Com_show_profiles 0 0
Com_show_relaylog_events 0 0
Com_show_slave_hosts 0 0
Com_show_slave_status 0 1
Com_show_slave_status_nolock 0 0
Com_show_status 1 2
Com_show_storage_engines 0 0
Com_show_table_statistics 0 0
Com_show_table_status 0 0
Com_show_tables 1 1
Com_show_temporary_tables 0 0
Com_show_thread_statistics 0 0
Com_show_triggers 0 0
Com_show_user_statistics 0 0
Com_show_variables 2 2
Com_show_warnings 0 0
Com_slave_start 0 0
Com_slave_stop 0 0
Com_stmt_close 0 0
Com_stmt_execute 0 0
Com_stmt_fetch 0 0
Com_stmt_prepare 0 0
Com_stmt_reprepare 0 0
Com_stmt_reset 0 0
Com_stmt_send_long_data 0 0
Com_truncate 0 0
Com_uninstall_plugin 0 0
Com_unlock_tables 0 0
Com_update 1 1
Com_update_multi 0 0
Com_xa_commit 0 0
Com_xa_end 0 0
Com_xa_prepare 0 0
Com_xa_recover 0 0
Com_xa_rollback 0 0
Com_xa_start 0 0
Compression OFF OFF
Connections 15 29
Created_tmp_disk_tables 0 11
Created_tmp_files 7 7
Created_tmp_tables 4 73
Delayed_errors 0 0
Delayed_insert_threads 0 0
Delayed_writes 0 0
Flashcache_enabled OFF OFF
Flush_commands 1 1
Handler_commit 141 141
Handler_delete 0 0
Handler_discover 0 0
Handler_prepare 122 122
Handler_read_first 19 19
Handler_read_key 16 16
Handler_read_last 0 0
Handler_read_next 0 0
Handler_read_prev 0 0
Handler_read_rnd 0 0
Handler_read_rnd_next 49487 49926
Handler_rollback 15 15
Handler_savepoint 0 0
Handler_savepoint_rollback 0 0
Handler_update 6 6
Handler_write 47754 48186
Innodb_adaptive_hash_cells 138337 138337
Innodb_adaptive_hash_heap_buffers 6 6
Innodb_adaptive_hash_hash_searches 128675 128675
Innodb_adaptive_hash_non_hash_searches 52783 52783
Innodb_background_log_sync 35 35
Innodb_buffer_pool_pages_data 693 693
Innodb_buffer_pool_pages_dirty 0 0
Innodb_buffer_pool_pages_flushed 811 811
Innodb_buffer_pool_pages_LRU_flushed 0 0
Innodb_buffer_pool_pages_free 1347 1347
Innodb_buffer_pool_pages_made_not_young 0 0
Innodb_buffer_pool_pages_made_young 0 0
Innodb_buffer_pool_pages_misc 7 7
Innodb_buffer_pool_pages_old 235 235
Innodb_buffer_pool_pages_total 2047 2047
Innodb_buffer_pool_read_ahead_rnd 0 0
Innodb_buffer_pool_read_ahead 0 0
Innodb_buffer_pool_read_ahead_evicted 0 0
Innodb_buffer_pool_read_requests 441583 441583
Innodb_buffer_pool_reads 0 0
Innodb_buffer_pool_wait_free 0 0
Innodb_buffer_pool_write_requests 234413 234413
Innodb_checkpoint_age 0 0
Innodb_checkpoint_max_age 7782360 7782360
Innodb_checkpoint_target_age 7539162 7539162
Innodb_data_fsyncs 125 125
Innodb_data_pending_fsyncs 0 0
Innodb_data_pending_reads 0 0
Innodb_data_pending_writes 0 0
Innodb_data_read 0 0
Innodb_data_reads 0 0
Innodb_data_writes 955 955
Innodb_data_written 32364544 32364544
Innodb_dblwr_pages_written 637 637
Innodb_dblwr_writes 16 16
Innodb_deadlocks 0 0
Innodb_dict_tables 26 26
Innodb_have_atomic_builtins ON ON
Innodb_history_list_length 0 0
Innodb_ibuf_discarded_delete_marks 0 0
Innodb_ibuf_discarded_deletes 0 0
Innodb_ibuf_discarded_inserts 0 0
Innodb_ibuf_free_list 0 0
Innodb_ibuf_merged_delete_marks 0 0
Innodb_ibuf_merged_deletes 0 0
Innodb_ibuf_merged_inserts 0 0
Innodb_ibuf_merges 0 0
Innodb_ibuf_segment_size 2 2
Innodb_ibuf_size 1 1
Innodb_log_waits 0 0
Innodb_log_write_requests 17776 17776
Innodb_log_writes 66 66
Innodb_lsn_current 8603780 8603780
Innodb_lsn_flushed 8603780 8603780
Innodb_lsn_last_checkpoint 8603780 8603780
Innodb_master_thread_1_second_loops 32 32
Innodb_master_thread_10_second_loops 3 3
Innodb_master_thread_background_loops 4 4
Innodb_master_thread_main_flush_loops 4 4
Innodb_master_thread_sleeps 32 32
Innodb_max_trx_id 840 840
Innodb_mem_adaptive_hash 672196 672196
Innodb_mem_dictionary 219018 219018
Innodb_mem_total 34062336 34062336
Innodb_mutex_os_waits 4 4
Innodb_mutex_spin_rounds 222 222
Innodb_mutex_spin_waits 14 14
Innodb_oldest_view_low_limit_trx_id 768 768
Innodb_os_log_fsyncs 87 87
Innodb_os_log_pending_fsyncs 0 0
Innodb_os_log_pending_writes 0 0
Innodb_os_log_written 8628736 8628736
Innodb_page_size 16384 16384
Innodb_pages_created 693 693
Innodb_pages_read 0 0
Innodb_pages_written 811 811
Innodb_purge_trx_id 0 0
Innodb_purge_undo_no 0 0
Innodb_row_lock_current_waits 0 0
Innodb_current_row_locks 0 0
Innodb_row_lock_time 0 0
Innodb_row_lock_time_avg 0 0
Innodb_row_lock_time_max 0 0
Innodb_row_lock_waits 0 0
Innodb_rows_deleted 0 0
Innodb_rows_inserted 46315 46315
Innodb_rows_read 46274 46274
Innodb_rows_updated 0 0
Innodb_s_lock_os_waits 24 24
Innodb_s_lock_spin_rounds 722 722
Innodb_s_lock_spin_waits 25 25
Innodb_truncated_status_writes 0 0
Innodb_x_lock_os_waits 8 8
Innodb_x_lock_spin_rounds 240 240
Innodb_x_lock_spin_waits 0 0
Key_blocks_not_flushed 0 0
Key_blocks_unused 14295 14295
Key_blocks_used 202 202
Key_read_requests 28816 28816
Key_reads 1 1
Key_write_requests 11127 11127
Key_writes 212 212
Last_query_cost 0.000000 0.000000
Max_used_connections 2 2
Not_flushed_delayed_rows 0 0
Open_files 54 54
Open_streams 0 0
Open_table_definitions 60 60
Open_tables 62 62
Opened_files 235 284
Opened_table_definitions 85 85
Opened_tables 94 94
Performance_schema_cond_classes_lost 0 0
Performance_schema_cond_instances_lost 0 0
Performance_schema_file_classes_lost 0 0
Performance_schema_file_handles_lost 0 0
Performance_schema_file_instances_lost 0 0
Performance_schema_locker_lost 0 0
Performance_schema_mutex_classes_lost 0 0
Performance_schema_mutex_instances_lost 0 0
Performance_schema_rwlock_classes_lost 0 0
Performance_schema_rwlock_instances_lost 0 0
Performance_schema_table_handles_lost 0 0
Performance_schema_table_instances_lost 0 0
Performance_schema_thread_classes_lost 0 0
Performance_schema_thread_instances_lost 0 0
Prepared_stmt_count 0 0
Qcache_free_blocks 0 0
Qcache_free_memory 0 0
Qcache_hits 0 0
Qcache_inserts 0 0
Qcache_lowmem_prunes 0 0
Qcache_not_cached 0 0
Qcache_queries_in_cache 0 0
Qcache_total_blocks 0 0
Queries 1158 1200
Questions 158 200
Rpl_status AUTH_MASTER AUTH_MASTER
Select_full_join 0 0
Select_full_range_join 0 0
Select_range 0 0
Select_range_check 0 0
Select_scan 5 10
Slave_heartbeat_period 0.000 0.000
Slave_open_temp_tables 0 0
Slave_received_heartbeats 0 0
Slave_retried_transactions 0 0
Slave_running OFF OFF
Slow_launch_threads 0 0
Slow_queries 0 0
Sort_merge_passes 0 0
Sort_range 0 0
Sort_rows 0 0
Sort_scan 0 0
Ssl_accept_renegotiates 0 0
Ssl_accepts 0 0
Ssl_callback_cache_hits 0 0
Ssl_cipher  
Ssl_cipher_list  
Ssl_client_connects 0 0
Ssl_connect_renegotiates 0 0
Ssl_ctx_verify_depth 0 0
Ssl_ctx_verify_mode 0 0
Ssl_default_timeout 0 0
Ssl_finished_accepts 0 0
Ssl_finished_connects 0 0
Ssl_session_cache_hits 0 0
Ssl_session_cache_misses 0 0
Ssl_session_cache_mode NONE NONE
Ssl_session_cache_overflows 0 0
Ssl_session_cache_size 0 0
Ssl_session_cache_timeouts 0 0
Ssl_sessions_reused 0 0
Ssl_used_session_cache_entries 0 0
Ssl_verify_depth 0 0
Ssl_verify_mode 0 0
Ssl_version  
Table_locks_immediate 189 190
Table_locks_waited 0 0
Tc_log_max_pages_used 0 0
Tc_log_page_size 0 0
Tc_log_page_waits 0 0
Threads_cached 0 0
Threads_connected 2 2
Threads_created 14 28
Threads_running 2 2
Uptime 96 107
Uptime_since_flush_status 96 107
binlog_commits 5 5
binlog_group_commits 5 5
wsrep_cluster_conf_id 18446744073709551615 18446744073709551615
wsrep_cluster_size 0 0
wsrep_cluster_state_uuid  
wsrep_cluster_status Disconnected Disconnected
wsrep_connected OFF OFF
wsrep_local_index 4294967295 4294967295
wsrep_provider_name  
wsrep_provider_vendor  
wsrep_provider_version  
wsrep_ready ON ON