I have just upgraded to version 1.2.9 and instantly got a broken replication error message from my monitoring system. There was a Duplicate entry for one of the records in vb_dbtech_dbseo_resolvedurl that stopped the slave server. I thought this could be just an installation issue, but standard...
I'm still working on the sphinxsearch issue (and it doesn't look good). But I've spent a lot of time looking at mytop and one thing caught my attention - there's a lot of
SELECT COUNT(*) AS earlierPosts FROM post AS post WHERE post.threadid = xxx AND post.visible = 1 AND post.dateline =...