(Ronald Bradford) Mark Leith, on of the MySQL Support Team managers wrote some time ago a very nice utility I use often called Statpack.
Tag: Open Source
MySQL security risk?
(Michael McLaughlin) Somebody asked me why you must provide the IDENTIFIED BY password clause on a grant after you’ve already created the user. This is a very good question, I wondered it myself a while back. This blog provides the what, why, and how of it.
Convert single row INSERTs to multi-row INSERT
(Craig) Ronald’s post regarding multi-row INSERTs with MySQL reminded me of a quick utility I wrote about a year ago. I wanted to test for myself how much performance can be gained over singleton INSERTs. The perl script below just takes the output from mysqldump and produces a file for each table,
MySQL Stored Functions: Impact of DECLARE HANDLER on Performance
(Roland Bouman) Just a moment ago, I read this post by Peter Gulutzan. In this post, Peter explains a little trick that allows you to capture the SQL state in a variable whenever an error occurs in your MySQL stored routine code.
Get the error return value in a variable
(Peter Gulutzan) One missing feature in our stored procedures and functions is that, if there’s an exception (error), you don’t know the error number or sqlstate or error message. The plan is there, of course, WL#2111 Stored Procedures: Implement GET DIAGNOSTICS but I haven’t ticked the architecture
Trivial MySQL Variable of the Day
(Sheeri Cabral) Today’s trivial MySQL system variable: old_alter_table
MySQL: Five Dials to Set
(Sean Hull) MySQL can be installed and up and running in a matter of minutes with RPMs or even quicker with tools like xampp. However, there are so many dials to turn, and options to set that even experienced DBAs can feel overwhelmed.
Converting an Oracle Schema to MySQL
(George J. Trujillo Jr.) Both Oracle and MySQL provide a number of sample schemas so users can build different schema environments and load them with data. So I thought I’d get one of the Oracle sample schemas and go through the exercise of converting it to a MySQL schema. I could have gone in eithe
MySQL: Refactoring a Stored Function
(Roland Bouman) I was just reading PlanetMySQL and noticed Mike Hillyer’s recent post on a user-friendly age function for MySQL. Basically, this function accepts two DATETIME values and returns an indication of the time between the two dates in the form of a human-readable string. For example:
Materialized Views Performance Tips
(David Fetter) So you don’t feel your clients’ time is best spent on scanning a multi-million row table, and you’ve decided to materialize some views. Here are some principles to keep in mind as you go forward…