[Users] Presence server with MySQL >=5.0.26

[Watkins, Bradley]

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.