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