We use UTM5 configured in hotspot module and we are facing with some problems, we cannot go beyond 140 simultaneous users in hotspot. I think this problem comes from a lack of resources, cause even with only 80 simultaneous users, almost all the memory is used.
For information we are using version UTM5 on a single server (NAS + Radius Server + UTM billing + User Web interface + database), running ubuntu client version 7.10 gutsy gibbon.
The hardware configuration is Intel(R) Xeon(R) CPU E5320 @ 1.86GHz, 2.5 GB memory, 260 GB HD raid.
There is one single hotspot service configured, and we have already generated more than 100.000 cards linked to this service.
We checked our configuration files and think that we may improve the use of the resources by tuning some values of the mysql and apache server. I hope you could help us about the following points:
- In the file /etc/mysql/my.cnf what values do you recommend for the following parameters?:
query_cache_limit
query_cache_size
innodb_buffer_pool_size
tmp_table_size
max_heap_table_size
- About the Apache server, what values do you recommend for the following parameters (in /etc/apache2/apache2.conf):
Timeout ?
MaxKeepAliveRequests ?
KeepAliveTimeout ?
Is it better to work with the Prefork or Worker module? And what are the best values for these parameters:
<IfModule mpm_prefork_module>
StartServers
MinSpareServers
MaxSpareServers
MaxClients
MaxRequestsPerChild
</IfModule>
<IfModule mpm_worker_module>
StartServers
MaxClients
MinSpareThreads
MaxSpareThreads
ThreadsPerChild
MaxRequestsPerChild
</IfModule>
Thank you in advance for any of your advices.
Tuning of Apache and Mysql servers for Hotspot utilization
)) 
Well, because web interface is designed as CGI binary, Apache forks any time when the user logs in or works with that binaries. Apache process itself uses about 5 megabytes. For 80 users, peak memory usage is about 400-430 megabytes. It isn't good for all-in-one server.
Try to install and configure any lightweight web server instead of Apache.
And for MySQL, try to set innodb_buffer_pool_size in range from 256 to 768M, and query_cache_size in range from 4 to 48M. Test these values carefully, blind copypaste isn't recommended.
Try to install and configure any lightweight web server instead of Apache.
And for MySQL, try to set innodb_buffer_pool_size in range from 256 to 768M, and query_cache_size in range from 4 to 48M. Test these values carefully, blind copypaste isn't recommended.