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 …

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 …

Year 2015 was a good year for proxies in MySQL environments. First, MariaDB released a GA version of MaxScale, a new proxy that understands MySQL Replication and Galera topologies and supports read-write splitting. Later in the year, at Percona Live Europe in Amsterdam, ProxySQL was announced as GA by its creator, René Cannaò.

ProxySQL was created for DBAs by René, himself a DBA trying to solve issues when working with complex replication topologies.

In this blog, we’ll give you an overview of ProxySQL, and show you how to install and configure it.

Installation of ProxySQL

Initial installation is pretty simple - all you need to do is grab the latest binaries from the site:

https://github.com/sysown/proxysql/releases/ …

Mon, 2016-03-07 07:49massimiliano_pinto_gMaxScale as a replication proxy, aka the Binlog Server

In database setups with a large number of users reading data, the Binlog Server can be used to offload traffic to the Master, make Master failover easier to handle and in general simplify replication. In this blog I will describe the benefits of Binlog Server and how to set up MaxScale as a Binlog Server.

In a traditional MariaDB/MySQL replication setup a single master server is created and a set of slaves of MariaDB/MySQL servers are configured to pull the binlog files from the master, putting a lot of load on the master. Introducing a layer between the master server and the slave servers can reduce the load on the master by only serving MaxScale’s Binlog Server instead of all the slaves. The slaves will only need to be aware of the Binlog Server and not the real master server. Removing the requirement for the slaves to have knowledge …