Personal schedule for Sean Williams
Download or
subscribe to Sean Williams's
schedule.
MySQL 5.1 introduces partitioning – a very useful feature for databases with large tables. The latest release, MySQL 5.5 enhances partitioning to make them even more user friendly and powerful. This tutorial explains the basics, and some advanced techniques to get the most from partitioning.
Read more.
Scaling Applications with Caching, Sharding and Replication
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.
Sharding is a hot topic. Every big web site is using some sharding
technique with home made solutions. The quest for the silver bullet goes on
without apparent good results. This session will present two MySQL storage
engines (Spider and Vertical partitioning) that implement transparent
sharding techniques.
Read more.
Join Oracle’s Linux and Virtualization guru, Wim Coekaerts, as he discusses Oracle’s Linux roadmap, and details specific features and contributions that will continue to drive Linux as a leading operating system for MySQL users. Wim will also talk about the role of virtualization, specifically Oracle VM, for MySQL and Linux deployments.
Read more.
Gearman is a distributed client/server architecture that can handle tasks independently from programming language and operating systems. Using it, you can create flexible and efficient applications. Through MySQL UDFs, Gearman functions can me made available to a MySQL server directly.
Read more.
Many casually written stored routines are unnecessarily slow. By observing a few principles, you can gain substantive benefits for performance and maintainability of your stored routines. By applying step-wise improvements to real-world examples you will become aware of potential problems in your own stored routines and learn how to refactor them to increase performance and maintainability.
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.
Many times, data warehouses are thrown up without much thought going into the logical/ physical design. But, high performance data warehouses and analytic databases don’t happen by accident; they come from solid up-front design work. This session describes the procedures to go from an empty data model to a physical data warehouse that can stand up to terabytes of data and intense user activity.
Read more.
Disks are often credited with being the biggest performance bottleneck to any database system. This session introduces you to Linux diagnostic tools, hardware purchasing options, and how you should be thinking about IO.
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.
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.
Want to learn what the difference between a 10 server deployment and a 200 server deployment is in terms of administration? Best practices in large deployments? Got questions on centralized management and change management? Capacity planning? All these subjects and more will be covered in this session
Read more.
This panel discussion, moderated by Sumeet Bansal, principal solutions architect for Fusion-io, the solid-state storage provider, will make clear to audience members the benefits of solid-state technologies, both from a performance standpoint and in relation to TCO. Q&A with the panel to follow. Participants include panelists from Answers.com, Cloudmark, Percona and Craigslist.org.
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.
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.