MySQL Screencasts and Videos from Percona
Everyone wants to prevent database downtime by being proactive. But how effective are the common measures such as inspecting logs and analyzing SQL? To be truly proactive, one must prevent problems, which requires studying and understanding the reasons for downtime. We have analyzed a selection of emergency issues that we have resolved to better understand [...]
What if you had all the data you needed to measure system performance and scalability at any tier, discover performance and stability problems before they happen, and plan for capacity and performance by modeling the system’s behavior at greater load than you currently have? Now it is as easy as running tcpdump and processing the [...]
Viadeo le réseau social professionnel et Le MySQL User Group Francophone (lemug.fr) ont organisés une rencontre MySQL le 16 novembre 2011 à Paris. Stéphane est DBA MySQL chez Dailymotion. Il travaille sur la plate-forme LAMP depuis presque 10 ans pour différentes sociétés et est particulièrement enthousiaste au sujet de MySQL. Il intervient régulièrement dans des [...]
What if you had all the data you needed to measure system performance and scalability at any tier, discover performance and stability problems before they happen, and plan for capacity and performance by modeling the system’s behavior at greater load than you currently have? Now it is as easy as running tcpdump and processing the [...]
MySQL running in the LAMP stack is a complex system, luckily there is a lot of good instrumentation for investigation into the three fundamental performance problems: high CPU load, disk bandwidth problems and internal locks contention. This webinar will discuss how to detect MySQL IO problems on Linux on different abstraction layers: Using high level [...]
Il sera question de la performance des bases de données. Quels sont les problèmes qui se posent généralement à ce propos? Quelles méthodes et quels outils peut-on mettre en oeuvre pour y faire face? Frédéric Descamps travaille pour Percona. Il est un consultant Open Source expérimenté aussi bien dans les projets d’infrastructure que dans le [...]
There have been many high-level talks about how to use MySQL and DTrace together, but very little technical detail. This talk will show you how to instrument MySQL and InnoDB internals at a very deep level, using filesystem operation latency as a key example. Other topics will include tracing InnoDB’s thread concurrency code. Presented by [...]
Replication is one of MySQL’s most widely-used features, and despite significant improvements over the years, it still fails. When this happens, it can be due to any number of factors, either internal or external to your MySQL database. No matter how it fails, it is always a problem that should be taken seriously. For those [...]
Graham drives Infobright’s product-development vision and processes, including research and development and quality assurance. Graham’s specialities include business integration, computational linguistics, artificial intelligence and database design. Graham has worked in several roles, from product design and development and business process re-engineering to customer deployment and managing large scale projects and programs for Fortune 500 companies. [...]
A relational database used to be the answer for almost every project that required data storage. A few years ago, that changed. The increased visibility and features in NoSQL solutions have driven many companies to think about, test, and implement some form of NoSQL technology in their stacks. Even MySQL itself offers NoSQL interfaces to [...]
