Default Syspass Root Folder Permission

Additional parameter for PMM-Server (Percona Monitoring)

Add this lines to the my.cnf configuration file :

log_output=file

slow_query_log=ON

long_query_time=0

log_slow_rate_limit=100

log_slow_rate_type=query

log_slow_verbosity=full

log_slow_admin_statements=ON

log_slow_slave_statements=ON

slow_query_log_always_write_time=1

slow_query_log_use_global_control=all

innodb_monitor_enable=all

userstat=1

performance_schema = ON

Error 0403-030 The fork function failed. Too many processes already exist.

This issue occur due to the process exceed the limit

Check using this command :

bash-3.00# lsattr -E -l sys0 -a maxuproc

output :

maxuproc 128 Maximum number of PROCESSES allowed per user True

then increase the parameter :

bash-3.00# chdev -l sys0 -a maxuproc=’256′

Give sudo to Linux User

1. Login as root/have sudo privileges
2. Type visudo
3. Then find the line looks like bellow pic
4. add line, with same rule as root (newuser ALL=(ALL)   ALL)

Downgrade CPU Core on Running VMware VM Guest

1. Chose Summary tab
2. Click Edit Setting
3. Chose hardware section, and change Number of virtual sockets (You can only increase the value when VM Guest running)
4. Then click ok to save the change

Check CPU Utilization in AIX

1. type nmon
2. type c

Check Memory Utilization in AIX

1. Type nmon
2. and then type m