Please subscribe to our RSS feed for new articles. We report on Wordpress news, themes, plugins, ideas, hacks, quick fixes and everything about blogging, especially about Wordpress. You can also receive updates from this blog via email if you want that method of notification.
The comment spam floods have subsided very suddenly and it can only mean that the spammers are re-grouping or working on some killer app in the spamming world.
I am afraid that can only mean more trouble for us bloggers. Stay tuned.
My server is having some Mysql connection issues. I know that the number of queries has increased exponentially and I am also aware that the server is doing a lot more work. However, I am wondering if I can tweak some Mysql parameters to make things work better. Here are some details:
Mysql frequently runs out of connections. I close every connection after I am done with it, and I try to reduce or break up all my slow queries. The server averages about 10 queries a second and the number of threads hover around mid 90s all the time. I have reduced the max_timeout and the connect errors to try and reduce the number of threads but that does not seem to make much of a difference. I have tried to increase the number of max connections and that just seems to grind the server to a halt. I have tweaked the SQL as far as I can and have looked at optimising the use of SQL. Is there something else that I should be looking at? If this continues I might have to rewrite some of the apps that use the mysql database. Also, as an aside, are the max connections per database or per database server?
PS: The load is NOT being generated by WordPress. There is true load on the server from some other applications that I run in the background.
If you are using the Technorati Link Cosmos using PHP then links that this tag generates will be counted by Search engines as being valid - which they may well be. But if a spammer sets up a blog, and links to you, you will be counted as providing a valid link. You might not want that to happen.
The altered script can be grabbed here: http://www.tamba2.org.uk/downloads/cosmos.phps
It won’t remove the link and it’s not ideal as you are tarring all links with the same brush, but it will make the spammers link useless for pagerank purposes.