ProxySQL

ClenUp

Borra los datos de las siguientes tablas:

1
2
3
4
5
SELECT * FROM stats_mysql_client_host_cache_reset;
SELECT * FROM stats_mysql_connection_pool_reset;
SELECT * FROM stats_mysql_errors_reset;
SELECT * FROM stats_mysql_query_digest_reset;
SELECT * FROM stats_proxysql_message_metrics_reset;

Conexiones

Estado general de cada MySQL server.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
SELECT hostgroup,
       SUBSTR(srv_host, 1, INSTR(srv_host, '.') - 1) AS instance,
       status,
       connused,
       connfree,
       connok,
       connerr,
       maxconnused,
       queries
FROM stats_mysql_connection_pool
ORDER BY srv_host;

Contadores

Es un contador de cualquier tipo de sentencia, también incluye media de rango de tiempos.

1
SELECT * FROM stats_mysql_commands_counters;

Errores

Registra cualquier query que genere algún error del lado de MySQL server.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
SELECT hostgroup,
       SUBSTR(hostname, 1, INSTR(hostname, '.') - 1) AS instance,
       client_address,
       username,
       schemaname,
       errno,
       count_star,
       from_unixtime(last_seen) AS last_seen,
       last_error
FROM stats_mysql_errors;

Ping

Constantemente está midiendo el tiempo de respuesta por cada uno de los MySQL server, lo hace para descartar aquellos que tardan mucho.

1
2
3
4
5
SELECT hostname,
       port,
       avg(ping_success_time_us) AS time_us
FROM monitor.mysql_server_ping_log
GROUP BY hostname, port;

Slow queries

Lista las 25 consultas más lentas.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
SELECT hostgroup,
       schemaname,
       username,
       digest,
       SUBSTR(digest_text,0,45),
       count_star,sum_time/count_star avg_time,
       min_time, max_time/1000000 AS max_time_secs,
       from_unixtime(first_seen) AS first_seen,
       from_unixtime(last_seen) AS last_seen
FROM stats_mysql_query_digest
WHERE digest_text LIKE 'SELECT%'
ORDER BY max_time DESC, digest
LIMIT 25;

Más ejecutadas

Lista las 25 consultas más frecuentes.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
SELECT digest, SUBSTR(digest_text,0,45),
       count_star,
       sum_time,
       from_unixtime(first_seen) AS first_seen,
       from_unixtime(last_seen) AS last_seen,
       username,
       hostgroup
FROM stats_mysql_query_digest
WHERE digest_text LIKE 'SELECT%'
ORDER BY count_star DESC
LIMIT 25;