Question : I’m troubleshooting an app that has a lot of sleeping connections to my MySQL (MariaDB) server. I’d like […]
Category: MariaDB
MariaDB: Periodic copy of data from local database to remote database
Question : I need to periodically copy the outcome of a view on our local database to another remote database. […]
Is there any way to graceful restart mysqld? [duplicate]
Question : This question already has answers here: Is there a graceful or safe restart for mysql like for apache […]
deadlock in mariadb: with non-index & fk table
Question : when i try to do an operation concurrently, there exists an deadlock from mariadb show engine innodb status, […]
Strong vs weak entity types on SQL
Question : I have a 3NF normalized database design and was trying to understand the concept of strong vs weak […]
can’t increase gcache.size galera cluster mariadb
Question : i wanted to increase the value of gcache.size on my 3 nodes of the mariadb galera cluster (galera […]
MariaDB Galera Arbitrator failing to sync with SSL
Question : So the scenario is this. I have already setup a 4 node MariaDB Galera cluster (10.5). I’m also […]
Why are collations specified at the column level?
Question : The charset defines how the row data is saved into the file store. Row 17: <CHARSET(‘utf8’, ‘hello’), 17, […]
Very Simple “SELECT * FROM” Times Out (InnoDB)
Question : Hello everyone and sorry for what may be a silly question, but I’m completely dazzled. First thing is […]
Access denied for user ‘root’@’localhost’ What proces is causing this?
Question : I got this connections constantly in logs, how to trace what app is trying to connect? root@localhost is […]