WassUp a great wordpress plugin, at a cost
I have been using Wassup, a wordpress that provides visitor statistics to your blog for about 2 years now. It is great, you can track the keywords that are driving the most traffic to your blog along with your referrals and visitors counts.
The downside is that WassUp collects a lot of data, way too much, and unless you have a killer server, your blog is going to get slower and slower until one day when the MySQL starts crashing on you.
As a matter of fact WassUp provides the ability to choose the data to be record, but if you had all recording options on for a long time, there is no way to delete just useless data, all you can do is delete the records that are older than a certain period.
In My case, the Wassup grew up to be 514,91 Mb (1934468 records) and that is way too much for my humble host. But at the same time, I didn”t want to lose all the records from the last two years. So what I did was to write my own SQL to delete only BOTs and spider visits leaving all real users data intact. The SQL query was:
delete from wp_wassup where `browser` =”;
after taking around 2 minutes to execute, this query deleted 1675315 rows, leaving my blog fresh and fast without losing the important records.
Also do not remember to adjust the WassUp options not to record everything, but only the things you really care to know.
Do you like WassUp, do you know of a better alternative? Tell us your story.
1 Year of AngryByte
That’s it! Anrgybyte.com turned 1 !
It’s as if it was yesterday when I posted my first article on how to play network games online.
Since then we have discussed many subjects such as games, hardware problems, windows hacks, anime, and fun stuff.
During this first year Angrybyte.com has constantly grown in both posts and visits, the chart below shows the total number of visitors per month
Here are a few statistics about this first year:
- The most discussed article was of course the famous : How to play guitar hero world tour vocals with any mic with 82 comments.
- The most visited article was this article about how to remove the Mabezat virus .
- the best google search keyword was Google wave.
- The most used browser by our visitors was: Firefox 3 with 15391 users
- The most used OS was WinXP
- about 75% of our visitors are from the United stats.
Now with this second year I promise you more advanced articles more hacks and more fun.
What would like to see on AngryByte? what would you like gone?
Thank you for your visit and I hope to see your IP in my logs again 
A great wordpress plugin to encourage comments
A very smart plugin that automatically generates a link to your commenter’s last post on their own blog!
This method will encourage more and more people to leave comments so that they gain a link from your website, some traffic, and a lot of LUV
Audio and video comments for your blog!
Today I found a new wordpress plugin, it is called Riffly. This plugin allows users to add webcam or audio comments.
The best of all is that it is free, just download it and install it, not even an API key is required. They even have the kindness to keep all videos and audio files in their own servers. You can check it out here .
Blogging Directly From Microsoft Word 2007
A great thing about Office 2007 is that you can publish to your blog directly from it and here is how to make that happen:
Read more
Ad.
