[MDEV-6544] 98% CPU load caused by innodb_buffer_pool_size without any application Created: 2014-08-06  Updated: 2014-09-15  Due: 2014-09-13  Resolved: 2014-09-15

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.12
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: HaPe4 Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: None
Environment:

Raspberry Pi with Archlinuxarm


 Description   

Trying to run mariadb on a Raspberry Pi for a small database I changed some parameters in the .cnf file to smaller values to save RAM

When setting
innodb_buffer_pool_size = 4M

the CPU-load of the Raspberry Pi jumps permanently (or at least for a very long time) to 98% without any database application running.

Returning to

innodb_buffer_pool_size = 4M

shows process mysqld with less than 1% CPU-load

 Comments   
Comment by Elena Stepanova [ 2014-08-13 ]

Hi,

Your description contains two identical values for innodb_buffer_pool_size, please correct it.

Please also attach your cnf file(s).

What is the total memory size?
What is the "small database" exactly?
At which point the CPU usage jumps – is it on startup, or on executing some SQL (and if so, what kind of queries), or...

Thanks.

Comment by Elena Stepanova [ 2014-09-15 ]

Closing as incomplete for now; if you have any new information, please comment to re-open the issue.

Generated at Thu Feb 08 07:12:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.