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? Should I prefer dbox format? Thank you in advance for your opinion!
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!
On 24/04/15 08:26, absolutely_free at libero.it wrote:> My question is: is better to use SQLite instead of MySQL? > Should I prefer dbox format? > > Thank you in advance for your opinion!While 10k accounts is not a few accounts, i wouldn't call that a LOT of accounts neither. Assuming that the query cache is active on MySQL, probably almost all your queries are being answered directly from the cache and, if not that, your tables shouldnt be that big and after a few queries should be all in cache memory of the Linux system. Your I/O costs on the MySQL should be very very very low, o i really doubt that MySQL is being part of your problem here. Unless, of course, that you have other heavy databases running on the MySQL instance your mail system is using... -- Atenciosamente / Sincerily, Leonardo Rodrigues Solutti Tecnologia http://www.solutti.com.br Minha armadilha de SPAM, N?O mandem email gertrudes at solutti.com.br My SPAMTRAP, do not email it