Mysql stops and my wordpress stops working
I am new to this server, apparently it is a mysql problem that stops when you consume too many resources, someone can help me.
I have a VPS with 500MB Ram digitalocean with Centos 6.5 x64
This is the configuration file of my mysql, the logs can see below. I hope someone can help, of course many thanks.
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql symbolic-links=0 max_connections=70 max_user_connections=30 wait_timeout=10 interactive_timeout=50 long_query_time=5 #log-queries-not-using-indexes #log-slow-queries=/var/log/mysql/log-slow-queries.log key_buffer = 16M myisam_sort_buffer_size = 32M join_buffer_size=1M read_buffer_size=1M sort_buffer_size=2M table_cache=1024 thread_cache_size=286 interactive_timeout=25 connect_timeout=5 max_allowed_packet=1M max_connect_errors=1000 query_cache_limit=1M query_cache_size=8M query_cache_type=1 tmp_table_size=16M #innodb_use_native_aio = 0 innodb_file_per_table [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
140912 9:27:44 [Warning] IP address '188.8.131.52' could not be resolved: Name or service not known 140912 12:01:02 mysqld_safe Number of processes running now: 0 140912 12:01:02 mysqld_safe mysqld restarted 140912 12:01:02 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 140912 12:01:02 [Note] Plugin 'FEDERATED' is disabled. 140912 12:01:02 InnoDB: The InnoDB memory heap is disabled 140912 12:01:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140912 12:01:02 InnoDB: Compressed tables use zlib 1.2.3 140912 12:01:02 InnoDB: Using Linux native AIO 140912 12:01:02 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 140912 12:01:02 InnoDB: Completed initialization of buffer pool 140912 12:01:02 InnoDB: Fatal error: cannot allocate memory for the buffer pool 140912 12:01:02 [ERROR] Plugin 'InnoDB' init function returned error. 140912 12:01:02 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140912 12:01:02 [ERROR] Unknown/unsupported storage engine: InnoDB 140912 12:01:02 [ERROR] Aborting 140912 12:01:02 [Note] /usr/libexec/mysqld: Shutdown complete 140912 12:01:02 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140912 16:57:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140912 16:57:29 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 140912 16:57:29 [Note] Plugin 'FEDERATED' is disabled. 140912 16:57:29 InnoDB: The InnoDB memory heap is disabled 140912 16:57:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140912 16:57:29 InnoDB: Compressed tables use zlib 1.2.3 140912 16:57:29 InnoDB: Using Linux native AIO 140912 16:57:29 InnoDB: Initializing buffer pool, size = 128.0M 140912 16:57:29 InnoDB: Completed initialization of buffer pool 140912 16:57:29 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 140912 16:57:29 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 140912 16:57:30 InnoDB: Waiting for the background threads to start 140912 16:57:31 InnoDB: 5.5.39 started; log sequence number 14584556 140912 16:57:31 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 140912 16:57:31 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 140912 16:57:31 [Note] Server socket created on IP: '0.0.0.0'. 140912 16:57:31 [Note] Event Scheduler: Loaded 0 events 140912 16:57:31 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.5.39' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi