open source databases

This Week in Data with Colin Charles 32: Stack Overflow Developer Survey, SCALE16x and Interesting MySQL 8 Version Numbers

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.
SCALE16x is over. Percona had a large showing — both Peter Zaitsev & myself had talks, and the booth in the expo hall saw Rick Golba, Marc Sherwood, and Dave Avery also pop by. The lead […]

Read more

This Week in Data with Colin Charles 28: Percona Live, MongoDB Transactions and Spectre/Meltdown Rumble On

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.
In case you missed last week’s column, don’t forget to read the fairly lengthy FOSDEM MySQL & Friends DevRoom summary.
From a Percona Live Santa Clara 2018 standpoint, beyond the tutorials getting picked and scheduled, […]

Read more

Webinar Thursday, February 15, 2018: Basic Internal Troubleshooting Tools for MySQL Server

Troubleshooting Tools

Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents “Basic Internal Troubleshooting Tools for MySQL Server” on Thursday, February 15, 2018, at 10:00 am PST (UTC-8) / 1:00 pm EST (UTC-5).
Register Now
 
MySQL Server has many built-in troubleshooting tools. They are always available and can provide many insights on what is happening internally. […]

Read more

Announcing Experimental Percona Monitoring and Management (PMM) Functionality via Percona Labs

Percona Monitoring and Management

In this blog post, we’ll introduce how you can look at some experimental Percona Monitoring and Management (PMM) features using Percona Labs builds on GitHub.
Note: PerconaLabs and Percona-QA are open source GitHub repositories for unofficial scripts and tools created by Percona staff. While not covered by Percona support or services agreements, these handy utilities […]

Read more

Four Ways MySQL Executes GROUP BY

MySQL GROUP BY

In this blog post, I’ll look into four ways MySQL executes GROUP BY. 
In my previous blog post, we learned that indexes or other means of finding data might not be the most expensive part of query execution. For example, MySQL GROUP BY could potentially be responsible for 90% or more of the query execution time. 
The […]

Read more

MySQL 8.0 RESOURCE_GROUP Overview

MySQL 8.0 innodb_dedicated_server

In this blog post, we’ll provide an overview of the new MySQL 8.0 RESOURCE_GROUP feature.
One great new feature introduced in MySQL 8.0 that – from my point of view – requires attention is RESOURCE_GROUP.
Short disclaimer: I want to point out that MySQL 8.0 is not GA yet, so it is possible for the MySQL 8.0 RESOURCE_GROUP […]

Read more

Webinar Thursday, January 25, 2018: Troubleshooting MySQL Crashes

MySQL Crashes

Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents Troubleshooting MySQL Crashes on January 25, 2018, at 10:00 am PST (UTC -8) / 1:00 pm EST (UTC -5).
Register Now
 
This webinar is for every MySQL user! In this talk, I won’t focus on how to analyze core files, read the source code or […]

Read more

Percona Server for MongoDB 3.6 Beta is now available

Percona Server for MongoDB

Percona is pleased to announce the release of Percona Server for MongoDB 3.6.1-1.0beta on January 23, 2018. Download the latest version from the Percona web site or the Percona Software Repositories.
NOTE: This version is considered BETA quality, and is not intended for use in production. Beta packages are available from testing repository.
Percona Server for MongoDB is an enhanced, open source, […]

Read more

Webinar Wednesday, January 24, 2018: Differences between MariaDB and MySQL

MariaDB and MySQL

Join Percona’s Chief Evangelist, Colin Charles as he presents Differences Between MariaDB and MySQL on Wednesday, January 24, 2018, at 7:00 am PST (UTC -8) / 10:00 am EST (UTC -5).
Register Now

Tags: MariaDB, MySQL, Percona Server for MySQL, DBA, SysAdmin, DevOps
Experience Level: Novice
MariaDB and MySQL. Are they syntactically similar? Where do these two query languages […]

Read more

This Week in Data with Colin Charles 22: CPU vulnerabilities and looking forward to 2018

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.
Happy New Year. Here’s to 2018 being a great year in the open source database world. What is in store for us? Probably: MySQL 8.0 and MariaDB Server 10.3 as generally available. What will we […]

Read more