MySQL Bugs: #56124: implement global variable to show current value of core-file

Bug #56124	implement global variable to show current value of core-file
Submitted:	19 Aug 2010 17:40	Modified:	23 Jan 2021 17:03
Reporter:	Shane Bester (Platinum Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Options	Severity:	S4 (Feature request)
Version:	5.1.49, 5.5.5	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
please expose the current value of my.cnf's core-file option in 'show global variables'

How to repeat:
try determine what the value currently is for a running server.

show global variables like '%core%';
select * from information_schema.global_variables where variable_name like '%core%';

Suggested fix:
expose opt_core in global variables.

s/opt_core/if test_flags has the bit set for TEST_CORE_ON_SIGNAL/ :)

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/130940

3261 Tatiana Azundris Nurnberg	2011-02-10
      Bug#56124: implement global variable to show current value of core-file
      
      implements feature, adds tests.
     @ mysql-test/suite/sys_vars/r/core_file_basic.result
        test results
     @ mysql-test/suite/sys_vars/t/core_file_basic-master.opt
        turn on core-dumps
     @ mysql-test/suite/sys_vars/t/core_file_basic.test
        show that I/S and SHOW VARIABLES displays work
     @ sql/sys_vars.cc
        add a read-only display for whether core-dumps are enabled.
     @ sql/sys_vars.h
        implement a generic boolean display for any given bit in the test_flags global.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/130942

3477 Tatiana Azundris Nurnberg	2011-02-10 [merge]
      merge and fixes for Bug#56124

correcting, pushed for 5.6.2-m5

Has actually been fixed since 5.6.37 at least, and should be closed as fixed?

mysql> show global variables like '%core%';
+---------------------------------+-------+
| Variable_name                   | Value |
+---------------------------------+-------+
| core_file                       | ON    |
| innodb_buffer_pool_in_core_file | ON    |
+---------------------------------+-------+
2 rows in set (0.01 sec)

mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.23    |
+-----------+
1 row in set (0.00 sec)

https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_buffer_pool_i...

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_core_file