The votes have been tallied, and we’re happy to fill you in on the Top 10 highest-rated talks at the Percona Live Open Source Database Conference 2019! A big thanks to everyone who voted, and if you didn’t attend any of these at the conference, now’s your chance to see what you missed. Percona […]Read more
I’m sure you’ve seen it – you kick off an ALTER and you get the dreaded “waiting on metadata lock”. In many cases, this is expected if you are actively working on the table. However, I recently had a case with a client where the table being altered was rarely updated and very small […]Read more
The CTO has issued the decree: “We are moving to the cloud!” Great, so now what do we do? When it comes to migrating from on-premise to the cloud, there are many factors to consider and decisions that need to be made. First (and probably most important) on that list: managed DBaaS or setup […]Read more
It’s bad practice to provide world-writable access to critical files in Linux, though we’ve seen time and time again that this is done to conveniently share files with other users, applications, or services. But with Xtrabackup, preparing backups could go wrong if the backup configuration has world-writable file permissions.
Say you performed a backup on […]
I want to thank everybody who attended my session “Deep Dive in PostgreSQL Indexes” in Austin. It was quite a wonderful experience! To cover a bigger audience, I also did a webinar on the same topic. There were many questions in that webinar, but unfortunately, there was not enough time to cover each and […]Read more
We’re counting down the top 10 most attended talks at the Percona Live Open Source Database Conference 2019! For those of you who attended, chances are that some of you were at a few of these talks. Percona Live conferences provide the open source database community with an opportunity to discover and discuss the […]Read more
In my previous blog post, I explained the internals of the sorted index build process. The blog ended with saying “there is one disadvantage.”
Beginning in MySQL 5.6, many DDLs including ALTER TABLE ADD INDEX became “ONLINE”. Meaning, when the ALTER is in progress, there can be concurrent SELECTS and DMLs. See the MySQL documentation […]
Please join Percona’s Principal Support Engineer Marcos Albe as he presents “Beyond Relational Databases: A Look Into MongoDB, Redis, and ClickHouse” on Thursday, June 27th, 2019 at 12:00 PM PDT (UTC-7).
We all use and love relational databases… until we use them for purposes for which they are not a good fit: queues, caches, […]
Percona is glad to announce the release of Percona XtraDB Cluster 5.7.26-31.37 on June 26, 2019. Binaries are available from the downloads section or from our software repositories.
Percona XtraDB Cluster 5.7.26-31.37 is now the current release, based on the following:
Percona Server for MySQL 5.7.26-29
Codership WSREP API release 5.7.25
Codership Galera library 3.26
All Percona software is open-source and […]Read more
In this blog post, I am going to show why we have to be careful with stored functions in select list, as a single query can cause thousands of queries in the background if we aren’t cautious.
For this example, I am only going to use the SLEEP function to demonstrate the issue, but you […]