by Fernando Laudares Camargos | Oct 8, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
In this penultimate post from our series on building an enterprise-grade PostgreSQL environment we cover the parameters we have enabled to configure detailed logging in the demo setup we will showcase in our upcoming webinar. Detailed logging in PostgreSQL and log...
by Jobin Augustine | Oct 5, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
In this current series of blog posts, we have been discussing various relevant aspects when building an enterprise-grade PostgreSQL setup, such as security, back up strategy, high availability, and different methods to scale PostgreSQL. In this blog post, we’ll...
by Alexey Stroganov | Apr 5, 2017 | Benchmarks, MySQL, Percona Software
In this blog post, we’ll look at some of the available PMP profiling tools. While debugging or analyzing issues with Percona Server for MySQL, we often need a quick understanding of what’s happening on the server. Percona experts frequently use the pt-pmp...
by Alok Pathak | Dec 16, 2015 | Insight for DBAs, MySQL
We work on data recoveries quite often. In many cases, we recover table structures from the .frm files because there was no backup available. There is already a great blog post by my colleague Miguel Ángel Nieto about how we can recover structures from .frm files...
by Kenny Gryp | Jul 12, 2013 | MySQL
Lefred and I spent a bit of time making innotop 1.9.1. We’ve released a new version mainly to include MySQL 5.6 support as well as including some bugs fixed by Baron Schwartz and Frédéric Descamps. You can download the .tar.gz and rpm’s (new!) at...
by Martin Arrieta | Jan 3, 2013 | Insight for DBAs, MySQL, Percona Software
pt-stalk recipes: Gather forensic data about MySQL when a server problem occurs It happens to us all from time to time: a server issue arises that leaves you scratching your head. That’s when Percona Toolkit’s pt-stalk comes into play, helping you diagnose...
by Bill Karwin | Nov 22, 2012 | Insight for DBAs, MySQL, Percona Events
One of my favorite tools in the Percona Toolkit is pt-query-digest. This tool is indispensable for identifying your top SQL queries, and analyzing which queries are accounting for your database load. But the report you get from pt-query-digest is only as good as the...
by Aurimas Mikalauskas | Aug 29, 2012 | Insight for DBAs, MySQL
If you ever had a replication slave that is severely behind, you probably noticed that it’s not catching up with a busy master at a steady pace. Instead, the “Seconds behind master” is going up and down so you can’t really tell whether the...
by Aurimas Mikalauskas | Apr 17, 2011 | Insight for DBAs, MySQL
I use Aspersa tools a lot and I find myself going to the website just to download one of the tools all the time. I love I can download maatkit with a simple wget maatkit.org/get/tool command so I made bit.ly shortcuts for all of the current aspersa tools. Here’s...
by Aurimas Mikalauskas | Apr 7, 2011 | Insight for DBAs, MySQL
I don’t use many tools in my consulting practice but for the ones I do, I try to know them as best as I can. I’ve been using mk-query-digest for almost as long as it exists but it continues to surprise me in ways I couldn’t imagine it would. This...
by Aurimas Mikalauskas | Mar 28, 2011 | Insight for DBAs, MySQL
Have you ever seen BIG weird numbers in mk-query-digest report that just seem wrong? I have! Here’s one report I got today: ... # Attribute total min max avg 95% stddev median # ============ ======= ======= ======= ======= ======= ======= ======= # Exec time...
by Aurimas Mikalauskas | Nov 9, 2010 | Insight for DBAs, MySQL
Before I start a story about the data recovery case I worked on yesterday, here’s a quick tip – having a database backup does not mean you can restore from it. Always verify your backup can be used to restore the database! If not automatically, do this...
by Aurimas Mikalauskas | Sep 6, 2010 | MySQL
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...
by Evgeniy Stepchenko | May 18, 2010 | Percona Events
We have had been using Akismet as our primary antispam tool for quite a while. It works okay, but recently we have started to get the feeling we need a better solution. With Akismet were still burdened with a lot of manual moderation for false negatives and scanning...
by Matt Yonkovit | Nov 12, 2009 | Benchmarks, Cloud, MySQL
This is part 3 of my Tyrant extra’s, part 1 focused on durability, part 2 focused on the perceived performance wall. #3. Tokyo Cabinet Can have only a single writer thread, bottlenecking performance When writing an application using Tokyo Cabinet only one...
by Matt Yonkovit | Nov 11, 2009 | Benchmarks, Cloud, MySQL
Continuing my look at Tokyo Tyrant/Cabinet and addressing some of the concerns I have seen people have brought up this is post #2. #2. As your data grows does Tokyo Cabinet slow down? Yes your performance can degrade. One obvious performance decrease with a larger...
by Matt Yonkovit | Nov 10, 2009 | Benchmarks, Cloud, MySQL
by Ryan Lowe | Sep 16, 2009 | Insight for DBAs
We often encounter customers who have partitioned their applications among a number of databases within the same instance of MySQL (think application service providers who have a separate database per customer organization … or wordpress-mu type of apps). For...
by Vadim Tkachenko | Sep 14, 2009 | Insight for DBAs
Since DTrace was released for Solaris I am missing it on Linux systems… It can’t be included in Linux by the same reason why ZFS can’t be – it’s licensing issue. Both ZFS and DTrace are under CDDL, which is incompatible with GPL. So you...
by Vadim Tkachenko | Sep 14, 2009 | Percona Software
If you ever wondered how big is that or another index in InnoDB … you had to calculate it yourself by multiplying size of row (which I should add is harder in the case of a VARCHAR – since you need to estimate average length) on count of records. And it...
