Hi there,
I have a 5 server distributed poller solution. A dedicated machine for SQL and a dedicated machine for RRD.
However performance is poor and it looks like i have mysql issues.
MariaDB [(none)]> show status like ‘%onn%’;
±----------------------------------------------±-------+
| 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 | 159411 |
| Max_used_connections | 295 |
| 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 | 225 |
| wsrep_connected | OFF |
±----------------------------------------------±-------+
Is there anyway I can improve or stream line the amount of connections at all?