While databases are increasingly being distributed across multiple nodes, the performance of every node still matters--especially if you're considering virtualized or cloud deployments that have their own specific trade-offs. Memory performance scaling as core count changes, all aspects of disk performance, and using sysbench to benchmark both MySQL and PostgreSQL are all topics covered here.
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.
This talk shows you how to gather the correct data for performance forecasting and capacity planning. You will learn how to apply mathematical models to the data, and get meaningful answers that are likely to resemble reality.
Choosing right Hardware components, configuring them properly, and optimizing Linux settings are very important for MySQL and other database server deployments. But they are frequently overlooked. Learning best practices will certainly improve performance and stability. Do you want to learn these best practices? This three-hour tutorial is for you.