Bug #83273 set innodb_buffer_pool_size to default value if malloc fails
Submitted: 5 Oct 2016 15:14
Reporter: Justin Swanhart Email Updates:
Status: Open Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version:8.0.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: usability

[5 Oct 2016 15:14] Justin Swanhart
innodb_buffer_pool_size is now a dynamic variable.  It could be set too large by a SET PERSIST or set too large in the my.cnf if memory has been removed from a system (for example, it was migrated to a smaller VM).

I would like innodb_buffer_pool_size set to the default value if the malloc fails because the value is too large.  A message should be written to the log that the server will likely experience lower performance because the BP is smaller than requested.

Because the variable is dynamic, it can be set at runtime to a larger value with SET PERSIST.

How to repeat:
try to start server with too large BP size

Suggested fix:
see above