MySQL Cluster 7.3 went GA yesterday and with it came a new member of the MySQL Cluster API family: mysql-js – a native Node.js connector. mysql-js uses the NDB API to connect directly to the data nodes which improves performance …
New Member of the Cluster API Family: The Native Node.js Connector Read more »
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 …
mysql is the MySQL Command Line Client – my favourite tool when using MySQL. It is available on all platforms where you can install MySQL and is part of a standard installation. As you can see there are many options, …
A problem that sometimes when writing queries or stored routines is the need to use strings to do basic manipulation of the data. While from a performance perspective it is generally faster to do these manipulations inside the application, for …
A Couple of Substring Functions: substr_count() and substr_by_delim() Read more »
First of all a big thank you to all of you who attended my two Hands-On Labs (HOL) session at this year’s MySQL Connect. I ended up doing two sessions as there was a last minute cancellation, so in addition …
Slides and Other Files From My Hands-On Labs at MySQL Connect 2012 Read more »
The improved Performance Schema in MySQL 5.6 provides a new way of investigating issues in the database. Many issues that previously required tools such as strace, dtrace, etc. can now be investigated directly from inside MySQL in a platform independent …
Why I am So Excited About the MySQL Performance Schema Read more »
When you have a non-trivial database installation, you will inevitably sooner or later encounter performance related issues ranging from a query not executing as fast as desirable to complete meltdowns where the database does not respond at all. Until MySQL …
What is the MySQL Performance Schema and Why is It Needed? Read more »
In the last weekend of September, MySQL Connect 2012 will take place in San Francisco as part of Oracle OpenWorld. MySQL Connect is a two day event that allows the attendees to focus on MySQL with the possibility to add …
