[ejabberd] MySQL test database schema

Oleg Motienko motienko at gmail.com
Thu Jan 12 09:07:14 MSK 2006


On 1/8/06, Oleg Motienko <motienko at gmail.com> wrote:

> P.P.S. If I restart mysql when ejabberd running, users can't login
> until restarting ejabberd. I think it's a bug.

In addition: mysqld drops connection after some idle timeout and
erlang doesn't reconnect.
Maybe it's a bug of native mysql module ?


On 1/11/06, Mickael Remond <mickael.remond at process-one.net> wrote:

> That strange as in my file the rosterusers table description contains:
>     username varchar(250) NOT NULL,
>     jid varchar(250) NOT NULL,
>
> Which does not reach the 1000 size limit mentioned in your reference
> URL (This happens if you use the same tabl description than with
> PostgreSQL.

Than URL describes differences of counting field length and index length.
Unicode characters uses more than one byte.

(250+250)*3=1500


--
Regards,
Oleg


More information about the ejabberd mailing list