MariaDB [test]> create table test as select seq from seq_1_to_300;
|
Query OK, 300 rows affected (0.003 sec)
|
Records: 300 Duplicates: 0 Warnings: 0
|
|
MariaDB [test]> show global status like 'innodb_buffer_pool_read%';
|
+---------------------------------------+-------+
|
| Variable_name | Value |
|
+---------------------------------------+-------+
|
| Innodb_buffer_pool_read_ahead_rnd | 0 |
|
| Innodb_buffer_pool_read_ahead | 0 |
|
| Innodb_buffer_pool_read_ahead_evicted | 0 |
|
| Innodb_buffer_pool_read_requests | 0 |
|
| Innodb_buffer_pool_reads | 165 |
|
+---------------------------------------+-------+
|
5 rows in set (0.001 sec)
|
|
MariaDB [test]> shutdown;
|
Query OK, 0 rows affected (0.001 sec)
|
|
MariaDB [test]> show global status like 'innodb_buffer_pool_read%';
|
ERROR 2006 (HY000): Server has gone away
|
No connection. Trying to reconnect...
|
Connection id: 3
|
Current database: test
|
|
+---------------------------------------+-------+
|
| Variable_name | Value |
|
+---------------------------------------+-------+
|
| Innodb_buffer_pool_read_ahead_rnd | 0 |
|
| Innodb_buffer_pool_read_ahead | 0 |
|
| Innodb_buffer_pool_read_ahead_evicted | 0 |
|
| Innodb_buffer_pool_read_requests | 0 |
|
| Innodb_buffer_pool_reads | 169 |
|
+---------------------------------------+-------+
|
5 rows in set (0.005 sec)
|
|
MariaDB [test]> select count(*) from test;
|
+----------+
|
| count(*) |
|
+----------+
|
| 300 |
|
+----------+
|
1 row in set (0.001 sec)
|
|
MariaDB [test]> show global status like 'innodb_buffer_pool_read%';
|
+---------------------------------------+-------+
|
| Variable_name | Value |
|
+---------------------------------------+-------+
|
| Innodb_buffer_pool_read_ahead_rnd | 0 |
|
| Innodb_buffer_pool_read_ahead | 0 |
|
| Innodb_buffer_pool_read_ahead_evicted | 0 |
|
| Innodb_buffer_pool_read_requests | 0 |
|
| Innodb_buffer_pool_reads | 169 |
|
+---------------------------------------+-------+
|
5 rows in set (0.001 sec)
|
Bug
Critical
MariaDB [test]> create table test as select seq from seq_1_to_300;Query OK, 300 rows affected (0.003 sec)Records: 300 Duplicates: 0 Warnings: 0MariaDB [test]> show global status like 'innodb_buffer_pool_read%';+---------------------------------------+-------+| Variable_name | Value |+---------------------------------------+-------+| Innodb_buffer_pool_read_ahead_rnd | 0 || Innodb_buffer_pool_read_ahead | 0 || Innodb_buffer_pool_read_ahead_evicted | 0 || Innodb_buffer_pool_read_requests | 0 || Innodb_buffer_pool_reads | 165 |+---------------------------------------+-------+5 rows in set (0.001 sec)MariaDB [test]> shutdown;Query OK, 0 rows affected (0.001 sec)MariaDB [test]> show global status like 'innodb_buffer_pool_read%';ERROR 2006 (HY000): Server has gone awayNo connection. Trying to reconnect...Connection id: 3Current database: test+---------------------------------------+-------+| Variable_name | Value |+---------------------------------------+-------+| Innodb_buffer_pool_read_ahead_rnd | 0 || Innodb_buffer_pool_read_ahead | 0 || Innodb_buffer_pool_read_ahead_evicted | 0 || Innodb_buffer_pool_read_requests | 0 || Innodb_buffer_pool_reads | 169 |+---------------------------------------+-------+5 rows in set (0.005 sec)MariaDB [test]> select count(*) from test;+----------+| count(*) |+----------+| 300 |+----------+1 row in set (0.001 sec)MariaDB [test]> show global status like 'innodb_buffer_pool_read%';+---------------------------------------+-------+| Variable_name | Value |+---------------------------------------+-------+| Innodb_buffer_pool_read_ahead_rnd | 0 || Innodb_buffer_pool_read_ahead | 0 || Innodb_buffer_pool_read_ahead_evicted | 0 || Innodb_buffer_pool_read_requests | 0 || Innodb_buffer_pool_reads | 169 |+---------------------------------------+-------+5 rows in set (0.001 sec)