By jhoedram
Hello everyone:
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 '118.123.119.110' 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
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
This comment has been deleted
You’re out of memory, so it cannot allocate the needed memory to innodb:
failed; errno 12
I’d recommend that you upgrade your server.
Failing that, stop apache, restart mysql, then start apache.
Hi, really thanks for your comment. I already did, but the problem persists, I insist that it is an optimization problem. Now I have a drop with 1GB of ram and I run out of memory.
Do not know what to do
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.
New accounts only. By submitting your email you agree to our Privacy Policy
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.