Showing entries 71 to 80 of 37125
« 10 Newer Entries | 10 Older Entries »
Fun with Bugs #46 - On Some Bugs I've Reported During the Year of 2016

It's time to summarize the year of 2016. As a kind of a weird summary, in this post I'd like to share a list of MySQL bug reports I've created in 2016 that are still remaining "Verified" today:

  • Bug #79831 - "Unexpected error message on crash-safe slave with max_relay_log_size set". According to Umesh this is not repeatable with 5.7. The fact that I've reported the bug on January 4 probably means I was working at that time. I should not repeat this mistake again next year.
  • Bug #80067 - "Index on BIT column is NOT used when column name only is used in WHERE clause". People say the same problem happens with INT and, what may be even less expected, BOOLEAN columns.
[Read more]
The MyRocks community in 2016

The MyRocks community grew in 2016 with significant contributions from early evaluators. I appreciate their help and have been busy documenting the problems that they reported. I look forward to more contributions in 2017.

MariaDB Corporation and Percona announced plans to include MyRocks in their distributions. You will be able to get MyRocks with expert support. Equally big have been the contributions from Sergey Pertunya to MyRocks.

The MySQL team at Alibaba reported poor performance from range scans with sysbench. The problem was memory system contention on a performance counter and the fix made long range scans 2X faster on concurrent workloads.

I have been using sysbench more and …

[Read more]
Testing MySQL/MariaDB/Percona versions with Docker

Giuseppe Maxia has provided some great MySQL docker images. Percona and MariaDB also provide version via Docker Hub. In an attempt to have a consistent means of launching these different images I created the following convenience functions.

  1. Install docker for your OS. See Official Docker installation instructions.
  2. Get dockerhelper.sh
  3. Run your desired variant and version.

$ wget https://raw.githubusercontent.com/ronaldbradford/mysql-docker-minimal/master/dockerhelper.sh
$ . ./dockerhelper.sh
Docker …
[Read more]
MariaDB's Columnar Store

I have been keeping an eye on MariaDB's Columnar store progress for a bit longer then half a year.

MariaDB chose to take the infinidb code after Calpoint closed shop about two years ago and implemented it into their product. I was a bit wary about infinidb as well as it was a columnar store without compression that had mixed reviews on news hacker.

However, it seems like MariaDB have pulled it off. They have added the infinidb engine to MariaDB with all its quirks and extra commands and they have added snappy compression as well. This is truely a huge win for them and their users, specifically in the area of reporting and analytics.

Here are two real life examples for getting data ready for reporting currently happening in the wild:
1) MySQL -> Sqoop -> Hadoop - where you would need a) 5-6 additional servers, …

[Read more]
Log Buffer #500: A Carnival of the Vanities for DBAs

As the festive season starts, bloggers across Oracle, SQL Server, and MySQL have been producing some sparkling blog posts. This Log Buffer Edition highlights a few of them this week.

Oracle:

Spencer McGhin blogs about Python for Analytics – Exploring Data with Pandas.

Say writes on Automated Deployment to SOA Cloud Services using Developer Cloud Services.

Kent Graziano gets an early Christmas as newest version of Oracle (#SQLDev) SQL Developer Data Modeler …

[Read more]
Query Language Type Overview

This blog provides a query language type overview.

The idea for this blog originated from some customers asking me questions. When working in a particular field, you often a dedicated vocabulary that makes sense to your peers. It often includes phrases and abbreviations because it’s efficient. It’s no different in the database world. Much of this language might make sense to DBA’s, but it might sound like “voodoo” to people not used to it. The overview below covers the basic types of query languages inside SQL. I hope it clarifies what they mean, how they’re used and how you should interpret them.

DDL (Data Definition Language)

A database schema is a visualization of information. It contains the data structure separated by tables structures, views and anything that contains structure …

[Read more]
pre-Fosdem’17 MySQL Day

Oracle’s  MySQL Community Team is organizing a pre-Fosdem MySQL Day on Friday 3rd February 2017.

The event is free (like in beer) for all participants but as seating is limited, registration is required.

Come to meet MySQL engineers and listen to them talking about new MySQL 8.0’s features. Some of Percona’s experienced staff will also deliver some talks on troubleshooting, architecture, …

And finally, Booking.com will also share their user experience with the audience.

What else to start the Fosdem Week-end in the best way ?

Agenda and registration can be found on lefred’s blog !

Pre-Fosdem’17 MySQL Day

This year, I’ve the honor to organize just before the FOSDEM MySQL & Friends Devroom an extra pre-FOSDEM MySQL Day. This MySQL Day will take place the Friday just before FOSDEM’s week-end.

During that day, we will highlight MySQL 8.0 new features but not only.

Oracle’s MySQL Community Team is sponsoring this event. Seating is limited, so please register.

The event is free and the location is the same as the very popular MySQL & Friends Community Dinner.

You can register now on eventbrite.

This is the agenda:

Start End Event Speaker Company Topic …
[Read more]
Percona Live Featured Tutorial with Øystein Grøvlen — How to Analyze and Tune MySQL Queries for Better Performance

Welcome to another post in the series of Percona Live featured tutorial speakers blogs! In these blogs, we’ll highlight some of the tutorial speakers that will be at this year’s Percona Live conference. We’ll also discuss how these tutorials can help you improve your database environment. Make sure to read to the end to get a special Percona Live 2017 registration bonus!

In this Percona Live featured tutorial, we’ll meet Øystein Grøvlen, Senior Principal Software Engineer at Oracle. His tutorial is on How to Analyze and Tune MySQL Queries for Better Performance. SQL query …

[Read more]
Checking disk activity using iostat

I often use a monitoring system to look at disk activity, but sometimes it’s nice to have a CLI tool to get stats in a different format. I use iostat(1) for that. iostat has a bunch of different options, but I usually stick to iostat -dxy.

Here’s the description for each option (from the man page):

-d     Display the device utilization report.
-x     Display extended statistics.
-y     Omit first report with statistics since system boot, if displaying multiple records at given interval.

Example output:

$ iostat -dxy 1
Linux 4.4.0-53-generic          12/28/2016      _x86_64_        (1 CPU)

Device:         rrqm/s   wrqm/s     r/s     w/s    rkB/s    wkB/s avgrq-sz avgqu-sz   await r_await w_await  svctm  %util
vda               0.00     0.00    0.00    9.90     0.00    39.60     8.00     0.00    0.00    0.00    0.00   0.00   0.00 …
[Read more]
Showing entries 71 to 80 of 37125
« 10 Newer Entries | 10 Older Entries »