Hej!
Using MySQL 3.22.32 on Tru64 4.0F patchkit 4. Compiled with Compaq CC.
Ran optimize on a table, and after 10 minutes :
010307 17:00:00 Out of memory; Check if mysqld or some other process uses
all available memory. If not you may have to use 'ulimit' to allow mysqld to
use more memory or you can add more swap space
mysqld ended on Wed Mar 7 17:00:21 MET 2001
I checked :
iratxe.tm.es> ulimit
unlimited
iratxe.tm.es> /usr/sbin/swapon -sv
Swap partition /dev/rz8b (default swap):
Allocated space: 48768 pages (381MB)
In-use space: 316 pages ( 0%)
Free space: 48452 pages ( 99%)
Swap partition /dev/rzb11c:
Allocated space: 256841 pages (2006MB)
In-use space: 312 pages ( 0%)
Free space: 256529 pages ( 99%)
Total swap allocation:
Allocated space: 305609 pages (2387MB)
Reserved space: 47242 pages ( 15%)
In-use space: 628 pages ( 0%)
Available space: 258367 pages ( 84%)
No ulimit and more than 2 GB free swap and no active swap usage.
Before the crash I'd succesfully optimized other (and smaller) tables.
I tried once again on the same table, and MySQL crashed again. Same thing
happened when I tried to put a new index on the table.
I checked the memory status :
http://www.dassic.dk/iratxe_memory.png
As seen, the optimize (around 17:00) causes the UBC filesystem buffer to
allocate more memory, and when it has used all the free memory, MySQL
crashes.
I don't understand this, since the memory used by the UBC is available for
any program that might need it. The operating system will only use memory
for UBC if it's not used for anything else, and release UBC memory if a
application needs more.
Secondly, MySQL crashed even before the machine started to swap, and as seen
the active memory increases only because of the UBC, not because MySQL
allocate more memory.
Does MySQL 3.22.32 have a bug in this area, and if so, is it fixed in later
versions ?
I've compiled MySQL with large file 64-bit support, and the filsystem
(AdvFS) has no problems with large files.
l8r/Jspr
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
