Bug #9204 innodb_buffer_pool_size > 4GB not displayed correctly via SHOW VARIABLES
Submitted: 15 Mar 2005 21:21 Modified: 20 Apr 2005 6:28
Reporter: Dean Ellis Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.24 OS:
Assigned to: Jani Tolonen CPU Architecture:Any

[15 Mar 2005 21:21] Dean Ellis
Description:
innodb_buffer_pool_size > 4GB is displayed incorrectly with SHOW VARIABLES.

4.1 is unaffected; in 4.0 SHOW_LONG casts to uint32, which is presumably the cause.

How to repeat:
mysqld --innodb_buffer_pool_size=6GB

SHOW VARIABLES LIKE 'innodb_buffer_pool_size';

Suggested fix:
n/a
[20 Apr 2005 6:28] Jani Tolonen
As bug reporter noted, this bug does not exists in 4.1 or 5.0. Fixing it to
4.0 would require another net_store_data() function, which takes ulong
instead of uint32 as the second parameter. While not hard to implement,
it could potentially change behavior in some places, or cause a bug.
As this is not critical, will leave it unfixed in 4.0.