Mon, 02 Oct 2023 14:57:29 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/workaround-for-the-reload-flush_tables-privilege-required-problem-when-using-oracle-mysqldump-8-0-32/ https://www.percona.com/blog/workaround-for-the-reload-flush_tables-privilege-required-problem-when-using-oracle-mysqldump-8-0-32/#respond Fri, 24 Mar 2023 13:10:24 +0000 https://www.percona.com/blog/?p=86360 In MySQL Server 8.0.32, Oracle fixed Bug #105761:“mysqldump make a non-consistent backup with ‐‐single-transaction option” (this commit)which caused a wave of complaints from users who could no longer do backups with the mysqldump utility because of the lack of the required privileges. Bug #109701 “Fix for #33630199 in 8.0.32 introduces regression when ‐‐set-gtid-purged=OFF” Bug #109685 […]]]> https://www.percona.com/blog/workaround-for-the-reload-flush_tables-privilege-required-problem-when-using-oracle-mysqldump-8-0-32/feed/ 0 86360 https://www.percona.com/blog/building-percona-server-for-mysql-8-0-with-rocksdb-storage-engine-on-macos/ https://www.percona.com/blog/building-percona-server-for-mysql-8-0-with-rocksdb-storage-engine-on-macos/#respond Wed, 10 Aug 2022 14:10:48 +0000 https://www.percona.com/blog/?p=81909 In Percona Server for MySQL 8.0.29-21, we added one more patch that helps us to build server code on macOS. To be precise here, we still could do this even before this patch but only partially. Now it is possible to build RocksDB Storage Engine as well.A word of disclaimer here, at the moment, by macOS […]]]> https://www.percona.com/blog/building-percona-server-for-mysql-8-0-with-rocksdb-storage-engine-on-macos/feed/ 0 81909 https://www.percona.com/blog/digital-signatures-another-layer-of-data-protection-in-percona-server-for-mysql/ https://www.percona.com/blog/digital-signatures-another-layer-of-data-protection-in-percona-server-for-mysql/#respond Thu, 30 Jun 2022 13:44:51 +0000 https://www.percona.com/blog/?p=81385 Imagine you need to design an online system for storing documents on a per-user basis where nobody, including database administrators, would be able to change the content of those documents without being noticed by document owners.In Percona Server for MySQL 8.0.28-20, we added a new component called Encryption UDFs – an open-source alternative to MySQL […]]]> https://www.percona.com/blog/digital-signatures-another-layer-of-data-protection-in-percona-server-for-mysql/feed/ 0 81385 https://www.percona.com/blog/generating-numeric-sequences-in-mysql/ https://www.percona.com/blog/generating-numeric-sequences-in-mysql/#comments Mon, 27 Jul 2020 14:27:26 +0000 https://www.percona.com/blog/?p=66958 What is the easiest way to generate a sequence of integers in MySQL? In other words, which “SELECT <something>” statement should I write to get 0, 1, 2, … N – 1?This is the question I have been struggling with for years and it looks like I have finally got the answer (although I must […]]]> https://www.percona.com/blog/generating-numeric-sequences-in-mysql/feed/ 5 66958