MySQL Bugs: #83273: set innodb_buffer_pool_size to default value if malloc fails

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:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	8.0.0	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	usability

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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