Percona

APRIL 24, 2023

Indexes are generally considered to be the panacea when it comes to SQL performance tuning, and PostgreSQL supports different types of indexes catering to different use cases. I keep seeing many articles and talks on “tuning” discussing how creating new indexes speeds up SQL but rarely ones discussing removing them. The urge to create more and more indexes is found to be causing severe damage in many systems.

Tuning 130

Tuning Cache Storage Database 130

Adrian Cockcroft

APRIL 24, 2023

Polestars and a few Teslas at Heathrow Hertz recently started to rent electric cars, and we’ve tried them out a few times. Most people are used to renting cars, but renting electric cars is a fairly new thing, so I’m sharing to help encourage people to try it out and to hopefully smooth the way with some learning and feedback ideas. We’re experienced electric car owners, and early adopters.

Infrastructure 98

Infrastructure Code Performance Systems 98

Percona

APRIL 24, 2023

In this blog post, we will see how to persist the password inside the ProxySQL mysql_users table in hashed format only. Also, even if someone stored the password in cleartext, we see how to change those into the hashed format easily. Here we are just highlighting one of the scenarios during work on the client environment where we noticed that the ProxySQL mysql_users table had more than 100 user entries, but some of them were available/inserted into the clear text password, whereas some were ins

Database 84

Database Best Practices Open Source Testing 84

Percona Community

APRIL 24, 2023

Database application by Nick Youngson CC BY-SA 3.

Database 52

Database Testing 52

Percona

APRIL 24, 2023

You know what time it is… it’s time for the release roundup! Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software.

Open Source 82

Open Source Storage Servers Database 82