innodb-flush-method            = O_DIRECT
innodb-log-files-in-group      = 2
innodb-log-file-size           = 512M
innodb-flush-log-at-trx-commit = 2
innodb-buffer-pool-size        = 72G
innodb-file-per-table          = true
innodb-io-capacity             = 80000
innodb-write-io-threads        = 24
innodb-read-io-threads         = 24
innodb-buffer-pool-instances   = 24
innodb-log-buffer-size         = 128M
innodb-sort-buffer-size        = 64M
innodb-numa-interleave         = ON

# numastat -pm | grep mysql
35008 (mysqld_safe)                 0.00            0.75            0.75
36012 (mysqld)                  49900.79        22251.62        72152.41

General error: 1205 Lock wait timeout exceeded; try restarting transaction. The SQL statement executed was: DELETE FROM `fh_user_file_log` WHERE user_id=:ycp0.

CREATE TABLE fh_user_file_log (
  id int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  user_file_id char(13) NOT NULL,
  date datetime NOT NULL,
  reason tinyint(4) DEFAULT NULL,
  user_id int(10) UNSIGNED DEFAULT NULL,
  PRIMARY KEY (id),
  INDEX FK_user_file_log_user_file (user_file_id),
  INDEX IX_user_file_log_date (date),
  INDEX IX_user_file_log_user_date (user_id, date),
  UNIQUE INDEX UK_user_file (user_file_id, reason)
)
ENGINE = INNODB
AUTO_INCREMENT = 321817977
AVG_ROW_LENGTH = 89
CHARACTER SET utf8
COLLATE utf8_general_ci;

UPDATE `fh_user_file` SET `date_updated` = NOW ( ) WHERE `fh_user_file` . `id` = ? 

Searching rows for update

UPDATE `fh_user_file` SET `deleted`=1, `date_updated`=CURRENT_TIMESTAMP WHERE `fh_user_file`.`id`='1690dee813985' AND (deleted = 0)