MySQL 5.5 Innodb_buffer_pool_bytes_data status variable missing

Question

We're running a MySQL 5.5.29 server in Production. If I do:

SHOW GLOBAL STATUS;

I'm not getting the status variable 'Innodb_buffer_pool_bytes_data' which according to the official documentation for this version should be there. What am I missing here?

mysql> SHOW GLOBAL STATUS where variable_name IN ('Innodb_buffer_pool_bytes_data'); is working perfectly for me. — atokpas, May 04 '17 at 08:40
Not for me unfortunately: ERROR 1054 (42S22) at line 1: Unknown column 'Innodb_buffer_pool_bytes_data' in 'where clause'. But this is another problem. There is just no such statvar!? — user214259, May 04 '17 at 08:54

score 0 · Answer 1 · edited May 12 '17 at 20:48

0

Run show global status like 'Innodb_buffer_pool_bytes_data';

edited May 12 '17 at 20:48

András Váczi

answered May 12 '17 at 16:48

ash_01

1

Please study carefully the formatting options and https://dba.stackexchange.com/help/how-to-answer to see what makes a good answer. – András Váczi May 12 '17 at 20:48

1 Answers1