Personal schedule for Baron Schwartz
subscribe to Baron Schwartz's
This tutorial focuses on the diagnostic tools you can turn to when confronted with an unexplained performance problem. Tools explained include iostat, vmstat, and mk-query-digest. The emphasis is on practical usage under pressure, and less on performance theory.
Drizzle is a fork of the MySQL server that has been talked about for
some time. This tutorial will cover how the Storage Engine API and its
subsystem has evolved. We will walk through the API with BlitzDB, a
storage engine that is built on top of this new storage subsystem.
Have you heard the buzz about Percona's enhancements to MySQL? What
about XtraDB, Percona's high-performance storage engine based on InnoDB?
Come learn what all the fuss is about. In this session you'll learn
about these and other open-source projects, and you'll get a preview of
the exciting roadmap for their future.
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.
Database access in Ruby on Rails can be extremely slow, but it doesn't have to be: this talk will discuss ways you can get massive performance speedups by increasing your query efficiency and by minimizing ActiveRecord object creation. This can keep your application scalable and responsible even under large datasets and modest hardware.
Many people know Linux terminologies such as ext3, tmpfs, cfq io scheduler, OOM killer, etc. But many times it is not appropriately configured. In this session, the speaker will show Linux performance tuning and stabilization practices for MySQL, such as how to avoid OOM Killer, performance difference between I/O schedulers, tuning Linux kernel parameters, profiling with SystemTap, etc.
Memcache is one of the tools of scaling read heavy architectures, but keeping it in sync with MySQL can be a challenge: scalability vs. consistency ? Do it in the app or the database ? Storage engines or Triggers + UDF ? Let's rethink it and make it scalable and consistent: let's replicate from MySQL to memcache.
Are you interested in splitting your application's reads and writes, so writes go to the master and SELECT queries go to slaves? This session is for you. Learn common patterns, pitfalls, and solutions.
Not primarily thought of as a geospatial data store, MySQL is making huge strides in this field. A branch is being developed on MySQL forge that is implementing all functionality defined by the Open GeoSpatial Consortium(OGC). This tutorial will combine a geospatial programming crash course with real world examples integrating MySQL geospatial storage and functionality into existing applications.
InnoDB provides many sources of diagnostic information. Filtering through that information to find what is wrong with a system can be a big task.
This talk with detail all of the different sources and what useful information you can get from them. In addition, it will offer common solutions for these problems to get you started in the right direction.
Many people view topics like Map/Reduce and queue systems as advanced concepts that require in-depth knowledge and time consuming software setup. Gearman is changing all that by making this barrier to entry as low as possible with an open source, distributed job queuing system. This session looks at advanced use cases that demonstrate the power and flexibility of distributed architectures.
Learn everything about the latest and greatest new feature for MySQL Cluster, pushdown-joins. How it's implemented in the data nodes, how the mysqld integration is done, what the next steps will be and the performance increases that we measured.
Galera is emerging synchronous multi-master replication method, providing tightly coupled InnoDB clustering solution.
Galera has nice features like:
* High Availability - no lost transactions
* Performance - scalability even with 100% write rate
* Transparency - direct MySQL connections
MySQL/Galera 0.7 is production-ready GA release
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.
Monitoring usage, efficiency, and performance of memcached can seem like a dark art. For most people, configuring a RAM limit and shoving in data is as far as they need to go. If you need to know more about how efficiently you are using memcached, as well as how all the statistics line up to make a big picture, this is the place.