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

Tag: mariadb-10.3

LEFT JOIN subquery fails in the presence of an EXISTS clause in the main query

By adminPosted on January 19, 2023

Question : I have this query: SELECT c.id contact_id, engagement.sent FROM contact c LEFT JOIN ( /* ➊ Inner query […]

MariaDB doesn’t set authentication_string during installation

By adminPosted on January 18, 2023

Question : I’m setting up a new server using MariaDB (current stable version of 10.3) and I notice that all […]

Query joining four tables resulting in one row

By adminPosted on December 14, 2022

Question : I have these two queries which pull data from four tables: select files.id, files.name, dirs.dir from files inner […]

How to lock all tables except some specific table?

By adminPosted on November 29, 2022

Question : I am trying to set a stage server which replicate some tables like articles, user etc from master. […]

fix InnoDB: corrupted TRX_NO after upgrading to 10.3.31

By adminPosted on November 7, 2022

Question : After upgrading mariadb from 10.3.25 to 10.3.31 it fails to start like described in this bug report I […]

Mysql: Unable to drop a columns NULL default

By adminPosted on October 27, 2022

Question : Running mariadb 10.3 I have a bunch of columns that were created by default as NULL defaults. I […]

SELECT from table without blocking INSERTs into it?

By adminPosted on September 22, 2022

Question : I have an application where each page load inserts information about the visit into a MariaDB table. There […]

How to get more connections for mariaDB or how to reduce RAM usage per thread?

By adminPosted on September 4, 2022

Question : We have an MariaDB 10.3 database server running on an 8 core and 64GB RAM machine. The database […]

MariaDB CONNECT engine to read external mongodb collections

By adminPosted on September 1, 2022

Question : I want to access MongoDB collections through MariaDB 10.4.17. Both are installed on my local machine running Windows […]

ERROR 1067 (42000): Invalid default value for ‘uploadedDate’

By adminPosted on August 25, 2022

Question : Hi everyone i am getting an error trying to run the below query ERROR 1067 (42000): Invalid default […]

  • 1
  • 2
  • 3
  • …
  • 7

Recent Posts

  • What is wrong in debunking myths about clustered indexes?
  • Should “Long Running with Low CPU” be expected for an SPROC that performs millions of INSERTS?
  • What’s the benefit of CROSS JOIN vs INNER JOIN in recursive CTE queries?
  • Mongoexport halts when it reaches 101 records
  • A Script to insert dummy Data in all tables of DB [duplicate]
  • Will query continue to run even after network times-out
  • Need some support on MySQL Query
  • The sort column must be the last column used in the index – MongoDB Indexing Advice
  • Understanding Backup Types
  • SQL Server sp_configure options?
  • DBA Permissions on LOCAL SERVER containing SQL SERVER [closed]
  • Update table using values from another table in SQL Server
  • Getting 0KB of size file while backup mysql database using mysql dump [closed]
  • Local Backup from Amazon RDS PostgreSQL database
  • Who is using my worker threads? SQL Server 2014 – HADR
  • Data Domain Boost viewing backups
  • One table for all persons
  • Database for building a realtime analytics system
  • Threads_cached 0 while thread_cache_size > 0
  • Why is performance non-linear if I do many UPDATEs in a single transaction

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