Forum GLPI-Project

Zimsil

Member

Registered: 2014-09-09

Posts: 28

Performance optimization

Hi

I am using glpi 0.84.5. I have a large number of users in my database and up to 25 users logged into the system at a given time. I have realized that when there arent many users on the system, loading users onto the dynamic drop-down when assigning is a tad faster than when there are say 25 people logged onto the system at the same time. Generally, performance is bad when there are many users logged on.

I figured that I had to tune my my.ini file. Now I am running the application on a windows environment(Server 2012, 8GB RAM 2.50GHz 4CPUs)  and from what I've checked, the tuning-primer doesnt work for windows. Can anyone suggest a tuning solution that works on windows too.

In the mean time here is what my config file looks like

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 256M
sort_buffer_size =2M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 256M
sort_buffer_size = 2M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

[mysqld]
port=3306
skip-grant-tables
skip-locking

back_log = 125
max_connections = 200
key_buffer_size = 4096M
myisam_sort_buffer_size = 16M
join_buffer_size = 2M
read_buffer_size = 2M
sort_buffer_size = 2M
table_cache = 1400
thread_cache_size = 70
wait_timeout = 12200
connect_timeout = 60
tmp_table_size = 8M
max_heap_table_size = 16M
max_allowed_packet = 16M
max_connect_errors = 1000
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 16M
query_cache_min_res = 2K
query_cache_limit = 16M
query_cache_size = 16M
query_cache_type = 1
query_prealloc_size = 65536
query_alloc_block_size = 131072

Can anyone suggest what changes to make

Regards

Last edited by Zimsil (2014-12-14 11:35:08)

albertus

Member

Registered: 2012-02-12

Posts: 20

Re: Performance optimization

Try optimizing php first. I suggest ZendOpCache for opcode caching. php-APC should work too, but it's older.

Zimsil

Member

Registered: 2014-09-09

Posts: 28

Re: Performance optimization

Hi

I have just installed php APC on my server. This is what I have in my php.ini file

apc.enabled = 1
apc.shm_segments = 1
apc.shm_size = 128M
apc.max_file_size = 10M

I restarted my apache service but there hasn't been much of a difference. Any idea what else I need to configure to optimize my php. I am on php version 5.3.0

ddurieux

Plugins Dev

From: Propières, France

Registered: 2005-06-17

Posts: 7,521

Re: Performance optimization

5.3.0 ? are you crazy ?

Udate to last version of 5.3.x or better in 5.4.x or 5.5.x

Zimsil

Member

Registered: 2014-09-09

Posts: 28

Re: Performance optimization

So, I finally upgraded to 5.5.12. I have enabled and configured opcache.

My settings look like this

zend_extension="C:\wamp\bin\php\php5.5.12\ext\php_opcache.dll"
opcache.enable=1
opcache.memory_consumption=256
opcache.max_accelerated_files=3907
opcache.interned_strings_buffer=8
opcache.revalidate_freq=60
opcache.fast_shutdown=1
opcache.enable_cli=1

There isnt much of a difference.

Last edited by Zimsil (2015-02-12 14:40:24)