Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC

Bug #1648015
Comment #15

Comment 15 for bug 1648015

Revision history for this message

Adrian Słowik (slowik-adrian) wrote on 2016-12-08:

#15

When I fill the buffer pool and then start dropping tables, mysql freezes after saveral drops.

Monitoring of buffer pool data during the process:

[[root@pm05 :: (none)]] > show global status like "%buffer_pool_bytes%";
+--------------------------------+-------------+
| Variable_name | Value |
+--------------------------------+-------------+
| Innodb_buffer_pool_bytes_data | 60038922240 |
| Innodb_buffer_pool_bytes_dirty | 372752384 |
+--------------------------------+-------------+
2 rows in set (0.00 sec)

[[root@pm05 :: (none)]] > show global status like "%buffer_pool_bytes%";
+--------------------------------+-------------+
| Variable_name | Value |
+--------------------------------+-------------+
| Innodb_buffer_pool_bytes_data | 60038922240 |
| Innodb_buffer_pool_bytes_dirty | 339984384 |
+--------------------------------+-------------+
2 rows in set (0.00 sec)

[[root@pm05 :: (none)]] > show global status like "%buffer_pool_bytes%";
+--------------------------------+-------------+
| Variable_name | Value |
+--------------------------------+-------------+
| Innodb_buffer_pool_bytes_data | 60038922240 |
| Innodb_buffer_pool_bytes_dirty | 325713920 |
+--------------------------------+-------------+
2 rows in set (0.00 sec)

[[root@pm05 :: (none)]] > show global status like "%buffer_pool_bytes%";
+--------------------------------+-------------+
| Variable_name | Value |
+--------------------------------+-------------+
| Innodb_buffer_pool_bytes_data | 60038922240 |
| Innodb_buffer_pool_bytes_dirty | 288768000 |
+--------------------------------+-------------+
2 rows in set (0.01 sec)

[[root@pm05 :: (none)]] > show global status like "%buffer_pool_bytes%";
+--------------------------------+-------------+
| Variable_name | Value |
+--------------------------------+-------------+
| Innodb_buffer_pool_bytes_data | 60038922240 |
| Innodb_buffer_pool_bytes_dirty | 288768000 |
+--------------------------------+-------------+
2 rows in set (0.00 sec)

Looks like it's not PXC issue, but mysql 5.7 bug

When I fill the buffer pool and then start dropping tables, mysql freezes after saveral drops.

Monitoring of buffer pool data during the process:

[[root@pm05 :: (none)]] > show global status like "%buffer_pool_bytes%";
+--------------------------------+-------------+
| Variable_name                  | Value       |
+--------------------------------+-------------+
| Innodb_buffer_pool_bytes_data  | 60038922240 |
| Innodb_buffer_pool_bytes_dirty | 372752384   |
+--------------------------------+-------------+
2 rows in set (0.00 sec)

[[root@pm05 :: (none)]] > show global status like "%buffer_pool_bytes%";
+--------------------------------+-------------+
| Variable_name                  | Value       |
+--------------------------------+-------------+
| Innodb_buffer_pool_bytes_data  | 60038922240 |
| Innodb_buffer_pool_bytes_dirty | 339984384   |
+--------------------------------+-------------+
2 rows in set (0.00 sec)

[[root@pm05 :: (none)]] > show global status like "%buffer_pool_bytes%";
+--------------------------------+-------------+
| Variable_name                  | Value       |
+--------------------------------+-------------+
| Innodb_buffer_pool_bytes_data  | 60038922240 |
| Innodb_buffer_pool_bytes_dirty | 325713920   |
+--------------------------------+-------------+
2 rows in set (0.00 sec)

[[root@pm05 :: (none)]] > show global status like "%buffer_pool_bytes%";
+--------------------------------+-------------+
| Variable_name                  | Value       |
+--------------------------------+-------------+
| Innodb_buffer_pool_bytes_data  | 60038922240 |
| Innodb_buffer_pool_bytes_dirty | 288768000   |
+--------------------------------+-------------+
2 rows in set (0.01 sec)

[[root@pm05 :: (none)]] > show global status like "%buffer_pool_bytes%";
+--------------------------------+-------------+
| Variable_name                  | Value       |
+--------------------------------+-------------+
| Innodb_buffer_pool_bytes_data  | 60038922240 |
| Innodb_buffer_pool_bytes_dirty | 288768000   |
+--------------------------------+-------------+
2 rows in set (0.00 sec)

Looks like it's not PXC issue, but mysql 5.7 bug