MariaDB keeps crashing

Discussion in 'Installation/Configuration' started by anteroriihimaki, May 2, 2018.

  1. anteroriihimaki

    anteroriihimaki New Member

    Hello,

    I just installed new Debian Server with ISPConfig 3. Usually I've used MySQL but this time for some reason decided to go with MariaDB and I'm starting to think I shouldn't have...

    The server is a small virtual server running two Wordpress + Woocommerce sites with very little traffic ~100 hits per day per site at the moment. Still MariaDB keeps crashing on what I think from error logs is a memory limit issue. The server has 1024MB memory + 512 SWAP partition.

    Here's my error.log

    Code:
    2018-05-02 11:55:01 140538738451008 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
    
    2018-05-02 11:55:01 140538738451008 [Note] InnoDB: Using mutexes to ref count buffer pool pages
    2018-05-02 11:55:01 140538738451008 [Note] InnoDB: The InnoDB memory heap is disabled
    2018-05-02 11:55:01 140538738451008 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2018-05-02 11:55:01 140538738451008 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
    2018-05-02 11:55:01 140538738451008 [Note] InnoDB: Compressed tables use zlib 1.2.8
    2018-05-02 11:55:01 140538738451008 [Note] InnoDB: Using Linux native AIO
    2018-05-02 11:55:01 140538738451008 [Note] InnoDB: Using SSE crc32 instructions
    2018-05-02 11:55:01 140538738451008 [Note] InnoDB: Initializing buffer pool, size = 128.0M
    InnoDB: mmap(140574720 bytes) failed; errno 12
    2018-05-02 11:55:01 140538738451008 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
    2018-05-02 11:55:01 140538738451008 [ERROR] Plugin 'InnoDB' init function returned error.
    2018-05-02 11:55:01 140538738451008 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    2018-05-02 11:55:01 140538738451008 [Note] Plugin 'FEEDBACK' is disabled.
    2018-05-02 11:55:01 140538738451008 [ERROR] Unknown/unsupported storage engine: InnoDB
    2018-05-02 11:55:01 140538738451008 [ERROR] Aborting
    Any ideas on how I should begin to debug this?
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    There should be no difference im stability when you compare MySQL and MariaDB, I never had any issues with MariaDB in the past. It might just be that the default settings from MariaDB are for larger systems, so you might have to adjust them for servers with very low RAM. You find a lot of tutorials on that topic when you search for 'mysql performance tuning' and also the toolmysqltuner might be handy for this.
     

Share This Page