Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 34763 10 Older Entries
VividCortex Live Demo
+0 Vote Up -0Vote Down

Have you been considering VividCortex but putting off a free trial? Are you a user who wants to get the most of the product? Are you a huge fan who simply wants to hear the brains behind the product give you the inside scoop?

Join us on Tuesday, September 15 at 2 p.m. ET (6 p.m. GMT), for a live walk through of VividCortex on production systems from our CEO, Baron Schwartz. He will use the product to demonstrate the following:

  • Using our top queries feature to quickly find queries that need attention
  • Finding and diagnosing stalls with …
  [Read more...]
MYSQL_HISTFILE and .mysql_history
+0 Vote Up -0Vote Down

The MySQL manual says:
"mysql Logging
On Unix, the mysql client logs statements executed interactively to a history file. By default, this file is named .mysql_history in your home directory. To specify a different file, set the value of the MYSQL_HISTFILE environment variable."
The trouble with that is: it doesn't tell you what you don't need to know. So I'll tell you.

Heritage

The history-file concept that MySQL and MariaDB are following is indeed "on Unix" and specifically is like the …




  [Read more...]
Is mysql/innodb good for high volume inserts?
+0 Vote Up -0Vote Down

As we are collecting an ever increasing amount of data and analyzing it, data storage products with alternate file structure have become popular, such as LSMs (log structured merge file) which is implemented in Cassandra and Hbase, as well as fractal indexes found in TokuDB/MX, which is a alternate file structure plugin for mysql and [...]

Inspecting All The Metrics With VividCortex
+0 Vote Up -0Vote Down

Someone asked me the other day about some of the more obscure metrics available from a database server’s internals, and wanted access to those. As it happens, we have a feature that lets you see every metric on your systems—yes, every metric, which is typically many thousands, sometimes millions.

First, though, let’s look at what this user was examining. We ship VividCortex with a prebuilt set of templates for graphing popular systems, to reduce time-to-insight as much as possible. (No more Google searching for good graph templates and fighting to get them installed!) They look like this:

There’s quite a variety of templates, dozens for …

  [Read more...]
MySQL 5.6 to 5.7 Upgrade Warning
Employee +1 Vote Up -0Vote Down

The MySQL 5.7.8 Release Candidate was released August 3rd. But before you upgrade, be sure to read how to upgrade from 5.6 to 5.7 PLEASE.

Yes, you need to make a backup (or three or four).

Be sure to run mysql_upgrade after starting the 5.7 binary. There are some changes to tables that must be made and this is the way to do it.

The …

  [Read more...]
Quickly tell who is writing to a MySQL replica
Employee +2 Vote Up -0Vote Down

Many of us have been there in the past, you get an alert telling you that replication has stopped because of an error, you dig in to it to find that you’re getting an error for an update event that is trying to update a non-existent row, or a duplicate key error because the row ID for some INSERT already exists.

Even with the server set to read only (and not using the new super_read_only variable from MySQL 5.7.8), these problems can still happen – how many of you have seen over-zealous ops trying to “quickly …

  [Read more...]
NDB 7.4 & SYS schema: When getting locks, detecting the guilty SQL & o.s.pid.
Employee +1 Vote Up -0Vote Down

Here’s a way to detect the sql query causing a lock or a session to fail, and also to identify the o.s.pid if need be (btw, no rocket science). “a” way.. I’m sure there are many others, so feel free to suggest, please.

So, we’re using MCM, and have created a MySQL Cluster like mentioned in the cluster intro session (in Spanish I’m afraid), using 7.4.6, which comes with 5.6.24.

With the env up and running, set up a schema, some data and run a few queries:

mysql> create database …
  [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
      #OR#
      sudo [yum/apt-get] remove valgrind
      sudo [yum/apt-get] install bzip2 glibc*
      wget http://valgrind.org/downloads/valgrind-3.10.1.tar.bz2
      tar -xf valgrind-3.10.1.tar.bz2; cd valgrind-3.10.1







  [Read more...]
On SHOW BINLOG/RELAYLOG EVENTS
+1 Vote Up -0Vote Down

Some notes after working with SHOW BINLOG EVENTS and SHOW RELAYLOG EVENTS statements; there are a few gotchas and some interesting facts. My reflections also follow.

I'm calling these commands from orchestrator when working with Pseudo-GTID (which I do alot). I …

  [Read more...]
Yet another MySQL 5.7 silent change
+0 Vote Up -0Vote Down

When a new version of MySQL appears, the first source of information for the brave experimenter is a page in the manual named What is new in MySQL X.X, also known as MySQL in a nutshell. For MySQL 5.7, the in-a-nutshell page lists quite a lot of changes. In that page, the list of removed features is enough to send a chill down the spine of most any DBA. Some of the items in the …

  [Read more...]
Showing entries 1 to 10 of 34763 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.