Developers guide

Chapter 9

Performance optimization 74

mysql> show variables;

| innodb_additional_mem_pool_size | 1048576 |

| innodb_autoextend_increment | 8 |

| innodb_buffer_pool_awe_mem_mb | 0 |

| innodb_buffer_pool_size | 8388608 |

PacketFence relies heavily on InnoDB, so you should increase the buffer_pool size from the default

values.

Shutdown PacketFence and MySQL

# /etc/init.d/packetfence stop

Shutting down PacketFence...

[...]

# /etc/init.d/mysql stop

Stopping MySQL: [ OK ]

Edit /etc/my.cnf (or your local my.cnf):

[mysqld]

# Set buffer pool size to 50-80% of your computer's memory

innodb_buffer_pool_size=800M

innodb_additional_mem_pool_size=20M

innodb_flush_log_at_trx_commit=2

# allow more connections

max_connections=700

# set cache size

key_buffer_size=900M

table_cache=300

query_cache_size=256M

# enable slow query log

log_slow_queries = ON

Start up MySQL and PacketFence

# /etc/init.d/mysqld start

Starting MySQL: [ OK ]

# /etc/init.d/packetfence start

Starting PacketFence...

[...]

Wait 10 minutes for PacketFence to initial the network map and re-check iostat and CPU