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.
If we are observing more and more swapping in (ver frequent si in vmstat) then we could look at decreasing swappiness.
In order to play with the swappiness, you can temporarily set it by doing the following…
Bloggers are touching base with the technologies which they cherish most and coming back with some master strokes. This new cool edition of Log Buffer, the coolest blog carnival covering hottest topics encompass that home coming. Now Chill with Log Buffer #222!!!