Bug #117102 Histogram Statistics Analysis cannot apply on standby database

• Submitted: 3 Jan 8:48
• Modified: 13 Jan 14:50
• Reporter: xincheng xie
• Status: Closed
• Category: MySQL Server: Replication
• Severity: S3 (Non-critical)
• Version: 8.0.34
• OS: Any
• Assigned to: MySQL Verification Team
• CPU Architecture: Any

[3 Jan 8:48] xincheng xie

Description:
hello,

we have two mysql which version is 8.0.34 ,and one is primary ,another is replica 
and we build Histogram Statistic through the statement( analyze table  update)
Although  binary log has been transferred to the slave  and executed, it has not taken effect yet。 We verify through select the table INFORMATION_SCHEMA.COLUMN_STATISTICS;

How to repeat:
1、 create table test1 (id int); insert into test1 values (1),(2),(3);

2、primary：
ANALYZE TABLE test1 UPDATE HISTOGRAM ON id WITH 10 BUCKETS；

select * from INFORMATION_SCHEMA.COLUMN_STATISTICS;

3、slave：
select * from INFORMATION_SCHEMA.COLUMN_STATISTICS;

we will see nothing happend on slave

[10 Jan 14:12] MySQL Verification Team

Hi,

Can you retry this on latests 8.0, I have issue reproducing this with 8.0.40

[13 Jan 7:44] xincheng xie

ok ，this bug has fixed  in 8.0.40  ，well done

[13 Jan 14:50] MySQL Verification Team

Thanks for confirmation