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

Tag: multiple-database

I dont know where to begin: mysql select with inner selects on iterations too slow with bigger tables ( 4 tables on 2 databases)

By adminPosted on August 22, 2023

Question : Kontext is easy: A) A [discussion-thread.db1] has many [Posts.db1] B) each Post has an [author.db2] and 1 to […]

I dont know where to begin: mysql select with inner selects on iterations too slow with bigger tables ( 4 tables on 2 databases)

By adminPosted on July 28, 2023

Question : Kontext is easy: A) A [discussion-thread.db1] has many [Posts.db1] B) each Post has an [author.db2] and 1 to […]

Does it matter which database you connect to when querying across multiple databases?

By adminPosted on October 28, 2022

Question : I’m building a Sharepoint application with Nintex workflow that runs a single SQL query over multiple databases (on […]

How do I set up one server to replicate X schemas from X different server, without resorting to mysqldump?

By adminPosted on October 30, 2021

Question : In other words; I’m trying to figure out how to restore multiple mariabackup dumps to one server (different […]

I dont know where to begin: mysql select with inner selects on iterations too slow with bigger tables ( 4 tables on 2 databases)

By adminPosted on March 25, 2021

Question : Kontext is easy: A) A [discussion-thread.db1] has many [Posts.db1] B) each Post has an [author.db2] and 1 to […]

Recent Posts

  • 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
  • how to script out database users and permissions in all user databases in the instance [closed]
  • Is it possible to have a shared secondary Mongo DB instance between two replica sets..?

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