Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: mariadb-10.5

Creating MEMORY table with varchar in MySQL

By adminPosted on June 13, 2023

Question : I need to create TEMPORARY tables for processing (via JOIN) a large set of data (1M rows), which […]

MariaDB optimizing geo IP lookup with Maxmind GeoLite2 database

By adminPosted on May 24, 2023

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

By adminPosted on March 25, 2023

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

By adminPosted on February 6, 2023

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

By adminPosted on January 31, 2023

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

By adminPosted on October 10, 2022

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

By adminPosted on August 14, 2022

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

By adminPosted on July 2, 2022

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

By adminPosted on May 16, 2022

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?

By adminPosted on May 14, 2022

Question : I am running a query on a table (transaction_items, c. 12 million rows) that has a many-to-many relationship […]

  • 1
  • 2
  • 3
  • 4

Recent Posts

  • Macroeconomic Time-Series Database
  • OUTER JOIN with join condition causes unexpected results
  • Need help with my.cnf: 32GB RAM and 3GB of InnoDB tables
  • How to model an activity feed
  • trigram matching on a jsonb array
  • Trigger to prevent update when Flag value is 1
  • SQL, SQLCLR objects & effective memory utilization
  • Queries on Mongo Secondary are not equally distributed
  • Timezone offset displayed though it shouldn’t be stored
  • Use composite type to create new table
  • what is ‘#’ in create table statement?
  • how to avoid duplicated column in two different tables?
  • RMAN – Archivelog deletion policy ignored
  • Query runs quicker when column calculation is done after initial query
  • Generating Error when data size is larger then max text repl size
  • mysql: Is mysqladmin -p create equivalent to create database?
  • Recovering from removal of ibdata1 [duplicate]
  • Reviewing all code on a SQL Server Instance
  • Select query on 8 million records with greater and less than columns (Slow)
  • Database Performance Tuning

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding