by Vadim Tkachenko | Nov 1, 2008 | Percona Events
This is a fantastic addition to the Percona team. Congratulations.
by Vadim Tkachenko | Oct 25, 2008 | Percona Software
Google patches V1 contain interesting patch to mirror binary log on slave. Although Google is preparing GlobalTransactionId patch, which going to be replacement for MirroredBinlogs, we still think mirroring binary logs is very useful for: Backup of binary logs in real...
by Vadim Tkachenko | Oct 20, 2008 | Percona Software
There is patch from Google to improve SMP performance , but for some workloads it showed for us reverse scalability. E.g. update_key benchmark from sysbench. There are also results with Yasufumi’s rw_locks (http://bugs.mysql.com/bug.php?id=26442) ThreadsStandard...
by Vadim Tkachenko | Sep 28, 2008 | Insight for DBAs
Ever wonder what is stored in InnoDB buffer pool at the moment ? It is not so hard actually – we made a short patch for MySQL 5.0 which show innodb buffer pool content mysql> select * from information_schema.INNODB_BUFFER_POOL_CONTENT;...
by Vadim Tkachenko | Sep 12, 2008 | Percona Software
Recently Google published V2 release of patches, one of them user_statistics we use in our releases. New features are quite interesting so we decided to port it to fresh releases of MySQL. Features includes: New statistics per user (Cpu_time, Bytes_received,...
by Vadim Tkachenko | Sep 9, 2008 | Benchmarks, Percona Software
We are going to show the effects of the new patches applied to Percona HighPerf release. As you see from the following graphs, there is significant difference to normal version when the data bigger than buffer pool (right graph shows CPU usage) The workload emulates...
by Evgeniy Firsov | Aug 4, 2008 | Percona Software
Recently, we added information schema support to Google’s userstats patch. There are three information schema tables added: user_statistics, table_statistics, index_statistics. One can now use select * from information_schema.user_statistics along with show...
by Maciej Dobrzanski | Apr 24, 2008 | Percona Software
A few weeks ago I was asked to isolate some functionalities from Mark Callaghan’s MySQL patch bundle. They were extensions adding per-user and per-table accounting to the database, accessible with a new set of commands such as SHOW TABLE_STATISTICS, SHOW...
by Maciej Dobrzanski | Apr 20, 2008 | Percona Software
For a couple of months there have been no updates to our msl patch, however recently I managed some time to change this. The functionality was extended a little bit and what’s even more important the patch is available for all the recent MySQL releases. To remind...
by Maciej Dobrzanski | Oct 31, 2007 | Percona Software
Microslow patch is used by many DBAs and developers to accurately time their queries and to catch those which run less than a second as they can also be a performance killer for a busy application. Recently I have started the development of an updated version of the...
by Maciej Dobrzanski | Aug 29, 2007 | Insight for DBAs
Vadim asked me yesterday to update Microslow patch for 5.1.21, because the previous one I wrote for 5.1.20 failed to apply correctly on the new MySQL release. Imagine the expression on my face after I unpacked the sources and found out that MySQL incorporated the...
by Maciej Dobrzanski | Jul 18, 2007 | Percona Software
Microslow patch has been there for some time, but only for earlier MySQL editions such as 4.1 and 5.0. Now it’s also available for the latest 5.1. Because MySQL went through a lot of internal changes, the patch had to be written from scratch. It introduces some...
by Vadim Tkachenko | Jun 6, 2007 | Insight for DBAs
Just short message that patch enables microsecond resolution in slow-log (see more https://www.percona.com/blog/2006/09/06/slow-query-log-analyzes-tools/) for 5.0.37 is available here: www.percona.com/blog/files/patches/patch.slow-micro.5.0.37.diff The patch for...
by Vadim Tkachenko | Jan 12, 2007 | Percona Events
Update 3 June 2008: We have removed the builds below, since they are quite obsolete and no one has posted comments about them since more than a year ago. Great news are MySQL finally released new Community release – MySQL 5.0.33, which however as promised comes...
by Vadim Tkachenko | Oct 1, 2006 | Percona Software
Taking into account 4.1 tree is still popular and is used on many production servers we decided to make backport of patch to slow-log queries. The patch allows to specify time of slow queries in microseconds and is very helpful in a fight with problematic queries. 4.1...
by Vadim Tkachenko | Sep 7, 2006 | Insight for DBAs
InnoDB uses its own mutexes and read-write locks instead of POSIX-mutexes pthread_mutex*, the main reason for that is performance, but InnoDB’s implementation isn’t ideal and on modern SMP boxes can cause serious performance problems. Let’s look on...
by Vadim Tkachenko | Jul 28, 2006 | Insight for DBAs
I’m again returning to InnoDB scalability and related bug #15815 as it hurts many users and customers using multi-cpu servers. Short intro into problem: On 4-CPU box 1 thread executes full-table scan select query for 8 sec, but with 4 threads – each thread...
by Vadim Tkachenko | Jul 19, 2006 | Insight for DBAs
We are going to release several patches which are not included in official MySQL releases. First one is automatically stack trace for x86_64 systems. Currently MySQL resolves stack in crash only for x86 boxes. You can download patch for 5.0.22 source tree here. How to...
