Comment 2 for bug 896439

Revision history for this message
Ɓukasz Muchlado (lukasz-muchlado) wrote : Re: Crash and restart of MariaDB 5.2.9 after running automysqlbackup on ubuntu 10.04

Thanks for fast and helpful response.

> What is the point of disabling innodb *and* running SELECT * FROM `INNODB_TABLE_STATS` ?

That query was run by backup application, not strictly by user

Workaround for my automysqlbackup problem is to exclude "information_schema" from autogenerated list of databases to backup. (Everything else is backed up without crashing mysqld).

But for me it don't feel right that simply querying:
SELECT * FROM information_schema.innodb_table_stats;
can CRASH whole mariadb server (if innodb storage engine is disabled).

Can I put in mariadb config something like "skip-innodb-table-stats" to feel safe from such crashing queries? (Or only method would be manualy disabling plugins by querying mariadb)?

> check what plugins you use with "show plugins", you probably did not disabled everything

I didn't disabled any plugins except disabling innodb storage engine by puting in config
skip-innodb

"show plugins" shows that everything (except disabled InnoDB STORAGE ENGINE) is enabled.