Question : After I set my.ini file following the answer by Rolando here : https://dba.stackexchange.com/a/83385/191579 , today I managed to […]
Category: MariaDB
Will “bridge” storage engines work with MariaDB Galera Cluster?
Question : Galera states that it only supports InnoDB. The reason is quite clear, and it is related with the […]
mariaDB not caching queries cached by mysql
Question : I’m migrating my database (MySQL 5.1.73) to a new server, and I am trying to replace it with […]
Optimize multiple group_concat
Question : Just wondering if this query could be optimized or if sub-queries would be better? select t.entry_id, t.title, d.field_id_249 […]
MariaDB Galera estimated database size is different from each node
Question : newbie question, why does my database size differs from other nodes in the cluster when I run: SELECT […]
mysql (mariadb) won’t start after power outage (MacOS)
Question : /var/log/system.log says (over and over) Oct 13 19:34:01 Data-Server com.apple.xpc.launchd[1] (com.mariadb.server[2128]): Service exited with abnormal code: 1 Oct […]
Less traffic, But Mysql Still Hit upto 200%
Question : I Run WordPress On my with with Less traffic, 5 or 6 online, but mysql till hits upto […]
Changing table types from MyISAM to InnoDB in a MySQLdump file
Question : I have a few hundred systems running running on a MariaDB 10.1.x. On these systems there is a […]
Do unused columns in MySQL/MariaDB notably affect performance?
Question : In the WordPress MySQL/MariaDB database there is a table with some columns that in my own uses of […]
Select all customers and number of orders per month as csv
Question : This is what I have: customer ——– customerId INT(10) name TINYTEXT phone VARCHAR(10) … order —– orderId int(10) […]