Bug #34363 myisam_block_size: Expose it as a system variable
Submitted: 6 Feb 2008 21:12 Modified: 31 Oct 2008 16:07
Reporter: Paul DuBois Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: General Severity:S4 (Feature request)
Version:all OS:Any
Assigned to: CPU Architecture:Any

[6 Feb 2008 21:12] Paul DuBois
Description:
This is a feature request to expose myisam_block_size as a system variable, per the following conversation:

----
Date: Wed, 6 Feb 2008 22:04:48 +0100
From: Sergei Golubchik <serg@mysql.com>
To: Paul DuBois <paul@mysql.com>
Subject: Re: myisam_block_size not a system variable after all?

Hi!

On Feb 05, Paul DuBois wrote:
> At 1:11 PM +0100 2/5/08, Sergei Golubchik wrote:
> >Hi!
> >
> >On Feb 04, Paul DuBois wrote:
> >> Hi Serg,
> >>
> >> In mysqld.cc, the option structure for myisam_block_size lists it
> >> in the section where system variables are listed, and lists the name
> >> with underscores rather than dashes (further implying that it is
> >> a system variable).
> >>
> >> However, it does not appear in set_var.cc, and is not listed by
> >> SHOW VARIABLES. Is it not a system variable after all, or is it
> >> supposed to be a system variable and it is a bug that set_var.cc/SHOW
> >> VARIABLES know nothing about it?
> >
> >Yeah, I don't see why it cannot be a server variable
> 
> Okay, I can file a bug report/feature request.  I suppose I should
> suggest some semantics for it:
> 
> - Has a GLOBAL value only (it doesn't make sense for this to have a
> SESSION value, does it?)
> - Should it be settable at runtime, or only at server startup?

Difficult to say. Maria's maria_block_size is only settable at startup,
let's do the same here.
----

So the request is:

- Expose myisam_block_size as a system variable
- This variable should have only a GLOBAL value
- The value should be settable only at server startup, i.e., not dynamic.

Thank you.

How to repeat:
N/A
[6 Feb 2008 21:18] Paul DuBois
Ah, it appears that Bug#20407 and Bug#33098 are related.
[10 Feb 2008 19:16] Valeriy Kravchuk
Thank you for a reasonable feature request.
[31 Oct 2008 16:07] Paul DuBois
Changing documentation to document myisam_block_size as a startup option only, not as a system variable.

See also Bug#20407, Bug#33098.