One of our store show following error and stop working at all.

SQLSTATE[HY000]: General error: 5 Out of memory

and Mysql / Innodb Error

InnoDB: ERROR: the age of the last checkpoint is 943460

[ERROR] /usr/sbin/mysqld: Out of memory (Needed 27262948 bytes)

Why Magento showing goes down and show this error?

More details (if needed):

At that time error occur online user were 150.

My.ini settings related to innodb are

query_cache_limit =500M
query_cache_size = 96M
innodb_buffer_pool_size = 2048M
key_buffer = 512M 
max_allowed_packet = 64M
table_cache = 1024
sort_buffer_size = 4M
read_buffer_size = 4M
query_cache_type = 1
innodb_additional_mem_pool_size = 20M
set-variable = max_connections=500


CPU: inter quad core 
memory: 4GB
disk: 100GB

OS centOS 6.3
Apache 2.0
PHP 5.3
Mysql 5.0


As per error ie. trying insert too much data into InnoDB too quickly.

log_visitor_info, log_url_info and log_url are much overwritten.

What if I will change log_visitor_info, log_url_info and log_url storage engine to myISAM will it solve this problem?

is it ok changing of storage engine of these tables?

Thanks in advance...

  • and your server specs? Commented Jul 6, 2013 at 12:11
  • I updated server specs in question. Let us know if anything missed
    – Sandesh
    Commented Jul 6, 2013 at 12:32
  • 1
    memory: 4GB vs input your variables in mysqlcalculator.com and you will see why you get that error. Commented Jul 6, 2013 at 13:03
  • Thanks FlorinelChis, It seems I need more than 8 Gb memory for this. How I can optimize MySql for 4GB memory as it unable to handle magento?
    – Sandesh
    Commented Jul 6, 2013 at 13:19
  • Problem updated requesting your attention..
    – Sandesh
    Commented Jul 6, 2013 at 16:20

1 Answer 1


This is a sql buffer size issue.

Review your query, increase buffers in my.ini. Also make sure to repair all your tables and re-index them.

See: http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.