Hot answers tagged

2 votes
Accepted

MySQL InnoDB migrations custom implementation: How to deal with DML statements which trigger a commit in the background?

I think you mean DDL. DML statements are like SELECT/INSERT/UPDATE/DELETE, and I can't think of one of the DML statements that cause an implicit commit. If you're concerned about a crash partway ...
user avatar
  • 9,761
1 vote

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

Can you live with 191 instead of 225? If not, your 5 options (including that one) are here: http://mysql.rjweb.org/doc.php/limits#767_limit_in_innodb_indexes
user avatar
  • 68.7k
1 vote
Accepted

single insert ignore on a table with no auto-increment

This can be confirmed in a test. Open two windows. In the first window: mysql> insert into t values (1, 10), (3, 30); mysql> begin; mysql> insert ignore into t values (1, 10); Query OK, 0 ...
user avatar
  • 9,761
1 vote
Accepted

Database becoming unresponsive after time (4 to 24 hours)

Turns out it is a known issue on proxmox+mariadb https://forum.proxmox.com/threads/snapshot-backup-not-working-guest-agent-fs-freeze-gets-timeout.99887/page-2
user avatar
1 vote

OPTIMIZE TABLE seems to "lock" tables (innodb)

The answer from Rick James is very wrong and misleading, so I felt the need to provide a different one. Please refer to https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html for requirements for ...
user avatar
  • 111

Only top scored, non community-wiki answers of a minimum length are eligible