New answers tagged

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
0 votes

Row size too large (> 8126)

For me, just running OPTIMIZE TABLE <table_name> solved the problem.
user avatar
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,746
1 vote

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,746
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
0 votes

Problem with phpmyadmin - no table

Here it is (thx for reply) <?php $servername = "localhost"; $database = "sensor"; $username = "root"; $password = ""; // Create ...
user avatar
0 votes

innodb cluster group replication Error_code: 1594

OK, so basiclly the solution was very simple:) setting relay_log_recovery=1 automatically recovered the logs from the master. Taken from MySQL docs (https://dev.mysql.com/doc/refman/5.7/en/replication-...
user avatar
0 votes

difference between page cleaner and background writer

page cleaner: when you execute commands on your database such as insert, update, and delete. data will change but before it goes to the hard disk it will go to the buffer. to make sure any other user ...
user avatar
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

Top 50 recent answers are included