Discover the basic tips and tricks on how to build your MySQL schemas so you don't get caught up in early performance problems.
Learn how to select your tables data types and what performance implications they have. Review how indexing works, as well as basic indexing tips and tricks. A healthy schema is one of the first steps to having a performant database.
Once vertically scaling your databases can’t help you any further you need to think about sharding them. Sharding basically means you are going to distribute your (write) workload over multiple database hosts using an algorithm. For some OpenSource Databases, you get sharding out of the box, but for MySQL, you don’t.
This means you either implement a sharding yourself and have absolute control over what data goes where or choose...
Advanced Optimization and Troubleshooting MySQL Using PMM2 - Peter Zaitsev - Percona Live ONLINE 2020
Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBAs.
The databases powering your applications need to be able to handle changing traffic workloads while remaining responsive and stable so that you can deliver an excellent user experience. Further, DBA’s are also expected to find cost-efficient means of solving these issues. In this presentation, we will...
Join Peter Zaitsev, Percona CEO, as he discusses bpfTrace and Dtrace on Linux.
While eBPF was included in Linux kernel for quite a few years, it lacked a good “front end” to complete Dtrace functionality in the Linux ecosystem. In this presentation, Peter will look into BPFTrace as a capable Dtrace replacement. He will also demonstrate how you can develop your own tools and utilities using BPFTrace as well as how you can use the...
Please watch Percona’s Senior Software Engineer, Ibrar Ahmed as he presents the “PostgreSQL High-Performance Tuning and Optimization" webinar.
PostgreSQL is one of the leading open-source databases. Out of the box, the default PostgreSQL configuration is not tuned for any workload. Thus, any system with least resources can run it. PostgreSQL does not give optimum performance on high permanence machines because it is not using the...
MySQL/InnoDB constantly performs merge and split operations, and you have very limited visibility of them. But they can bite you, and bite hard, especially if using a spindle storage VS SSD (which have different issues, by the way).
This is an important point to keep in mind. In InnoDB you cannot have fragmented records, but you can have a nightmare at the page-extent level.
The sad story is there is also very little we...
Scalability can be achieved horizontally or vertically. Vertical scalability means adding more resources/hardware to existing nodes to enhance the capability of the database to store and process more data, for example, adding a new process, memory, or disk to an...
PostgreSQLHigh AvailabilityPerformance Optimization
The goal of this hour long webinar is to go through some of our design principles and how we have managed to progress from database proxy to multi-function tool that so many benefit from.
ProxySQL 2.0 has so many new features, from setting up...
MySQLPercona XtraDB ClusterPerformance Optimization