LVS
lvs-users
Google
 
Web LinuxVirtualServer.org

Re: ldirectord mysql "negotiate" patch

To: "LinuxVirtualServer.org users mailing list." <lvs-users@xxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: ldirectord mysql "negotiate" patch
From: Todd Lyons <tlyons@xxxxxxxxxx>
Date: Thu, 20 Jan 2005 13:40:48 -0800
sockmonk@xxxxxxxxx wanted us to know:

>If you want to test whether the server is still answering queries, why
>not use something like "SELECT 1" for the query. You should see the
>following benefits:
>* Independent of the particular database or table structure;
>* Should always return exactly one row;
>* That row should contain one field with the value "1" which you can
>also test for;
>* Requires minimal resources from the database server to execute and
>return the result.
>This seems to meet the stated requirements, although it does not test

I agree that this is the original line of thinking and as such the
select statement achieves the desired results, that something is
answering.
-- 
Regards...              Todd
They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety.       --Benjamin Franklin
Linux kernel 2.6.8.1-12mdkenterprise   2 users,  load average: 1.04, 1.09, 1.08

<Prev in Thread] Current Thread [Next in Thread>