[Catalyst] MySQL server has gone away

Oleg Pronin syber.rus at gmail.com
Fri Apr 27 23:10:43 GMT 2007


If you don't need transaction you don't use it. This is not we talking
about. To use transaction or not in every case is a high-level logic
decision

2007/4/27, Jeff Chimene <jchimene at gmail.com>:
>
> Oleg Pronin wrote:
> > One can say that it is a very rare situation. I can tell you that in
> > production environment (about 1.000.000 hits per day) it happens every
> > day several times. Some users just see an error, some lost their data.
> > This is just not always visible to you.
> The OP may find a requirement to incorporate a transaction model
> (explicit start txn/commit/rollback) to solve this problem in MySQL;
> which is what they'd have to do for Oracle or Postgres or Rdb. I'd hope
> that MySQL reports a transaction failure when the database connection
> evaporates. This would allow a retry on the failed transaction. However,
> it may be that the Catalyst Controller / View design/implementation is
> only what would ordinarily be flat file accesses that use SQL instead of
> keyed-access flat files. If that's the case, wrapping a transaction
> around each of these SQL prepare/execute pairs will be a substantial
> performance hit.
>
> _______________________________________________
> List: Catalyst at lists.rawmode.org
> Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
> Searchable archive:
> http://www.mail-archive.com/catalyst@lists.rawmode.org/
> Dev site: http://dev.catalyst.perl.org/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20070428/bd656=
0e2/attachment.htm


More information about the Catalyst mailing list