by Roel Van de Paar | Jul 7, 2015 | Insight for DBAs, Insight for Developers, MySQL
Welcome to MySQL QA Episode 3: “Debugging: GDB, Backtraces, Frames and Library Dependencies”In this episode you’ll learn how to use debugging tool GDB. The following debugging topics are covered:1. GDB Introduction 2. Backtrace, Stack trace 3.... by Roel Van de Paar | Jun 26, 2015 | Security
In a recent article on the Percona blog, I recommended readers to a tool called CamStudio for making technical screen recordings. The blog post was very popular and got 300+ Facebook likes in a short time. Providentially though, a reader commented that the installer... by Roel Van de Paar | May 15, 2015 | Insight for DBAs, Insight for Developers, MySQL, Percona Services, Percona Software
Welcome to MySQL QA Episode 2: Build a MySQL Server – Git, Bazaar (bzr), Compiling, and Build ToolsIn this episode you’ll learn how to build Percona Server and/or MySQL Server for QA purposes & more in this short 25 minute tutorial.In HD quality (set... by Roel Van de Paar | Apr 9, 2015 | Insight for DBAs, Insight for Developers, MySQL
After we released pquery to the community, and as we started logging bug reports with pquery testcases, it quickly became clear that pquery binaries with statically compiled-in client libraries would be of great convenience, both for ourselves and for the... by Roel Van de Paar | Mar 17, 2015 | Insight for DBAs, Insight for Developers, MySQL, Percona Services
MySQL QA Episode #1: Bash/GNU Tools & Linux Upskill & Scripting FunThis episode consists of 13 parts, and an introduction. See videos belowIn HD quality (set your player to 720p!)IntroductionPart 1: echo, ls, cp, rm, vi, cat, df, du, tee, cd, clear, uname,... by Roel Van de Paar | Mar 17, 2015 | Insight for DBAs, Insight for Developers, MySQL, Percona Services
Welcome to the MySQL QA Training Series!If you have not read our introductory blog post on pquery yet, I’d recommend reading that one first to get a bit of background. The community is enthuastic about pquery, and today I am happy to announce a full training... by Roel Van de Paar | Feb 4, 2015 | Insight for DBAs, Insight for Developers, MySQL
Being a QA Engineer, how would you feel if you had access to a framework which can generate 80+ crashes – a mix of hitting developer introduced assertions (situations that should not happen), and serious unforeseen binary crashes – for the... by Roel Van de Paar | Sep 3, 2014 | Insight for DBAs, MySQL
Let me start by saying a big “thank you” to the staff at Oracle for deciding to open source reducer.sh. It’s a tool I developed whilst I was working for them several years ago. Its sole purpose is to do one thing – but do it good: test-case... by Roel Van de Paar | Apr 17, 2014 | Insight for DBAs, Insight for Developers, MySQL
Finding bugs in MySQL is not only fun, it’s also something I have been doing the last four years of my life. Whether you want to become the next Shane Bester (who is generally considered the most skilled MySQL bug hunter worldwide), or just want to prove you can... by Roel Van de Paar | Nov 11, 2013 | Insight for DBAs, Insight for Developers, MySQL, Percona Events, Percona Software
8PM. One of the servers found a critical bug. Hop online and discuss, log bug. 10PM. Patch ready. 10:30PM. New build ready. 10:45PM. New RQG run initiated. This was by no means an uncommon sight during the months of testing that went into Percona Server 5.6, in fact... by Roel Van de Paar | Nov 11, 2013 | Insight for DBAs, Insight for Developers, MySQL
How do we ensure that, when we have 35+ testable option combinations for mysqld, we test each and every combination of them? For example: will a different innodb_log_file_size combined with more innodb_log_files_in_group and a modified innodb_fast_shutdown setting... by Roel Van de Paar | Nov 11, 2013 | Insight for DBAs, Insight for Developers, MySQL
This post builds on the How to obtain the “LES” (Last Executed Statement) from an Optimized Core Dump? post written about a year ago.A day after that post was released, Shane Bester wrote an improved version, How to obtain all executing queries from a core... by Roel Van de Paar | Feb 25, 2013 | Hardware and Storage, Insight for DBAs, Insight for Developers, MySQL
There are many reasons for wanting a small MySQL database server: You’re a uni student who wants to learn the SQL language better and needs a mini-testbox You’re a Windows user who wants to play around with Percona Server on Linux You’re a corporate... by Roel Van de Paar | Jan 9, 2013 | Insight for DBAs, Insight for Developers, MySQL
There are times where you need to know exactly how much memory the mysqld server (or any other program) is using, where (i.e. for what function) it was allocated, how it got there (a backtrace, please!), and at what point in time the allocation happened.For example;... by Roel Van de Paar | Oct 23, 2012 | Benchmarks, Insight for DBAs, Percona Events, Percona Software
Continuous integration of new features and bug fixes is great – but what if a small change in seemingly insignificant code causes a major performance regression in overall server performance?We need to ensure this does not happen.That said, performance... by Roel Van de Paar | Sep 9, 2012 | Insight for DBAs, Insight for Developers, MySQL