EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL QA Episode 6: Analyzing and Filtering

 | July 15, 2015 |  Posted In: Insight for DBAs, Insight for Developers, Percona Server, Percona Software, Quality Assurance

Welcome to MySQL QA Episode #6! Today we will look into analyzing and filtering our QA run. We’ll use tools like pquery-prep-red.sh, pquery-clean-known.sh & pquery-results.sh 1. Quick re-cap and QA run setup 2. pquery-prep-red.sh 3. pquery-clean-known.sh 4. pquery-results.sh 5. Bonus: pquery reach – pquery-reach++.sh We’ll also introduce the text_string.sh tool which extracts a most-specific text string […]

Read More

MySQL QA Episode 5: Preparing Your QA Run with pquery

 | July 13, 2015 |  Posted In: Insight for DBAs, Insight for Developers, Percona Server, Percona Software, Quality Assurance

Welcome to MySQL QA Episode #5! In this episode we’ll be setting up and running pquery for the first time… and I’ll also trigger some actual bugs (fun guaranteed)! I’ll also introduce you to mtr_to_sql.sh and pquery-run.sh. pquery-run.sh (the main wrapper around pquery) is capable of generating 80-120 MySQL Server crashes – per hour! See how […]

Read More

MySQL QA Episode 4: QA Framework Setup Time!

 | July 8, 2015 |  Posted In: Insight for DBAs, Insight for Developers, Percona Server, Percona Software, Quality Assurance

Welcome to MySQL QA Episode 4! In this episode we’ll look into setting up our QA Framework: percona-qa, pquery, reducer & more. 1. All about percona-qa 2. pquery

3. reducer.sh

4. Short introduction to pquery framework tools The tools introduced in this episode will be covered further in next two episodes. Full-screen viewing @ […]

Read More

MySQL QA Episode 3: How to use the debugging tool GDB

 | July 7, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

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. Frames 4. Commands & Logging 5. Variables 6. Library dependencies 7. c++filt 8. Handy references – GDB Cheat […]

Read More

Optimizing Percona XtraDB Cluster for write hotspots

 | June 3, 2015 |  Posted In: InnoDB, Insight for DBAs, MySQL, Percona XtraDB Cluster

Some applications have a heavy write workload on a few records – for instance when incrementing a global counter: this is called a write hotspot. Because you cannot update the same row simultaneously from multiple threads, this can lead to performance degradation. When using Percona XtraDB Cluster (PXC), some users try to solve this specific […]

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.