This post was originally published on the MySQL Support Team Blog at https://blogs.oracle.com/mysqlsupport/entry/innodb_locks_analysis_why_is on 14 April 2017. Consider the scenario that you execute a query. You expect it to be fast – typically subsecond – but now it take not …
While I prepared for my Hands-On Lab about the Performance Schema at MySQL Connect last year, one of the things that occurred to me was how difficult it was quickly getting an overview of which consumers, instruments, actors, etc. are …
Easier Overview of Current Performance Schema Setting Read more »
In MySQL 5.5 and earlier, the steps to resize the InnoDB log files were a bit involved and for example included manually moving the log files out of the way as InnoDB would only create new files, if none existed. …
Changing the Size of the InnoDB Log Files In MySQL 5.6 Read more »
With MySQL 5.6 just gone GA, I thought it would be good to take a look at the changes in options and variables that comes with the new release. First of all, several of the existing options have get new …
