Hi, our site stopped working, the server load is so high that it is almost impossible to change any option in joomla. I have rebooted the server several time, still not much help.

| 96625 | naplesne_jomking | localhost | naplesne_joomla | Query | 816 | Locked | SELECT * FROM jos_sefurls WHERE ((`sefurl` = 'component/comments') OR (`sefurl` = 'component/comment |
| 96627 | naplesne_jomking | localhost | naplesne_joomla | Query | 816 | Locked | SELECT `a`.`vars`, `u`.`sefurl` FROM `jos_sefaliases` AS `a` INNER JOIN `jos_sefurls` AS `u` ON `u`. |
| 96628 | naplesne_jomking | localhost | naplesne_joomla | Query | 816 | Locked | SELECT * FROM jos_sefurls WHERE ((`sefurl` = 'component/comments') OR (`sefurl` = 'component/comment |
| 96629 | naplesne_jomking | localhost | naplesne_joomla | Query | 816 | Locked | SELECT * FROM jos_sefurls WHERE ((`sefurl` = 'component/comments') OR (`sefurl` = 'component/comment |
| 96630 | naplesne_jomking | localhost | naplesne_joomla | Query | 816 | Locked | SELECT * FROM jos_sefurls WHERE ((`sefurl` = 'component/comments') OR (`sefurl` = 'component/comment |
| 96631 | naplesne_jomking | localhost | naplesne_joomla | Query | 816 | Locked | SELECT * FROM jos_sefurls WHERE ((`sefurl` = 'component/comments') OR (`sefurl` = 'component/comment |
| 96632 | naplesne_jomking | localhost | naplesne_joomla | Query | 816 | Locked | SELECT * FROM jos_sefurls WHERE ((`sefurl` = 'component/comments') OR (`sefurl` = 'component/comment |
| 96633 | naplesne_jomking | localhost | naplesne_joomla | Query | 801 | Locked | SELECT * FROM `jos_sefurls` WHERE (`sefurl` = '' OR `sefurl` = 'index.php') AND `trashed` = '0' LIMI |
| 96646 | naplesne_jomking | localhost | naplesne_joomla | Query | 774 | Locked | SELECT `a`.`vars`, `u`.`sefurl` FROM `jos_sefaliases` AS `a` INNER JOIN `jos_sefurls` AS `u` ON `u`. |
| 96650 | naplesne_jomking | localhost | naplesne_joomla | Query | 760 | Locked | SELECT `a`.`vars`, `u`.`sefurl` FROM `jos_sefaliases` AS `a` INNER JOIN `jos_sefurls` AS `u` ON `u`. |
| 96660 | naplesne_jomking | localhost | naplesne_joomla | Query | 720 | Locked | SELECT `a`.`vars`, `u`.`sefurl` FROM `jos_sefaliases` AS `a` INNER JOIN `jos_sefurls` AS `u` ON `u`. |
| 96661 | naplesne_jomking | localhost | naplesne_joomla | Query | 720 | Locked | SELECT `a`.`vars`, `u`.`sefurl` FROM `jos_sefaliases` AS `a` INNER JOIN `jos_sefurls` AS `u` ON `u`. |
| 96665 | naplesne_jomking | localhost | naplesne_joomla | Query | 699 | Locked | SELECT `a`.`vars`, `u`.`sefurl` FROM `jos_sefaliases` AS `a` INNER JOIN `jos_sefurls` AS `u` ON `u`. |
| 96666 | naplesne_jomking | localhost | naplesne_joomla | Query | 699 | Locked | SELECT `a`.`vars`, `u`.`sefurl` FROM `jos_sefaliases` AS `a` INNER JOIN `jos_sefurls` AS `u` ON `u`. |
| 96668 | naplesne_jomking | localhost | naplesne_joomla | Query | 686 | Locked | SELECT `a`.`vars`, `u`.`sefurl` FROM `jos_sefaliases` AS `a` INNER JOIN `jos_sefurls` AS `u` ON `u`. |

I found out that I have over 750 000 urls I am trying to purge them but I keep on timing out.

What is the best way to maintain JoomSEF so this does not happen in the future?

I think I was able to purge them but when I look in jos_sefurls table I have almost 8 millions records.

Should I purge them directly via mysql?

Just a summary:
this was caused by a JEvents component that produced almost 7 milion records in the DB (due to no limitations for dates set and many categories defined).
The solution was to forbid JEvents from storing its URLs in DB.