Latest Post

MySQL Partitioning and open_file_limit

We ran into an interesting problem recently and wanted to share the research. MySQL partitioning is a great way to improve performance in some circumstances, but it has a behavior that’s not widely noted. That is specifically with the MyISAM storage engine. MySQL seems to open two (2) file pointers for each table or partition [...]

Featured Post

How to - LIKE - use prepared statements

I was going to do the whole Valley Girl theme for this post, but decided that was lame. So while converting an internal application query into a user-input web query when I stumbled across a problem. My prepared statement was not throwing an error and not giving me results. It took me a while [...]

Asides

• Yes, I have finally succumbed to the pressure and I've created facebook pages for my online properties. Here is the FB page for spindomains.BIZ FB.init("23fccab4ac6ce299ba4c816bbcedf2bc");spindomains.BIZ on Facebook #
• Updated 2009-09-26 - Just reflecting on what a great conference this was. Very, very, informative. OSCON 2009 is "Open for Business" OSCON Is Underway Now more than ever, open source technology is the smart choice for navigating uncertain economic waters. In a competitive business environment, open source gives you the means to drive down costs while increasing system and staff efficiencies. OSCON 2009 is where you'll find the latest information and new ways to connect with the growing community that is open source. #
• A fast way to grow your skills The 7th annual MySQL Conference & Expo, co-presented by Sun Microsystems, MySQL and O'Reilly Media. Happening April 20-23, 2009 in Santa Clara, CA, at the Santa Clara Convention Center and Hyatt Regency Santa Clara, brings over 2,000 open source and database enthusiasts together to harness the power of MySQL and celebrate the huge MySQL ecosystem. All around the world, people just like you are innovating with MySQL—and MySQL is fueling the innovation engine by releasing new mission critical solutions to help you work smarter. This deeply technical conference brings all of that creativity, energy, and knowledge together in one place for four very full days. #
• USENIX / LISA 2008 Conference Xen tutorials were great and informative. VMWare tutorials were all marketing fluff and worthless. #