File: mysql-status

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-- 8,823 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
Aborted_connects	0
Binlog_cache_disk_use	1
Binlog_cache_use	4
Binlog_stmt_cache_disk_use	0
Binlog_stmt_cache_use	1
Bytes_received	3254928
Bytes_sent	3284914
Com_admin_commands	2
Com_assign_to_keycache	0
Com_alter_db	0
Com_alter_db_upgrade	0
Com_alter_event	0
Com_alter_function	0
Com_alter_procedure	0
Com_alter_server	0
Com_alter_table	0
Com_alter_tablespace	0
Com_analyze	0
Com_begin	1
Com_binlog	0
Com_call_procedure	0
Com_change_db	2
Com_change_master	0
Com_check	0
Com_checksum	1
Com_commit	2
Com_create_db	2
Com_create_event	0
Com_create_function	3
Com_create_index	0
Com_create_procedure	3
Com_create_server	0
Com_create_table	19
Com_create_trigger	6
Com_create_udf	0
Com_create_user	0
Com_create_view	7
Com_dealloc_sql	0
Com_delete	0
Com_delete_multi	0
Com_do	0
Com_drop_db	1
Com_drop_event	0
Com_drop_function	0
Com_drop_index	0
Com_drop_procedure	0
Com_drop_server	0
Com_drop_table	1
Com_drop_trigger	0
Com_drop_user	0
Com_drop_view	0
Com_empty_query	0
Com_execute_sql	0
Com_flush	0
Com_grant	0
Com_ha_close	0
Com_ha_open	0
Com_ha_read	0
Com_help	0
Com_insert	1059
Com_insert_select	0
Com_install_plugin	0
Com_kill	0
Com_load	1
Com_lock_tables	0
Com_optimize	0
Com_preload_keys	0
Com_prepare_sql	0
Com_purge	0
Com_purge_before_date	0
Com_release_savepoint	0
Com_rename_table	0
Com_rename_user	0
Com_repair	0
Com_replace	0
Com_replace_select	0
Com_reset	0
Com_resignal	0
Com_revoke	0
Com_revoke_all	0
Com_rollback	1
Com_rollback_to_savepoint	0
Com_savepoint	0
Com_select	17
Com_set_option	12
Com_signal	0
Com_show_authors	0
Com_show_binlog_events	0
Com_show_binlogs	0
Com_show_charsets	0
Com_show_client_statistics	0
Com_show_collations	0
Com_show_contributors	0
Com_show_create_db	0
Com_show_create_event	0
Com_show_create_func	0
Com_show_create_proc	0
Com_show_create_table	0
Com_show_create_trigger	0
Com_show_databases	0
Com_show_engine_logs	0
Com_show_engine_mutex	0
Com_show_engine_status	1
Com_show_events	0
Com_show_errors	0
Com_show_fields	0
Com_show_function_status	0
Com_show_grants	0
Com_show_index_statistics	0
Com_show_keys	0
Com_show_master_status	0
Com_show_open_tables	0
Com_show_plugins	0
Com_show_privileges	0
Com_show_procedure_status	0
Com_show_processlist	0
Com_show_profile	0
Com_show_profiles	0
Com_show_relaylog_events	0
Com_show_slave_hosts	0
Com_show_slave_status	0
Com_show_slave_status_nolock	0
Com_show_status	1
Com_show_storage_engines	0
Com_show_table_statistics	0
Com_show_table_status	0
Com_show_tables	1
Com_show_temporary_tables	0
Com_show_thread_statistics	0
Com_show_triggers	0
Com_show_user_statistics	0
Com_show_variables	2
Com_show_warnings	0
Com_slave_start	0
Com_slave_stop	0
Com_stmt_close	0
Com_stmt_execute	0
Com_stmt_fetch	0
Com_stmt_prepare	0
Com_stmt_reprepare	0
Com_stmt_reset	0
Com_stmt_send_long_data	0
Com_truncate	0
Com_uninstall_plugin	0
Com_unlock_tables	0
Com_update	1
Com_update_multi	0
Com_xa_commit	0
Com_xa_end	0
Com_xa_prepare	0
Com_xa_recover	0
Com_xa_rollback	0
Com_xa_start	0
Compression	OFF
Connections	15
Created_tmp_disk_tables	0
Created_tmp_files	7
Created_tmp_tables	4
Delayed_errors	0
Delayed_insert_threads	0
Delayed_writes	0
Flashcache_enabled	OFF
Flush_commands	1
Handler_commit	141
Handler_delete	0
Handler_discover	0
Handler_prepare	122
Handler_read_first	19
Handler_read_key	16
Handler_read_last	0
Handler_read_next	0
Handler_read_prev	0
Handler_read_rnd	0
Handler_read_rnd_next	49487
Handler_rollback	15
Handler_savepoint	0
Handler_savepoint_rollback	0
Handler_update	6
Handler_write	47754
Innodb_adaptive_hash_cells	138337
Innodb_adaptive_hash_heap_buffers	6
Innodb_adaptive_hash_hash_searches	128675
Innodb_adaptive_hash_non_hash_searches	52783
Innodb_background_log_sync	35
Innodb_buffer_pool_pages_data	693
Innodb_buffer_pool_pages_dirty	0
Innodb_buffer_pool_pages_flushed	811
Innodb_buffer_pool_pages_LRU_flushed	0
Innodb_buffer_pool_pages_free	1347
Innodb_buffer_pool_pages_made_not_young	0
Innodb_buffer_pool_pages_made_young	0
Innodb_buffer_pool_pages_misc	7
Innodb_buffer_pool_pages_old	235
Innodb_buffer_pool_pages_total	2047
Innodb_buffer_pool_read_ahead_rnd	0
Innodb_buffer_pool_read_ahead	0
Innodb_buffer_pool_read_ahead_evicted	0
Innodb_buffer_pool_read_requests	441583
Innodb_buffer_pool_reads	0
Innodb_buffer_pool_wait_free	0
Innodb_buffer_pool_write_requests	234413
Innodb_checkpoint_age	0
Innodb_checkpoint_max_age	7782360
Innodb_checkpoint_target_age	7539162
Innodb_data_fsyncs	125
Innodb_data_pending_fsyncs	0
Innodb_data_pending_reads	0
Innodb_data_pending_writes	0
Innodb_data_read	0
Innodb_data_reads	0
Innodb_data_writes	955
Innodb_data_written	32364544
Innodb_dblwr_pages_written	637
Innodb_dblwr_writes	16
Innodb_deadlocks	0
Innodb_dict_tables	26
Innodb_have_atomic_builtins	ON
Innodb_history_list_length	0
Innodb_ibuf_discarded_delete_marks	0
Innodb_ibuf_discarded_deletes	0
Innodb_ibuf_discarded_inserts	0
Innodb_ibuf_free_list	0
Innodb_ibuf_merged_delete_marks	0
Innodb_ibuf_merged_deletes	0
Innodb_ibuf_merged_inserts	0
Innodb_ibuf_merges	0
Innodb_ibuf_segment_size	2
Innodb_ibuf_size	1
Innodb_log_waits	0
Innodb_log_write_requests	17776
Innodb_log_writes	66
Innodb_lsn_current	8603780
Innodb_lsn_flushed	8603780
Innodb_lsn_last_checkpoint	8603780
Innodb_master_thread_1_second_loops	32
Innodb_master_thread_10_second_loops	3
Innodb_master_thread_background_loops	4
Innodb_master_thread_main_flush_loops	4
Innodb_master_thread_sleeps	32
Innodb_max_trx_id	840
Innodb_mem_adaptive_hash	672196
Innodb_mem_dictionary	219018
Innodb_mem_total	34062336
Innodb_mutex_os_waits	4
Innodb_mutex_spin_rounds	222
Innodb_mutex_spin_waits	14
Innodb_oldest_view_low_limit_trx_id	768
Innodb_os_log_fsyncs	87
Innodb_os_log_pending_fsyncs	0
Innodb_os_log_pending_writes	0
Innodb_os_log_written	8628736
Innodb_page_size	16384
Innodb_pages_created	693
Innodb_pages_read	0
Innodb_pages_written	811
Innodb_purge_trx_id	0
Innodb_purge_undo_no	0
Innodb_row_lock_current_waits	0
Innodb_current_row_locks	0
Innodb_row_lock_time	0
Innodb_row_lock_time_avg	0
Innodb_row_lock_time_max	0
Innodb_row_lock_waits	0
Innodb_rows_deleted	0
Innodb_rows_inserted	46315
Innodb_rows_read	46274
Innodb_rows_updated	0
Innodb_s_lock_os_waits	24
Innodb_s_lock_spin_rounds	722
Innodb_s_lock_spin_waits	25
Innodb_truncated_status_writes	0
Innodb_x_lock_os_waits	8
Innodb_x_lock_spin_rounds	240
Innodb_x_lock_spin_waits	0
Key_blocks_not_flushed	0
Key_blocks_unused	14295
Key_blocks_used	202
Key_read_requests	28816
Key_reads	1
Key_write_requests	11127
Key_writes	212
Last_query_cost	0.000000
Max_used_connections	2
Not_flushed_delayed_rows	0
Open_files	54
Open_streams	0
Open_table_definitions	60
Open_tables	62
Opened_files	235
Opened_table_definitions	85
Opened_tables	94
Performance_schema_cond_classes_lost	0
Performance_schema_cond_instances_lost	0
Performance_schema_file_classes_lost	0
Performance_schema_file_handles_lost	0
Performance_schema_file_instances_lost	0
Performance_schema_locker_lost	0
Performance_schema_mutex_classes_lost	0
Performance_schema_mutex_instances_lost	0
Performance_schema_rwlock_classes_lost	0
Performance_schema_rwlock_instances_lost	0
Performance_schema_table_handles_lost	0
Performance_schema_table_instances_lost	0
Performance_schema_thread_classes_lost	0
Performance_schema_thread_instances_lost	0
Prepared_stmt_count	0
Qcache_free_blocks	0
Qcache_free_memory	0
Qcache_hits	0
Qcache_inserts	0
Qcache_lowmem_prunes	0
Qcache_not_cached	0
Qcache_queries_in_cache	0
Qcache_total_blocks	0
Queries	1158
Questions	158
Rpl_status	AUTH_MASTER
Select_full_join	0
Select_full_range_join	0
Select_range	0
Select_range_check	0
Select_scan	5
Slave_heartbeat_period	0.000
Slave_open_temp_tables	0
Slave_received_heartbeats	0
Slave_retried_transactions	0
Slave_running	OFF
Slow_launch_threads	0
Slow_queries	0
Sort_merge_passes	0
Sort_range	0
Sort_rows	0
Sort_scan	0
Ssl_accept_renegotiates	0
Ssl_accepts	0
Ssl_callback_cache_hits	0
Ssl_cipher	
Ssl_cipher_list	
Ssl_client_connects	0
Ssl_connect_renegotiates	0
Ssl_ctx_verify_depth	0
Ssl_ctx_verify_mode	0
Ssl_default_timeout	0
Ssl_finished_accepts	0
Ssl_finished_connects	0
Ssl_session_cache_hits	0
Ssl_session_cache_misses	0
Ssl_session_cache_mode	NONE
Ssl_session_cache_overflows	0
Ssl_session_cache_size	0
Ssl_session_cache_timeouts	0
Ssl_sessions_reused	0
Ssl_used_session_cache_entries	0
Ssl_verify_depth	0
Ssl_verify_mode	0
Ssl_version	
Table_locks_immediate	189
Table_locks_waited	0
Tc_log_max_pages_used	0
Tc_log_page_size	0
Tc_log_page_waits	0
Threads_cached	0
Threads_connected	2
Threads_created	14
Threads_running	2
Uptime	96
Uptime_since_flush_status	96
binlog_commits	5
binlog_group_commits	5
wsrep_cluster_conf_id	18446744073709551615
wsrep_cluster_size	0
wsrep_cluster_state_uuid	
wsrep_cluster_status	Disconnected
wsrep_connected	OFF
wsrep_local_index	4294967295
wsrep_provider_name	
wsrep_provider_vendor	
wsrep_provider_version	
wsrep_ready	ON