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

Category: InnoDB

How can I set the auto_increment value of a column in an existing InnoDB table, without incurring downtime?

By adminPosted on May 29, 2023

Question : I have an InnoDB table whose primary key column is defined as follows: id INT NOT NULL AUTO_INCREMENT […]

Set up a MySQL slave using mysqldump to get the initial data

By adminPosted on May 27, 2023

Question : I have a master database which already has some data in it. The tables in the master database […]

MySQL Enterprise Backup error: Log scan was only able to reach xxxx

By adminPosted on May 27, 2023

Question : I use MySQL Enterprise Backup to make incremental backups, but when I apply a restore (copy-back), I can’t […]

Which MySQL storage engine is the most similar to ARCHIVE when that is not available?

By adminPosted on May 27, 2023

Question : I have a table that contains a log of events that is written to often and read very […]

Which one to use? InnoDB Replication or MySQL Cluster?

By adminPosted on May 26, 2023

Question : I am building a url shortener and I use InnoDB as the storage engine for link data. I […]

Why is it slower to access records at the end of the database?

By adminPosted on May 24, 2023

Question : I have a mysql innodb database running with some 200k records, and I’m having some unexpected slowdown when […]

Is Mysql creating any temp table , when running Mysql delete query?

By adminPosted on May 24, 2023

Question : Server details We have one Galera cluster Mariadb with 3 nodes . On primary node database size is […]

Percona pt-deadlock-logger strange results

By adminPosted on May 22, 2023

Question : Running the deadlock detector from Percona Toolkit, I get something like the following (MySQL 5.7 / AWS RDS, […]

UPDATE query periodically is slower by factor of 5000x

By adminPosted on May 21, 2023

Question : I run a site (Magento) which have a problem with a specific UPDATE query. Under heavy load, this […]

How to use Limit in query on my index column without scan all rows?

By adminPosted on May 20, 2023

Question : Here is my table : In my table Clustering_key (Primary key and auto incremental) ID (Index Column) Data […]

  • 1
  • 2
  • 3
  • …
  • 137

Recent Posts

  • Logs growing and took up entire log drive even with log backups [duplicate]
  • How can I optimize this query?
  • Updating BLOB Columns
  • Availability groups NIC best practices
  • Need to create join on multiple ids on same cell
  • how to find number of empty tables in any schema?
  • Get all records from inner joined tables if second table does not have data
  • Is there an Express version of Azure SQL DB?
  • Optimize schema and query for overlapping date ranges query
  • Merging one-to-many and one-to-one relation in the same JSON object in postgresql
  • Mysql Replication trigger not executing on slave
  • Set priority for an SQL Server role
  • How can I group two joined tables
  • SQL Server Chaining Many-To-Many tables
  • Help with design of sales database
  • Chat schema for PostgreSQL and MongoDB
  • PostgreSQL Database Migration
  • MDX datetime comparison
  • How PostgresSQL stores duplicated VARCHAR values in a column
  • Shrinking T-Log file every weekend basis

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