diff options
-rw-r--r-- | issues/database-not-responding.gmi | 55 |
1 files changed, 55 insertions, 0 deletions
diff --git a/issues/database-not-responding.gmi b/issues/database-not-responding.gmi index f9ae8b2..f33ee89 100644 --- a/issues/database-not-responding.gmi +++ b/issues/database-not-responding.gmi @@ -218,3 +218,58 @@ Rows matched: 1 Changed: 1 Warnings: 0 ``` There must have been an update block. Best to do diagnostics when the system is blocking. + +# Connections + +``` +MariaDB [db_webqtl]> SHOW STATUS LIKE '%connect%'; ++-----------------------------------------------+-------+ +| Variable_name | Value | ++-----------------------------------------------+-------+ +| Aborted_connects | 0 | +| Connection_errors_accept | 0 | +| Connection_errors_internal | 0 | +| Connection_errors_max_connections | 0 | +| Connection_errors_peer_address | 0 | +| Connection_errors_select | 0 | +| Connection_errors_tcpwrap | 0 | +| Connections | 700 | +| Max_used_connections | 29 | +| Performance_schema_session_connect_attrs_lost | 0 | +| Slave_connections | 0 | +| Slaves_connected | 0 | +| Ssl_client_connects | 0 | +| Ssl_connect_renegotiates | 0 | +| Ssl_finished_connects | 0 | +| Threads_connected | 3 | +| wsrep_connected | OFF | ++-----------------------------------------------+-------+ +17 rows in set (0.001 sec) +``` + +``` +MariaDB [db_webqtl]> SHOW VARIABLES LIKE '%timeout%'; ++---------------------------------------+----------+ +| Variable_name | Value | ++---------------------------------------+----------+ +| connect_timeout | 10 | +| deadlock_timeout_long | 50000000 | +| deadlock_timeout_short | 10000 | +| delayed_insert_timeout | 300 | +| idle_readonly_transaction_timeout | 0 | +| idle_transaction_timeout | 0 | +| idle_write_transaction_timeout | 0 | +| innodb_flush_log_at_timeout | 1 | +| innodb_lock_wait_timeout | 50 | +| innodb_rollback_on_timeout | OFF | +| interactive_timeout | 28800 | +| lock_wait_timeout | 86400 | +| net_read_timeout | 30 | +| net_write_timeout | 60 | +| rpl_semi_sync_master_timeout | 10000 | +| rpl_semi_sync_slave_kill_conn_timeout | 5 | +| slave_net_timeout | 60 | +| thread_pool_idle_timeout | 60 | +| wait_timeout | 28800 | ++---------------------------------------+----------+ +``` |