Category Archives: Performance

OurSQL Episode 199: Make It Fast

Posted on August 24, 2017 by Technocation, Inc.

This week, we discuss common MySQL performance tips.
Continue reading →

Posted in Performance, Podcasts, Query Optimization, Server Tuning | Comments Off on OurSQL Episode 199: Make It Fast

OurSQL Episode 201: What are you doing?

Posted on August 24, 2017 by Technocation, Inc.

This week we discuss user statistics in the MariaDB and Percona forks of MySQL. Continue reading →

Posted in Learning, Performance, Podcasts | Comments Off on OurSQL Episode 201: What are you doing?

OurSQL Episode 202: Scaling by Proxy

Posted on August 24, 2017 by Technocation, Inc.

This episode we start a 2-part series on MaxScale, a scaling proxy for MySQL. Ear Candy is OS Query and At the Movies is about MaxScale.
Continue reading →

Posted in Learning, Performance, Podcasts | Comments Off on OurSQL Episode 202: Scaling by Proxy

OurSQL Episode 203: Scaling by Proxy Part 2

Posted on August 24, 2017 by Technocation, Inc.

In this episode we finish our series on MaxScale. Ear candy is about using MySQL and Galera for geographic replication, and at the Movies uses MySQL to build big data applications.
Continue reading →

Posted in Learning, Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 203: Scaling by Proxy Part 2

OurSQL Episode 206: Pieces of Fabric

Posted on August 24, 2017 by Technocation, Inc.

In this episode we discuss sharding and high availability with MySQL Fabric, including installation and configuration. Ear Candy is rolling out GTIDs with no restarting, and At the Movies is putting MySQL Fabric to use, including a live demo.
Continue reading →

Posted in Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 206: Pieces of Fabric

OurSQL Episode 192: Common Schema, part 2

Posted on July 7, 2014 by podcast

This week we continue our discussion of Common Schema by finishing up the routines and starting to look at the views it offers. Ear Candy is and At The Movies is
News
In the news, the OurSQL podcast will change to a monthly format after episode 200. W… Continue reading →

Posted in General, Performance, Podcasts, Routines | Comments Off on OurSQL Episode 192: Common Schema, part 2

OurSQL Episode 190: Server State Monitoring

Posted on June 23, 2014 by podcast

This week we discuss pt-sift and pt-stalk. Ear Candy is about a new tool called Orchestrator, and At the Movies is about Trove on OpenStack to provide open source Database as a Service.
News
Gerry:
In the news, the OurSQL podcast will change to a month… Continue reading →

Posted in Performance, Podcasts, Query Optimization | Comments Off on OurSQL Episode 190: Server State Monitoring

OurSQL Episode 184: Digging Through the Tool Chest

Posted on May 12, 2014 by podcast

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 182: Optimizing MariaDB

Posted on April 21, 2014 by podcast

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
U… Continue reading →

Posted in Performance, Podcasts, Query Optimization | Comments Off on OurSQL Episode 182: Optimizing MariaDB

OurSQL Episode 180: Sharing the Load

Posted on April 7, 2014 by podcast

This week we talk to Justin Swanhart about Shard-Query, a massively parallel processing query engine for MySQL. Ear candy is about mydumper, and At the Movies is “Common Deadly MySQL Development Mistakes.”
Events
Percona Live
DB Hangops – every other W… Continue reading →

Posted in Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 180: Sharing the Load