percona | Geek Tank

MySQL, Percona, MariaDB Error: Out of sort memory, consider increasing server sort buffer size!

May 17, 2022 by Jordan

There is a bug in MySQL 8.0.18, and above https://bugs.mysql.com/bug.php?id=103225 it was patched in 8.0.28 https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-28.html It looks as though Percona released version 8.0.28, which includes all features and bug fixes in MySQL. However, if you only do security updates, it’s possible you might have an older version of Percona based on your server’s deployment … Read more

MySQL 8 and Persona 8 Tuning for WordPress

May 31, 2019 by Jordan

If you’re running MySQL 8 or Percona 8, then you’ll probably see lots of guides online that reference some out of data configuration that really only deals with functions in MySQL 5 that have been deprecated in MySQL 8 and Percona 8 Query Cache No longer used, and removed from MySQL 8 and Percona 8, … Read more

Creating Users and Databases in MySQL 8 and Percona 8

September 29, 2022May 30, 2019 by Jordan

If you’ve started using MySQL 8, you’ll notice your usually commands for creating a user no longer function. That’s because it’s changed in MySQL 8, you need to now create a user, then grant privileges. Let’s create a user The critical part here is the “mysql_native_password” if you don’t have this portion, you’ll get errors … Read more