Introduction

This blog is a follow up to my original blog in https://blog.mariadb.org/performance-evaluation-of-mariadb-10-1-and-mysql-5-7-4-labs-tplc/ . First of all I would like to thank for all the comments I received. Based on the comments there was a concern if the differences seen on performance was due to different configuration setup. Furthermore, I did not know that there was a configuration variable to get similar multi-threaded flush mechanism on MySQL as there is on MariaDB. To find out if the different configuration variables or different defaults were the reason for different performance, I ran several rounds of new tests.

Test 1

Changing number of buffer pool instances or value of innodb thread concurrency do not seem to have significant effect on at least LinkBench benchmark …

Disclaimer: I’m not specially an expert of benchmarking, this post is to compare different options. All comments and advices are welcome.

I’m not telling you anything new, the show processlist command is a fantastic command line tool for instant check.
But what about monitor your databases with this command embedded in a tool?

Just have a look at this graph:

With 5K queries per seconds, how much will be hidden with a show processlist executed every seconds? Probably a lot.
So, I wanted to test which alternatives could be efficient to retrieve all the queries during a time lapse.

Test procedure and configuration

I used sysbench 0.5 (with oltp.lua) to make my tests on different configurations and …

Below are some of the common scenarios where information_schema is useful :

Tables table

How to check the database size using information_schema ?

SELECT table_schema "Data Base Name", SUM( data_length + index_length) / 1024 / 1024 
"Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;

How to list the tables created before 4 days ?

select * from information_schema.tables where CREATE_TIME < NOW() - INTERVAL 4 DAY ;

Columns table :

List all the tables that have a column called birth_date

select table_name from information_schema.columns where table_schema='employees' and column_name='birth_date';

List all tables without primary/unique key:

select 
    table_schema,table_name 
from  
    information_schema.columns  
group by 
    table_schema,table_name   
having 
    sum(if(column_key in ('PRI','UNI'), …

It can also work without needing to give Full access on S3.
http://bugs.mysql.com/bug.php?id=73615

And if you're going to use a non-US bucket you might hit this bug:
http://bugs.mysql.com/bug.php?id=73616

This post walks through some examples of using the geospatial functions provided by MySQL and Sphinx. Enjoy! Getting Started First of all, here are some helpful resources: We wrote about geospatial search with Sphinx in this blog post. It has a more Sphinx-specific focus than this post. Alexander Rubin wrote these helpful articles: “Creating Geo [...]

Dear MySQL Users,

The MySQL developer tools team announces 6.2.2 RC – the final release
candidate for MySQL Workbench 6.2.

MySQL Workbench 6.2 is the upcoming major update for the official MySQL
graphical development tool .

MySQL Workbench 6.2 focuses on support for innovations released in MySQL
5.6 and MySQL 5.7 DMR (Development Release) as well as MySQL Fabric 1.5,
with features such as:

• A new spatial data viewer, allowing graphical views of result sets
  containing GEOMETRY data and taking advantage of the new GIS
  capabilities in MySQL 5.7.
• Support for new MySQL 5.7.4 SQL syntax and configuration options.
• Metadata Locks View shows the locks connections are blocked or waiting
  on.
• MySQL Fabric cluster connectivity – Browsing, view status, and connect
  to any MySQL instance in a Fabric Cluster. …

The MySQL developer tools team announces 6.2.2 RC – the final release candidate for MySQL Workbench 6.2.

MySQL Workbench 6.2 is the upcoming major update for the official MySQL 
graphical development tool .

MySQL Workbench 6.2 focuses on support for innovations released in MySQL 5.6  and MySQL 5.7
DMR (Development Release) as well as MySQL Fabric 1.5, with features such as:

• A new spatial data viewer, allowing graphical views of result sets containing GEOMETRY data and
   taking advantage of the new GIS capabilities in MySQL 5.7.
• Support for new MySQL 5.7.4 SQL syntax and configuration options.
• Metadata Locks View shows the locks connections are blocked or waiting on.
• MySQL Fabric cluster connectivity – Browsing, view status, and connect to any MySQL instance in a 
  Fabric Cluster. …

Fri, 2014-09-05 19:57Marc Sherwood

We all know that persistence is a virtue. But with databases, persistence is everything! Thats why Red Hat and MariaDB have teamed up to embed MariaDB at the heart of OpenStack.

Sign up now for your seat at the webinar!

Tuesday, September 9 at 15:00 UTC
(8am Los Angeles, 11am New York, 5pm Paris)

The power of MariaDB, coupled with highly-available Galera multi-master, synchronous, clustering is an unbeatable foundation on which to build OpenStack. That’s why Red Hat Enterprise Linux OpenStack Platform leverages MariaDB and Galera as a building-block for all of its services; a natural next step to Red Hat making MariaDB the default MySQL-compatible database in RHEL.

Want to learn more? …

As one writes code, the mind changes state over time adding code artifacts to the brain's short-term and long-term memory.  Having every line of code memorized would be perfect for a programmer's brain  to work on code.    Only at first blush.  Maybe even better is to have the entire call graph memorized.  Well, even better than having all code memorized and the call graph memorized, is to have all possible states the computer will move through memorized as well.  So on and so forth.  One could imagine a graph or set of graphs indicating the amount of programmer memory (PM) on a project.

It's this programmer memory that benefits projects.  A project with low PM will take longer to implement and probably be more bug-ridden.   There's probably a real positive correlation between a programmer's experience on the project and PM.  So programmer experience on the project is …

Percona is glad to announce the new release of Percona XtraDB Cluster 5.5 on September 5th 2014. Binaries are available from downloads area or from our software repositories.

Based on Percona Server 5.5.39-36.0 including all the bug fixes in it, Galera Replicator 2.11, and on …