We did it! Hear how we went from a third party database system to a 60G MySQL Cluster hosting large external web services and intensive internal data applications flawlessly, in three months.
Harnessing the performance of MyISAM to simply scale-out highly write-intensive applications.
A deep tour into the design of Maria, a new MVCC storage engine for MySQL from the original authors of MySQL that is designed to support transactions and automatic recovery.
Batched Key Access is an advanced technique that is able to speed up the execution of queries with multitable joins to the factor of 5 and more.
Benchmarking and Profiling are extrememly important and a large array of tools exist for the job. Join Tom Hanlon for a tour of the current landscape. Demos of each tool wil be shown.
Join us for a presentation of the wonderful world of benchmarks and monitoring tools. Here you will learn what is available, how each tool works, and a demonstration using each tool against a running database from a veteran MySQL expert.
A popular and lighthearted session in quiz format. Fun and educational, a broad range of "what not to do" is explored, taking examples from the scary real world.
Noted Solaris and DTrace expert Ben Rockwood will show how to evaluate and introspect MySQL's behavior, and gain information that isn't normally attainable by developers and system administrators.
EXPLAIN is one of MySQL's most-used and least-understood features, and it's not documented fully. This session helps EXPLAIN make sense by showing how it really maps to a query execution plan.
This presentation covers new Full Text Search features in MySQL 5.1. We also show some common tasks and solutions with Full Text Search in MySQL as well as benchmark results.
Mike Callaghan will describe enhancements to InnoDB that improve its scalability on servers with many disks and many CPU cores, results from benchmarks, and results from production systems.
You may have heard Innodb has limited scalability with multiple CPUs and some of these were fixed in recent MySQL 5.0 versions. In this presentations we will look into which problems are fixed.
Learn about a horizontal scalable architecture for accessing exponentially growing datasets, and performance results obtained on several filesystems, MySQL storage engines, and partitioning.
Large MySQL deployments and Memcached go hand and hand. This tutorial details how to get started, the ins and outs of deploying Memcached as a key caching layer in your applications, and how to keep scaling.
Phorum is the message board software used by MySQL. One reason they chose Phorum was because of its speed. We have to use some tricks and fancy SQL to make this happen. Learn how.
This presentation discusses how MySQL was leveraged to provide a large scale personalization technology platform solution for a site like ebay.com, which processes over 2 billion URL requests per day.
In this session we'll put features that do the same thing up against each other and see which performs better. We find the optimal way to do smaller things. Everything is backed up by benchmarks and discussion.
In this presentation learn how MySQL, InnoDB, and Solaris helped Fotolog gain the top performance it desired as the world's largest photo blogging community through tuning and schema optimizations.
Learn about all the tricks required to make MySQL Cluster high performance. This includes using real-time scheduling, batching in all its form, cluster interconnects, and locking threads to CPUs.
This talk presents new open source tools that allow users to set up and run database scale-out benchmarks easily. Hodges illustrates with benchmark results from your favorite MySQL configurations.
Ask Bjoern Hansen will be covering the overall platform and architecture considerations involved in tuning applications from a holistic perspective. You'll be shown design scaleable architectures for dynamic, high-volume web sites. Topics covered include caching, scalable database design, replication, load-balancing, and architectural decisions derived from many years of experience.
Flickr implemented a real-time collection of referrers to Photos, streams, sets and collections. MySQL myISAM/INNODB, curl, Java are the only component used in the setup and it scales linearly. This talk is about building a model for capacity planning, scaling for triple the request rate, and scaling linearly for an intensive application.
In this session, Cole and Bergen will take a look at the hardware of recent past, today's hardware, and what hardware trends will become interesting during 2008 and beyond.
Bill Karwin has answered questions from SQL users for over ten years. Some techniques have emerged as widely used, but flawed, making them brittle, buggy solutions and create security or scalability risks in your projects. In this tutorial, Karwin describes SQL techniques that should be called antipatterns, illustrates their weaknesses, and offers better solutions.
One of the most powerful, yet underutilized MySQL features are User Defined Functions and Aggregates. Learn how to use them to dramatically improve the speed of your data warehouse processing.
This technical session highlights three benchmark tools that MySQL users and web developers can use to compare, test, and tune MySQL performance: SPECjAppServer2004, EAStress, and FABAN.