All, I would still be in favor of moving all of the tables over to having the primary key be an autoincremented unsigned int.
Mike Williams On Thursday 16 November 2006 08:19, Watkins, Bradley wrote: > I originally sent this to the OP instead of the list by mistake: > > This sounds like a bug in the package you're using or MySQL 5.0.26 > itself. The storage requirements for the key should be 388 bytes, which > is much less (obviously) than the maximum key length of a MyISAM table. > > Empirically, I tested this on MySQL 5.0.22 (Fedora RPMs) and MySQL > 5.1.11 (RPMs from MySQL's website) with the original values and they > both worked. The documentation for 5.0 and 5.1 on MySQL's site both > state the 1000 byte limitation (that is, without code modification). > > > As an additional data point not in the original e-mail above, using the > 5.0.27 .tar.gz from MySQL also has no problems with this table > definition. > > I've even gone so far as doubling the size of the fields used for the > PK, and none of the aforementioned versions balked. > > With the original sizes, it should even work in older (I think pre > 4.1.12?) versions of MySQL where the max key length is 500 bytes. I > really don't think there's a problem here. > > Regards, > - Brad > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Bogdan-Andrei Iancu > > Sent: Thursday, November 16, 2006 7:06 AM > > To: Nicolas Palix; Anca Vamanu > > Cc: [email protected] > > Subject: Re: [Users] Presence server with MySQL >=5.0.26 > > > > Hi Nicolas, > > > > I think the solution will be to have a primary key a simple > > unsigned int outincrement field in the table and move the > > primary key as unique. > > > > I will ask Anca to do this change as most probably it will be > > a good idea to do it for the rest of the tables also. > > > > regards, > > Bogdan > > > > Nicolas Palix wrote: > > >Hi, > > > > > > > > >The primary key of the watchers is too long with this > > > > version of MySQL: > > >"Specified key was too long; max key length is 1000 bytes" > > > > > >Downgrading "[pw]_domain" from 128 to 96. Works. > > > > > >CREATE TABLE `watchers` ( > > > `p_user` varchar(64) NOT NULL, > > > `p_domain` varchar(96) NOT NULL, > > > `w_user` varchar(64) NOT NULL, > > > `w_domain` varchar(96) NOT NULL, > > > `subs_status` varchar(64) NOT NULL, > > > `reason` varchar(64) NOT NULL, > > > PRIMARY KEY (`p_user`,`p_domain`,`w_user`,`w_domain`) > > >) ENGINE=MyISAM; > > > > > >Regards > > > > _______________________________________________ > > Users mailing list > > [email protected] > > http://openser.org/cgi-bin/mailman/listinfo/users > > The contents of this e-mail are intended for the named addressee only. It > contains information that may be confidential. Unless you are the named > addressee or an authorized designee, you may not copy or use it, or > disclose it to anyone else. If you received it in error please notify us > immediately and then destroy it. > > _______________________________________________ > Users mailing list > [email protected] > http://openser.org/cgi-bin/mailman/listinfo/users _______________________________________________ Users mailing list [email protected] http://openser.org/cgi-bin/mailman/listinfo/users
