Hot answers tagged

2

I have some annoying news for you. MySQL 5.7 has InnoDB enabled permanently. It's in the Docs: Important InnoDB cannot be disabled. The --skip-innodb option is deprecated and has no effect, and its use results in a warning. It will be removed in a future MySQL release. This also applies to its synonyms (--innodb=OFF, --disable-innodb, and so forth). ...


1

I just encountered a question 5 days ago : InnoDB errors and crashes with MyISAM database? When troubleshooting the issue in a live chat session, I discovered that dirty pages from Temporary InnoDB Tables were occupying the InnoDB Buffer Pool. The file ibtmp was 482MB with 75% of the buffer pool being dirty since innodb_max_dirty_pages_pct was 75. The ...


1

I know this question is a year old but thought I would post an answer considering there is no real answer to this that I have found. In this answer, for the remote server commands, I'm assuming you're using a Linux Debian-based OS. Otherwise there is another option at the end. This sounds like an issue in the storage engine "ibdata1" file in your /var/lib/...


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