Mon, 06 May 2024 18:18:20 +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/valkey-redis-configurations-and-persistent-setting-of-the-key-parameters/ https://www.percona.com/blog/valkey-redis-configurations-and-persistent-setting-of-the-key-parameters/#respond Mon, 06 May 2024 18:18:20 +0000 https://www.percona.com/blog/?p=96136 Since Valkey (a fork of Redis) is around the corner, I thought to write a short blog post about some of the configuration parts, mainly discussing how to dynamically change certain settings and persist those inside the configuration file.Disk persistenceLet me start with a very important setting, which is “SAVE,” that helps in performing a […]]]> https://www.percona.com/blog/valkey-redis-configurations-and-persistent-setting-of-the-key-parameters/feed/ 0 96136 https://www.percona.com/blog/wiredtiger-logging-and-checkpoint-mechanism/ https://www.percona.com/blog/wiredtiger-logging-and-checkpoint-mechanism/#comments Tue, 28 Mar 2023 13:13:41 +0000 https://www.percona.com/blog/?p=86465 In this blog post, we will dive deep into WiredTiger’s Logging and Checkpoint mechanism.Every database system has to ensure durability and reliability. MongoDB uses classic Write-Ahead-Logging (WAL) using Journals and Checkpoints.Starting with the basics, why is WAL needed in the first place? It’s to ensure that our data is durable after each write operation and […]]]> https://www.percona.com/blog/wiredtiger-logging-and-checkpoint-mechanism/feed/ 1 86465 https://www.percona.com/blog/innodb-performance-optimization-basics-updated https://www.percona.com/blog/innodb-performance-optimization-basics-updated#comments Thu, 23 Mar 2023 13:31:33 +0000 https://www.percona.com/blog/?p=86300 This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Although there have been many blogs about adjusting MySQL variables for better performance since then, I think this topic deserves a blog update since the last update was a decade ago, and MySQL 5.7 and 8.0 have been […]]]> https://www.percona.com/blog/innodb-performance-optimization-basics-updated/feed/ 1 86300 https://www.percona.com/blog/percona-operator-for-mongodb-backup-and-restore-on-s3-compatible-storage-backblaze/ https://www.percona.com/blog/percona-operator-for-mongodb-backup-and-restore-on-s3-compatible-storage-backblaze/#respond Fri, 25 Nov 2022 14:16:33 +0000 https://www.percona.com/blog/?p=83765 One of the main features that I like about the Percona Operator for MongoDB is the integration with Percona Backup for MongoDB (PBM) tool and the ability to backup/restore the database without manual intervention. The Operator allows backing up the DB to S3-compatible cloud storage and so you can use AWS, Azure, etc.One of our customers […]]]> https://www.percona.com/blog/percona-operator-for-mongodb-backup-and-restore-on-s3-compatible-storage-backblaze/feed/ 0 83765 https://www.percona.com/blog/raspberry-on-the-rocks-build-percona-server-for-mysql-with-myrocks-on-your-raspberry-pi/ https://www.percona.com/blog/raspberry-on-the-rocks-build-percona-server-for-mysql-with-myrocks-on-your-raspberry-pi/#respond Thu, 03 Nov 2022 12:10:26 +0000 https://www.percona.com/blog/?p=83420 Raspberry PI is a small single-board computer (SBCs) developed by the Raspberry Pi Foundation in association with Broadcom. This tiny computer is extremely popular and widely used in many areas. Thanks to its size, low cost, and low energy requirements, it can be used to collect data in remote locations or from sensor devices. We […]]]> https://www.percona.com/blog/raspberry-on-the-rocks-build-percona-server-for-mysql-with-myrocks-on-your-raspberry-pi/feed/ 0 83420 https://www.percona.com/blog/how-to-reclaim-disk-space-in-percona-server-for-mongodb/ https://www.percona.com/blog/how-to-reclaim-disk-space-in-percona-server-for-mongodb/#comments Mon, 01 Aug 2022 11:52:27 +0000 https://www.percona.com/blog/?p=81961 Compaction in Percona Server for MongoDB (PSMDB)There are two ways to reclaim disk space in Percona Server for MongoDB (PSMDB): run compact on nodes or resync the node. In this blog, we will see the best practice for reclaiming the fragmented space on a disk in PSMDB using compact.Disk storage is a critical resource for any […]]]> https://www.percona.com/blog/how-to-reclaim-disk-space-in-percona-server-for-mongodb/feed/ 3 81961 https://www.percona.com/blog/performance-of-various-ebs-storage-types-in-aws/ https://www.percona.com/blog/performance-of-various-ebs-storage-types-in-aws/#comments Fri, 20 Aug 2021 13:36:54 +0000 https://www.percona.com/blog/?p=77786 EBS storage type choices in AWS can be impacted by a lot of factors. As a consultant, I get a lot of questions about choosing the best storage type for a workload. Let me share a few examples. Is io2 better than gp2/3 if the configured iops are the same? What can I expect when […]]]> https://www.percona.com/blog/performance-of-various-ebs-storage-types-in-aws/feed/ 4 77786 https://www.percona.com/blog/mysql-zfs-performance-update/ https://www.percona.com/blog/mysql-zfs-performance-update/#comments Fri, 09 Jul 2021 12:14:38 +0000 https://www.percona.com/blog/?p=77189 As some of you likely know, I have a favorable view of ZFS and especially of MySQL on ZFS. As I published a few years ago, the argument for ZFS was less about performance than its useful features like data compression and snapshots. At the time, ZFS was significantly slower than xfs and ext4 except […]]]> https://www.percona.com/blog/mysql-zfs-performance-update/feed/ 28 77189 https://www.percona.com/blog/mongodb-tuning-anti-patterns-how-tuning-memory-can-make-things-much-worse/ https://www.percona.com/blog/mongodb-tuning-anti-patterns-how-tuning-memory-can-make-things-much-worse/#comments Mon, 24 May 2021 14:50:21 +0000 https://www.percona.com/blog/?p=75633 It’s your busiest day of the year and the website has crawled to a halt and finally crashed… and it was all because you did not understand how MongoDB uses memory and left your system open to cluster instability, poor performance, and unpredictable behavior. Understanding how MongoDB uses memory and planning for its use can […]]]> https://www.percona.com/blog/mongodb-tuning-anti-patterns-how-tuning-memory-can-make-things-much-worse/feed/ 1 75633 https://www.percona.com/blog/testing-the-value-of-scaleflux-computational-storage-drive-csd-for-postgresql/ Mon, 08 Mar 2021 17:03:13 +0000 https://www.percona.com/blog/?p=74710 Some time ago we at Percona were approached by ScaleFlux Inc to benchmark their latest hardware appliance, the CSD 2000 Drive, which is a next-generation SSD computational storage drive. It goes without saying that a truly relevant report requires us to be as honest and as forthright as possible. In other words, my mission was […]]]> 74710 https://www.percona.com/blog/deploying-percona-kubernetes-operators-with-openebs-local-storage/ Thu, 01 Oct 2020 18:52:35 +0000 https://www.percona.com/blog/?p=71661 Network volumes in Kubernetes provide great flexibility, but still, nothing beats local volumes from direct-attached storage in the sense of database performance.I want to explore ways to deploy both Percona Kubernetes Operators (Percona Kubernetes Operator for Percona XtraDB Cluster and Percona Kubernetes Operator for Percona Server for MongoDB) using local volumes, both on the bare-metal […]]]> 71661 https://www.percona.com/blog/dba-concerns-about-next-gen-non-volatile-memory-storage-products/ Wed, 11 Mar 2020 16:24:03 +0000 https://www.percona.com/blog/?p=65794 Abstract: Storage engine algorithmic gains have mostly settled and Moore’s law for CPU speed is bottoming out, but database performance still stands to increase ~10x thanks to continuing NAND Flash improvement, Optane, Flash-idiomatic SSD drives (e.g. OpenChannel, Zoned Namespaces), KeyValue SSD, etc. The downside is each storage engine revolution historically has broken encapsulation/reuse and required […]]]> 65794 https://www.percona.com/blog/comparing-s3-streaming-tools-with-percona-xtrabackup/ https://www.percona.com/blog/comparing-s3-streaming-tools-with-percona-xtrabackup/#comments Tue, 26 Nov 2019 16:07:33 +0000 https://www.percona.com/blog/?p=63631 Making backups over the network can be done in two ways: either save on disk and transfer or just transfer without saving. Both ways have their strong and weak points. The second way, particularly, is highly dependent on the upload speed, which would either reduce or increase the backup time. Other factors that influence it […]]]> https://www.percona.com/blog/comparing-s3-streaming-tools-with-percona-xtrabackup/feed/ 2 63631 https://www.percona.com/blog/update-on-fsync-performance/ https://www.percona.com/blog/update-on-fsync-performance/#comments Thu, 19 Sep 2019 19:00:11 +0000 https://www.percona.com/blog/?p=62293 Last year, I wrote a post focused on the performance of the fsync call on various storage devices. The fsync call is extremely important for a database when durability, the “D” of the ACID acronym is a hard requirement. The call ensures the data is permanently stored on disk. The durability requirement forces every transaction […]]]> https://www.percona.com/blog/update-on-fsync-performance/feed/ 4 62293 https://www.percona.com/blog/webinar-rock-myrocks/ Mon, 14 Jan 2019 21:35:00 +0000 https://www.percona.com/blog/?p=54857 Please join Percona’s Chief Technology Officer, Vadim Tkachenko, as he presents How to Rock with MyRocks on Thursday, January 17th at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). View the Recording MyRocks is a new storage engine from Facebook and is available in Percona Server for MySQL. In what cases will you want […]]]> 54857 https://www.percona.com/blog/aws-elastic-block-storage-ebs-can-we-get-it-truly-elastic/ https://www.percona.com/blog/aws-elastic-block-storage-ebs-can-we-get-it-truly-elastic/#comments Wed, 12 Dec 2018 12:28:47 +0000 https://www.percona.com/blog/?p=54252 At AWS Re:Invent 2018 there were many great announcements of AWS New Services and New Features, but one basic feature that I’ve been waiting for years to be released is still nowhere to be  found.AWS Elastic Block Storage (EBS) is great and it’s got better through the years, adding different storage types and features like Provisioned IOPS. […]]]> https://www.percona.com/blog/aws-elastic-block-storage-ebs-can-we-get-it-truly-elastic/feed/ 5 54252 https://www.percona.com/blog/scaling-percona-monitoring-management-pmm/ https://www.percona.com/blog/scaling-percona-monitoring-management-pmm/#comments Fri, 28 Sep 2018 12:29:34 +0000 https://www.percona.com/blog/?p=52842 Starting with PMM 1.13,  PMM uses Prometheus 2 for metrics storage, which tends to be heaviest resource consumer of CPU and RAM.  With Prometheus 2 Performance Improvements, PMM can scale to more than 1000 monitored nodes per instance in default configuration. In this blog post we will look into PMM scaling and capacity planning—how to […]]]> https://www.percona.com/blog/scaling-percona-monitoring-management-pmm/feed/ 5 52842 https://www.percona.com/blog/scaling-io-bound-workloads-mysql-cloud/ https://www.percona.com/blog/scaling-io-bound-workloads-mysql-cloud/#comments Wed, 29 Aug 2018 15:55:36 +0000 https://www.percona.com/blog/?p=52182 Is increasing GP2 volumes size or increasing IOPS for IO1 volumes a valid method for scaling IO-Bound workloads? In this post I’ll focus on one question: how much can we improve performance if we use faster cloud volumes? This post is a continuance of previous cloud research posts: Saving With MyRocks in The Cloud Percona […]]]> https://www.percona.com/blog/scaling-io-bound-workloads-mysql-cloud/feed/ 2 52182 https://www.percona.com/blog/restore-mysql-logical-backup-maximum-speed/ https://www.percona.com/blog/restore-mysql-logical-backup-maximum-speed/#comments Fri, 23 Feb 2018 00:35:56 +0000 https://www.percona.com/blog/?p=47448 The ability to restore MySQL logical backups is a significant part of disaster recovery procedures. It’s a last line of defense.Even if you lost all data from a production server, physical backups (data files snapshot created with an offline copy or with Percona XtraBackup) could show the same internal database structure corruption as in production […]]]> https://www.percona.com/blog/restore-mysql-logical-backup-maximum-speed/feed/ 3 47448 https://www.percona.com/blog/archiving-mysql-tables-in-clickhouse/ https://www.percona.com/blog/archiving-mysql-tables-in-clickhouse/#comments Tue, 20 Feb 2018 00:05:16 +0000 https://www.percona.com/blog/?p=47307 In this blog post, I will talk about archiving MySQL tables in ClickHouse for storage and analytics.Why Archive?Hard drives are cheap nowadays, but storing lots of data in MySQL is not practical and can cause all sorts of performance bottlenecks. To name just a few issues: The larger the table and index, the slower the performance […]]]> https://www.percona.com/blog/archiving-mysql-tables-in-clickhouse/feed/ 2 47307