Providing educational resources and monetary grants to IT professionals.

OpenSQLCamp Lightning Talk Videos

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 (we only had 3 video cameras, and 4 rooms, and 2 sessions were not recorded).

All the videos ...

Presentation: Drizzle is not MySQL with Changes by Brian Aker

Another video from the recent OpenSQLCamp in Portland, Oregon....Earlier today I uploaded the Lightning Talk Videos. Due to the holiday I am unsure when the rest of the videos will be ready. When they are, I will do one blog post featuring them all.

However, I have had several ...

Presentation: Drizzle is not MySQL with Changes by Brian Aker

Another video from the recent OpenSQLCamp in Portland, Oregon….Earlier today I uploaded the Lightning Talk Videos. Due to the holiday I am unsure when the rest of the videos will be ready. When they are, I will do one blog post featuring them all.
However, I have had several requests for this specific video, so here is Brian Aker speaking about Drizzle.
The slides are up at http://www.slideshare.net/brianaker/drizzle-opensql-camp, and here’s the video:

OpenSQLCamp Lightning Talk Videos

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 (we only had 3 video cameras, and 4 rooms, and 2 sessions were not recorded).
All the videos have been processed, and I am working on uploading them to YouTube and filling in details for the video descriptions. Not all the videos are up right now….right now all the lightning talks are up.

I am working on uploading the rest of the sessions, so look for them next week, though I may have one or two up very soon.

Free 10-day trial of Safari Books Online

That's right -- get your free 10-day trial! All the information I know is here:

http://bit.ly/37E9ld

But 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" ...

Free 10-day trial of Safari Books Online

That’s right — get your free 10-day trial! All the information I know is here:
http://bit.ly/37E9ld
But 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.
To sign up now: https://ssl.safaribooksonline.com/tryitfree
I was asked to send this information along, so I am…Now’s your chance to skim High Performance MySQL, among other high quality books!

Video: Building a MySQL Slave and Keeping it in Sync

Last night at the Boston MySQL User Group I presented on how to get a consistent snapshot to build a slave, how to 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 ...

Testing TokuDB – Faster and smaller for large tables

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 ...

Testing TokuDB – Faster and smaller for large tables

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, but here’s the table:
ActionInnoDBTokuDB
Importing ~40 million rows119 min 20.596 sec69 min 1.982 sec
INSERTing again, ~80 million rows total5 hours 13 min 52.58 sec56 min 44.56 sec
INSERTing again, ~160 million rows total20 hours 10 min 32.35 sec2 hours 2 min 11.95 sec
Size of table on disk42 Gb15 Gb
COUNT(*) query with GROUP BY58 min 10.11 sec5 min 3.21 sec
DELETE query2 hours 46 min 18.13 sec1 hour 14 min 57.75 sec
Size of table on disk42 Gb12 Gb
OPTIMIZE TABLE1 day 2 hours 19 min 21.96 sec21 min 4.41 sec
Size of table on disk41 Gb12 Gb
TRUNCATE TABLE1 min 0.13 sec0.27 sec
Size of table on disk41 Gb193 Mb (after waiting 60 seconds before doing an ls -l)
OPTIMIZE TABLE23.88 sec0.03 sec
Size of table on disk176 Kb193 Mb

Video: Building a MySQL Slave and Keeping it in Sync

Last night at the Boston MySQL User Group I presented on how to get a consistent snapshot to build a slave, how to 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 slides are online at http://technocation.org/files/doc/slave_sync.pdf.
The video can be watched on youtube at http://www.youtube.com/watch?v=Un0wqYKmbWY or directly in your browser with the embedded player below: