← Back to team overview

maria-discuss team mailing list archive

Re: My Solution to MariaDB Database Server Crashed in Experimental Online Store


Am 22.10.18 um 11:48 schrieb Turritopsis Dohrnii Teo En Ming:
> My MariaDB SQL Database Server really crashed. I did not reboot my virtual server at all. It has crashed twice already.

in your first message you only mentioned
systemctl start mariadb.service
systemctl enable mariadb.service

at at least when you pretend that enable a service solved your porblemn
and don't provide any useful informations what do you think?


> 181019  9:04:06 [ERROR] mysqld: Out of memory (Needed 128917504 bytes)
> 181019  9:04:06 [ERROR] mysqld: Out of memory (Needed 96681984 bytes)
> 181019  9:04:06 [ERROR] mysqld: Out of memory (Needed 72499200 bytes)

reduce innodb_buffer_pool_size and look with mysqltuner which
per-thread-buffers which you thougfht are per instance are pervertly
high which is a often made mistake and last but not least it tells you
the highest to expect memory usage from mysqld with your config where
you need in mind that the OS and other applications needs memory too

anyways, 1 GB is a joke for a server doing more than sitting around