May 2, 2016

Troubleshooting Scenarios with Performance Schema

David Turner, DBA, Dropbox, René Cannaò, Lead Engineer, Self Employed, and Thomas Manville, Software Engineer, Dropbox deliver their talk, "Troubleshooting Scenarios with Performance Schema" on day 2 of the 2016 Percona Data Performance Conference, 4/20/2016, in Santa Clara, CA.
 
In this talk we'll run through numerous performance problems and how to troubleshoot them using Performance Schema. Many of these...

Percona Live SessionsDiscover


May 2, 2016

Drupal Just Wants to Hug Your Database

Emily Slocombe, Platform DBA, Acquia, delivers their talk, "Drupal Just Wants to Hug Your Database" on day 2 of the 2016 Percona Data Performance Conference, 4/20/2016, in Santa Clara, CA. 
 
Drupal is one of the more widely adopted CMSs. It is open source and has a huge developer base. However, I rarely hear a DBA mention having to administer Drupal with anything but frustration and pessimism. At Acquia, we have...

Percona Live SessionsOperations


May 2, 2016

Did you accidentally build a database?

Spencer Kimball, CEO & Co-Founder, Cockroach Labs, delivers their talk, "Did you accidentally build a database?" on day 2 of the 2016 Percona Data Performance Conference, 4/20/2016, in Santa Clara, CA. 
 
A surprising number of companies are building proprietary databases and refuse to admit it. Worse, most are doing a terrible job. A traditional RDBMS is a great choice for both building applications and...

Percona Live SessionsNon-MySQL


May 2, 2016

Operational Buddhism: Building Reliable Services From Unreliable Components

Ernie Souhrada, Database Engineer and Bit Wrangler, Pinterest, delivers their talk, "Operational Buddhism: Building Reliable Services From Unreliable Components "on day 2of the 2016 Percona Data Performance Conference, 4/20/2016, in Santa Clara, CA. 
 
The rise of utility computing has revolutionized much about the way organizations think about infrastructure and back-end serving systems compared to the "olden...

Percona Live SessionsBusiness / Case Study


May 2, 2016

RocksDB: Key-Value Store Optimized for Flash-Based SSD

Siying Dong, Software Engineer, Facebook Inc delivers their talk, "RocksDB: Key-Value Store Optimized for Flash-Based SSD "on day 2 of the 2016 Percona Data Performance Conference, 4/20/2016, in Santa Clara, CA.

RocksDB is an embedded persistent key-value store for low-latency and high-throughput workload. It has been...

Percona Live SessionsNew Tech & Trends


May 2, 2016

InnoDB Locking Explained With Stick Figures

Bill Karwin, Senior Database Architect, SchoolMessenger, delivers their talk "InnoDB Locking Explained With Stick Figures" on day 2 of the 2016 Percona Data Performance Conference, 4/20/2016, in Santa Clara, CA. 
 
When does InnoDB lock a row? Multiple rows? Why would it lock a gap? How do transactions affect these scenarios? Locking is one of the more opaque features of MySQL, but it’s very important for both...

Percona Live SessionsPerformance


May 2, 2016

Shifting the Paradigm: MongoDB and the MEAN Stack

Kat Styons, Senior Full Stack Developer, The Washington Post delivers their talk Shifting the Paradigm: MongoDB and the MEAN Stack on Day 2 of the 2016 Percona Data Performance Conference, 4/20/2016 in Santa Clara, CA.
 
Several teams across The Washington Post collected content in different ways and it was not easily shared or accessible. So, we built a tool called Submission Platform to collect and curate the...

Percona Live SessionsMongoDB


May 2, 2016

Tooling for GTID

Ryan Lowe, Production Engineer, Square, Inc. delivers their talk Tooling for GTID on Day 2 of the 2016 Percona Data Performance Conference, 4/20/2016 in Santa Clara, CA.

So you want to transition to GTID? Great! However, GTID fundamentally changes many assumptions in instance management, incident response, and high-availability tooling. In this talk, we’ll provide practical examples of how Square had to update its tooling to...

Percona Live SessionsReplication


Apr 29, 2016

Troubleshooting Slow Queries

Effective queries are a core requirement of MySQL performance. Even a perfectly optimized MySQL server running on the most powerful hardware can lag due to badly optimized queries. EXPLAIN is one of the most powerful and always-available query tuning instruments built-in to MySQL.

In this...

Percona MySQL Webinars


Apr 7, 2016

Introduction to Troubleshooting Performance: What Affects Query Execution?

Slow running queries, threads stacking for ages during peak times, application performance suddenly lagging: these are some of the things on a long list of possible database performance issues. How can you figure out why your MySQL installation isn't running as fast as you'd like?

In this introductory webinar, we will concentrate on the three main reasons for performance slowdown:

- Poorly optimized queries
-...

Percona MySQL Webinars


Pages