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

MariaDB start is slow

    XMLWordPrintable

    Details

      Description

      It takes about 10 mins to start, had seen the same issue earlier in 10.1.18 which was fixed but has reoccurred in 10.1.22

      2017-04-27 15:48:10 139983869696032 [Warning] option 'general_log': boolean value 'xxxxx.log' wasn't recognized. Set to OFF.
      2017-04-27 15:48:10 139983869696032 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
      2017-04-27 15:48:10 139983869696032 [Note] /usr/libexec/mysqld (mysqld 10.1.22-MariaDB) starting as process 19851 ...
      2017-04-27 15:48:12 7f5088d3d820 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
      2017-04-27 15:48:12 139983869696032 [Note] InnoDB: Using mutexes to ref count buffer pool pages
      2017-04-27 15:48:12 139983869696032 [Note] InnoDB: The InnoDB memory heap is disabled
      2017-04-27 15:48:12 139983869696032 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      2017-04-27 15:48:12 139983869696032 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
      2017-04-27 15:48:12 139983869696032 [Note] InnoDB: Compressed tables use zlib 1.2.3
      2017-04-27 15:48:12 139983869696032 [Note] InnoDB: Using Linux native AIO
      2017-04-27 15:48:12 139983869696032 [Note] InnoDB: Using SSE crc32 instructions
      2017-04-27 15:48:12 139983869696032 [Note] InnoDB: Initializing buffer pool, size = 2.0G
      2017-04-27 15:48:12 139983869696032 [Note] InnoDB: Completed initialization of buffer pool
      2017-04-27 15:48:13 139983869696032 [Note] InnoDB: Highest supported file format is Barracuda.
      2017-04-27 15:58:24 139983869696032 [Note] InnoDB: 128 rollback segment(s) are active.
      2017-04-27 15:58:24 139983869696032 [Note] InnoDB: Waiting for purge to start
      2017-04-27 15:58:24 139983869696032 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 657936019547
      2017-04-27 15:58:25 139980747806464 [Note] InnoDB: Dumping buffer pool(s) not yet started
      2017-04-27 15:58:25 139983869696032 [Note] Plugin 'FEEDBACK' is disabled.
      2017-04-27 15:58:25 139983869696032 [Note] Server socket created on IP: '::'.
      2017-04-27 15:58:25 139983869696032 [Note] /usr/libexec/mysqld: ready for connections.
      Version: '10.1.22-MariaDB'  socket: 'xxxxx.sock'  port: 3306  MariaDB Server
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jplindst Jan Lindström
              Reporter:
              dgavhane Darshit Gavhane
              Votes:
              2 Vote for this issue
              Watchers:
              10 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: