zembly update

We just finished pushing an update to the zembly production site, if you haven't been there in a while it is a good time to check it out as we have made major and minor improvements to the user experience so we would like to know what you think. 

Posted at 12:16PM Feb 14, 2009 by Christopher Webster in General  | 

MySQL 5.1 v 5.0

I recently had an opportunity to compare the performance of MySQL 5.1 v. 5.0. The daily performance test suite for zembly simulates the various loads that we see in our production environment, so our experiment was to change the JDBC connection pool in glassfish to point to an instance of MySQL 5.1 and run the tests.  Without any code changes, we saw a better than 25% improvement. Nice work guys!

We also use the MySQL enterprise monitor both in our testing and production environments. The 2.0 version has query analyzer which gives you the query statistics v. just telling you there are slow queries.  This functionality uses the MySQL proxy to aggregate the query information. There is a performance impact for this (we noticed this during our peformance testing scenarios), but we did some discover some queries which were running to often so it proved useful.

Posted at 04:07PM Feb 07, 2009 by Christopher Webster in General  |