Solved

MySQL going to sleep

Posted on 2016-08-29
4
69 Views
Last Modified: 2016-08-30
Running MySQL as the database for FreeRADIUS on Debian 8.5.

After a few hours I am not able authenticate using EreeRADIUS. From what I have found the MySQL is going to sleep so authentication requests are not processed.

How do i prevent MySQL from going to sleep?
0
Comment
Question by:jimmylew52
  • 2
4 Comments
 
LVL 34

Accepted Solution

by:
Dan Craciun earned 250 total points
ID: 41775470
You mean you have many connections that are marked as "sleep" when running
show full processlist; ?

Quick fix: change max_connections in my.cnf, then restart MySQL.

Permanent fix: find out why FreeRADIUS does not properly closes connections.

HTH,
Dan
0
 
LVL 77

Assisted Solution

by:arnold
arnold earned 250 total points
ID: 41775709
You may have a misconfiguration other then what was pointed out by Dan, your Freeradius may be saturating either the connections, or requests it receives...... Thus not being responsive.

Merely increasing connection may simply extend the duration until you windup back where you currently are.
I.e. You may gave a limit of 20, raiding it 100 will not fix the underlying cause of your current situation.
0
 
LVL 1

Author Comment

by:jimmylew52
ID: 41776145
What I mean is, mysql quits responding to requests from Freeradius, I think. I do not know why. I know that I cannot authenticate using Freeradius after a few hours. I only have three users connecting so I have no idea why Freeradius would be filling up the connections.

Is Show process list run from inside MySQL? Sorry, I have worked very little with MySQL and have never had to do any troubleshooting.

The only thing that fixes the problem so far is to reboot the server.

If I restart MySQL service will that reset the connections?

I am not skilled with using MySQL and I am groping for answers.
0
 
LVL 1

Author Comment

by:jimmylew52
ID: 41776488
After digging some more i find that mysql is not even installed. I was mislead. I have a network interface problem and not a mysql problem.

Thanks for the replies.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Cassandra Select Query 1 55
Anything Suspicious in this Report Email on Linux Server 4 39
Backup & Restore 3 46
constraint check 2 16
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now