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 ...
- 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
- 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 ...
- 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
- 41
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 ...
- 111
Only top scored, non community-wiki answers of a minimum length are eligible