Cache Hosts - Which are tempting max_connect_errors?

Hi, Is there a way in 4.X or 5.0 to tell which hosts are running up the counter towards max_connect_errors? We'd like to be able to monitor this and act accordingly? I've seen that they suggest to set it to 9 in 13.5.5.2 FLUSH Syntax to avoid it. I'm just wondering why they didn't

Re: [mysql] Re: SELECT to return 0 instead of NULL?

> > On Fri, May 23, 2008 at 8:23 AM, Tuc at T-B-O-H.NET <[EMAIL PROTECTED]> wrote: > > Hi, > > > >I'm running a query : > > > > SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='hotspot'; > > > >But if the

SELECT to return 0 instead of NULL?

Hi, I'm running a query : SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='hotspot'; But if there aren't any rows in "radacct" for the UserName of "hotspot", it returns a NULL. Is there a way to change it to return 0 instead? (I can't change the application, but I can cha

Connection time out/slow response from server

Hi, Running 4.1.22 created from FreeBSD ports on FreeBSD 5.5 . I run under TCP Wrappers. Even if 1 foreign machine attempts to contact us on the tcp port, the database becomes incredibly sluggish or unresponsive at all. Is there something I can do to prevent this from h

TCPWrappers and database unavailibility

Hi, Running 4.1.22 created from FreeBSD ports on FreeBSD 5.5 . I run under TCP Wrappers. Even if 1 foreign machine attempts to contact us on the tcp port, the database becomes incredibly sluggish or unresponsive. phpmyadmin shows " MySQL said: #2003 - The server is not