Merry Christmas
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, …
Year: 2012
A Couple of Substring Functions: substr_count() and substr_by_delim()
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 »
Slides and Other Files From My Hands-On Labs at MySQL Connect 2012
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 »
Why I am So Excited About the MySQL Performance Schema
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 »
What is the MySQL Performance Schema and Why is It Needed?
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 »
Attending MySQL Connect 2012
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 …