MySQL Forums
Forum List  »  NDB clusters

Re: MySQL crashes every 2 days
Posted by: Adam Dixon
Date: December 20, 2006 07:12PM

To tune properly, Ive used a nice perl script to calculate out per thread memory usage; Yours reads as follows;

/usr/local/mysql5021/bin/mysqld will use at most:
42.0 MB for global stuff
10.5 MB per thread
10.3 GB total (with 1000 active threads)
and additionally:
16.0 MB for each HEAP table
16.0 MB for each temporary table

See the forge; http://forge.mysql.com/snippets/view.php?id=44

Dont know if that may trigger something for you? Your ndb_mgmd should be logging somewhere; config.ini under [NDB_MGMD] see your LogDestination parameter. See if anything is in that at all. Otherwise it could just by mysqld using all your memory.

When the problem occurs, in linux use the command 'free' to see your memory status. Provide that here perhaps.

Adam

Options: ReplyQuote


Subject
Views
Written By
Posted
3846
December 20, 2006 01:32PM
1611
December 20, 2006 02:33PM
1523
December 20, 2006 02:56PM
Re: MySQL crashes every 2 days
1575
December 20, 2006 07:12PM
1347
December 21, 2006 06:37PM
1392
December 21, 2006 08:47PM
1274
December 21, 2006 09:12PM
1353
December 22, 2006 11:26AM
1253
December 26, 2006 05:21PM
1309
December 21, 2006 03:15AM
1236
December 21, 2006 06:46PM
1234
December 22, 2006 08:10AM


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.