MySQL RPMs for RH9?

2007-01-01 Thread Shaun T. Erickson
I have a client who has a RH9 server that I'm not allowed to upgrade to something newer. It has MySQL 3.23.58 on it and I need to replace that with the newest I can get. The MySQL-AB site doesn't seem (unless I missed it, which is quite possible) to have any RPMs for RH9 anymore. Can anyone point

Deleting Foreign Key

2007-01-01 Thread Mungbeans
I have a foreign key in a table which I need to drop. I have successfully dropped other foreign keys from this table using phpMyAdmin. However when I use these commands I get similar error messages: ALTER TABLE `mytable` DROP FOREIGN KEY `keyname` #1025 - Error on rename of '.\database\mytab

Re: How scaleable is MySQL 5's Innodb with multi-core CPU's?

2007-01-01 Thread mos
At 12:49 PM 1/1/2007, Jochem van Dieten wrote: On 1/1/07, mos wrote: Is there a problem with InnoDb scaling with multi-processor CPU's? Apparently after reading the Tweakers.net article, with only 40 simultaneous users the performance of MySQL 5 will collapse. http://www.mysqlperformanceblog.

Re: Bizarre InnoDB Error Message ( trx->active_trans == 0, but trx->conc_state != TRX_NOT_STARTED)

2007-01-01 Thread Jason J. W. Williams
Hi Heikki, Yes indeed. We have a "uid" field that is AUTO INC. Is the error more an issue of the auto inc code in InnoDB not setting its error codes correctly on a rollback than the auto increment code initiating an error? Thank you in advance. Best Regards, Jason On 12/31/06, Heikki Tuuri <[EM

Re: How scaleable is MySQL 5's Innodb with multi-core CPU's?

2007-01-01 Thread Jochem van Dieten
On 1/1/07, mos wrote: Is there a problem with InnoDb scaling with multi-processor CPU's? Apparently after reading the Tweakers.net article, with only 40 simultaneous users the performance of MySQL 5 will collapse. http://www.mysqlperformanceblog.com/2006/11/30/interesting-mysql-and-postgresql-

How scaleable is MySQL 5's Innodb with multi-core CPU's?

2007-01-01 Thread mos
Is there a problem with InnoDb scaling with multi-processor CPU's? Apparently after reading the Tweakers.net article, with only 40 simultaneous users the performance of MySQL 5 will collapse. http://www.mysqlperformanceblog.com/2006/11/30/interesting-mysql-and-postgresql-benchmarks/ http://t