Skip navigation links

OurSQL: The MySQL Database Community Podcast

OurSQL Episode 182: Optimizing MariaDB

Monday, April 21, 2014

This week we discuss new optimizer improvements in MariaDB 10. Ear Candy is about the MariaDB threadpool, and At the Movies is Oracle's Tomas Ulin talking about raising the bar with MySQL.

Events
DB Hangops - every other Wednesay at noon Pacific time

Upcoming MySQL events

Training
SkySQL Trainings

Tungsten University trainings

read more

OurSQL Episode 181: MariaDB Goodies

OurSQL Episode 180: Sharing the Load

OurSQL Episode 179: MySQL's Materialized Views

OurSQL Episode 178: License to Use

OurSQL Episode 177: Artistic License

OurSQL Episode 176: Replication Everywhere

OurSQL Episode 175: Interesting CONNECtions

OurSQL Episode 174: CONNECT the world

OurSQL Episode 173: Time for Percona Live

OurSQL Episode 172: A New Proxy

OurSQL Episode 171: Another Round of Toolkit

OurSQL Episode 170: Auto-failover, part 2

OurSQL Episode 169: Having Fun

OurSQL Episode 168: Autofailover, part 1

OurSQL Episode 167: Data, Data Everywhere

OurSQL Episode 166: Top Hat Options

OurSQL Episode 165: Top Hat Cluster

OurSQL Episode 164: Who's Doing What?

OurSQL Episode 163: Moving Along

OurSQL Episode 162: Exploring Workbench Further

OurSQL Episode 161: The sharpest tool on the bench

OurSQL Episode 160: More Free Hot Backup

OurSQL Episode 159: Free Hot Backup

OurSQL Episode 158: Know Your Forks

OurSQL Episode 157: More Than One Master

OurSQL Episode 155: Weaving with Fabric

OurSQL Episode 155: Tooling Around, Part 5

OurSQL Episode 154: Tooling Around, Part 4

OurSQL Episode 153: Tooling Around, Part 3

OurSQL Episode 152: Tooling Around, Part 2

OurSQL Episode 151: Tooling Around, Part 1

OurSQL Episode 150: MySQL Connect

OurSQL Episode 149: Trolling

OurSQL Episode 148: Intellectual Property

OurSQL Episode 147: It's Web Scale

OurSQL Episode 146: License to run

OurSQL Episode 145: Biblical Tools, part 3

OurSQL Episode 144: Biblical Tools, part 2

OurSQL Episode 143: Biblical Tools

OurSQL Episode 142: Great Views

OurSQL Episode 141: Performance Enhancements

OurSQL Episode 140: More Performance

OurSQL Episode 139: Starting to Perform

OurSQL Episode 138: The Relevance of Tungsten

OurSQL Episode 137: Playing in the Sandbox

OurSQL Episode 136: Digging for Information

OurSQL Episode 135: Another Kind of Buffer

OurSQL Episode 134: When Binary's Not Binary

OurSQL Episode 133: MySQL on Auto-Tune

OurSQL Episode 132: New and Shiny!

OurSQL Episode 131: Fresh Variables

OurSQL Episode 130: Retired Variables

OurSQL Episode 129: New and Extended

OurSQL Episode 128: Your Global ID Please

OurSQL Episode 127: No Sweat Slaves

OurSQL Episode 126: Subqueries and Tracking

OurSQL Episode 125: New and Improved...And Faster!

OurSQL Episode 124: When Do You Want It?

OurSQL Episode 123: Storing Bags of Bytes

OurSQL Episode 122: Nobody's Perfect - 2012 Blooper Retrospective

OurSQL Episode 121: Fun with text files

OurSQL Episode 120: Trigger Happy

OurSQL Episode 119: I Do DECLARE

OurSQL Episode 118: Not Our Usual Routine

OurSQL Episode 117: Foreign Policy

OurSQL Episode 116: Do You Make the Grade (part 5)?

OurSQL Episode 115: Do You Make the Grade (part 4)?

OurSQL Episode 114: Do You Make the Grade (part 3)?

OurSQL Episode 113: A JS API with JDD

OurSQL Episode 112: Do You Make the Grade (part 2)?

OurSQL Episode 111: Do You Make the Grade (part 1)?

OurSQL Episode 110: The Key to 5.6

OurSQL Episode 109: Starting with the right foot

OurSQL Episode 108: Legendary Searches

OurSQL Episode 107: Staying concurrent

OurSQL Episode 106: FULLTEXT on ACID

OurSQL Episode 105: Lost for Words

OurSQL Episode 104: Making a Connection, part 2

OurSQL Episode 103: Making a Connection, part 1

OurSQL Episode 102: Virtualization 102

OurSQL Episode 100: The Ball Pit

OurSQL Episode 99: Data Privacy and Security

OurSQL Episode 98: MySQL Puppeteering

OurSQL Episode 97: Who's Watching the Databases?

OurSQL Episode 96: Talking about Nothing

OurSQL Episode 95: Finding data at OSCON

OurSQL Episode 94: It's Still Not Our Type, Part 3

OurSQL Episode 93: A GUI is Worth a Thousand Commandlines

OurSQL Episode 92: It's Not Our Type, Part 2

OurSQL Episode 91: It's Not Our Type, Part 1

OurSQL Episode 90: Handle With Care

OurSQL Episode 89: Seal of Approval

OurSQL Episode 88: MySQL Founders

OurSQL Episode 87: A Shift in the Cloud

OurSQL Episode 86: Speed Demon

OurSQL Episode 85: Keep it Under Control

OurSQL Episode 84: Going to the Big Show

OurSQL Episode 83: The NewSQL World

OurSQL Episode 82: Cloudy With a Chance of Data

OurSQL Episode 81: From the Tool Bench

OurSQL Episode 80: Lesser Known Percona Tools

OurSQL Episode 79: Removing Evil Queries, part 3

OurSQL Episode 78: Removing Evil Queries, part 2

OurSQL Episode 77: Removing Evil Queries, part 1

OurSQL Episode 76: Off the Charts, part 3

OurSQL Episode 75: Off the Charts, part 2

OurSQL Episode 74: Off the Charts, part 1

OurSQL Episode 73: What happened?

OurSQL Episode 72: Blooper Retrospective

OurSQL Episode 71: Table Manners, part 2

OurSQL Episode 70: Table Manners, part 1

OurSQL Episode 69: Replication Secret Agent

OurSQL Episode 68: Scaling, or Sailing?

OurSQL Episode 67: HA and Replication

OurSQL Episode 66: Breaking the News Reels

OurSQL Episode 65: Security Blanket - The Missing Link

OurSQL Episode 64: Are We Normal Yet?

OurSQL Episode 63: Snowing Already?

OurSQL Episode 62: Data Warehousing 101

OurSQL Episode 61: Security Blankets, Part 2

OurSQL Episode 60: Charming Data

OurSQL Episode 59: Security Blankets, Part 1

OurSQL Episode 58: Opening up Oracle's World

OurSQL Episode 57: Eventual Discovery part 2

OurSQL Episode 56: Eventual Discovery part 1

OurSQL Episode 55: MySQL Data Encryption

OurSQL Episode 54: Scaling MySQL

OurSQL Episode 53: MySQL 5.6 at OSCon Data

OurSQL Episode 52: Database Theory ABC

OurSQL Episode 51: Data Infrastructure at OSCon Data

OurSQL Episode 50: MySQL at Facebook, Current and Future

OurSQL Episode 49: Stalking MySQL

OurSQL Episode 48: Percona Live NYC 2011

OurSQL Episode 47: Replication logs and objects

OurSQL Episode 46: It's About Time

OurSQL Episode 45: Hackathon Success! (MySQL -> MongoDB replication)

OurSQL Episode 44: Elemental Replication (Tungsten, that is)

OurSQL Episode 43: Repli-cans and repli-can'ts

OurSQL Episode 42: The Buzz about MySQL 5.6

OurSQL Episode 41: Zmanda [backup series #6]

OurSQL Episode 40: TokuDB 5.0 part 2

OurSQL Episode 39: TokuDB 5.0 part 1

OurSQL Episode 38: Xtrabackup (Backup Series #5)

OurSQL Episode 37: It's Still Not Our (De)fault! Part 2

OurSQL Episode 36: It's Not Our (De)fault! Part 1

OurSQL Episode 35: Advanced Logical Export Features (Backup Series #4)

OurSQL Episode 34: Collaborating

OurSQL Episode 33: Looking Through the Lenz (Backup Series #3, mylvmbackup)

OurSQL Episode 32: Backup tools you already have [Backup series #2]

OurSQL Episode 31: The MySQL Ecosystem

OurSQL Episode 30: Backup Glossary (Backup Series #1)

OurSQL Episode 29: Subpar Subqueries

OurSQL Episode 28: Conferential Integrity

OurSQL Episode 27: To SQL or No[tto]SQL, that is the question

OurSQL Episode 26: Zombies!

OurSQL Episode 24: The Sun is Shining

OurSQL Episode 23: Back To School

OurSQL Episode 22: Things To Avoid With MySQL Querie

OurSQL Episode 21: The Rise of the MySQL DBA

OurSQL Episode 20: The Pythian Group

OurSQL Episode 19: MySQL Proxy

OurSQL Episode 18: De-myth-tifying Indexes

OurSQL Episode 17: Hashing it out

OurSQL Episode 16: The Art of Innovation, Guy Kawasaki

OurSQL Episode 15: Eben Moglen's Keynote at the 2007 MySQL Conference

OurSQL Episode 14: The MySQL Conference & Expo

OurSQL Episode 13: The Nitty Gritty of Indexes

OurSQL Episode 12: Interview with Kaj Arno About the Google Summer of Code

OurSQL Episode 11: Catching Up

OurSQL Episode 10: How About Some Cache?

OurSQL Episode 9: Jay Speaks About the MySQL Conference

OurSQL Episode 8: Basic MySQL Security

OurSQL Episode 7: What's it Like To Be Normal?

OurSQL Episode 6: Falcon, Part 2

OurSQL Episode 5: Falcon, Part 1

OurSQL Episode 4: Cluster From Down Under

OurSQL Episode 3: Your Database on ACID

OurSQL Episode 2: Wild Performance Tips

OurSQL Episode 1: Backups, Backups Everywhere

OurSQL Episode 0: MySQL Community Podcast