A lot of effort has been put into making the userTrack tracking and dashboard as fast as possible. userTrack runs well on most servers, but depending on the amount of traffic you get and the total database size you should consider the following suggestions for your server configuration:
Minimum recommended server specifications:
<50k monthly visits
Any cheap VPS or shared hosting should work
1 GB RAM
1 vCPU
10GB disk
You should consider upgrading your server if you store more than 500k total sessions
<250k monthly visits
2 GB RAM
2 vCPU
25GB disk
You should consider upgrading your server if you store more than 1M total sessions
<2M monthly visits
8GB RAM
4 vCPU
50GB disk
2M+ monthly visits
userTrack has not been tested for this amount of traffic
Note that normally the RAM is not fully utilized by the MySQL database unless you properly configure your MySQL config (my.cnf).
It is important to change your the innodb-buffer-pool-size
based on the available RAM size.
Here is a recommended MySQL config for an 8GB/4vCPU server:
[mysqld]# InnoDBinnodb-buffer-pool-size = 5500M # This should be around 70% of your total RAMinnodb_buffer_pool_instances = 6innodb_stats_on_metadata = 0innodb_log_file_size = 768M # Around 15% of buffer-pool-sizeinnodb_file_per_table = 1 # Don't fragment tables across filesinnodb_flush_log_at_trx_commit = 2 # Increases tracking write speedmax_connections = 100
If you can't decide what server configuration to use, you can contact support for help and suggestions.