I just upgraded to the latest version today, to be honest i don't know from what version, but i'm pretty sure it was pre 1.7.17.
Before it was running fine, MySQL updates taking less then a second, after the upgrade, when Anope is updating the tables, it will hug the database, put CPU to 300% on the mysql process, and make a lot of delayed inserts. While doing updates, Anope freezes on irc, which besides from making it unresponsive, also makes the botserv kickers kick people for flooding etc, because when it stops lagging it will process a lot of messages.
Could it be that something changed with the scheme update, that made performance really bad? This is the first i've had of this kinda problem.
I don't really need the MySQL data, but i use MySQL with anope for the ns_ajoin module.
Edit: oh, and my database is no more then 500kb in size
[Edited on 22-6-2007 by hod]