On 2014-02-21 10:41, Jay Fitz wrote:
> Really? That seems a tad inefficient.

Really? The tables hold different data (raw data, ACLs and a
pre-rendered cache), why clobber all that in a single one?

> Is there any way to get it to put
> all that data in a single table? There's a single table for all of the
> users folder  and session info.

Those also hold significantly less data.

> OK, technically innodb can handle up to 4 billion tables and I'm
> probably going to end up with only 50,000 but more than 100 in a single
> DB makes me uncomfortable.

50000 columns per table are hardly an improvement. ;)

> 
> 
> On 20 February 2014 19:17, Louis-Philippe <[email protected]
> <mailto:[email protected]>> wrote:
> 
>     It's not a problem ... It's normal.
> 
>     add a event in a calendar and delete the tables ... You will lost
>     your data !
> 
> 
> 
> 
> 
> 
>     2014-02-20 12:45 GMT-05:00 <[email protected]
>     <mailto:[email protected]>>:
> 
>         sogo 2.0.7-1, ubuntu 12.04, postfix, mysql, dovecot
> 
>         hello, got an odd problem, using sogo with mysql and whenever a
>         user first
>         logs in, it creates three tables in my vmail database like this
> 
>         sogouserdoma0010691ef21
>         sogouserdoma0010691ef21_acl
>         sogouserdoma0010691ef21_quick
> 
>         it uses the first 8 characters of the email address where it has
>         "userdoma"
>         and the a quasi random string
> 
>         There doesn't appear to be anything in these tables and nothing
>         seems to break
>         when I delete them.
> 
>         Can anyone suggest why this many be happening and how to stop it?
>         --
>         [email protected] <mailto:[email protected]>
>         https://inverse.ca/sogo/lists
> 
> 
> 
> 
>     -- 
>     Louis-Philippe
> 
> 
> 
> 
> -- 
> This is not a signature
> 

-- 
Mit freundlichen Grüßen, / Best Regards,
Sven Schwedas
Systemadministrator
TAO Beratungs- und Management GmbH | Lendplatz 45 | A - 8020 Graz
Mail/XMPP: [email protected] | +43 (0)680 301 7167
http://software.tao.at

Attachment: signature.asc
Description: OpenPGP digital signature

Reply via email to