The Call For Papers (CFP) for Percona Live 2020 is now open!

DEADLINE EXTENDED TO WEDNESDAY, January 22.

Percona Live will be held in Austin, Texas from Monday, May 18 through Wednesday, May 20, 2020 at a new venue, the AT&T Hotel and Conference Center. The CFP is open for submissions from November 27, 2019, through January 13  22, 2020. We invite abstracts covering any and all aspects of open source databases, including on-premise, in the cloud, and across the multi-verse!

Hot Open Source Topics for 2020

All Open Source database themes are welcome, but these are our hot topics for 2020:

• Success in the multi-verse: How to optimize performance, architecture, high-availability, replication, and …

MySQL does its best to return requested bytes as fast as possible. However, it needs human help to identify what is important and should be accessed in the first place. Queries, written smartly, can significantly outperform automatically generated ones. Indexes and Optimizer statistics, not limited to the Histograms only, help increase the speed of the query.

Join Percona’s Principal Support Engineer for MySQL Sveta Smirnova on Thurs, Dec 5th from 10 to 11 am PST to learn how MySQL query performance can be improved through the utilization of Developer and DevOps tools. In addition, you’ll learn troubleshooting techniques to help identify and solve query performance issues.

Register Now

If you can’t attend, sign up …

Geo-scale MySQL – or how to build a global, multi-region MySQL cloud back-end capable of serving several hundred million player accounts

This blog introduces a series of blogs we’ll be publishing over the next few months that discuss a number of different customer use cases that our solutions support and that centre around achieving continuous MySQL operations with commercial-grade high availability (HA), geographically redundant disaster recovery (DR) and global scaling.

This first use case looks at a customer of ours who are a global gaming company with several hundred million world-wide player accounts.

What is the challenge?

How to reliably, and fast, cater to hundreds of millions of game players around the world? The challenge here is to serve a game application for a geographically-distributed audience; in other words, a pretty unique challenge.

It requires fast, local response times …

Author: Robert Agar

MySQL is one of the most popular and widely used database platforms in the world. If you are a DBA or database developer, there is a very high probability that at least some of the systems under your purview are powered by MySQL. The standard tasks such as user administration and ensuring that the databases are backed up and can be restored are important facets of your daily responsibilities. You will also be charged with maintaining a high level of performance that addresses the concerns of the database’s users.

Creating backup jobs and setting up new user accounts are fairly straightforward tasks that should not be overly challenging to an experienced DBA. Even if you do not have extensive experience with MySQL, you will very quickly become comfortable with any idiosyncrasies that the platform presents. Performance tuning, on the other hand, can be a complicated undertaking. It can …

Hello dear MySQL Community ! As you know FOSDEM 2020 will take place February 1st and 2nd. After having received many, many requests we decided to organize for the 4th year in a row the pre-FOSDEM MySQL Day… with a big change, for this edition the event will be called “pre-FOSDEM MySQL Days” !

We have decided to extend that extra day related to the world’s most popular open source database to 2 days: 30th and 31st of January at the usual location in Brussels.

We will also have the usual sessions track but most probably a second room for those who would like to get their hands dirty in the code !!

Please don’t forget to register as soon as possible as you may already know, the seats are limited !

Register on eventbrite: …

Hi Vitor,

Thanks. Yes, the source code for the report was written for Python 2.7 that was used in MySQL Shell 8.0.17 and earlier. But MySQL Shell upgraded Python to version 3.6, so some changes in the report are required. I have updated the blog to work with MySQL Shell 8.0.18 and later.

Best regards,
Jesper

Today, we will cover a totally different MySQL Shell plugin: InnoDB.

Currently only 3 methods have been created:

Those related to the Table space fragmentation, have already been covered in this recent article.

Let’s discover the getAlterProgress()method. This method allows us to have an overview of the progress of some alter statements status like:

• stage/innodb/alter table (end)
• stage/innodb/alter table (flush)
• stage/innodb/alter table (insert)
• stage/innodb/alter table (log apply index)
• stage/innodb/alter table (log apply table)
• stage/innodb/alter table (merge sort)
• stage/innodb/alter table (read PK and internal sort)
• stage/innodb/alter tablespace (encryption)

This is an output of the method:

As …

Hi,

I got this error on startup log:

2019-11-29 21:48:59: Error: Error loading Python file ‘C:\Cmder\bin\oracle\clients\mysqlsh\init.d\sessions.py’:
Execution failed:
Traceback (most recent call last):
File “sessions.py”, line 75, in
SystemError: TypeError: Shell.register_report: Option ‘values’ is expected to be of type Array, but is String

Any tips? 🙂

best regards
Vitor Jr.

As follow up to the regular shows announcements, we would like to inform you about places & shows where you can find MySQL Community team or MySQL experts at during December to February timeframe. Please find the list below:

December 2019:

• UKOUG Tech Fest, Brighton, UK, December 1-4, 2019

  • Oracle is having a big booth at this show, however this time MySQL is not part of this. Instead David Stokes, the MySQL Community Manager has a MySQL talk on "MySQL 8.0" scheduled for December 2nd @16:45-17:30. Please see the schedule.
• …

Presentation of some of the new features of MySQL 8.0.18 released on October 14, 2019.

The post MySQL 8.0.18 New Features Summary first appeared on dasini.net - Diary of a MySQL expert.