Hi!
I am in the process of upgrading the machine with everything to a newer versions. This time, I'm getting rid of the IBM DB2 as it won't be there. So, I downloaded the MySQL 64 bits for the AIX and extracted it there. The AIX server use 64 bits kernel and Enhanced Journal File System (JFS2). It also have 1 GB of RAM and 35 GB Hard Disk. I remembered that running this test is require to make sure MySQL work properly and can handle the workload with the machine. So, I typed the mysql-test-run command and here's what I got. --snip- fulltext [ pass ] fulltext2 [ pass ] fulltext_cache [ pass ] fulltext_distinct [ pass ] fulltext_left_join [ pass ] fulltext_multi [ pass ] fulltext_order_by [ pass ] fulltext_update [ pass ] fulltext_var [ pass ] func_compress [ fail ] Errors are (from /usr/local/mysql/mysql-test/var/log/mysqltest-time) : mysqltest: At line 48: query 'select compress(repeat('aaaaaaaaaa', IF('', 10, 10000000))) is null' failed: 5: Out of memory (Needed 120000024 bytes) (the last lines may be the most important ones) Aborting: func_compress failed in default mode. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon Master shutdown finished Slave shutdown finished --snip- I'm a little baffled because the server have 1 GB of RAM. Something is wrong. So, what's up with that? Thanks, Scott