If one is going to perform maintenance on the IEPM data base, such as creating indexes, dropping indexes, optimizing the database, etc. The following steps should be taken to assure that no access is attempted while the database is undergoing modification.
Remove the crontab: Log onto the iepm account and execute 'crontab -l > /tmp/crontab'
Shut down all the servers and daemons that would access the data base: $bandsrc/utils/kill-all-servers
Perform the maintenance, and when done with the maintenance reload the crontab: crontab /tmp/crontab
Reloading the crontab will restart all the servers and daemons within 10 minutes.
It is not necessary to shut down mysql, but if you want to, use the following commandsÂ
| Anchor | ||||
|---|---|---|---|---|
|
To stop mysql: mysqladmin -u root -p shutdown
| Anchor | ||||
|---|---|---|---|---|
|
To restart mysql: sudo mysqld_safe &