War story of the day: do not use — or be very careful when using — the max_connections beta database flag on CloudSQL... because it has many bugs.
I was hit by this today: we set the max_connections flag to 8000 on a primary server a few days ago, we had a failover last night, and the flag was not set on the replica (bug #1).
Update 2019-05-03: there is another bug (bug #1.5). If you set the
Last week, Oracle reported on the list of MySQL Community Contributors for 2019 and we’re proud to say that five serving Perconians made it to the list of 19 people recognized as such. Entries are nominated by the MySQL community and their nominations are assessed against six criteria by a volunteer committee of community mavens.
The members of Percona who will be proudly wearing their community …
[Read more]
MySQL 8.0.16 was released last week and includes many great
features including support for CHECK constraints and
upgrades without the need of mysql_upgrade. As usual
there are also several contributions from the community. These
are the ones, I would like to highlight in this blog to say
“thank you for the contributions”.
Facebook has contributed with another two patches and so has Daniel Black. Additionally, there are patches from Yuhui Wang, Wei Zhao, Yan Huang, and Dirkjan Bussink. The contributions are:
mysql-test-run.pl now supports the
MTR_UNIQUE_IDS_DIR environment variable, which may
be set to specify a unique-IDs directory to be used as the
common location …Join Percona CEO Peter Zaitsev and PingCAP Senior Product and Community Manager Morgan Tocker as they present How to horizontally scale MySQL with TiDB while avoiding sharding issues on Wednesday, May 1st, 2019, at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4).
In this joint webinar, PingCAP will provide an introduction and overview of TiDB, tailored for those with a strong background in MySQL. PingCAP will use MySQL as an example to explain …
[Read more]Fedora 30 is out today. We congratulate the Fedora community on another rev of their favorite Linux distro. As usual, we support the latest Fedora from day one, and we have added the following MySQL products to our official MySQL yum repos: MySQL Server (8.0.16 and 5.7.26) Connector C++ 8.0.16 Connector Python 8.0.16 Connector ODBC […]
(In the previous post, Part 1, we covered Data Writing.)
In this blog post, we continue on our series of exploring MyRocks mechanics by looking at configurable server variables and column family options. In our last post, I explained at a high level how data first entered memory space and in this post, we’re going to pick up where we left off and talk about how the flush from immutable memtable to disk occurs. We’re also going to talk about how newly created secondary indexes on existing tables get written to disk.
We already know from our previous post in the series that a flush can be prompted by one of several events, the most common of which would be when an active memtable is filled to its maximum capacity and is rotated into immutable status.
When your immutable memtable(s) is ready …
[Read more]This post is just a reminder on how to find which settings have been set on MySQL Server.
If you have modified some settings from a configuration file or during runtime (persisted or not), these two queries will show you what are the values and how they were set. Even if the value is the same as the default (COMPILED) in MySQL, if you have set it somewhere you will be able to see where you did it.
Global Variables
First, let’s list all the GLOBAL variables that we have configured in our server:
SELECT t1.VARIABLE_NAME, VARIABLE_VALUE, VARIABLE_SOURCE
FROM performance_schema.variables_info t1
JOIN performance_schema.global_variables t2
ON t2.VARIABLE_NAME=t1.VARIABLE_NAME
WHERE t1.VARIABLE_SOURCE != 'COMPILED';
This is an example of the output:
Session Variables
And now the same query for the session variables:
SELECT t1.VARIABLE_NAME, VARIABLE_VALUE, …[Read more]
FromDual has the pleasure to announce the release of the new version 0.9 of its popular FromDual Ops Center for MariaDB and MySQL focmm.
The FromDual Ops Center for MariaDB and MySQL (focmm) helps DBA's and System Administrators to manage MariaDB and MySQL database farms. Ops Center makes DBA and Admins life easier!
The main task of Ops Center is to support you in your daily MySQL and MariaDB operation tasks. More information about FromDual Ops Center you can find here.
Download
The new FromDual Ops Center for MariaDB and MySQL
(focmm) can be downloaded from here. How to
install and use focmm is documented in the …
As of 8.0.16, the mysql_upgrade binary is deprecated, but its functionality is moved into the server. Let’s call this functionality the “server upgrade”. This is added alongside the Data Dictionary upgrade (DD Upgrade), which is a process to update the data dictionary table definitions.…
Facebook Twitter Google+ LinkedIn
Dear MySQL users,
MySQL Connector/ODBC 5.3.13, a new version of the ODBC driver for
the
MySQL database management system, has been released.
The available downloads include both a Unicode driver and an
ANSI
driver based on the same modern codebase. Please select the
driver
type you need based on the type of your application – Unicode or
ANSI.
Server-side prepared statements are enabled by default. It is
suitable
for use with any MySQL version from 5.6.
This is the sixth release of the MySQL ODBC driver conforming to
the
ODBC 3.8 specification. It contains implementations of key
3.8
features, including self-identification as a ODBC 3.8
driver,
streaming of output parameters (supported for binary types only),
and
support of the SQL_ATTR_RESET_CONNECTION connection attribute
(for the
Unicode driver only).
The release is now available in …
[Read more]