[storm] Storm and MySQL in WSGI environment - MySQL server run away

[Steve Kieu]

Hi,

I use  MyISAM engine thus there is no transaction. In the action_* method it
call the Storm object whether to create new or get existing one from DB or
to do some thing like search, etc. In each Storm object the constructor just
create the object and call storm.flush() or commit() right away.

Yeas, I think I have to wrap all Storm object called from all action_* to
deal with that case.

.. which is a bit daunting task. I will try later to see if it is better

Many thanks :-)




> Where do your transactions begin and end?  In general, that is the
> level at which you want to check for disconnections (or serialisation
> failures and maybe integrity errors), since it represents the block of
> work that will need to be redone.
>
> If you are handling your transactions within the action_* methods,
> then that is probably where you want to add your error recovery.
>
> James.
>



-- 
Steve Kieu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/storm/attachments/20110126/15f4e89b/attachment.html>