Bug #49244 Default storage engine at database level

• Submitted: 1 Dec 2009 0:49
• Modified: 1 Dec 2009 10:53
• Reporter: Federico Razzoli (OCA)
• Status: Duplicate
• Category: MySQL Server
• Severity: S4 (Feature request)
• OS: Any
• CPU Architecture: Any

[1 Dec 2009 0:49] Federico Razzoli

Description:
MySQL allows one to specify a default storage engine using the storage_engine variable. This may be useful for someone, but I think it would be more useful to set a default SE for each database. It would be consistent with the ability to set a default charset / collation for each db.

How to repeat:
feature request

Suggested fix:
CREATE DATABASE db_name [DEFAULT] ENGINE = innodb

ALTER DATABASE db_name [DEFAULT] ENGINE = pbxt

[1 Dec 2009 4:41] Valeriy Kravchuk

I think this is a duplicate of bug #48489. Please, check.

[1 Dec 2009 9:33] Federico Razzoli

Yes. That feature request is more general than this one, and I agree with the reporter.
Sorry for creating a duplicate.

[1 Dec 2009 10:53] Valeriy Kravchuk

Duplicate of bug #48489.