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

[Note] InnoDB: page_cleaner: 1000ms intended loop took XXXXms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)

    XMLWordPrintable

Details

    Description

      Hi,
      I migrated from MySQL 5.6.36 to MariaDB 10.2.8 32bit on Windows 2008 R1.
      I have started to see the following in our production environment.

      2017-08-29 10:45:24 4432 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4197ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
      

      I have not made any changes to the configuration file (my.ini); I was wondering do I need to

      the settings are:-

      MariaDB [(none)]> show global variables like 'innodb_buffer%';
      +-------------------------------------+----------------+
      | Variable_name                       | Value          |
      +-------------------------------------+----------------+
      | innodb_buffer_pool_chunk_size       | 134217728      |
      | innodb_buffer_pool_dump_at_shutdown | ON             |
      | innodb_buffer_pool_dump_now         | OFF            |
      | innodb_buffer_pool_dump_pct         | 25             |
      | innodb_buffer_pool_filename         | ib_buffer_pool |
      | innodb_buffer_pool_instances        | 1              |
      | innodb_buffer_pool_load_abort       | OFF            |
      | innodb_buffer_pool_load_at_startup  | ON             |
      | innodb_buffer_pool_load_now         | OFF            |
      | innodb_buffer_pool_populate         | OFF            |
      | innodb_buffer_pool_size             | 268435456      |
      +-------------------------------------+----------------+
      11 rows in set (0.00 sec)
      

      Do I need to increase innodb_buffer_pool_instances, or anything else to stop this latency which I never saw logged with MySQL 5.6.36?

      many thanks for your advice and guidance.

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              slaterss Stuart Slater
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.