(Giuseppe Maxia) MySQL 8.0 GA is right around the corner. I don’t have precise information about its release, as I don’t work at Oracle. If I did, I would probably know, but I couldn’t tell when the release is scheduled to appear because of company policies.
Tag: Open Source
Safely Purging Binary Logs From Master
(Vinicius Grippa) In this blog post, we’ll discuss some of the options available when purging binary logs. We’ll look at how to safely purge them when you have slaves in your topology and want to avoid deleting any binary log that still needs to be applied.
ClickHouse and MySQL do not have the same SQL syntax and functions
(René Cannaò) ProxySQL is a popular open source, high performance and protocol-aware proxy server for MySQL and its forks.
ANALYZE TABLE Is No Longer a Blocking Operation
(Sveta Smirnova) In this post, I’ll discuss the fix for lp:1704195 (migrated to PS-2503), which prevents ANALYZE TABLE from blocking all subsequent queries on the same table.
MySQL Security – The Connection-Control Plugins
(Olivier Dasini) When thinking about security within a MySQL installation, you should consider a wide range of possible procedures / best practices and how they affect the security of your MySQL server and related applications.
New MySQL 8.0 innodb_dedicated_server Variable Optimizes InnoDB from the Get-Go
(Jaime Sicam) In this post, we’ll look at the MySQL 8.0 innodb_dedicated_server variable.
Windows Tools for MySQL DBAs: Basic Minidump Analysis
(Valeriy Kravchuk) Even though I had written many posts explaining the use of gdb for various MySQL-related tasks, I have to use other OS level troubleshooting tools from time to time. Moreover, as MySQL and MariaDB are still supported and used under Microsoft Windows in production by customers I ha
Caching SHA-2 (or 256) Pluggable Authentication for MySQL 8
(Dave Stokes) If you are like me and you spend chilly spring evenings relaxing by the fire, reading the manual for the upcoming MySQL 8 release, you may have seen Caching SHA-2 Pluggable Authentication in section 6.5.1.3.
MySQL 8.0 Source Code Improvements
(Geir Hoydalsvik) With this post, I want to bring your attention to source code improvements in MySQL 8.0. MySQL 8.0 modernizes the code base by using C++11 constructs, being warning-free on more compilers and platforms, being UBSan- and ASan- clean, improving header file dependencies, improving the
MySQL sys Schema in MariaDB 10.2
(Shinguz) MySQL has introduced the PERFORMANCE_SCHEMA (P_S) in MySQL 5.5 and made it really usable in MySQL 5.6 and added some enhancements in MySQL 5.7 and 8.0.