Emergency

Search Results for: mysql config

MySQL is crashing: a support engineer’s point of view

In MySQL QA Episode #12, “MySQL is Crashing, now what?,” Roel demonstrated how to collect crash-related information that will help Percona discover what the issue is that you are experiencing, and fix it. As a Support …

Read More
 

The MySQL query cache: Worst enemy or best friend?

During the last couple of months I have been involved in an unusually high amount of performance audits for e-commerce applications running with Magento. And although the systems were quite different, they also had one …

Read More
 

MySQL QA Episode 11: Valgrind Testing: Pro’s, Con’s, Why and How

Today’s episode is all about Valgrind – from the pro’s to the con’s, from the why to the how! This episode will be of interest to anyone who is or wants to work with Valgrind on …

Read More
 

Multi-source replication in MySQL 5.7 vs Tungsten Replicator

MySQL 5.7 comes with a new set of features and multi-source replication is one of them. In few words this means that one slave can replicate from different masters simultaneously. During the last couple of …

Read More
 

MySQL QA Episode 9: Reducing Testcases for Experts: multi-threaded reducer.sh

Welcome to MySQL QA Episode 9. This episode will go more in-depth into reducer.sh: Reducing Testcases for Experts: multi-threaded reducer.sh We will explore how to use reducer.sh to do true multi-threaded testcase reduction – a world’s …

Read More
 

The Q&A: Creating best-in-class backup solutions for your MySQL environment

Thank you for attending my July 15 webinar, “Creating Best in Class Backup solutions for your MySQL environment.” Due to the amount of content we discussed and some minor technical difficulties faced near the end …

Read More
 

MySQL QA Episode 8: Reducing Testcases for Engineers: tuning reducer.sh

Welcome to MySQL QA Episode 8: Reducing Testcases for Engineers: tuning reducer.sh Advanced configurable variables & their default/vanilla reducer.sh settings FORCE_SKIPV FORCE_SPORADIC TIMEOUT_COMMAND & TIMEOUT_CHECK MULTI_THREADS MULTI_THREADS_INCREASE QUERYTIMEOUT STAGE1_LINES SKIPSTAGE FORCE_KILL Some examples FORCE_SKIPV/FORCE_SPORADIC TIMEOUT_COMMAND/TIMEOUT_CHECK …

Read More
 

SELinux and the MySQL init script

I recently worked with a customer who had a weird issue: when their MySQL server was started (Percona Server 5.5), if they try to run service mysql start a second time, the init script was …

Read More
 

MySQL QA Episode 7: Reducing Testcases for Beginners – single-threaded reducer.sh!

Welcome to MySQL QA Episode #7 – Reducing Testcases for Beginners: single-threaded reducer.sh! In this episode we’ll learn how to use reducer.sh. Topics discussed; reducer.sh introduction/concepts Basic configurable variables & their default reducer.sh settings INPUTFILE options …

Read More
 

Practical MySQL Performance Optimization (July 2 webinar)

Applications often become impacted by MySQL performance. Optimization is the obvious solution but where to start? Join me on July 2 at 11 a.m. Pacific and I’ll show you how to optimize MySQL in a …

Read More