I think the problem was that the binary was indeed probably incompatible with my libraries/kernel. I installed an IBM supplied version and it seems to work OK now, albeit with some strange warning messages from time to time.
I would have prefered using an x86 platform myself, but we had all these old RS/6000 boxes lying around :) Thanks, Paul -----Original Message----- From: Sasha Pachev [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 12:08 PM To: Paul Sue Cc: [EMAIL PROTECTED] Subject: Re: mysql-3.23.35.0 on AIX 4.3: CPU Hog Paul Sue wrote: > Hi, > > I downloaded mysql-3.23.35.0 for AIX 4.3 from bullfreeware.com and as I soon > as I start mysqld, it starts consuming almost all the CPU (hovers around 97%). > > Any idea what might be the cause of this?? Paul: I assume this happens with no or minimal server activity. If yes, the binary you are using is probably not fully compatible with your libraries/kernel. You can either try another binary, or build from source. If this is some retired AIX server that you are just trying to put to work, and there is no other strong attachment to AIX, it might be more cost effective to dig up an old or not so old x86 machine, put Linux on it, and then install MySQL . My expectation is that PII and above with 128 MB or higher will outperform most older AIX machines. As for the newer, my intuition tells few even multi-processor machines will be able to outdo a uniprocessor AMD 1800+ (those can do 8000 indexed selects of one row per second). If some AIX fan wants to challenge my intuition with a benchmark, you are more than welcome. -- Sasha Pachev Create online surveys at http://www.surveyz.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
