Personal schedule for Billy Earney
Download or
subscribe to Billy Earney's
schedule.
Wanna be a Certified MySQL DBA? This Tutorial summarizes every chapter covered in the first part of the official MySQL DBA Exam. Join the tutorial, take and pass the exam during the conference.
Read more.
Wanna be a Certified MySQL DBA? This Tutorial summarizes every chapter covered in the second part of the official MySQL DBA Exam. Join the tutorial, take and pass the exam during the conference.
Read more.
War and peace stories from Facebook - how to detect, analyze and fix problems below, inside and above overloaded MySQL servers.
This covers concurrecy problems that appear in real world environments, beyond labs and benchmarks.
Read more.
Performance Schema is a major new MySQL Server feature which shows where we're going with monitoring and performance measurement.
Read more.
MySQL's EXPLAIN output is rich with information, but can be difficult to understand. This session helps EXPLAIN make sense by showing how it reveals the server's estimated query execution plan.
Read more.
This talk will give an overview of how to connect to MySQL and which
drivers are available today under Python v2.x, and tomorrow's Python v3.x.
We'll dive into MySQLdb, its strong history, its present. We'll go over
OurSQL and various other community projects, as well as Sun Microsystems'
MySQL Connector/Python (mainted by the speaker).
Read more.
A lot of companies do not have a dedicated DBA, rather they rely on sysadmins, web developers, or others to put the DBA hat on five minutes at a time. This session is designed to provide these people the basic DBA tips and tricks they need to be successful. What are the most important parameters? What sort of hardware should the database run on? When I have a problem where do I look?
Read more.
After a short introduction this talk will describe new features in the plugin API - new plugin types, with use cases and examples, and Server Services - the solution to the main problem that prevents a true binary plugin independence.
Read more.
The MySQL Server ships with a number of command-line administration tools. However, they only provide basic functionality and make it complicated or sometimes even impossible to accomplish common DBA tasks. In this session, Lenz will give an introduction to the most popular and commonly used Open Source tools that a DBA should be aware of and that make MySQL administration tasks a breeze.
Read more.
This talk is for developers or administrators who need to make their queries faster.
Read more.
Description:
In this session, the speaker will explain some important but not well known indexing topics. Advanced topics such as indexes and lock contentions, how indexes impact MySQL optimizer will be covered. This session is the sequel to "Mastering the Art of Indexing" (http://www.mysqlconf.com/mysql2009/public/schedule/detail/6661), presented at the last MySQL Conference.
Read more.
Ever wanted to de-fragment your data set to regain disk space and increase performance? Ever needed to add or change an index on a large table? Ever needed to change a primary key? If you answered yes to any of these and you already know a lot about MySQL then this talk is for you!
Read more.
Everyone knows memcached is useful for alleviating database load. What may be less well known is that memcached’s new storage engine API allows you to create new solutions for myriad needs, building on what makes memcached fast and simple. This discussion of the storage engine API includes a case study of its use at Zynga, where NorthScale Membase Server is the key-value database behind FarmVille.
Read more.
Sphinx is a FOSS full-text search engine that makes searching MySQL databases a breeze. This talk covers a number of recently developed advanced Sphinx features (RT indexes, parallel searching improvements, subquery caches, hitless indexes, "blended" indexing, SphinxQL interface, etc) in detail, explaining how and why to use them in your application.
Read more.
Facebook runs MySQL on commodity servers. Commodity servers have become extremely fast. Learn about the methods we use to identify performance bottlenecks in MySQL and the projects we have completed or started to keep pace with hardware advances.
Read more.
This session shows you how to get rich historical data about your MySQL server's performance and usage with the open-source Cacti graphing tool. Best of all, it's easy, open-source, and free -- so you can stop flying blind.
Read more.
Query reviews are a great way to find potentially slow queries before they become a problem. A query review is like a code review, except instead of reviewing code, queries are reviewed. This presentation will show you how to use the Maatkit tool mk-query-digest to create a digest of queries. This digest can be a one-off report, or it can be saved to a database table.
Read more.
Discuss what to look at when regular monitoring information is not descriptive enough. Review how to obtain useful status snapshots and how to interpret the results using real world examples covering items like: replication health, memory allocation, network issues and performance.
Read more.