Question : I’m trying to get pt-kill to work to kill queries running longer than n. The command as I’m […]
Tag: mariadb-10.1
MariaDB – “ERROR 1205 … Lock wait timeout exceeded; …” when doing multiple parallel UPDATEs affecting different rows
Question : We are using MariaDB 10.1.19 hosting a legacy database. We have an lpr table (on InnoDB) where we […]
Using “OR” against two indexed columns doesn’t use indexes
Question : In the query below, from and tid are indexes of the replies table. SELECT * FROM `replies` WHERE […]
User rank based on cumulative rows
Question : UPDATE: Full table schema and data: https://www.db-fiddle.com/f/jT3Mfwd1BJ8GrsBxxPDC8M/1 Table structure (some fields are hidden): +———+———+————+————-+——-+——-+ | user_id | kind_id […]
reduce number of innodb pages read by a query
Question : In my mariadb I have a large innodb table (600 millions rows). Simple queries on the table using […]
Processes dissappear from processlist (MariaDB)
Question : In my application I need to monitor list of process ids for some database user, so I execute […]
pt-query-digest –type binlog (percona-toolkit) gives empty output with MariaDB/Galera 10.1
Question : My installed versions of MariaDB and Percona Toolkit on MacBook: brew info percona-toolkit percona-toolkit: stable 3.0.10 (bottled), HEAD […]
I can’t add an extra node to mariadb cluster 10.1
Question : I was installing a test mariadb cluster but I have a problem when I want to add an […]
Unexpected RAM usage on MySQL
Question : We have a server which hosts about 10 customers in a multi-tenant web application, each customer has its […]
Galera Cluster – 3rd Quoroum Only Node – No Replication – Possible?HowTo?
Question : I want to setup a 2 node cluster for MariaDB Galera cluster. What I read says it “requires” […]