Geek Answers Handbook

How to configure the default mechanism at the circuit level? [MySQL]

I am trying to set the default database engine for each of my MySQL schemas, but I cannot figure out how to do this.

I know that you can specify the mechanism at the table level and in the configuration file with --default-storage-engine=type , but is there no way to set it at the schema level?

+4
source share
1 answer

No, you can configure the engine for use in the CREATE TABLE statement, or you can set the default value using the -default-storage-engine server start option or set the default storage option in my .cnf. Finally, you can set the default storage engine that will be used during the current session by setting the storage_engine storage_engine variable.

There is no default schema storage mechanism.

+5
source

More articles:


All Articles