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

Tag: percona-toolkit

pt-online-schema-change failed when creating new tablle, specified key was too long; max key length is 767 bytes issue

By adminPosted on February 23, 2023

Question : The version, mysql is InnoDB 5.6.10-log, pt-online-schema-change 3.1.0. table info is `email` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `uid` […]

Cleanup / Prune Unreferenced Data in Dimension Tables

By adminPosted on August 2, 2022

Question : We have a star schema data warehouse running on MySQL 5.6. We keep a rolling 18 months of […]

Skipping chunk X of Y.Z because MySQL chose no index instead of the word_sid_typeindex

By adminPosted on July 18, 2021

Question : My environment: # cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.8 (Santiago) # uname -a Linux A.B.C […]

Is it necessary to run apply-log immediately after innobackupexec has run?

By adminPosted on July 4, 2021

Question : i have been trying to read other questions, but i did not find a answer to suit me. […]

Where is pt-table-checksum finding this hostname?

By adminPosted on April 26, 2021

Question : The Setup: An EC2 instance running MySQL 5.6 locally replicating to RDS MySQL. The VPC IP address range […]

Recent Posts

  • How to set roles and users with correct permissions on Postgres? [closed]
  • SQL query optmization [closed]
  • Is it possible to optimize this query? Currently taking days (no sign of stopping) on ~11 million records
  • We use MongoDB 3.6 community version, How can i get the number of hits on single collection as well as bandwith usage?
  • Will too many tables slow Mysql down?
  • Group By hour over large dataset
  • “Force Encryption” vs “Force Protocol Encryption” in SQL Server
  • Mysql checksum for master-slave replication returning different values, despite being identical
  • Same record shows up multiple times in ordered paginated query
  • Allow users to only view the databases they have access to
  • Does ALTER on PostgreSQL, Oracle table (respectively) create intermediate copy of the table?
  • Delete rows from a large table with joins and aggregating (resulting in 1 % less rows in the big table)
  • How to record sqlplus session activity like “/var/messages” in Unix..? [closed]
  • Mysql dump with View dependent on user
  • How does Oracle know who I am?
  • Filter a SQL replication
  • Return values from Left Table Only Once
  • Get the list of all Tables, Views, Stored procedures that are not added in a publication for replication
  • Optional oneToOne relations and criteria field
  • Create incremental/differential backups in ProgressDB

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