Question : I need to create TEMPORARY tables for processing (via JOIN) a large set of data (1M rows), which […]
Tag: mariadb-10.5
MariaDB optimizing geo IP lookup with Maxmind GeoLite2 database
Question : I have the following two tables that I ingest with data from Maxmind’s GeoLite2 Country database: CREATE TABLE […]
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 […]
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 […]
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 […]