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 4, 2017 at 8: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 4, 2017 at 8:54

dezso · Accepted Answer · 2017-05-12 20:48:55Z

0

Run show global status like 'Innodb_buffer_pool_bytes_data';

dezso

31k13 gold badges100 silver badges147 bronze badges

answered May 12, 2017 at 16:48

ash_01

647 bronze badges

1

Please study carefully the formatting options and dba.stackexchange.com/help/how-to-answer to see what makes a good answer.
– dezso
May 12, 2017 at 20:48

Add a comment |

1 Answer 1