At MariaDB Foundation, we are proud of MariaDB Server getting plenty of contributions. But we don’t want to get cocky, so here is an update about where we stand, and what we want to make happen. First, we have shown our contribution pride in several places. On 15 February 2019, I tweeted On code contributions, […]
The post On Contributions, Pride and Cockiness appeared first on MariaDB.org.
As continue of our previous announcement from March 14, please find below a list of shows & conferences where you can find MySQL team at:
June 2019:
OpenSource Conference, Hokkaido, Japan, May 31-June 1, 2019
Q: Validate an instance for MySQL InnoDB Cluster usage?
A: Use check_instance_configuration()
The world seems awash in unstructured, NoSQL data, mainly of the
JSON variety. While this has a great many benefits as far
as data mutability and not being locked into a rigid structure
there are some things missing that are common in the structured
world of SQL databases.
What if there was a way to take this unstructured NoSQL JSON data
and cast it, temporarily, into a structured table? Then you
could use all the processing functions and features found in a
relation database on you data. There is a way and it is the
JSON_TABLE function.
JSON_TABLE
You can find the documentation for JSON_TABLE here but there are some examples below
that may make learning this valuable function easier than the
simple RTFM.
I will be using the world_x dataset for the next example
If …
Monitoring MySQL server has never been an easy task. Monitoring also needs to go through many Complex and difficult queries to get the details.
All these problems can be overcome by an excellent command line monitoring tool called “Innotop”. Innotop comes with many features and different types of modes/options, which helps to monitor different aspects of MySQL (InnoDB) performance and also helps database administrator to find out what’s wrong going with MySQL server. Innotop helps in monitoring user statistics, mysql replication status,query list, InnoDB I/O informations etc. Another important thing about innotop is it refreshes the data continuously , so we can view realtime statistics.
Innotop is one of the designed based on top utility for linux.
…[Read more]It's our pleasure to mention 2 shows we are supporting & attending this week. They are: PHPTek19, May 21-23, 2019, Atlanta, US. MySQL Community team is again a proud sponsor of this great event.
The second show is OpenSUSE, May 24-26, 2019 in Nuremberg, Germany where MySQL is a Silver sponsor with a MySQL booth in the expo area. We will be happy to hear feedback, answer your questions and have discussion with you @OpenSUSE.
Introduction
We are well aware that ProxySQL is one of the leading SQL aware proxy for MySQL. In this blog I am going to explain the backup & restore strategies of the ProxySQL . I think, still there is not well structured blog about this topic .
If you are looking for other articles on our ProxySQL Series :
[Read more]
ERROR 1040 (HY000): Too many connections
An application might face this issue when all the defined
max_connections parameter value is exhausted.
mysqld reserve a +1 connection (i.e., max_connections + 1)
for the user who is having the SUPER privilege.
When this issue appears, Only the user with the SUPER privileges
can be connected if any other user who has SUPER privileges is
not already connected to the database and we have reached
max_connections.
1. Always make sure to DON'T give the SUPER privilege to any application user or any user which is being used inside the scripts. Because if that user has …
[Read more]
NOTE [2019-05-18]: Debian/Ubuntu
5.6.44-85.0-1 packages were replaced today in the
repositories with the 5.6.44-85.0-2 because they
would reset the root password to an empty string during the
upgrade on Debian/Ubuntu (bug #5640). If you upgraded packages on Debian/Ubuntu
to the 5.6.44-85.0-1 please upgrade to
5.6.44-85.0-2 and re-set your root password.
Percona announces the release of Percona Server for MySQL 5.6.44-85.0 on May 17, 2019. Download the latest version from the Percona web …
[Read more]
So, typically, a Percona Live (or MySQL User) Conference blog
would start off with some mention of the fact that it’s great to
be meeting up again in Santa Clara, California, the birthplace of
the MySQL User Conference, and a continuous fixture on the yearly
MySQL community agenda.
But no, not this time!
On this occasion, the Percona Live Conference blog starts off by
pointing out that for the first time since its inception (as far
as I can recollect), the MySQL User Conference, i.e. Percona Live
Conference (in North America) doesn’t take place in Santa Clara,
but rather in Austin, Texas.
Never having been to Texas before myself, I’m looking forward to
that innovation, discovering the new surroundings and seeing
whether that changes anything or not to the familiar “feel” of a
Percona Live / MySQL User Conference.
By the way, there’s still time to …
