Dear Community,

The build 17 of MySQL with Percona patches is available.

New features in the release:

• MySQL-5.0.83 is taken as the basis
• The new patch innodb_use_sys_malloc.patch is added
• The new patch innodb_split_buf_pool_mutex.patch is added

This patch splits the single global InnoDB buffer pool mutex into several mutexes for different purposes. This reduces mutex contention. It may help if you suffer performance loss when the working set does not fit in memory. You can detect buffer pool mutex contention by examining the output of SHOW INNODB STATUS and looking at the first section, SEMAPHORES.

Here are the minutes of the meeting. They can also be found online
with the irc logs here.

SRU tracking on server-related packages

mathiaz had a chat with bdmurray about a way to generate a list of bugs that have been fix for a previous week. bdmurray has a script that almost does the job.

ACTION: mathiaz to follow up with bdmurray about the list of fixed released bugs related to the ubuntu-server team.

Ubuntu HA team: Cluster stack update

mathiaz reported that the latest version of drbd had been uploaded to Debian. It was using DKMS as suggested by ivoks. The drbd package has been synced in Ubuntu Karmic.

RoAkSoAx updated the Ubuntu HA …

Intuit launches open source project. SFLC on Microsoft GPL violation accusations.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

# Intuit launched open source projects and community to develop apps based on its Intuit Partner Platform, while Savio Rodrigues declared Intuit’s open source play is all business.

# SFLC’s Bradley Kuhn told SDTimes Microsoft was in violation of the GPL.

# MySQL and Memcached-based appliance vendor Schooner Info Tech has raised $20m in Series B funding.

# …

MySQL 5.1 was uploaded to Debian unstable, and until we get it into testing, I am providing semi-official up-to-date backports of MySQL 5.1.36 and 5.0.84 for i386 and amd64 in my home directory on people.debian.org. I am providing MySQL 5.0.84 for Debian 4.0 and 5.0, and MySQL 5.1.36 for Debian 5.0. If you need MySQL 5.1.36 for Debian 4.0 as well, please let me know.

MySQL 5.0.84 for Debian 4.0:

deb http://people.debian.org/~nobse/mysql-dfsg-5.0/ etch-backports mainMySQL 5.0.84 for Debian 5.0:deb http://people.debian.org/~nobse/mysql-dfsg-5.0/ lenny-backports mainMySQL 5.1.36 for Debian 5.0:deb http://people.debian.org/~nobse/mysql-dfsg-5.1/ lenny-backports mainWhen MySQL 5.1.36 (or newer) made it into …

MySQL 5.1 was uploaded to Debian unstable, and until we get it into testing, I am providing semi-official up-to-date backports of MySQL 5.1.36 and 5.0.84 for i386 and amd64 in my home directory on people.debian.org. I am providing MySQL 5.0.84 for Debian 4.0 and 5.0, and MySQL 5.1.36 for Debian 5.0. If you need MySQL 5.1.36 for Debian 4.0 as well, please let me know.

MySQL 5.0.84 for Debian 4.0:deb http://people.debian.org/~nobse/mysql-dfsg-5.0/ etch-backports main
MySQL 5.0.84 for Debian 5.0:deb http://people.debian.org/~nobse/mysql-dfsg-5.0/ lenny-backports mainMySQL 5.1.36 for Debian 5.0:deb http://people.debian.org/~nobse/mysql-dfsg-5.1/ lenny-backports mainWhen MySQL 5.1.36 (or newer) made it into testing, I am …

In the MySQL Community team, our charter is to serve the MySQL community — new and old MySQL users alike. One of the ways we do this is by facilitating information exchange between community members, where the new can learn from the old.

And there’s been lots of that information exchange going on, such as over mailing lists (in the early days the dominant vehicle), forums, and Planet MySQL.

One problem with this information exchange has been its ephemeral nature. The same questions pop up for many new users, and should they for some reason not be amongst the issues solved in the MySQL documentation, chances are you’ll have to know quite precisely what you’re looking for when coming up with your Google search phrases. Of course, browsing Planet MySQL is a great way of keeping up to …

iostat -x is very useful to check disk i/o activities. Sometimes it is said that "check %util is less than 100%" or "check svctm is less than 50ms", but please do not fully trust these numbers. For example, the following two cases (DBT-2 load on MySQL) used same disks (two HDD disks, RAID1) and reached almost 100% util, but performance numbers were very different (no.2 was about twice as fast as no.1).

# iostat -xm 10
avg-cpu:  %user   %nice %system %iowait  %steal   %idle
       21.16    0.00    6.14   29.77    0.00   42.93

Device: rqm/s   wrqm/s   r/s   w/s    rMB/s    wMB/s
sdb    2.60 389.01  283.12 47.35     4.86     2.19
avgrq-sz avgqu-sz   await  svctm  %util
43.67     4.89   14.76   3.02  99.83

# iostat -xm 10
avg-cpu:  %user   %nice %system %iowait  %steal   %idle
       40.03    0.00   16.51   16.52    0.00   26.94

Device:         rrqm/s   wrqm/s   r/s …

An unknown error connecting to MySQL on 10.0.6.28? Oh dear me… It came back up within 2 minutes though from the time I got the screenshot.

Platform: Linux/Unix

If you come across below errors when trying to connect MySQL then there might be couple of reasons behind it.

-bash-3.2$ mysql --user=root --password

Enter password:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

One of the reason could be that MySQL server isn't running. So how do you check whether or not MySQL is running? try running below shell command and see what it reports


-bash-3.2$ ps -e|grep mysqld
30878 ? 00:00:00 mysqld_safe
30939 ? 00:58:06 mysqld
-bash-3.2$


If you see at least 2 process are running/listed from the above command then it is confirmed that MySQL is running.
What if you don't see any process(as shown below)? then the MySQL services is not at all running then try to start it and watch …

Hi all,

This is a quick post to let you know that the memcached functions for MySQL have been moved to Launchpad. The project page is: https://launchpad.net/memcached-udfs

I think this will help to get the project more exposure, as well as making it easier for people to contribute to the project. I've found Launchpad to be quite useful for managing projects and so decided to move the UDFs there.

I'm working on getting out another version soon. I just fixed a bug the deals with user-defined variables that were set to NULL causing the UDFs to crash the server. It was a bug in the length of the argument being set to 8192


For instance, the first explicitly:

mysql> select memc_set('nullval', null);

(gdb) p args->args[1]
$3 = 0x0
(gdb) p args->lengths[1]
$4 = …