MySQL
What do MySQL Consultants do?
One role of a MySQL consultant is to review an existing production system. Sometimes you have sufficient time and access, and other times you don’t. If I am given a limited time here is a general list of things I look at.
Read moreTiming your SQL queries
When working interactively with the MySQL client, you receive feedback of the time the query took to complete to a granularity of 10 ms. Enabling profiling is a simple way to get more a more accurate timing of running queries.
Read moreUpcoming Conferences with dedicated MySQL content
We recently held a dedicated MySQL Track at ODTUG Kaleidoscope 2010 conference for 4 days. This is the first of many Oracle events that will begin to include dedicated MySQL content.
Read moreImproving MySQL Productivity – From Design to Implementation
My closing presentation at the dedicated MySQL track at ODTUG Kaleidoscope 2010 discussed various techniques and best practices for improving the ROI of developer resources using MySQL. Included in the sections on Design, Security, Development, Testing, Implementation, Instrumentation and Support were also a number of horror stories of not what to do, combined with practical examples of improving productivity.
Read moreMySQL Idiosyncrasies That Bite
The following are my slides that I presented at ODTUG Kaleidoscope 2010 . This presentation talks about the MySQL defaults including a non-transactional state, silent data truncations, date management, and transaction isolation options.
Read moreStill room at Kaleidoscope for MySQL attendees
Today I received notice that next week’s Velocity conference is at maximum capacity. With just under 2 weeks before the start of ODTUG Kaleidoscope in Washington DC we still have room for late registrations.
Read moreOracle resources for the MySQL Community
While I have spent a lot of time recently helping the MySQL community interact with and integrate with various Oracle User Groups including ODTUG, IOUG, NoCOUG, NYOUG, DAOG I thought I’d share some resources for the MySQL Community that wanted to know more about Oracle.
Read moreWhy is MySQL documentation search so wrong?
I just don’t get this I don not know what the technology is behind the search box at MySQL Documentation but it annoys me when I want to see the syntax of a command and Search can’t find the page, when a dedicated page exists and I’m using the exact syntax of both the command the title of the page.
Read moreI’ll have a MySQL shot to go!
Wednesday night of the MySQL track of ODTUG Kaleidoscope will include an evening with Last Comic Standing comedian, John Heffron . It should be great way to unwind after day 3 of the conference.
Read moreWhen SET GLOBAL affects SESSION scope
We have all been caught out with using SET and not realizing that the default GLOBAL Scope (since 5.0.2) does not change the current SESSION scope. I was not aware until today that changing GLOBAL scope has some exceptions that also automatically affect SESSION scope.
Read moreBest Practices: Additional User Security
By default MySQL allows you to create user accounts and privileges with no password. In my earlier MySQL Best Practices: User Security I describe how to address the default installation empty passwords.
Read moreEventually consistent Group Commit
Having just written an interview response about NoSQL concepts for a RDBMS audience it was poetic that an inconspicuous title “(4 of 3)” highlights that both a MySQL read scalable implementation via replication and a NoSQL solution can share a common lack of timely consistency of data.
Read moremk-query-digest Tips – Showing all hosts & users
The Maatkit tools provide a suite of additional MySQL commands. There is one command I use constantly and that is mk-query-digest. Unfortunately the documentation does leave a lot to be desired for usability.
Read moretcpdump errors on FreeBSD for mk-query-digest
While I use this tcpdump command for MySQL query analysis with mk-query-digest , I found recently that it didn’t work on FreeBSD $ tcpdump -i bge0 port 3306 -s 65535 -x -n -q -tttt -c 5 tcpdump: syntax error It left me perplexed and reading the man page seemed to indicate my options were valid.
Read more