[Users] Presence server with MySQL >=5.0.26

Mike Williams mike at mikebwilliams.com
Thu Nov 16 18:31:17 CET 2006


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: users-bounces at openser.org
> > [mailto:users-bounces at openser.org] On Behalf Of Bogdan-Andrei Iancu
> > Sent: Thursday, November 16, 2006 7:06 AM
> > To: Nicolas Palix; Anca Vamanu
> > Cc: users at openser.org
> > 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
> > Users at openser.org
> > 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
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users




More information about the Users mailing list