Hello @D_T,
Starting in MySQL 8, the core system dictionary tables that MySQL uses to store table metadata, manage schemas, stored procedures, user accounts, etc became InnoDB tables. These used to be .frm files back in 5.7 and before. Thus it is now impossible to run MySQL without some InnoDB.
You can SET GLOBAL default_storage_engine=RocksDB so that all tables created without specifying the ENGINE will be created as MyRocks but you would still be able to override manually by saying ENGINE=INNODB.
1 Like