• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 102
  • Last Modified:

MySQL going to sleep

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
jimmylew52
Asked:
jimmylew52
  • 2
2 Solutions
 
Dan CraciunIT ConsultantCommented:
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
 
arnoldCommented:
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
 
jimmylew52Author Commented:
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
 
jimmylew52Author Commented:
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now