Bug #48489 Expand ALTER DATABASE to include per-database settings beyond character set

• Submitted: 2 Nov 2009 22:57
• Modified: 3 Nov 2009 5:57
• Reporter: Tim Soderstrom
• Status: Verified
• Category: MySQL Server: DDL
• Severity: S4 (Feature request)
• Version: 6.0
• OS: Any
• CPU Architecture: Any
• Tags: alter database, Postgresql

[2 Nov 2009 22:57] Tim Soderstrom

Description:
I noticed that some other DB platforms (including one open-source Elephant in the room) have a much more useful ALTER DATABASE command. Some things I would like to see MySQL have would be per-database settings for:

sql_mode
default-storage-engine
per-thread buffers
slow query log settings (ie long_query_time)

This would be much kick-ass...

How to repeat:
N/A

Suggested fix:
N/A

[3 Nov 2009 5:57] Valeriy Kravchuk

Thank you for the feature request.

[1 Dec 2009 10:54] Valeriy Kravchuk

Bug #49244 was marked as a duplicate of this one.