# Can we have rocksdb as the one and only on-disk storage engine for percona mysql 8.0.x

**URL:** <https://forums.percona.com/t/can-we-have-rocksdb-as-the-one-and-only-on-disk-storage-engine-for-percona-mysql-8-0-x/22097>\
**Category:** Percona Server for MySQL 8.0\
**Created:** [May 17, 2023, 1:52am UTC](https://forums.percona.com/t/can-we-have-rocksdb-as-the-one-and-only-on-disk-storage-engine-for-percona-mysql-8-0-x/22097 "2023-05-17T01:52:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![D\_T](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/d_t/32/10615_2.png) [@D\_T](https://forums.percona.com/u/D_T)\
**Post date:** [May 17, 2023, 1:52am UTC](https://forums.percona.com/t/can-we-have-rocksdb-as-the-one-and-only-on-disk-storage-engine-for-percona-mysql-8-0-x/22097/1 "2023-05-17T01:52:26Z")

</div>

Is it possible to have rocksdb as the only storage engine that stores data on-disk?

It seems like ‘skip\_innodb’ config parameter has been deprecated and innodb made mandatory from 5.7 onwards.

Is there a email thread or forum posting that discusses this? What are the changes, either in code or configuration, that need to be made so that we have only rocksdb writing to disk.

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [May 17, 2023, 3:51am UTC](https://forums.percona.com/t/can-we-have-rocksdb-as-the-one-and-only-on-disk-storage-engine-for-percona-mysql-8-0-x/22097/2 "2023-05-17T03:51:21Z")

</div>

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.