Question : I did INSERT INTO SELECT of a huge table (1TB). When the process is finished, MySQL/InnoDB still does […]
Tag: mariadb-10.5
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. […]
Stored procedure prepared statement no error and not working [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Suddenly, started getting “ERROR 2026 (HY000): Unknown SSL error”
Question : MariaDB instance has been running well for ages, and suddenly, starting about 30 minutes ago, my apps get […]
Creating MEMORY table with varchar in MySQL
Question : I need to create TEMPORARY tables for processing (via JOIN) a large set of data (1M rows), which […]