Memory leak in MySQL 8 with indexed generated virtual columns
Some time ago we have observed that memory for some MySQL instances has been constantly eaten away. Investigation pointed us to memory/innodb/memory area and databases with tables having generated virtual columns, which in addition were used in indexes. It was affecting both 8.0.25 and 8.0.28…
proxysql-nagios with Python 3.x
If you use MySQL together with ProxySQL and if you ever wondered if very handy proxysql-nagiosscript (https://github.com/sysown/proxysql-nagios) will work with Python 3.x, I can give you an answer – yes, but at least with the current version (v. 1.0.0), small correction is needed. Please check…
NVMes write back vs. write through performance
Recently I was running some benchmarks to double-check that the performance of AMD EPYCs servers delivered by Company A, match the performance of those delivered by Company B. I was using our benchmark automation tool (about which I may write a bit more in the…
Important behaviour change between bash version 4.3 and 4.4
Please be aware about important behaviour change between bash version 4.3 and 4.4. You can observe it for example while migrating from Oracle Linux 7 to 8/CentOS 7 to Rocky Linux 8/etc. as version 7 of RHEL compatible system comes with bash 4.2, whereas version…
Change is the only constant…
I have a feeling that the name of my blog has never been so true :). Since today I work for Proton Technologies AG (https://protonmail.com, https://protonvpn.com). Still as a database engineer, but with completely different database engine – MySQL! Even though Oracle database is a…
How Well a Query Optimizer Handles Subqueries?
At the beginning of December, at the UKOUG Tech17 conference in Birmingham (GB), I presented a comparison of the query optimizers of MySQL 8.0.3 and PostgreSQL 10.1. One of the things I talked about is their ability to handle subqueries. I summarized my findings with…