Bug #74009 | Buffer Pool graph: used > total | ||
---|---|---|---|
Submitted: | 22 Sep 2014 10:50 | Modified: | 22 Sep 2014 13:24 |
Reporter: | Daniël van Eeden (OCA) | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Enterprise Monitor: Web | Severity: | S3 (Non-critical) |
Version: | 3.0.14 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[22 Sep 2014 10:50]
Daniël van Eeden
[22 Sep 2014 10:52]
Daniël van Eeden
Graph
Attachment: mem_bp_used_gt_total.png (image/png, text), 50.97 KiB.
[22 Sep 2014 10:52]
Daniël van Eeden
I expect this to be due to compression being activated.
[22 Sep 2014 13:24]
MySQL Verification Team
Hello Daniël, Thank you for the report. Verified as described. You are right compression triggers this issue. Thanks, Umesh
[22 Sep 2014 13:26]
MySQL Verification Team
How to repeat: Run something like below, and observe the buffer pool graph: SET GLOBAL innodb_file_per_table=1; SET GLOBAL innodb_file_format=Barracuda; drop table if exists keyvalue10; CREATE TABLE `keyvalue10` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(250), PRIMARY KEY (`id`) ) ENGINE=innodb ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;; set @id:=0; insert into `keyvalue10` values (@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)); insert into `keyvalue10`(`id`,`name`) select @id:=@id+1,md5(rand()*1000000) from `keyvalue10` k1, `keyvalue10` k2, `keyvalue10` k3, `keyvalue10` k4,`keyvalue10` k5,`keyvalue10` k6, `keyvalue10` k7, `keyvalue10` k8, `keyvalue10` k9, `keyvalue10` k0,`keyvalue10` ka, `keyvalue10` kb, `keyvalue10` kc, `keyvalue10` kd limit 10000000;