Category Archives: Performance

OurSQL Episode 167: Data, Data Everywhere

This week we discuss test data sets. Ear Candy is errata from Episode 165 on Galera Cluster, and At the Movies is “Runaway Complexity in Big Data”
Test Data Sets
Episode 81, where we talked about different benchmark tools
Sysbench – general version
Per… Continue reading

Posted in Performance, Podcasts | Comments Off on OurSQL Episode 167: Data, Data Everywhere

OurSQL Episode 166: Top Hat Options

This week we discuss fine-tuning Galera Cluster. In this week’s ear candy we talk about recent changes to mysqldump and locking; At the Movies presents “Using Amazon Web Services for MySQL at Scale”.
Events
DB Hangops – every other Wednesay at noon Pac… Continue reading

Posted in Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 166: Top Hat Options

OurSQL Episode 165: Top Hat Cluster

This week we talk about how to install and set up Galera Cluster. Ear Candy talks about the new MySQL repos from Oracle and what to know about using them; At the Movies is Michael Stonebreaker talking about how to process today’s big data transactional… Continue reading

Posted in Learning, Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 165: Top Hat Cluster

OurSQL Episode 158: Know Your Forks

This week we discuss features of Percona Server 5.6 compared to MySQL 5.6. Ear Candy is about pt-upgrade, and At the Movies is a set of lightning talks.
Events
DB Hangops – every other Wednesay at noon Pacific time
Upcoming MySQL events
Percona Live Lo… Continue reading

Posted in Performance, Podcasts | Comments Off on OurSQL Episode 158: Know Your Forks

OurSQL Episode 147: It’s Web Scale

This week we talk with Tim Callaghan of Tokutek about TokuMX, a take on MongoDB. Ear Candy is perror on Windows and At the Movies is a presentation from the SkySQL and MariaDB Solutions Day 2013 about Tokutek.
TokuMX
Replication between MySQL and Mongo… Continue reading

Posted in Performance, Podcasts | Comments Off on OurSQL Episode 147: It’s Web Scale

OurSQL Episode 145: Biblical Tools, part 3

This week we finish up talking about the Openark Kit for MySQL. Ear Candy is using both –master-data and –tab with mysqldump, and At the Movies features Robert Hodges of Continuent presenting Scalable MySQL Operation in the Cloud with Continuent Tung… Continue reading

Posted in Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 145: Biblical Tools, part 3

OurSQL Episode 144: Biblical Tools, part 2

This week we continue talking about the Openark Kit. Ear candy is the Percona Configuration Wizard, and At the Movies is a keynote from the SkySQL and MariaDB Solutions Day about the SkySQL and MariaDB merger and the MariaDB Foundation.
Openark Kit ser… Continue reading

Posted in Performance, Podcasts, Routines | Comments Off on OurSQL Episode 144: Biblical Tools, part 2

OurSQL Episode 141: Performance Enhancements

This week we talk about server and status variables relating to the performance schema and the ps_helper tool. Ear Candy is an sql_mode bug, and At the Movies is a performance_schema and ps_helper webinar.
Performance Schema Variables
MySQL 5.5 perform… Continue reading

Posted in Performance, Podcasts | Comments Off on OurSQL Episode 141: Performance Enhancements

OurSQL Episode 140: More Performance

This week we explain performance_schema a bit deeper. In Ear Candy, we talk about max_binlog_cache_size and At the Movies presents Max Mether of SkySQL talking about “High Availability Solutions for MySQL”.
Events
DB Hangops – every other Wednesay at n… Continue reading

Posted in Performance, Podcasts | Comments Off on OurSQL Episode 140: More Performance

OurSQL Episode 139: Starting to Perform

This week we discuss the basics of using the performance schema in MySQL 5.5 and 5.6. Ear Candy is about a temporal gotcha when using dates and times that do not exist, and At the Movies is David Stokes giving some useful for System Administrators who … Continue reading

Posted in Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 139: Starting to Perform