It was a nice enough flight from Ottawa to Chicago to San Jose, if a little long. Security (or the baggage handlers) completely trashed our boxes of information folders, but I think we managed to salvage some… so if you’re looking for information on Pythian, come see us early. The weather here is just like [...]

I got tired of going all over the place to get information about mysqld variables, so I decided to make a summary of most of them (for version 5.0.27 linux). (Due to lack of horizontal space, I had to make two tables — the second one containing a short description of the variable.)

Corrections, additions, and amplifications are welcome. Enjoy!

Table 1: MySQL Variables

I will be out of the office all next week, so expect more blog posts from me! That’s not a joke — both Yannick Gratton and I will be at the MySQL Conference in Santa Clara, taking in all the material we can, processing it, and spewing out what I hope will be [...]

Welcome to the 41st edition of Log Buffer, the weekly review of database blogs. There is rarely any shortage of commentary on conferences in the world of databases. This week is no exception, with one or two waiting in the wings and another fading into the past. That would be Collaborate ‘07. Here’s a sample [...]

Here is the perl script referred to by mysql-memory-usage-profile.

Downloadable: mysql_memory_profile.pl

#!/usr/bin/perl
# Version: 1 Last Change by: procter.pythian. 20070419 14:14:39
# Copyright 2007, The Pythian Group, Inc. All rights reserved.
# Hey, we work hard on this stuff!

# Feel free to use this script, un-modified, as much as you like 
#on any system. If you find issues or have comments, we would 
#welcome the opportunity to collaborate with you on it. But we 
#haven't yet decided on any formal licensing (GPL etc.) and 
#public interest will be a factor on whether we go that route.

# MySQL Memory Profiling Script

# Reference: http://www.pythian.com/blogs/431/mysql-memory-usage-profile

#MD5 Checksum 5D713DCA3702EBC91D3B1AA997E68F07 …

There are various tools available for gathering and monitoring mysql performance data, but it’s not always clear what they mean, what is important, and what can be tuned. I’m not going to try to post a comprehensive mysql tuning manual here. This post is about taking a snapshot profile of a mysql instance that will allow you to define what type of instance you are dealing with, and give you some idea about whether the current configurations are stable or not.

I’ll be using a script that I’ve designed for daily reporting on the mysql instances that we monitor. This script will be available in a follow-up post, but for now, you can see the output of the report itself and a break-down of the more important sections.

To start with, let’s look at an example report:
Sample Report 1

Global engine stats: 13 [InnoDB] 183 …

Welcome to the 40th edition of Log Buffer, the weekly review of database blogs. In celebration of this special number, LB has gone out and bought itself a sexy new sports car in which it plans to ride around with a younger, blonde blog. The MySQL User Conference & Expo is very close, so it’s [...]

Don Seiler has published the 39th edition of Log Buffer, the weekly review of database blogs, on die Seilerwerks. As always, please see Log Buffer’s homepage to learn more about contributing. Here’s Log Buffer #39.

Those of you who, like we do here at Pythian, have the pleasure of supporting both MySQL and Oracle environments (among others) will definitely know who Tom Kyte is. He is a VP of Oracle in the Public Sector group, but he’s much more well-known for his Ask Tom site, where he has been the [...]

The 38th edition of Log Buffer, the weekly review of database blogs, has been published on Padgraig O’Sullivan’s Padraig’s Blog. Don’t forget, Log Buffer uses a distributed editorship. It needs your perspectives, so if you want to try your hand at editing and publishing an edition, please read the Log Buffer homepage for more [...]