Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6544

98% CPU load caused by innodb_buffer_pool_size without any application

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Incomplete
    • Affects Version/s: 10.0.12
    • Fix Version/s: N/A
    • Component/s: None
    • 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

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            elenst Elena Stepanova added a comment -

            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.

            Show
            elenst Elena Stepanova added a comment - 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.
            Hide
            elenst Elena Stepanova added a comment -

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

            Show
            elenst Elena Stepanova added a comment - Closing as incomplete for now; if you have any new information, please comment to re-open the issue.

              People

              • Assignee:
                Unassigned
                Reporter:
                hp4 HaPe4
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved: