MySQL Bugs: #3560: key_* variables set to 0 with latest 4.1.2 bk tree

Bug #3560	key_* variables set to 0 with latest 4.1.2 bk tree
Submitted:	25 Apr 2004 23:58	Modified:	28 Apr 2004 12:02
Reporter:	jocelyn fournier (Silver Quality Contributor)	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	4.1.2 bk tree	OS:	Linux (Linux)
Assigned to:	Dean Ellis	CPU Architecture:	Any

Description:
Hi,

With latest 4.1.2 bk tree key_* variables are set to 0. (and the key_cache *IS* disabled according to key_read_requests/key_reads)

Show variables displays :

| key_buffer_size                 | 0                                      |
| key_cache_age_threshold         | 0                                      |
| key_cache_block_size            | 0                                      |
| key_cache_division_limit        | 0                                      |

If I revert to a little bit older 4.1.2 bktree version (before the NDB introduction), all is working fine :

| key_buffer_size                 | 1073741824                             |
| key_cache_age_threshold         | 300                                    |
| key_cache_block_size            | 1024                                   |
| key_cache_division_limit        | 100                                    |

Regards,
  Jocelyn

How to repeat:
SHOW VARIABLES LIKE "key%" with the latest bk version.

I cannot repeat this with today's 4.1.2 BK tree:

mysql> show variables like 'key%';
+--------------------------+---------+
| Variable_name            | Value   |
+--------------------------+---------+
| key_buffer_size          | 8388600 |
| key_cache_age_threshold  | 300     |
| key_cache_block_size     | 1024    |
| key_cache_division_limit | 100     |
+--------------------------+---------+

Hi,

After investigation, it seems to be a gcc-3.4.0 related issue : 

if I compile the source with 3.3.3 the problem disappears.

Regards,
  Jocelyn

Thank you one more time Jocelyn