Solved

MySQL going to sleep

Posted on 2016-08-29
4
80 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 35

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 78

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

Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

Question has a verified solution.

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

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
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…

752 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