article thumbnail

Is ANALYZE TABLE Safe on a Busy MySQL Database Server?

Percona

MySQL Server – Community Edition The problem applies to all versions of the upstream MySQL Community up to 8.0.23. Here is an example scenario you may end up here: mysql > select @@version,@@version_comment; + --+ + | @@version | @@version_comment | + --+ + | 5.7.43 | MySQL Community Server (GPL) | + --+ + 1 row in set (0.00

Servers 98
article thumbnail

Percona Server for MongoDB 7 Is Now Available

Percona

Why choose Percona Server for MongoDB? The difference between Percona Server for MongoDB and MongoDB CE is that we strive to provide a gap-closing set of features for users who want to use MongoDB in production. Why release Percona Server for MongoDB 7 now? which was released as Percona Server for MongoDB RC 7.0.2-1.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

The Dynatrace journey toward DORA compliance

Dynatrace

When operational disruptions strike—whether it’s a rogue server or a cyberattack—Dynatrace services remain in harmony. Imagine a dashboard that whispers, “Hey, there’s a vulnerability brewing in Server Room B.” Business continuity : We don’t just draft continuity plans; we live them. The show must go on.

Tuning 250
article thumbnail

Run Percona Server for MongoDB on Your ARM-based MacBooks and More

Percona

The good news is we’ve got you covered with ARM64 container images for Percona Server for MongoDB 6. With the release of Percona Server for MongoDB 6.0.4, Just replace docker with podman: $ podman run -d --name psmdb --restart always percona/percona-server-mongodb:6.0.4-3-arm64 3-arm64 Note that you’ll want to replace 6.0.4-3-arm64

Servers 96
article thumbnail

Add More Security to Your Percona Server for MongoDB With AWS IAM integration!

Percona

Did you notice that Percona Server for MongoDB 6.0.5-4 One key to rule them all — improvements to master key rotation With the improvements introduced in Percona Server for MongoDB 6.0.5-4, 4, one key path can be used for all servers in a clustered environment. Changes introduced with Percona Server for MongoDB 6.0.5-4

AWS 105
article thumbnail

Additional T-SQL Improvements in SQL Server 2022

SQL Performance

Recently I covered some of the T-SQL improvements in SQL Server 2022 here , and Aaron Bertrand covered additional improvements here. Microsoft just announced the release of SQL Server 2022 CTP 2.1. For example, suppose that prior to SQL Server 2022 you had the following query: SELECT. So far so good. FROM T1 INNER JOIN T2 ON T1.

Servers 142
article thumbnail

Don’t Start Using Your MySQL Server Until You’ve Configured Your OS

Percona

Whenever you install your favorite MySQL server on a freshly created Ubuntu instance, you start by updating the configuration for MySQL, such as configuring buffer pool, changing the default datadir director, and disabling one of the most outstanding features – query cache. It’s a nice thing to do, but first things first.

Servers 115