MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: innodb keeps crashing due to out-of-memory errors
Posted by: Heikki Tuuri
Date: March 07, 2005 01:58AM

Eddie,

to process some queries, MySQL creates temp tables. If you let them be up to 128 MB HEAP tables, they can eat up too much memory. Use SHOW PROCESSLIST and EXPLAIN SELECT to monitor if there are such queries.

But if the memory usage gradually climbs, then it might be a memory leak.

Best regards,

Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL

InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
innodb keeps crashing due to out-of-memory errors
7075
Eddie Moojen
March 03, 2005 06:55PM
Re: innodb keeps crashing due to out-of-memory errors
2876
Kostas Pyliouras
March 03, 2005 07:30PM
Re: innodb keeps crashing due to out-of-memory errors
2922
Eddie Moojen
March 04, 2005 07:16AM
Re: innodb keeps crashing due to out-of-memory errors
2370
Kostas Pyliouras
March 04, 2005 09:02AM
Re: innodb keeps crashing due to out-of-memory errors
2588
Eddie Moojen
March 07, 2005 03:38AM
Re: innodb keeps crashing due to out-of-memory errors
2438
Kostas Pyliouras
March 08, 2005 06:35PM
Re: innodb keeps crashing due to out-of-memory errors
2282
Eddie Moojen
March 09, 2005 08:51AM
Re: innodb keeps crashing due to out-of-memory errors
2297
Kostas Pyliouras
March 09, 2005 08:55AM
Re: innodb keeps crashing due to out-of-memory errors
2142
Eddie Moojen
March 09, 2005 09:04AM
Re: innodb keeps crashing due to out-of-memory errors
2472
Kostas Pyliouras
March 09, 2005 09:28AM
Re: innodb keeps crashing due to out-of-memory errors
2505
Heikki Tuuri
March 05, 2005 01:47AM
Re: innodb keeps crashing due to out-of-memory errors
2622
Eddie Moojen
April 01, 2005 05:13AM
Re: innodb keeps crashing due to out-of-memory errors
2333
Ken Ellis
June 13, 2005 06:54AM
Re: innodb keeps crashing due to out-of-memory errors
2708
Heikki Tuuri
March 05, 2005 01:54AM
Re: innodb keeps crashing due to out-of-memory errors
1869
Eddie Moojen
March 06, 2005 03:38PM
Re: innodb keeps crashing due to out-of-memory errors
2341
Heikki Tuuri
March 07, 2005 01:58AM
Re: innodb keeps crashing due to out-of-memory errors
2433
Eddie Moojen
March 07, 2005 10:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.