Maciej Dobrzanski

Character encoding configuration in MySQL has always been a bit confusing. With too many options to set, unclear relationships between them, and the default settings that make MySQL incompatible with most languages, it is a headache to many users, many of whom end up with broken data. This lecture will provide an overview of the character set support in MySQL, guidelines on how to use it correctly, and will demonstrate several methods of detecting and repairing mangled data.

It is a typical day at work when suddenly someone notices that the application loads slow. They immediately switch to complaining about database performance and demand that you find the problem and fix it. But how to verify the problem is really with the database? What are the common symptoms and where to look for them? And how to isolate the culprit?

The session will discuss the practical approach to troubleshooting performance problems in MySQL: where to start the investigation, what information to look at and how to interpret it. I will also be talking about useful tools and preparing the environment for effective troubleshooting.

MySQL security beyond users and passwords. Overview of architectures and available technologies that can limit both external and internal risks. Operational and performance implications of increased security measures.