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

Dumping buffer pool noisy in the logs.

    XMLWordPrintable

    Details

    • Sprint:
      10.1.6-1

      Description

      Hi,

      Dumping the buffer pool on shutdown is very noisy when having large buffer pool:

      [...]
      2015-06-10 15:14:43 140091534046976 [Warning] InnoDB: Dumping buffer pool(s) to .//ib_buffer_pool
      2015-06-10 15:14:43 140091534046976 [Note] InnoDB: Dumping buffer pool 1/35, page 1/124296
      2015-06-10 15:14:43 140091534046976 [Note] InnoDB: Dumping buffer pool 1/35, page 129/124296
      [...]
      2015-06-10 15:14:45 140091534046976 [Note] InnoDB: Dumping buffer pool 35/35, page 123905/124054
      2015-06-10 15:14:45 140091534046976 [Note] InnoDB: Dumping buffer pool 35/35, page 124033/124054
      2015-06-10 15:14:45 140091534046976 [Warning] InnoDB: Buffer pool(s) dump completed at 150610 15:14:45
      [...]

      cat mysqld2.log | wc --lines --bytes
        33824 3241720

      cat mysqld2.log | grep -v "Dumping buffer pool" | wc --lines --bytes
           41    3938

      So the logs for the dump account for 3MB and more than 33K lines on a less than 3 seconds dump.

      In 10.0.16, I do not have all those lines when doing MariaDB restart:

      150611 12:50:05 [Note] /usr/sbin/mysqld: Normal shutdown
      [...]
      150611 12:50:05 [Note] InnoDB: Starting shutdown...
      2015-06-11 12:50:06 7ee566df7700 InnoDB: Dumping buffer pool(s) to .//ib_buffer_pool
      2015-06-11 12:50:09 7ee566df7700 InnoDB: Buffer pool(s) dump completed at 150611 12:50:09
      [...]
      150611 12:50:30 [Note] /usr/sbin/mysqld: Shutdown complete
      [...]
      150611 12:50:31 mysqld_safe Starting mysqld_wrapper daemon with databases from [...]
      [...]
      Version: '10.0.16-MariaDB-log'  socket: 'mysql.sock'  port: 3306  MariaDB Server

      Thanks for looking into that,

      JFG

        Attachments

          Activity

            People

            Assignee:
            jplindst Jan Lindström
            Reporter:
            jgagne Jean-François Gagné
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: