Are you experiencing current performance bottlenecks in your high availability applications ? Are you designing a new mission-critical application and want to know how best to structure your schema and index strategy for optimal performance? Interested in how to transform your SQL into faster, more efficient queries?
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.
Spider and Vertical Partitioning Storage Engine will be introduced by Giuseppe in this Conference.
In this session, I'll introduce some additional tips for joinable database sharding using Spider and Vertical Partitioning.
Learn how to find your database problems more quickly without special software. Automatically tracking all database changes and keeping a historical record enables you to figure out problems faster, reducing downtime for critical production systems. Existing monitoring systems are very good at detecting actual errors but not very good at telling you what triggered your performance issue
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.
Drizzle and MySQL both have a number of static DTrace probes embedded
within them which allows observability tools to gain deep insight into
what the server is doing. In this session, an overview of these static
probes will be given and examples of utilizing these probes will be
shown using both DTrace on Solaris and SystemTap on Linux.
Getting the most out of your MySQL Cluster (NDB) deployment
Lets unleash MySQL Cluster information on people by starting with the
This talk will give you an idea on what great tool MySQL Cluster and how it can help you reach high availability.
We'll show you how it works without going to much in the technical
details. Showing off where it make sense to deploy, and stress points
where you should not use Cluster (yet).
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.
In this talk, the developers behind MySQL Replication walk through some of the new Replication features of MySQL 5.5
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.
If you're using or planning to use an Object-Relational Mapping (ORM) library
for PHP, this talk is for you. We'll survey common ORMs available and see how to use them,
including relevant design patterns.
Additionally, we'll examine potential pitfalls that can lead to poor performance and other side
effects if you use ORMs in their default manner or without understanding what they do.
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.
Replication is a versatile tool to use in your toolbox. It can be used to solve many problems modern web architectures, as well as various ways to simplify maintenance.
Learn about the features built into MySQL Connector/J targeted at scalability and reliability. The session will cover fault tolerant load balancing, replication-aware load balancing with slave fail-over, custom exception handling and some creative use of statement interceptors mixed with the built-in load balancer to implement sharding.
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
MySQL data types do not support the SQL standard WITH TIME ZONE attribute. How do you store times in MySQL to efficiently show your customers times in their own time zone?
This talk is for developers or administrators who need to make their queries faster.
Memcached has become the de facto standard for caching web applications. But, many users jump in feet first without understanding what it does or perhaps more importantly what it does not do. Once you understand memcached, you may come to realize that it is what it does not do that makes it so good.