08-24-2008, 02:23 PM
Update. Instead of using MySQL's own indexer, I now use a third party indexer. This means for you that you have blazingly fast logs. I will also delete all entries older than 3 weeks, to keep the size of the database managable.
Also, there's now an option which allows you to easy copy and paste logs, for use on the forum, or IRC. Of course, this new way of indexing also introduces some neat little search operators, but as nobody ever uses them, I won't be telling what they are.
Klotebot also uses the new index, so !logs <searchtext> is back. Happy adminning.
Oh by the way, the Regular Server logs still use the old way. So those are still slow.
Also, there's now an option which allows you to easy copy and paste logs, for use on the forum, or IRC. Of course, this new way of indexing also introduces some neat little search operators, but as nobody ever uses them, I won't be telling what they are.
Klotebot also uses the new index, so !logs <searchtext> is back. Happy adminning.
Oh by the way, the Regular Server logs still use the old way. So those are still slow.