From OCS Inventory NG
Jump to: navigation, search

Ajustes del servidor de Administración (Management server)

OCS Inventory NG management server needs some tuning to support the load of a large number of inventoried computers. Performances are just limited by the hardware configuration (especially the amount of RAM, processor is not very loaded) of computer hosting the 3 main components:

  • MySQL database server.
  • Communication server.
  • Administration server.
  • Deployment server.

For example, our production server manages more than 70 000 clients. For this, we have 3 servers running Linux Debian Sarge, one for the database server and the Communication server, another one for Administration console and a replica of database server (we choose to replicate database on Administration server to avoid Administration console SQL queries using CPU and MySQL connextions of database used by Communication server) and the last one for deployement server. Hardware configuration for servers is the following:

  • 1 Intel Pentium Xeon 2,8 GHz.
  • 3 GB RAM

Because of the amount of available RAM, we have to limit the number of simultaneous HTTP connection to Communication and Administration server to 400.

You must keep an eye on Apache web server logs for Communication server to detect any problems. Also, check Communication server log file in directory “/var/log/ocsinventory-NG”.

If you want to upgrade the number of simultaneous connections, you must update the “MaxClients” directive in Apache configuration file, usually “/etc/httpd/conf/httpd.conf”.

Refer to Apache tuning guidelines on Apavhe web site ( for more information.

Also, MySQL database server is limited by default to 100 simultaneous connections. So, if the Communication server handles more than 100 simultaneous requests for inventory, it will not be able to answer all. You can upgrade this value by updating the “max_connections” MySQL variable for mysqld daemon.

Here is sample recommdations found on MySQL web site, using server with different amount of physical memory.

800 MB
1.7 GB
2.4 GB
Table_cache 64M 64M 64M
Key_buffer 128M 256M 256M
Sort_buffer_size 2M 2M 2M
Read_buffer_size 2M 2M 2M
Read_rnd_buffer_size 4M 4M 4M
Myisam_sort_buffer_size 64M 64M 64M
Query_cache_size 128M 128M 128M
InnoDB_buffer_pool_size 384M 1024M 1700M
InnoDB_additional_mem_pool_size 20M 20M 20M
InnoDB_log_buffer_size 8M 8M 8M

Refer to MySQL tuning guidelines on MySQL web site ( for more information.