Next test in my divide-and-conquer is to try postgresql. I installed postgresql and psycopg2. I had to touch up my models just a little bit... it's picky about having unique=True on all foreign keys that aren't primary keys, and I had to name my enums, and any select where code=52 (where code is a String(2)) needed to be forced to string to get code='52'...
And then I wrote a load tester in funkload, including a login and a few big database dump style requests... and it pegged the system's CPU for 20 minutes without an error. So it looks like either MySQL (mysql Ver 14.14 Distrib 5.5.31, for debian-linux-gnu (i686) using readline 6.2) on Ubuntu Server ( 3.5.0-34-generic #55~precise1-Ubuntu SMP Fri Jun 7 16:32:06 UTC 2013 i686 i686 i386 GNU/Linux) and python-mysqldb Version: 1.2.3-1ubuntu0.1 is some how buggy. -- You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/pylons-discuss. For more options, visit https://groups.google.com/groups/opt_out.
