ldirectord mysql "negotiate" patch

Todd Lyons tlyons at ivenue.com
Thu Jan 20 21:40:48 GMT 2005


sockmonk at gmail.com 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


More information about the lvs-users mailing list