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 instances (we haven’t checked the other versions), both master and its replicas.

Continue reading “Memory leak in MySQL 8 with indexed generated virtual columns”

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.

Continue reading “proxysql-nagios with Python 3.x”
Design a site like this with WordPress.com
Get started