mySQL disconnects

[Bob Sneidar]

hmmm… interesting idea. That would certainly isolate whether or not the problem was one with sqlYoga, if I used Livecode API to do a time query. If it succeeds and an sqlYoga query times out, that would give me a vector on the problem. If a simple query fails using the LC API, then I would know it’s some kind of host connectivity issue. 

Thanks for the suggestion.

Bob


On Feb 2, 2014, at 11:45 , stephen barncard <stephenREVOLUTION2 at barncard.com> wrote:

> On Sun, Feb 2, 2014 at 11:34 AM, Bob Sneidar <bobsneidar at iotecdigital.com>wrote:
> 
>> What I need is a way to check for the availability of the database without
>> actually running a query. My gut feeling is that there is not without
>> invoking the dreaded 1 minute timeout, so the real question is, can I
>> adjust the amount of time Livecode will wait before giving up?
> 
> 
> have you tried some queries NOT using SQL yoga?
> 
> I thought most timing stuff was on the server side…
> 
> regarding a reliable 'ping':
> I know there are non-storage mySQL commands like time and calculations that
> would be very small blips… I assume you've tried those.
> 
> it's been a while since I did much mySQL work.. and I used Trevor's earlier
> 'abstraction layer' libraries that I needed to hack for my own purposes.
> 
> *--*
> *Stephen Barncard - San Francisco Ca. USA - Deeds Not Words*
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode