Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 426 10 Older Entries

Displaying posts with tag: Insight for DBAs (reset)

Capture database traffic using the Performance Schema
+1 Vote Up -0Vote Down

Capturing data is a critical part of performing a query analysis, or even just to have an idea of what’s going on inside the database.

There are several known ways to achieve this. For example:

  • Enable the General Log
  • Use the Slow Log with long_query_time = 0
  • Capture packets that go to MySQL from the network stream using TCPDUMP 
  • Use the …
  [Read more...]
Webinar: Introduction to MySQL SYS Schema follow up questions
+1 Vote Up -0Vote Down

Thanks to all who attended my webinar Introduction to MySQL SYS Schema. This blog is for me to address the extra questions I didn’t have time to answer on the stream.

Can i have the performance_schema enabled in 5.6 and then install the sys schema? Or they are one and the same?

You need to have enabled the performance_schema in order to use it through the sys schema. They are different entities. In general, performance_schema collects and stores the data, and sys schema reads and presents the data.

The …

  [Read more...]
Percona Server audit log plugin best practices
+0 Vote Up -0Vote Down

Auditing your database means tracking access and changes to your data and db objects. The Audit Log Plugin has been shipped with Percona Server since 5.5.37/5.6.17, for a little over 12 months. Prior to the Audit Log Plugin, you had to work in darker ways to achieve some incarnation of an audit trail.

We have seen attempts at creating audit trails using approaches such as ‘sniffing the wire’, init files, in-schema ‘on update’ fields, triggers, proxies and trying to parse the traditional logs of MySQL (slow, general, binary, error). All of these attempts miss a piece of the pie, i.e. if you’re sniffing …

  [Read more...]
MySQL is crashing: a support engineer’s point of view
+0 Vote Up -0Vote Down

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 Engineer I (Sveta) am very happy to see this post – but as a person who better understands writing than recording – I’d like to have same information, in textual form. We discussed it, and decided to do a joint blog post. Hence, this post …

  [Read more...]
MySQL Quality Assurance: A Vision for the Future by Roel Van de Paar (Final Episode 13)
+0 Vote Up -0Vote Down

Welcome to the final – but most important – episode in the MySQL QA Series.

In it, I present my vision for all MySQL Quality Assurance – for all distributions – worldwide.

Episode 13: A Better Approach to all MySQL Regression, Stress & Feature Testing: Random Coverage Testing & SQL Interleaving

1. pquery Review
2. Random Coverage Testing
3. SQL Interleaving
4. The past & the future

Presented by Roel Van de Paar. Full-screen viewing @ 720p resolution recommended

Interested in the full MySQL QA Series?

The …

  [Read more...]
MySQL QA Episode 12: My server is crashing… Now what? For customers or users experiencing a crash
+0 Vote Up -0Vote Down

My server is crashing… Now what?

This special episode in the MySQL QA Series is for customers or users experiencing a crash.

  1. A crash?
    1. Cheat sheet:
    2. Sever install & crash. Note this is as a demonstration: do not action this on a production server!
      sudo yum install -y
      sudo yum install -y Percona-Server-client-56 …

  [Read more...]
MySQL QA Episode 11: Valgrind Testing: Pro’s, Con’s, Why and How
+0 Vote Up -0Vote Down

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 a regular or semi-regular basis.

  1. Pro’s/Why
  2. Con’s
  3. How
    1. Using the latest version
      sudo [yum/apt-get] install valgrind
      sudo [yum/apt-get] remove valgrind
      sudo [yum/apt-get] install bzip2 glibc*
      tar -xf valgrind-3.10.1.tar.bz2; cd valgrind-3.10.1

  [Read more...]
MySQL QA Episode 10: Reproducing and Simplifying: How to get it Right
+0 Vote Up -0Vote Down

Welcome to the 10th episode in the MySQL QA series! Today we’ll talk about reproducing and simplifying: How to get it Right.

Note that unless you are a QA engineer stuck on a remote, and additionally difficult-to-reproduce or difficult-to-reduce bug, this episode will largely be non-interesting for you.

However, what you may like to see – especially if you watched episodes 7 (and possibly 8 and 9) – is how reducer automatically generates handy start/stop/client (cl) etc. scripts, all packed into a handy bug tarball, in combination with the reduced SQL testcase.

This somewhat separate part is covered …

  [Read more...]
Multi-source replication in MySQL 5.7 vs Tungsten Replicator
+0 Vote Up -0Vote Down

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 months I’ve been playing a lot with this trying to analyze its potential in a real case that I’ve been facing while working with a customer.

This was motivated because my customer is already using multi-sourced slaves with Tungsten Replicator and I wanted to do a side-by-side comparison between Tungsten Replicator and Multi-source Replication in MySQL 5.7

Consider the following scenario:

  [Read more...]
MySQL QA Episode 9: Reducing Testcases for Experts: multi-threaded
+0 Vote Up -0Vote Down

Welcome to MySQL QA Episode 9. This episode will go more in-depth into Reducing Testcases for Experts: multi-threaded

We will explore how to use to do true multi-threaded testcase reduction – a world’s first.


  1. Expert configurable variables & their default settings

  [Read more...]
Showing entries 1 to 10 of 426 10 Older Entries

Planet MySQL © 1995, 2015, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.