We truncated the table
core_url_rewrite and deleted the files in
var/locks/*. What happened next is our server keeps using high CPU usage. See the high CPU usage below:
I restarted apache and it keeps coming back.I don't have any idea what's happening right now.
Every year we cleaned up data by creating new website instance and we keep the old instance. Each user has a unique associated product and we have thousands of users on every year/website.
I already reindex all indexes, down the site and wait to complete the indexes. It was completed around 40 minutes because it recreates all
core_url_rewrite. I was thinking that it was completed successfully, but this high CPU usage keeps coming back.