Deployment Architecture

MySQL 5.3 connection issues

Langbost
Engager

Hello, experts. Recently i have met with CentOS 6.3 x64 server at my new office. On this server apache2, MySQL, postfix and apache protection on the base of mod_security installed, also there is Splunk on this server. And a couple of days ago MySQL started to experience some connection difficulties, it shows me connection errors sometimes, 'Can't connect to [local] MySQL server' and 'Too many connections' and so on. I have seen such errors on my local server, so i made all the same as i made earlier to fix it. Namely, set a larger value for a max_connections variable and check all connection settings and so on. Everything looks fine, all settings are alright and i am confused...can it be Splunk problem? Honestly, i have not worked with Splunk, so i do not know all its features. Maybe anyone knows?

0 Karma
1 Solution

AlfwineTrefield
Engager

Check whether the server is running on that host by executing telnet some_host 3306 and pressing the Enter key a couple of times. If there is a MySQL server running and listening to the port, you should get a response that includes the server's version number. If you get an error such as telnet: Unable to connect to remote host: Connection refused, then there is no server running on the given port.

Unfortunately this all what i found. Read also: https://answers.yahoo.com/question/index?qid=20140714042757AAqezy3
it might help

View solution in original post

AlfwineTrefield
Engager

Check whether the server is running on that host by executing telnet some_host 3306 and pressing the Enter key a couple of times. If there is a MySQL server running and listening to the port, you should get a response that includes the server's version number. If you get an error such as telnet: Unable to connect to remote host: Connection refused, then there is no server running on the given port.

Unfortunately this all what i found. Read also: https://answers.yahoo.com/question/index?qid=20140714042757AAqezy3
it might help

Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Matching cron expressions

This puzzle (first published here) is based on matching timestamps to cron expressions.All the timestamps ...

Why Splunk Customers Should Attend Cisco Live 2026 Las Vegas

Why Splunk Customers Should Attend Cisco Live 2026 Las Vegas     Cisco Live 2026 is almost here, and this ...

Data Management Digest – May 2026

Welcome to the May 2026 edition of Data Management Digest!   As your trusted partner in data innovation, the ...