Personal schedule for Suhas Mallya
Download or
subscribe to Suhas Mallya's
schedule.
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.
Read more.
This tutorial aims to guide normal MySQL users and DBAs into the world of MySQL Cluster. From installing and configuring to creating your first clustered table and finally node failure handling. At the end of the session you'll will be the proud owner of a full blown, tiny MySQL Cluster which you can show off at work.
Read more.
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.
Read more.
Scaling Applications with Caching, Sharding and Replication
Read more.
Join Edward Screven, Oracle’s Chief Corporate Architect and leader of the MySQL business, as he discusses the current and future state of MySQL, now part of the Oracle family of products. The presentation also covers Oracle’s investment in MySQL technology and community; and the role that open source in general is playing within heterogeneous customer environments around the world.
Read more.
Tim returns to share insights into the world of emerging technology, presenting his take on what matters most-and what will be most disruptive-to the tech community.
Read more.
Many things happen when MySQL is part of the core technology used to
scale a rapidly growing social networking service. Mark will share
stories and details about the MySQL deployment at Facebook.
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.
This talk introduces Sqoop, the open source SQL-to-Hadoop tool. Sqoop helps users perform efficient imports of data from MySQL and other databases to Hadoop's distributed file system, where it can be processed in concert with other data sources. Sqoop also allows users to export Hadoop-generated results back to MySQL and other systems for use with other data pipelines.
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.
Learn how Infobright's columnar analytic database delivers very fast query response against large volumes of data without indexes, data partitioning or other DBA effort. Includes case studies on the leading mobile analytics company who saw query response time reduced from many minutes to just seconds and a large energy company who had data compression of 98% and implemented a data mart in weeks.
Read more.
This presentation provides an overview of Pentaho Data Integration (a.k.a. Kettle) with a focus on how it can help you to work with MySQL databases.
Read more.
Do you need a straightforward way to add reporting to your MySQL applications? Enable end-users to build their own reports? Provide analytic capabilities that let your users leverage Excel to evaluate MySQL data combined with other managed and unmanaged data sources? This is the session for you.
Read more.
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.
Read more.
What's the forecast for Drizzle, a database optimized for Cloud and Net applications? Brian provides an overview of the Drizzle project's current state as well as what's ahead.
Read more.
Monty, the co-founder of MySQL and now project lead of MariaDB, discusses what MariaDB is all about. He'll also present an overview of the future of this community developed branch of the MySQL database.
Read more.
Sheeri Cabral knows the MySQL Community. Working for the Pythian
Group, she has tapped her co-workers' knowledge about the Oracle
Community. In this brief community keynote, Sheeri maps out the
differences between the communities and what we can expect next now
that MySQL is "under new management".
Read more.
Many LAMP websites use Memcached to offload dynamic data from their MySQL database to speed up performance. Answers.com, however, did not want to be in the business of managing a growing Memcached layer. In this case study, Answers.com discusses its choices when it came to scaling out with Memcached and the lessons learned.
Read more.
Getting the most out of your MySQL Cluster (NDB) deployment
Read more.
SQL Injection is one of the most common and most serious threats to web application security. In this presentation, you'll see some myths busted, you'll get a better understanding of SQL Injection, and you'll learn simple and effective techniques to combat it.
Read more.
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.
Read more.
Explore options outside the traditional RDBMS during this high level tour of some common application architectures. We will discuss how these tools differ, where they fit, and how they can be used collaboratively to build an application with the best of all the worlds.
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.
Before you throw away the binary logs that you use for replication, transform them into an analysis tool. Use them to track the frequency of inserts, updates and deletes on all of your tables. Maintain a history of the response times of your most frequent write queries.
Read more.
In a complement to Edward Screven's opening keynote, Kaj will interpret the state of the MySQL community and the happenings of the MySQL Conference in a language familiar to those whose business has grown up with MySQL. What has changed already, what will change soon, and what won't change with Oracle as the steward of MySQL?
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.
Lucene is a powerful, high-performance, full-featured text search engine library.
In this presentation, learn how you can use Lucene with MySQL to offer powerful searching capabilities to your stakeholders. This session is highly recommended for those looking to add full-text cross-platform, database independent search capability to their application.
Read more.
Taking a client from a minimum 700ms, and at times 1-2 seconds front page load time to a consistent 60ms is a great success story for the improvements possible in optimizing database performance. In this presentation we will outline the steps taken and what can be applied to any website as one possible model to use in evaluation of your website, as well as provide specific examples.
Read more.
Take the opportunity to network one last time at this closing event, enjoy ice cream and refreshments. Say thank you and exchange contact information until next year.
Read more.