Has anyone thought about using mysql proxy to split "select" and
"manipulation" querys to 2 Servers?
I used MySQL Proxy just for testing and a sms script, but I think it
should be possible to use LUA to
split the queries to do a simple load balancing. If you like I can try to
write such a sc
er proxy code, but I doubt that it has improved so much
> that it would be a viable solution for most end users expectations of
> how fast their server should give them their mail.
>
> -Jon
>
> ITronic Harald Leithner wrote:
>> Has anyone thought about using mysql proxy t
Not much more, 64GB on InnoDB.
have fun,
Harald
Am 27.07.2010, 15:14 Uhr, schrieb Jorge Bastos :
> Howdy People,
>
>
> I'm curious about one thing, I'd like to know who has the biggest,
> Database
> size!
>
> I have 41GB InnoDB now.
>
>
> Thanks,
>
> Jorge,
>
>
___
Hi all,
I'm going to change my server hardware for my DBMail system.
At the moment it runs on Debian DBMail 2.2.11-rc3 with a Intel Atom 330
2GB DDR2.
This system is the failover system because the main server run into a
hardware error.
DBMail serves about 200 user accounts and 80 GB on data,
Hi,
first there is an inconsistent in the create_table.sql and the upgrade
2_2-3_0.sql
in create_table the some bigint columns are not unsigned for example:
part_id, physmessage_id, headername_id, headervalue_id
but in the upgrade file all bigint columns are unsigned, so I think that
all columns
Hi,
I hope thats correct.
Harald
Am 11.02.2012, 21:12 Uhr, schrieb Paul J Stevens :
On 02/10/2012 10:04 PM, ITronic Harald Leithner wrote:
Hi,
first there is an inconsistent in the create_table.sql and the upgrade
2_2-3_0.sql
in create_table the some bigint columns are not unsigned for
Hi Paul,
while trying to upgrade dbmail I came to the problem that I have 300.000
duplicated or tripled entries in dbmail_envelope, they have the same
physmessage_id and envelope value but with a different id values.
Can I delete the duplicated entries?
thx
Harald
_
Looks better now thx.
Am 13.02.2012, 12:28 Uhr, schrieb Paul J Stevens :
On 02/13/2012 12:07 PM, ITronic Harald Leithner wrote:
Hi Paul,
while trying to upgrade dbmail I came to the problem that I have 300.000
duplicated or tripled entries in dbmail_envelope, they have the same
Can you show me your create statement for dbmail_sievescripts?
Am 13.02.2012, 16:06 Uhr, schrieb Reindl Harald :
Am 13.02.2012 15:35, schrieb Paul J Stevens:
On 02/13/2012 03:24 PM, Reindl Harald wrote:
hi
is there a really good reason dropping all foreign keys
and create them new? this qu
RENCES `dbmail_users` (`user_idnr`) ON
DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
Am 13.02.2012 16:18, schrieb ITronic Harald Leithner:
Can you show me your create statement for dbmail_sievescripts?
Am 13.02.2012, 16:06 Uhr, schrieb Reindl Harald
:
I will update the sql script to detect the index key and drop it, so the
rest of the script should run fine.
Harald
Am 14.02.2012, 12:41 Uhr, schrieb Paul J Stevens :
On 02/14/2012 12:10 PM, Reindl Harald wrote:
how acts mysql in this case if one of the queries is failing?
will it stop the
te entries
in the dbmail-2.2 data, so i removed them and added the key
manually in the running 2.2 database to not run into this while
making the final upgrade
Am 14.02.2012 12:45, schrieb ITronic Harald Leithner:
I will update the sql script to detect the index key and drop it, so
the rest of
Now drops the index of the sievescripts table regardless of the name.
Truncate the envelope table to prevent double key values.
Harald
Am 13.02.2012, 16:44 Uhr, schrieb ITronic Harald Leithner
:
schaut so aus...
I have a key called owner_idnr_2 this key is a index on owner_idnr and
name
Hi Paul,
I have done my migration yesterday and most of the things are working
fine, thx for your work.
To the list I can add
Opera Mail
Roundcube Webmail
Blackberry Telecom edition fetcher
A small thing about the dbmail-util migration process, if you interrupt
the script it leave the new
Hi,
since upgrade to 3.0.2 my Rounmdcube Mail dates are strange, I'm not sure
why but the ordering is wrong if I sort for date.
Harald didn't you have the problem while testing Roundcube?
Regards
Harald
Am 11.03.2012, 18:15 Uhr, schrieb Reindl Harald :
great - thank you!
imapd feels even
Hi,
I upgraded to DBmail 3.0.2 and it seams that
UID SORT (DATE) US-ASCII ALL
is broken. While
UID SORT (ARRIVAL) US-ASCII ALL
seams to work well.
-> C= 1332931088 username CLIENT: sd [8]
A0006 UID SORT (ARRIVAL) US-ASCII ALL^
-> C= 1332931088 username SERVER: sd [11]
* SORT 32288
Harald
Am 28.03.2012, 14:35 Uhr, schrieb Paul J Stevens :
On 03/28/2012 12:46 PM, ITronic Harald Leithner wrote:
Hi,
I upgraded to DBmail 3.0.2 and it seams that
UID SORT (DATE) US-ASCII ALL
is broken. While
UID SORT (ARRIVAL) US-ASCII ALL
seams to work well.
-> C= 1332931
(not tested)
Regards,
Harald
Am 28.03.2012, 20:04 Uhr, schrieb Reindl Harald :
Am 28.03.2012 14:57, schrieb Paul J Stevens:
On 03/28/2012 02:48 PM, ITronic Harald Leithner wrote:
no Problem. I will do this tonight because this would take sometime to
rebuild 3 GB on header informa
Paul,
any statement to the "referencesfield" Problem?
thx
Harald
Am 29.03.2012, 10:34 Uhr, schrieb ITronic Harald Leithner
:
Hi,
So I truncating the cache was successful, but I got duplicate error
message while rebuilding:
---
Mar 29 08:37:31 mailstore dbmail-util[19249]:
Hi,
today my imapd crashed with the following message:
Apr 2 12:10:26 mailstore kernel: [4393934.966925] dbmail-imapd[21452]:
segfault at 0 ip 7faead3468ea sp 7fae9b5b1c20 error 4 in
libdbmail.so.0.0.0[7faead329000+5c000]
I think with this informations no body can help me, so its j
oxy in front reconnect without
users notice anything
Am 02.04.2012 12:27, schrieb ITronic Harald Leithner:
Hi,
today my imapd crashed with the following message:
Apr 2 12:10:26 mailstore kernel: [4393934.966925] dbmail-imapd[21452]:
segfault at 0 ip 7faead3468ea sp
7fae9b5b1c20 erro
With this query you will find all unconnected headervalues:
select * from dbmail_headervalue where id not in (select headervalue_id
from dbmail_header);
In my case there are 245,257 unused values while purging 4000 messages, so
I could do a cronjob with:
delete from dbmail_headervalue
I only know it for MySQL, you can't delete rows from the same table (this
would only work with sub-sub query).
In this Query I take the values from another table.
So this would not work:
delete from dbmail_headervalue b where id in (select id from
dbmail_headervalue a where id=1);
but thi
For me it works perfect after cache reset, running roundcube 0.7.1
Harald, maybe test it with telnet, or you use imapproxy to log the
communication between Roundcube and dbmail-imapd (as i did)
You sould see a command coming from Roundcube like this:
A UID SORT (DATE) US-ASCII ALL
this
Harald Leithner:
For me it works perfect after cache reset, running roundcube 0.7.1
Harald, maybe test it with telnet, or you use imapproxy to log the
communication between Roundcube and dbmail-imapd
(as i did)
where is the secret how to turn on logging?
"may only be turned on for one user
There is a problem in the sql Script from Harald Reindl.
The script creates the envelope table to early.
You could try to use the 2_2-3_0.mysql script in sql/mysql directory found
in the dbmail.tar.gz
after "DROP PROCEDURE IF EXISTS dodropkeys;"
regards,
Harald
Am 17.04.2012, 10:30 Uhr, s
Hi Leandro,
there is already a good solution for this:
http://www.gossamer-threads.com/lists/dbmail/users/31530#31530
But I think Paul has other things to develop, may you could write the code
that do this?
bye
HArald
Am 15.05.2012, 17:08 Uhr, schrieb leandro :
Hello,
am I wrong or th
Hi Jorge,
I upgraded form dbmail 2.2 to 3.0 and mysql 5.0 to percona server 5.5 but
on a new hardware so I couldn't give you any good information about
performance but I think Reindl Harald may have some information about the
innodb compressed feature in mysql 5.5.
regards,
Harald Leithn
About 70Gb without compression but with file_per_table with about 32
messages.
Am 13.06.2012, 23:51 Uhr, schrieb Jorge Bastos :
One extra info, for both,
Wich are the DB size each of you have?
I have 120GB now, InnoDB, with file_per_table.
Jorge,s
we are using compressed tables since
I upgraded at 19:00 all fine till now.
On 26. Februar 2014 22:48:28 MEZ, Jorge Bastos wrote:
>Hi,
>
>Anyone already using 3.1.11?
>Maybe this is the version that I'll use for my upgrade, but 'd like
>some
>feedback from anyone using it already,
>
>Thanks!!
>
>> Hi all,
>>
>> About time I release
Sure sabredav, but not outofthebox
On 19. Juli 2014 20:59:13 MESZ, Jorge Bastos wrote:
>Hi guys,
>
>
>
>Sorry for this offtopic once again,
>
>I'm looking for a working opensource caldav+carddav server for linux,
>anyone
>knows one?
>
>
>
>Thanks in advanced,
>
>Jorge Bastos,
>
>
>
>---
31 matches
Mail list logo
