SQL helper

1. check db the long running transaction
select * from information_schema.innodb_trx where TIME_TO_SEC(timediff(now(),trx_started))>60;
2. Rebuild index
alter table T engine=InnoDB;
3. Innodb buffer pool
buffer pool composite
4. Double write
3 steps of double write

Refer:

1. InnoDB关键特性之double write

Leave a Reply

Your email address will not be published. Required fields are marked *