-
Recent Posts
Recent Comments
Archives
- August 2017
- June 2015
- April 2015
- March 2015
- February 2015
- December 2014
- November 2014
- August 2014
- July 2014
- June 2014
- May 2014
- April 2014
- March 2014
- February 2014
- January 2014
- December 2013
- November 2013
- October 2013
- September 2013
- August 2013
- July 2013
- June 2013
- May 2013
- April 2013
- March 2013
- February 2013
- January 2013
- December 2012
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- February 2009
- January 2008
- October 2007
- August 2007
- July 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
Categories
Meta
Category Archives: Learning
OurSQL Episode 184: Digging Through the Tool Chest
This week we discuss more Percona tools: pt-online-schema-change and pt-slave-find. Ear Candy is using the CONNECT storage engine to read GPX files, and At the Movies is Performance at Scale with TokuDB.
Events
DB Hangops – every other Wednesay at noon… Continue reading
Posted in General, Learning, Performance, Podcasts
Comments Off on OurSQL Episode 184: Digging Through the Tool Chest
OurSQL Episode 183: Map Our Way Around
This week we discuss MySQL and Geographical Information Systems (GIS). Ear candy is how MVCC in InnoDB relates to undo logging and how you can write better queries based on this information. At the Movies is a demo of GIS.
MySQL and MariaDB geographic … Continue reading
OurSQL Episode 181: MariaDB Goodies
This week we discuss more features of MariaDB 10. Ear Candy is how to avoid downtime when switching to GTIDs and At the Movies is Managing Hundreds of MySQL Servers Efficiently.
News
MySQL Community Awards 2014: the Winners
MariaDB 10
MariaDB 10.0.1 fe… Continue reading
OurSQL Episode 179: MySQL’s Materialized Views
This week, we interviewed longtime community member and Percona principal support engineer Justin Swanhart about Flexviews, a tool for Materialized Views in MySQL. Ear Candy is about the EXPLAIN analyzer, and At the Movies is about “Advanced MySQL Repl… Continue reading
OurSQL Episode 177: Artistic License
This week, we sat down with Luis Villa about non-software licenses. Ear Candy is and At the Movies is Sheeri talking about Percona Replication Manager at the Boston MySQL User Group a few years ago.
Non-software Licenses
Luis Villa’s Wikipedia page.
Ba… Continue reading
OurSQL Episode 176: Replication Everywhere
This week we talk about replication features in MariaDB 10. Ear Candy is a gotcha about PIVOT tables in MariaDB, and At the Movies is about the viability of transactions.
Percona Live
DB Hangops – every other Wednesay at noon Pacific time
Upcoming MySQ… Continue reading
OurSQL Episode 175: Interesting CONNECtions
This week, we talk about the awesome ways to use MariaDB’s CONNECT storage engine that go above and beyond merely connecting to remote tables.
MariaDB CONNECT Engine
Episode 174, where we talked about setting up the CONNECT storage engine and some simp… Continue reading
OurSQL Episode 174: CONNECT the world
This week we discuss MariaDB’s CONNECT storage engine. Ear Candy is inconsistent behavior with dates, NULLs and collations. At the Movies is a talk about the history and future of MySQL and its variants.
Sheeri:
The 2014 MySQL Community Awards are open… Continue reading
OurSQL Episode 171: Another Round of Toolkit
This week we discuss more tools in the Percona Toolkit – pt-align, pt-fifo-split, pt-diskstats, pt-ioprofile, pt-fk-error-logger, pt-mext and pt-mysql-summary. Ear Candy is why you should load the timezone tables in MySQL and At the Movies is using GTI… Continue reading
OurSQL Episode 170: Auto-failover, part 2
This week we discuss administering Percona Replication Manager. Ear Candy is about repository packages from MariaDB and Oracle, and At the Movies presents a Riak engineer talking about “convergent replicated data types” – data structures that tolerate … Continue reading