Proper indexing is a key ingredient of database performance and MySQL is no exception. In this session we will talk about how MySQL uses indexes for query execution, how to come up with an optimal index strategy, how to decide when you need to add an index, and how to …
MySQL users commonly ask: What indexes do I need? Why aren’t my indexes helping me? Don’t indexes cause overhead? This webinar will provide practical, step by step methods for finding the queries you need to optimize and choosing the best indexes for them.
As operational database schemas become complex, users resort to denormalization to handle performance issues. This includes a range of techniques from materialized views to using MySQL as a key-value store for blobs containing full objects.
As MySQL powers more and more business critical applications it is very important to be able to upgrade MySQL server with as low risk as possible. In this presentation we will go into details of best practices used by Percona to perform hundreds of MySQL upgrade projects as well as …
This talk focuses on how MySQL SQL injection vulnerabilities can be used to gain remote code execution on the LAMP and WAMP environments. Attackers performing SQL injection on a MySQL platform must deal with several limitations and constraints. For example, the lack of multiple statements in one query makes MySQL …
To understand large and busy environments one needs a collection of tools and methodologies. We will discuss how performance analysis, management and diagnostics are done at Facebook, from use cases of our cluster-scale MySQL client pmysql, to how we use additional instrumentation both inside MySQL (table/user statistics, slocket) and outside …
