The MariaDB Foundation is pleased to announce the availability of MariaDB 10.3.12, the latest stable release in the MariaDB 10.3 series, as well as MariaDB Connector/ODBC 3.0.8, the latest stable release in the MariaDB Connector/ODBC series. See the release notes and changelogs for details. Download MariaDB 10.3.12 Release Notes Changelog What is MariaDB 10.3? MariaDB […]
The post MariaDB 10.3.12 and MariaDB Connector/C 3.0.8 now available appeared first on MariaDB.org.
1.0. Introduction:
MySQL 8.0 was released with awesome features. One of its most prominent features is CTE (Common Table Expression).
The Common Table Expression can be used to construct complex queries in a more readable manner. In this blog, I have described how the CTE works with some useful examples.
1.1 What is CTE?
A Common Table Expression (CTE) is the result set of the query, which exists temporarily and uses only within the context of a larger query.
The CTE provides better readability and performance in comparison with a derived table.
In a normal query the temporary result set that exists only within the execution scope of a single SQL statement.
Example:
select …[Read more]
As you know, MySQL uses some keywords and some of them are also reserved.
Let’s have a look how to deal with that:
mysql> create table WRITE (id int auto_increment primary key, varying varchar(10), than int);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'WRITE (id int auto_increment primary key,
varying varchar(10), than int)' at line 1
OK, it seems WRITE is a keyword I cannot use as table name. I’ve then two choices:
Let’s use the first option:
mysql> create table WRITE_TBL (id int auto_increment primary key, varying varchar(10), than …[Read more]
MySQL is extensive and has lots of areas to optimize and tweak for the desired performance. Some changes can be performed dynamically, others require a server restart. It is pretty common to find a MySQL installation with a default configuration, although the latter may not be appropriate per se from your workload and setup.
Here are the key areas in MySQL which I have taken from different expert sources in the MySQL world, as well as our own experiences here at Severalnines. This blog would serve as your cheat sheet to tune performance and make your MySQL great again :-)
Let’s take a look on these by outlining the key areas in …
[Read more]Amazon Aurora with MySQL Compatibility comes in three editions which, at the time of writing, have quite a few differences around the features that they support. Make sure you don’t assume the newer Aurora 2.x supports everything in Aurora 1.x. On the contrary, right now Aurora 1.x (MySQL 5.6 based) supports most Aurora features. The serverless option was launched for this version, and it’s not based on the latest MySQL 5.7. However, the serverless option, too, has its own set of limitations
I found a concise comparison of what is available in which Amazon Aurora edition hard to come by so I’ve created one. The table was compiled based mostly on documentation research, so if you spot some mistakes please let me know and I’ll make a correction.
Please keep in mind, this is expected to …
[Read more]Percona announces the release of Percona XtraDB Cluster 5.6.42-28.30 (PXC) on January 4, 2019. Binaries are available from the downloads section or our software repositories.
Percona XtraDB Cluster 5.6.42-28.30 is now the current release, based on the following:
All Percona software is open-source and free.
Fixed …
[Read more]Percona is glad to announce the release of Percona XtraDB Cluster 5.7.24-31.33 (PXC) on January 4, 2019. Binaries are available from the downloads section or from our software repositories.
Percona XtraDB Cluster 5.7.24-31.33 is now the current release, based on the following:
Deprecated
The following variables are deprecated starting from this release:
…Recently, I encountered a situation where MySQL gave error messages that I had never seen before:
2018-12-12T14:36:45.571440Z 0 [ERROR] Error log throttle: 150 'Can't create thread to handle new connection' error(s) suppressed 2018-12-12T14:36:45.571456Z 0 [ERROR] Can't create thread to handle new connection(errno= 11) 2018-12-12T14:37:47.748575Z 0 [ERROR] Error log throttle: 940 'Can't create thread to handle new connection' error(s) suppressed 2018-12-12T14:37:47.748595Z 0 [ERROR] Can't create thread to handle new connection(errno= 11)
I was thinking maybe we hit some
ulimit
limitations or similar, but all the usual suspects were set high enough, and we were not even close to them.
After googling and discussing with the customer, I found they had had similar issues in the past, and I learned something new. Actually it is relatively new, as it has been around for a few years but is not that well known. It is …
[Read more]This is my first post in 2019, and Im starting with a MySQL solution. In MySQL world, implementing a better backup strategy to meet all of your requirement is still a challenging thing. The complexity depends on your RPO and RTO. Percona has many tools to help DBAs in many scenarios. Xtrabackup is one of …
The post Automation Script For Percona Xtrabackup FULL/Incremental appeared first on SQLgossip.
Image Source: DigitalOcean
This is my first post in 2019, and Im starting with a MySQL
solution. In MySQL world, implementing a better backup strategy
to meet all of your requirement is still a challenging thing. The
complexity depends on your RPO and RTO. Percona has many tools to
help DBAs in many
scenarios. [Xtrabackup](https://www.percona.com/software/mysql-database/percona-xtrabackup) is
one of the best backup tools to perform a better backup on
TeraBytes size of databases. Also, another great feature is it
supports Incremental and Differential backup.
There are couple of tools which is available in MySQL world, But due to some restrictions we can’t achieve what we are expecting.
#1 mysqldump
This is a widely used backup tool and most of the DBAs are trust this. This comes with …
[Read more]