In this blog post, we’ll discuss JSON document fast lookup with MySQL 5.7.

Recently I attended Morgan Tocker’s talk on MySQL 5.7 and JSON at FOSDEM, and I found it awesome.

I learned some great information from the talk. Let me share one of them here: a very useful trick if you plan to store JSON documents in your MySQL database and want to retrieve the documents from some attribute’s values. So let’s look at how to do JSON document fast lookup with MySQL 5.7!

In this short example, I show you how we can speed up this type of search using JSON functions and virtual columns.

This our test table:

Table: test_features
Create Table: CREATE TABLE …

TL;DR summary: sysbench development has slowed down over the last years, resulting in users looking for workarounds for missing features and limitations. However, things are going to change with more active development and many features and fixes planned for the next version. This is the first post in a series to describe all those improvements.

sysbench started as an ad-hoc project inside the High Performance team in MySQL AB. In fact, the very first version was a single large C source file Peter Zaitsev sent me when I had to look into a Linux kernel 2.6 regression (TODO: find that email for my memoirs when I retire).

The original version didn't have all the features I needed for that task, so I started hacking on it, adding the missing bits and refactoring the code to simplify adding new features. …

TL;DR summary: sysbench development has slowed down over the last years, resulting in users looking for workarounds for missing features and limitations. However, things are going to change with more active development and many features and fixes planned for the next version. This is the first post in a series to describe all those improvements.

sysbench started as an ad-hoc project inside the High Performance team in MySQL AB. In fact, the very first version was a single large C source file Peter Zaitsev sent me when I had to look into a Linux kernel 2.6 regression (TODO: find that email for my memoirs when I retire).

The original version didn't have all the features I needed for that task, so I started hacking on it, adding the missing bits and refactoring the code to simplify adding new features. …

TL;DR summary: sysbench development has slowed down over the last years, resulting in users looking for workarounds for missing features and limitations. However, things are going to change with more active development and many features and fixes planned for the next version. This is the first post in a series to describe all those improvements.

sysbench started as an ad-hoc project inside the High Performance team in MySQL AB. In fact, the very first version was a single large C source file Peter Zaitsev sent me when I had to look into a Linux kernel 2.6 regression (TODO: find that email for my memoirs when I retire).

The original version didn't have all the features I needed for that task, so I started hacking on it, adding the missing bits and refactoring the code to simplify adding new features. …

If you read my last In Brief post, you may have tried setting up a cron job to run mysqldump nightly, gone back to check the results the following day and found a zero byte file where you expected to see a dumpfile.

-rw-rw-r--  1 forge forge    0 Mar  5 00:00 dump-nightly.sql

Don't worry! The backup still ran, but Forge does some auto-magic output redirection that had me guessing for a little while.

The Magic Of 2>&1

When I saw that my sql file was zero-length, I started trying to track down what went wrong. First stop was Forge's log file for the job in the web console. Viewing this showed that mysqldump had run just fine.

-- MySQL dump 10.13  Distrib 5.7.10, for Linux (x86_64)
--
-- Host: localhost    Database: 
-- …

you use sql where exists clause in laravel whereExists through you can use sql where exists clause in your laravel project It is very easy to use and you can easily undestand You can give SELECT statment in where condition you can see bellow example and you can learn how to use whereExists in yo

Percona is pleased to announce the availability of Percona Toolkit 2.2.17.  Released March 7, 2016. Percona Toolkit is a collection of advanced command-line tools to perform a variety of MySQL server and system tasks that are too difficult or complex for DBAs to perform manually. Percona Toolkit, like all Percona software, is free and open source.

This release is the current GA (Generally Available) stable release in the 2.2 series. It includes multiple bug fixes for pt-table-checksum with better support for Percona XtraDB Cluster, various other fixes, as well as MySQL 5.7 general compatibility. Full details are below. Downloads are available  …

The Percona Live Data Performance Conference in Santa Clara is being held April 18-22, 2016. It is quickly approaching, and Pythian is going to show you how we Love Your Data in a big way!

We have an awesome lineup of speakers this year:

• Alkin Tezuysal, Okan Buyukyilmaz, and Emanuel Calvo will be presenting the Break/Fix Lab tutorial. This is becoming a standard so if you haven’t had the opportunity to participate, don’t miss it!
• Christos Soulios will be presenting a tutorial on MongoDB design patterns with Pythian alum Nik Vyzas and Percona’s Roman Vynar.
• Derek …

Percona is glad to announce the release of Percona Server 5.6.29-76.2 on March 7, 2016. Download the latest version from the Percona web site or from the Percona Software Repositories.

Based on MySQL 5.6.29, including all the bug fixes in it, Percona Server 5.6.29-76.2 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source and free …

While looking to optimize your MySQL, you are needing to spot slow/bad queries at a glance and get deep insights about them with ease.

The latest update of MONyog brings new easier ways to find problem SQL in Real-Time, Wayback Machine and sniffer based Query Analyser using Performance Schema. Here is what’s new:

Query Execution Status and Full Table Scan Count
View success/failure status of every query executed and also the number of ‘full table scans’ for queries in a single glance.

The latest update also has an option to switch between Performance Schema and Processlist in Real-Time making it easy for you to enable/disable Performance Schema or Processlist.

Get the latest update now to enjoy these features.Existing customers can download MONyog 6.52 from Customer Area. To evaluate MONyog 6.52, please …