Re: Mysql 5 - Pierre Ancelot - com.mysql.lists.cluster

9 messages in com.mysql.lists.clusterRe: Mysql 5

From	Sent On	Attachments
Pierre Ancelot	19 Jan 2006 09:00
Alex Davies	19 Jan 2006 09:07
Pierre Ancelot	19 Jan 2006 09:36
Alex Davies	19 Jan 2006 09:38
Pierre Ancelot	19 Jan 2006 09:45
Jimmy Guerrero	19 Jan 2006 09:56
Alex Davies	19 Jan 2006 09:58
Geert Vanderkelen	19 Jan 2006 09:58
Stewart Smith	19 Jan 2006 17:35

Subject:	Re: Mysql 5
From:	Pierre Ancelot (pie...@bostoncybertech.com)
Date:	01/19/2006 09:36:47 AM
List:	com.mysql.lists.cluster

Well, creating the table works if i remove the auto increment I thought by the version 5 this kind of things shouldn't happen again...

On Thu, 2006-01-19 at 17:08 +0000, Alex Davies wrote:

I guess you have already seen http://forums.mysql.com/read.php?25,61739,61739 - and I guess also the bug @ http://bugs.mysql.com/bug.php?id=11997. It does not look like much is happening at that end - perhaps you could find a reproducable case and post it, confirming that it exists in 5.0.18 which is the latest version. Hopefully that will get it fixed.

Alex

On 19/01/06, Pierre Ancelot <pie...@bostoncybertech.com> wrote:

I have two clusters, one i'm actually creating and the other one in production. On the production, we run mysql 4 since a moment, we had BIG performace issues, i have no idea what really happened since it seems to be deep inside mysql and i'm only administrating it, not developping it i don't have the knowledge to know what going on in it. the fact is, when this database is used on a simple (non clustered) mysql 4, it works, when mysql-cluster, we lose LOADS of performance, so i reinstalled mysql4 cluster which didn't works so i have been preconised by a friend to switch to mysql 5.

On the new cluster i'm preparing, i have setup mysql 5 (5.0.18 actually), i have done a dump of my mysql4 databases and i tryied to inject them to mysql5 cluster. BUT sounds like there's an auto-increment initialisation problem, i get this:

node1:/home/tmp/db# mysql -u root < databasesdump.sql ERROR 1005 (HY000) at line 29: Can't create table './cheapchicinc/menu.frm' (errno: 4336)

I really don't want to change from 5.0.18 since it's packaged for my distro. Anyone might help me please ?

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender immediately by e-mail and delete this e-mail permanently.