Posts by Sheeri Cabral
According to the official lifecycle calendar, active support for MySQL 5.0 (including regular binary updates) will end on December 31st, 2009. Upgrading to MySQL 5.1 is not difficult, though it requires more steps than just upgrading the packages. There is a link to a post which walks you through the upgrade.I hope this helps folks out, and please feel free to ask any questions. Pythian is available to assist you in the upgrade process, just contact us if you want to engage our help.
OpenSQLCamp was a huge success! I took videos of most of the sessions. The links to the videos are in this post. Enjoy!
Another video from the recent OpenSQLCamp in Portland, Oregon. I have had several requests for this specific video, so here is Brian Aker speaking about Drizzle.
OpenSQLCamp was a huge success! Not many folks have blogged about what they learned there….if you missed it, all is not lost. We did take videos of most of the sessions. All the videos have been processed, and I am working on uploading them to YouTube and filling in details for the video descriptions.
That’s right — get your free 10-day trial! All the information I know is here. The basics are: No access to Rough Cuts or Downloads, for new subscribers only. It’s one of those “sign up and if you do not cancel after 10 days, we bill you” — and at $42.99 a month, that’s not a mistake you want to make. Must sign up by Nov. 24th.
For the past two months, I have been running tests on TokuDB in my free time. TokuDB is a storage engine put out by Tokutek. TokuDB uses fractal tree indexes instead of B-tree indexes to improve performance, which is dramatically noticeable when dealing with large tables (over 100 million rows). For those that like the information “above the fold”, here is a table with results from a test comparing InnoDB and TokuDB. All the steps are explained in the post below, if you want more details.
Last night at the Boston MySQL User Group I presented on how to get a consistent snapshot to build a slave, use mk-table-checksum to check for differences between masters and slaves on an ongoing basis, and how to use tools such as mk-table-sync and mysqldump to sync the data if there are any discrepancies. The links to the slides and video are here.
People often ask “what’s the best hardware to run a database on?” And the answer, of course, is “it depends”. With MySQL, though, you can get good performance out of almost any hardware. If you need *great* performance, and you have active databases with a large data set, here are some statistics on real life databases — feel free to add your own.
This presentation was done by Sheeri Cabral of The Pythian Group and went into how to use SHOW ENGINE INNODB STATUS to get more information about your Innodb tables, foreign keys and transactions. This is a great presentation to learn how InnoDB works.
This is a hack, but it is a good one. I was looking at some machines on a new client, and they had the general log turned on. I was surprised, because it was a fairly busy server, and they had had many problems with the server a few months ago. I thought perhaps they had turned on the general log to diagnose a problem and forgotten to turn it off, or something similar.