TroubleShootingVOMS

Troubleshooting and FAQ's for VOMS

VOMS at 100% CPU

The problem seems to be due to a MySQL performances problem. The simple solution is to check the database and optimize it with the standard sqlcheck command:

mysqlcheck -u root -p -a -o -A

The meaning of the flags are:

-u for the login to use on the DBMS (here root);

-p for password authentication;

-o for optimization enabled (ask mysql to optimize DB, could take a long time if optimizations are required ;-));

-a for analyse (ask mysql to analyse DB);

-A for all databases (ask mysql to check and optimize all databases on this server).