Cache Hosts - Which are tempting max_connect_errors?

[Tuc at T-B-O-H.NET]

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 say
to just use --skip-cache-host .

Thanks, Tuc

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SELECT to return 0 instead of NULL?

[Tuc at T-B-O-H.NET]

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 change the SQL)

Thanks, Tuc

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

[Tuc at T-B-O-H.NET]

 
 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 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 change the SQL)
 
 
 
 SELECT IFNULL( SUM(AcctSessionTime),0) FROM radacct WHERE UserName='hotspot';

Exactly what I need, thanks...

I didn't see anything like that on the headers of :

http://dev.mysql.com/doc/refman/5.0/en/select.html

otherwise I wouldn't have asked. Thanks!

Tuc

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Connection time out/slow response from server

[Tuc at T-B-O-H.NET]

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 happening?
I'm using TCPWrappers to help control access to the database instead
of going to firewall rules. I'd rather not do this, defeats what
TCPWrappers was all about.

Thanks, Tuc

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

TCPWrappers and database unavailibility

[Tuc at T-B-O-H.NET]

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 responding
 Is there something I can do to prevent this from causing all the problems? 

Thanks, Tuc

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]