Indeed with this new setup, everything is ok. But When I search for a single user using name and surname mysql starts to use a lot of CPU time and I get the result in about 40-50 seconds.
These are the technical details of our server where we run the
kopano-server and the
mysql database :
- It’s a virtual machine running
- 4 CPUs (virtual CPUs)
- 8 GB of RAM
- 40 GB of Disk
Maybe there is something wrong in my configuration. But I checked the queries executed when I search something in the GAB and for every new query in the GAB the database has to execute something like 80.000 sql commands when I search for name and surname. Instead when I try to get the entire GAB it has to execute something like 180.000 queries.
Our Global Address book has 45.000 contacts.
Is it something we can fix with the currect setup? Or we need to optimize and tune the database?