Performance

[Roland van Laar]

On 24-04-15 13:26, absolutely_free at libero.it wrote:
> Hi,
>
> at moment I have this environment:
>
> CentOS
> nginx + phpfpm
> Dovecot, with Maildir format
> Postfix
> Roundcube
> MySQL backend
> about 10000 mailusers
> dual core Intel(R) Pentium(R) D CPU 3.00GHz
> 8 GB RAM
> network storage device (Coraid), ext4 file system
>
> I have no performance issue now, but I need to move to a different  server:
>
> FreeBSD 10.1-RELEASE
> nginx + phpfpm
> Dovecot
> Postfix
> Roundcube
> dual core Intel(R) Xeon(R) CPU            5120  @ 1.86GHz
> 16 GB RAM
> local storage with zfs file system
>
> My question is: is better to use SQLite instead of MySQL?

Do you have a lot of writes?

With SQLite you can run into locking issues:
https://www.sqlite.org/lockingv3.html
Or use the Write-Ahead Logging:
https://www.sqlite.org/wal.html

Regards,

Roland

> Should I prefer dbox format?
>
> Thank you in advance for your opinion!