(Rob Gravelle) In my An Overview of the MySQL Performance Schema article, I talked about a relatively new tool called the Performance Schema. Initially implemented in MySQL 5.5 and further improved for MySQL 5.6, the Performance Schema is a tool for monitoring MySQL Server execution at a low level
Tag: Open Source
MySQL and swapping
(Srinivasa Inaganti) Did you ever encounter swap space issue with MySQL ? This problem is really annoying and here are some possible solutions :
Geographic replication with MySQL and Galera
(Marco) With the introduction of Galera replication for MySQL, Codership has, in my opinion, provide the most significant support to MySQL that the community had seen in the last tree years.
Sys Schema for MySQL 5.6 and MySQL 5.7
(Miguel Angel Nieto) Performance Schema (P_S) has been available since MySQL 5.5, more than 4 years ago. It is still difficult to see production servers with P_S enabled, even with MySQL 5.6 where the feature is enabled by default.
Logging with MySQL: Error-Logging to Syslog & EventLog
(Tatiana) You’ve already read it in What’s new in 5.7 (So Far) — the MySQL server now has new-and-improved supported for syslog (on unix-like systems) and EventLog (on Windows). In the next few paragraphs, we’ll take a look at what they are, what has changed, and how they can make your life easier.
Avoiding MySQL ALTER table downtime
(Andrew Moore) MySQL table alterations can interrupt production traffic causing bad customer experience or in worst cases, loss of revenue. Not all DBAs, developers, syadmins know MySQL well enough to avoid this pitfall.
Analyzing Prepared Statement Performance With VividCortex
(John Potocny) Optimizing MySQL performance requires the ability to inspect production query traffic. If you’re not seeing your application’s production workload, you’re missing a vital part of the picture.
MySQL’s INNODB_METRICS table: How much is the overhead?
(Peter Zaitsev) Starting with MySQL 5.6 there is an INNODB_METRICS table available in INFORMATION_SCHEMA which contains some additional information than provided in the SHOW GLOBAL STATUS output – yet might be more lightweight than PERFORMANCE_SCHEMA.
GDB Tips: Inspecting MySQL Plugin Variables in Core File
(Annamalai Gurusami) Recently I had a need to determine the session value of a MySQL plugin variable in a core file. Here I use the word plugin variable to refer to MySQL system variables provided by plugins.
Optimising multi-threaded replication
(Arjen Lentz) Multi-threaded replication is a new feature introduced in MySQL 5.6 and MariaDB 10.0. In traditional single-threaded replication, the slaves have a disadvantage as they have to process in sequence what a master executed in parallel.
