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 (410 lines) | stat: -rw-r--r-- 9,773 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
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
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	3315595
Bytes_sent	796598
Com_admin_commands	1
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	2
Com_alter_tablespace	0
Com_analyze	0
Com_begin	1
Com_binlog	0
Com_call_procedure	0
Com_change_db	59
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	2
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	326
Com_set_option	373
Com_signal	0
Com_show_authors	0
Com_show_binlog_events	0
Com_show_binlogs	11
Com_show_charsets	0
Com_show_client_statistics	0
Com_show_collations	0
Com_show_contributors	0
Com_show_create_db	3
Com_show_create_event	0
Com_show_create_func	3
Com_show_create_proc	3
Com_show_create_table	96
Com_show_create_trigger	6
Com_show_databases	13
Com_show_engine_logs	0
Com_show_engine_mutex	0
Com_show_engine_status	12
Com_show_events	0
Com_show_errors	0
Com_show_fields	48
Com_show_function_status	3
Com_show_grants	0
Com_show_index_statistics	0
Com_show_keys	0
Com_show_master_status	11
Com_show_open_tables	0
Com_show_plugins	11
Com_show_privileges	0
Com_show_procedure_status	3
Com_show_processlist	11
Com_show_profile	0
Com_show_profiles	0
Com_show_relaylog_events	0
Com_show_slave_hosts	0
Com_show_slave_status	11
Com_show_slave_status_nolock	0
Com_show_status	18
Com_show_storage_engines	0
Com_show_table_statistics	0
Com_show_table_status	48
Com_show_tables	7
Com_show_temporary_tables	0
Com_show_thread_statistics	0
Com_show_triggers	48
Com_show_user_statistics	0
Com_show_variables	12
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	202
Created_tmp_disk_tables	242
Created_tmp_files	7
Created_tmp_tables	976
Delayed_errors	0
Delayed_insert_threads	0
Delayed_writes	0
Flashcache_enabled	OFF
Flush_commands	3
Handler_commit	220
Handler_delete	0
Handler_discover	0
Handler_prepare	183
Handler_read_first	26
Handler_read_key	23
Handler_read_last	0
Handler_read_next	36
Handler_read_prev	0
Handler_read_rnd	0
Handler_read_rnd_next	61902
Handler_rollback	32
Handler_savepoint	0
Handler_savepoint_rollback	0
Handler_update	6
Handler_write	59905
Innodb_adaptive_hash_cells	138337
Innodb_adaptive_hash_heap_buffers	6
Innodb_adaptive_hash_hash_searches	129190
Innodb_adaptive_hash_non_hash_searches	53308
Innodb_background_log_sync	45
Innodb_buffer_pool_pages_data	708
Innodb_buffer_pool_pages_dirty	0
Innodb_buffer_pool_pages_flushed	916
Innodb_buffer_pool_pages_LRU_flushed	0
Innodb_buffer_pool_pages_free	1332
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	241
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	447048
Innodb_buffer_pool_reads	0
Innodb_buffer_pool_wait_free	0
Innodb_buffer_pool_write_requests	236593
Innodb_checkpoint_age	0
Innodb_checkpoint_max_age	7782360
Innodb_checkpoint_target_age	7539162
Innodb_data_fsyncs	131
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	1067
Innodb_data_written	36013056
Innodb_dblwr_pages_written	742
Innodb_dblwr_writes	17
Innodb_deadlocks	0
Innodb_dict_tables	27
Innodb_have_atomic_builtins	ON
Innodb_history_list_length	1
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	18226
Innodb_log_writes	70
Innodb_lsn_current	8809964
Innodb_lsn_flushed	8809964
Innodb_lsn_last_checkpoint	8809964
Innodb_master_thread_1_second_loops	42
Innodb_master_thread_10_second_loops	4
Innodb_master_thread_background_loops	3
Innodb_master_thread_main_flush_loops	3
Innodb_master_thread_sleeps	42
Innodb_max_trx_id	846
Innodb_mem_adaptive_hash	672196
Innodb_mem_dictionary	221035
Innodb_mem_total	34062336
Innodb_mutex_os_waits	6
Innodb_mutex_spin_rounds	271
Innodb_mutex_spin_waits	11
Innodb_oldest_view_low_limit_trx_id	825
Innodb_os_log_fsyncs	93
Innodb_os_log_pending_fsyncs	0
Innodb_os_log_pending_writes	0
Innodb_os_log_written	8836608
Innodb_page_size	16384
Innodb_pages_created	708
Innodb_pages_read	0
Innodb_pages_written	916
Innodb_purge_trx_id	824
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	47315
Innodb_rows_read	47274
Innodb_rows_updated	0
Innodb_s_lock_os_waits	24
Innodb_s_lock_spin_rounds	720
Innodb_s_lock_spin_waits	24
Innodb_truncated_status_writes	0
Innodb_x_lock_os_waits	9
Innodb_x_lock_spin_rounds	270
Innodb_x_lock_spin_waits	0
Key_blocks_not_flushed	0
Key_blocks_unused	14495
Key_blocks_used	2
Key_read_requests	47
Key_reads	1
Key_write_requests	12
Key_writes	12
Last_query_cost	0.000000
Max_used_connections	4
Not_flushed_delayed_rows	0
Open_files	51
Open_streams	0
Open_table_definitions	50
Open_tables	45
Opened_files	1349
Opened_table_definitions	107
Opened_tables	109
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	2450
Questions	1450
Rpl_status	AUTH_MASTER
Select_full_join	0
Select_full_range_join	0
Select_range	0
Select_range_check	0
Select_scan	243
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	2
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	214
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	4
Threads_created	201
Threads_running	1
Uptime	2511
Uptime_since_flush_status	2511
binlog_commits	5
binlog_group_commits	5
wsrep_local_state_uuid	968bdd7e-38cc-11e2-0800-a86d39553d83
wsrep_protocol_version	4
wsrep_last_committed	49
wsrep_replicated	49
wsrep_replicated_bytes	3372882
wsrep_received	11
wsrep_received_bytes	658
wsrep_local_commits	4
wsrep_local_cert_failures	0
wsrep_local_bf_aborts	0
wsrep_local_replays	0
wsrep_local_send_queue	0
wsrep_local_send_queue_avg	0.000000
wsrep_local_recv_queue	0
wsrep_local_recv_queue_avg	0.000000
wsrep_flow_control_paused	0.000000
wsrep_flow_control_sent	0
wsrep_flow_control_recv	0
wsrep_cert_deps_distance	1.000000
wsrep_apply_oooe	0.000000
wsrep_apply_oool	0.000000
wsrep_apply_window	0.000000
wsrep_commit_oooe	0.000000
wsrep_commit_oool	0.000000
wsrep_commit_window	0.000000
wsrep_local_state	4
wsrep_local_state_comment	Synced
wsrep_cert_index_size	73966
wsrep_causal_reads	0
wsrep_incoming_addresses	192.168.0.100,192.168.0.100,192.168.0.100
wsrep_cluster_conf_id	3
wsrep_cluster_size	3
wsrep_cluster_state_uuid	968bdd7e-38cc-11e2-0800-a86d39553d83
wsrep_cluster_status	Primary
wsrep_connected	ON
wsrep_local_index	0
wsrep_provider_name	Galera
wsrep_provider_vendor	Codership Oy <info@codership.com>
wsrep_provider_version	2.2(r137)
wsrep_ready	ON