Good evening from Singapore, My virtual server is an Amazon AWS Linux instance. I only gave it 1 GB of RAM. How much RAM/memory do I need to support MariaDB SQL database server without crashing? Giving my virtual server more than 1 GB of RAM will cost me more money. ________________________________ From: Rhys.Campbell@swisscom.com <Rhys.Campbell@swisscom.com> Sent: Monday, October 22, 2018 6:22 PM To: Turritopsis Dohrnii Teo En Ming; maria-discuss@lists.launchpad.net Subject: RE: [Maria-discuss] My Solution to MariaDB Database Server Crashed in Experimental Online Store It's failing to allocate memory the innodb buffer pool. Check your memory usage / total ram / add more ram -----Original Message----- From: Maria-discuss [mailto:maria-discuss-bounces+rhys.campbell=swisscom.com@lists.launchpad.net] On Behalf Of Turritopsis Dohrnii Teo En Ming Sent: 22 October 2018 11:49 To: Reindl Harald <h.reindl@thelounge.net>; maria-discuss@lists.launchpad.net Subject: Re: [Maria-discuss] My Solution to MariaDB Database Server Crashed in Experimental Online Store Good afternoon from Singapore, My MariaDB SQL Database Server really crashed. I did not reboot my virtual server at all. It has crashed twice already. Here is the output of /var/log/mariadb/mariadb.log. [root@ip-10-0-0-76 mariadb]# tail -n 50 mariadb.log 181018 5:43:33 [Note] Server socket created on IP: '0.0.0.0'. 181018 5:43:33 [Note] Event Scheduler: Loaded 0 events 181018 5:43:33 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.5.60-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 181018 7:22:34 [Warning] IP address '31.184.193.100' could not be resolved: Name or service not known 181018 7:55:41 [Warning] IP address '58.218.213.3' could not be resolved: Name or service not known 181018 12:58:57 [Warning] IP address '113.4.133.5' could not be resolved: Name or service not known 181018 19:59:04 [Warning] IP address '196.52.43.89' could not be resolved: Name or service not known 181019 09:04:06 mysqld_safe Number of processes running now: 0 181019 09:04:06 mysqld_safe mysqld restarted 181019 9:04:06 [Note] /usr/libexec/mysqld (mysqld 5.5.60-MariaDB) starting as process 15275 ... 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) 181019 9:04:06 InnoDB: The InnoDB memory heap is disabled 181019 9:04:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins 181019 9:04:06 InnoDB: Compressed tables use zlib 1.2.7 181019 9:04:06 InnoDB: Using Linux native AIO 181019 9:04:06 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137756672 bytes) failed; errno 12 181019 9:04:06 InnoDB: Completed initialization of buffer pool 181019 9:04:06 InnoDB: Fatal error: cannot allocate memory for the buffer pool 181019 9:04:06 [ERROR] Plugin 'InnoDB' init function returned error. 181019 9:04:06 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 181019 9:04:06 [Note] Plugin 'FEEDBACK' is disabled. 181019 9:04:06 [ERROR] Unknown/unsupported storage engine: InnoDB 181019 9:04:06 [ERROR] Aborting 181019 9:04:06 [Note] /usr/libexec/mysqld: Shutdown complete 181019 09:04:07 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended 181022 02:54:37 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 181022 2:54:37 [Note] /usr/libexec/mysqld (mysqld 5.5.60-MariaDB) starting as process 22837 ... 181022 2:54:37 InnoDB: The InnoDB memory heap is disabled 181022 2:54:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins 181022 2:54:37 InnoDB: Compressed tables use zlib 1.2.7 181022 2:54:37 InnoDB: Using Linux native AIO 181022 2:54:37 InnoDB: Initializing buffer pool, size = 128.0M 181022 2:54:37 InnoDB: Completed initialization of buffer pool 181022 2:54:37 InnoDB: highest supported file format is Barracuda. 181022 2:54:37 InnoDB: Starting crash recovery from checkpoint LSN=94454915 InnoDB: Restoring possible half-written data pages from the doublewrite buffer... 181022 2:54:37 InnoDB: Starting final batch to recover 4 pages from redo log 181022 2:54:37 InnoDB: Waiting for the background threads to start 181022 2:54:38 Percona XtraDB (http://www.percona.com) 5.5.59-MariaDB-38.11 started; log sequence number 94455139 181022 2:54:38 [Note] Plugin 'FEEDBACK' is disabled. 181022 2:54:38 [Note] Server socket created on IP: '0.0.0.0'. 181022 2:54:39 [Note] Event Scheduler: Loaded 0 events 181022 2:54:39 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.5.60-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server ===BEGIN SIGNATURE=== Turritopsis Dohrnii Teo En Ming's Academic Qualifications as at 30 Oct 2017 [1] https://tdtemcerts.wordpress.com/ [2] http://tdtemcerts.blogspot.sg/ [3] https://www.scribd.com/user/270125049/Teo-En-Ming ===END SIGNATURE=== From: Maria-discuss <maria-discuss-bounces+turritopsis.dohrnii=teo-en-ming.com@lists.launchpad.net> on behalf of Reindl Harald <h.reindl@thelounge.net> Sent: Friday, October 19, 2018 8:00 PM To: maria-discuss@lists.launchpad.net Subject: Re: [Maria-discuss] My Solution to MariaDB Database Server Crashed in Experimental Online Store Am 19.10.18 um 13:17 schrieb Turritopsis Dohrnii Teo En Ming:
Good evening from Singapore,
Here is my solution:
# systemctl start mariadb.service
# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 2 Server version: 5.5.60-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> quit Bye
# systemctl enable mariadb.service
what has this to do with a crash? you simply forgot to enable the service and rebootet _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp