In this blog, i’m going to review a recent MySQL upgrade I have done on one of the systems I am involved in administering. This is a real world example of an upgrade project, and hopefully when we’re done, there may even be an overall performance boost.
There are many variates of mangoes and its hard to pick from them as they all are so sweet and eye catching. Same is the case with the database related blogs, when it comes to selection for the edition of Log Buffer. So once again here you are, about to savor the sweet blogs in Log Buffer #224.
In an interview with Startup 3.0, Pythian Founder, Paul Vallee tells the tale of how Pythian started and how he built his management team. He also talks candidly about what it takes to build a successful business, provides advice to budding entrepreneurs, and shares the latest Pythian news of being named one of Canada’s fastest-growing companies.
Thanks to Pythian’s philosophy of keeping their employees on the bleeding edge of technology, at the end of this month I’ll be crossing the American borders to join the YAPC::NA festivities. Am I thrilled? Ooooh heck yeah, I sure am. I looked at the list of talks and divided them into two groups, talks I want to see, and talks I really, want to see. Here is what my own personal schedule tentatively looks like:
Let us talk how OPTIMIZE partitions doesn’t work and what to do. I have set up a simple test instance with two tables, and use my stresstool (java), to fill the tables and play with the inserting threads.
Please join Pythian for our next series of live and recorded webinars and have the chance to ask questions directly of our DBA experts. If you miss a session, you can always check out select recorded webinars here
Social media is buzzing with the news and views of bloggers. From the database side of this glorious media, we have picked out some of the gems for you in this edition of Log Buffer, which is the Log Buffer #223.
For the second year in a row, Pythian is proud to be named to the prestigious Profit 200 Ranking of Canada’s Fastest Growing Companies. Pythian is also happy to announce the official opening of our Toronto, Canada office.
Using algorithm described in “Relational Database Index Design and the Optimizers by Tapio Lahdenmaki and Mike Leach”, I quickly came up with two indexes and while first one looked fine, I was really confused by the second one for the elimination of the sort. Let me show an example, not copy one from the book, but rather show a test I did with MySQL.
WordPress is a really cool open source tool for easy web design and blogging. Unfortunately, it has limitations related to the use of MyISAM as a storage engine. But, there is good news, Word Press Supports InnoDB! Here are some approaches to set this up for your environment.