Question : I did INSERT INTO SELECT of a huge table (1TB). When the process is finished, MySQL/InnoDB still does […]
Tag: mariadb-10.5
InnoDB Buffer pool not showing as much I configured in MariaDB 10.5
Question : I’m using MariaDB 10.5 on Centos7 with 4G RAM and 2 CPU. Here’s my.cnf configuration [mysqld] log-error=/var/lib/mysql/mysql-3.kannel.com.err max_allowed_packet=1G […]
MariaDB Maxscale caching not working
Question : I have setup Maxscale (v6.2) and have connected to the Galera Cluster (3 nodes – MariaDB 10.5). I […]
Monitoring MySQL/innoDB post-process
Question : I did INSERT INTO SELECT of a huge table (1TB). When the process is finished, MySQL/InnoDB still does […]
High CPU usage, low memory usage on Mariadb 10.5.8 — SQL tuner complaining about memory, performance seems fine
Question : I’m hoping to get some friendly advice how to proceed with optimizing this server. VM: 8vCPU – 2.6GHz […]
Cannot find aria_s3_copy utility in mariadb 10.5.5
Question : I am not able to find the Aria utility – aria_s3_copy under bin. I use mariadb official docker […]
Why does an integer comparison result in no temporary index in MariaDB?
Question : I am running a query on a table (transaction_items, c. 12 million rows) that has a many-to-many relationship […]
Is CHARSET important for tables with INT only?
Question : My server default CHARSET is UTF-8 (set in my.cnf). I create tables like CREATE TABLE t1 ( ID […]
How can I use LOAD DATA LOCAL INFILE for specific columns?
Question : I have a directory of text files, as the filename is the id, and the content text for […]
MariaDB – Replication – Unable to login remotely
Question : So I’ve been trying to configure MariaDB replication for our server. Unfortunately I cannot get it replicating correctly. […]