pythontr.com
Öncelikle eş zamanlı olarak Connections, Threads_created, ve Max_used_connections verilerinin son haline ulaşalım.
Veritabanına bağlandıktan sonra aşağıdaki queryleri çalıştırarak bu sonuçlara ulaşabiliriz.
MariaDB > SHOW GLOBAL STATUS LIKE 'Connections'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | Connections | 1750 | +---------------+-------+ 1 row in set (0.00 sec) MariaDB > SHOW GLOBAL STATUS LIKE 'Threads_created'; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | Threads_created | 19 | +-----------------+-------+ 1 row in set (0.00 sec) MariaDB > SHOW GLOBAL STATUS LIKE 'Max_used_connections'; +----------------------+-------+ | Variable_name | Value | +----------------------+-------+ | Max_used_connections | 19 | +----------------------+-------+
Threads_created / Connections < 0.01 ( eğer sonuc 0.01 den küçük değilse thread_cache_size arttırmalısınız)
Ayrıca thread_cache_size > Max_used_connections dan büyük olmalıdır.
Thread cache hit oranı = 100 – ((Threads_created / Connections) * 100)
Kullanılan bağlantıların yüzdesi: processlist / max_connections
MariaDB > select (( pl.connections / gv.max_connections ) * 100) as percentage_used_connections from ( select count(*) as connections from information_schema.processlist ) as pl, ( select VARIABLE_VALUE as max_connections from information_schema.global_variables where variable_name = 'MAX_CONNECTIONS' ) as gv; +-----------------------------+ | percentage_used_connections | +-----------------------------+ | 13 | +-----------------------------+ 1 row in set (0.00 sec)
Yorumlar