EmergencyEMERGENCY? Get 24/7 Help Now!

Microslow patch for 5.1.20

 | July 18, 2007 |  Posted In: 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 minor change in existing functionality and also adds […]

Read More

Microslow patch for 5.0.37

 | June 6, 2007 |  Posted In: 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 5.0.41 : www.percona.com/blog/files/patches/patch.slow-micro.5.0.41.diff

Read More

Backport of micro-time patch to mysql 4.1

 | October 1, 2006 |  Posted In: 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 Patch is available here (The original patch was […]

Read More

Internals of InnoDB mutexes

 | September 7, 2006 |  Posted In: 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 InnoDB mutex (schematic for simplification):

Read More

Slow Query Log analyzes tools

 | September 6, 2006 |  Posted In: Insight for DBAs

(There is an updated version of this post here). MySQL has simple but quite handy feature – slow query log, which allows you to log all queries which took over define number of seconds to execute. There is also an option to enable logging queries which do not use indexes even if they take less […]

Read More

Returning to InnoDB scalability

 | July 28, 2006 |  Posted In: 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 executes query for 240 sec. It is very strange as threads […]

Read More

Stack trace for x86_64 boxes

 | July 19, 2006 |  Posted In: 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 use: place stack64.diff into main source dir; execute patch -p1 […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.