Percona Server version 5.1.53-12.4 is now available for download. It is now the current stable release version. Functionality Added or Changed  Percona Server 5.1.53-12.4 is based on MySQL 5.1.53.  New Features Added: Precompiled UDFs for Maatkit (FNV and MurmurHash hash functions to provide faster checksums) are now included in distributions. Fixes feature request #689992. (Aleksandr Kuzminsky) [...]
UDF -vs- MySQL Stored Function
September 6, 2010 By 8 Comments
Few days ago I was working on a case where we needed to modify a lot of data before pushing it to sphinx – MySQL did not have a function to do the thing so I thought I’ll write MySQL Stored Function and we’ll be good to go. It worked! But not so well really [...]
A micro-benchmark of stored routines in MySQL
August 16, 2009 By 7 Comments
Ever wondered how fast stored routines are in MySQL? I just ran a quick micro-benchmark to compare the speed of a stored function against a “roughly equivalent” subquery. The idea — and there may be shortcomings that are poisoning the results here, your comments welcome — is to see how fast the SQL procedure code [...]
The feature I love in TokuDB
June 11, 2009 By 4 Comments
Playing with TokuDB updates I noticed in SHOW PROCESSLIST unsual for MySQL State.
1 2 3 4 5 6 7 8 9 10 11 12 | mysql> show processlist; +----+------+-----------+--------+---------+------+---------------------------+-----------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+-----------+--------+---------+------+---------------------------+-----------------------------+ | 3 | root | localhost | sbtest | Query | 30 | Updated about 764000 rows | update sbtest set email=zip | ... mysql> show processlist; +----+------+-----------+--------+---------+------+----------------------------+-----------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+-----------+--------+---------+------+----------------------------+-----------------------------+ | 3 | root | localhost | sbtest | Query | 79 | Updated about 1900000 rows | update sbtest set email=zip | ... |
(Do not look in stupid UPDATE query, it’s just for testing ) So looking in SHOW PROCESSLIST you can see progress of query execution. I would want to see it in standard MySQL and InnoDB more than all these triggers and [...]
How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
I vaguely recall a couple of blog posts recently asking something like “what’s the formula to compute mysqld’s worst-case maximum memory usage?” Various formulas are in wide use, but none of them is fully correct. Here’s why: you can’t write an equation for it.
Profiling MySQL stored routines
January 19, 2009 By 4 Comments
These days I’m working with a customer who has an application based entirely on stored routines on MySQL side. Even though I haven’t worked much with stored procedures, I though it’s going to be a piece of cake. In the end – it was, but there’s a catch.
