# Percona mysql 8.0.25-15 crash restarts for count(\*) **URL:** \ **Category:** MySQL & MariaDB\ **Created:** [July 7, 2022, 3:36pm UTC](https://forums.percona.com/t/percona-mysql-8-0-25-15-crash-restarts-for-count/16475 "2022-07-07T15:36:23Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Charan\_Reddy](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/charan_reddy/32/6918_2.png) [@Charan\_Reddy](https://forums.percona.com/u/Charan_Reddy)\ **Post date:** [July 7, 2022, 3:36pm UTC](https://forums.percona.com/t/percona-mysql-8-0-25-15-crash-restarts-for-count/16475/1 "2022-07-07T15:36:23Z")
Hello, I’m having issue with mysql server when doing a select count(_) from table. The mysql server crash restart when doing the count(_) error message: Lost connection to mysql My RAM on the machine is 16GB and my innodb\_buffer\_pool\_size is 13GB Info from error.log 2022-07-06T21:23:35.316227Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-15) starting as process 27393 2022-07-06T21:23:35.426026Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2022-07-06T21:23:36.740294Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2022-07-06T21:23:38.197831Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: ‘::’ port: 33060, socket: /var/lib/mysql/mysqlx.sock Wed Jul 6 21:23:38 2022 PerconaFT recovery starting in env /data/mysql/ Wed Jul 6 21:23:38 2022 PerconaFT recovery scanning backward from 843222 Wed Jul 6 21:23:38 2022 PerconaFT recovery bw\_end\_checkpoint at 843222 timestamp 1657142590908817 xid 843218 (bw\_newer) Wed Jul 6 21:23:38 2022 PerconaFT recovery bw\_begin\_checkpoint at 843218 timestamp 1657142590508642 (bw\_between) Wed Jul 6 21:23:38 2022 PerconaFT recovery turning around at begin checkpoint 843218 time 400175 Wed Jul 6 21:23:38 2022 PerconaFT recovery starts scanning forward to 843222 from 843218 left 4 (fw\_between) Wed Jul 6 21:23:38 2022 PerconaFT recovery closing 2 dictionaries Wed Jul 6 21:23:38 2022 PerconaFT recovery making a checkpoint Wed Jul 6 21:23:38 2022 PerconaFT recovery done 2022-07-06T21:23:38.285525Z 0 [System] [MY-010229] [Server] Starting XA crash recovery… 2022-07-06T21:23:38.302393Z 0 [System] [MY-010232] [Server] XA crash recovery finished. ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [July 7, 2022, 4:41pm UTC](https://forums.percona.com/t/percona-mysql-8-0-25-15-crash-restarts-for-count/16475/2 "2022-07-07T16:41:40Z")
> [@Charan\_Reddy](#): > > My RAM on the machine is 16GB and my innodb\_buffer\_pool\_size is 13GB Your system is running out of memory. Check `dmesg` and system logs to look for “OOM”. Most likely the kernel killed MySQL because it was using too much memory. You need to decrease buffer pool to 8 or 10GB, or add more memory to the server. ---
**Author:** ![Charan\_Reddy](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/charan_reddy/32/6918_2.png) [@Charan\_Reddy](https://forums.percona.com/u/Charan_Reddy)\ **Post date:** [July 7, 2022, 5:27pm UTC](https://forums.percona.com/t/percona-mysql-8-0-25-15-crash-restarts-for-count/16475/3 "2022-07-07T17:27:04Z")
> [@matthewb](#): > > dmesg Thank you @matthewb, I’ll reduce the buffer pool size. Just out of curiosity wouldn’t mysql use max memory of 13Gib since buffer pool size is set to 13Gib. ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [July 7, 2022, 6:05pm UTC](https://forums.percona.com/t/percona-mysql-8-0-25-15-crash-restarts-for-count/16475/4 "2022-07-07T18:05:52Z")
> [@Charan\_Reddy](#): > > wouldn’t mysql use max memory of 13Gib since buffer pool size is set to 13Gib. No. InnoDB buffer pool size only restricts the size of the innodb buffer pool. That’s why it is named like that. It is not called ‘mysql\_buffer\_pool\_size’. InnoDB is 1 engine running within MySQL. There are many other memory allocations that take place within MySQL during normal operations and even more when running queries that examine lots of data. ---
**Author:** ![Charan\_Reddy](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/charan_reddy/32/6918_2.png) [@Charan\_Reddy](https://forums.percona.com/u/Charan_Reddy)\ **Post date:** [July 7, 2022, 6:13pm UTC](https://forums.percona.com/t/percona-mysql-8-0-25-15-crash-restarts-for-count/16475/5 "2022-07-07T18:13:59Z")
Thank you. @matthewb