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@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@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@solutti.com.br
My SPAMTRAP, do not email it
participants (3)
-
absolutely_free＠libero.it
-
Leonardo Rodrigues
-
Roland van Laar