Monthly Roundup - January 2009 - Statistics

Posted February 2nd, 2009 in Monthly Roundup

My monthly stats round up posts a summary of the most read posts over the previous month, numbers of visitors to the blog and any changes I have made over the month that may have affected visitor numbers etc. This is the monthly stats roundup for January 2009.

From 2009 my Monthly Roundup is split over two days with a list of all posts for the previous month on the first day of each month and the stats on the second day of the month.

Please note: there will be a PHP post later on today. This is a supplementary post for today.

25 most popular articles in January 2009

The following were the top 25 most accessed articles on this blog in January 2009, along with the original post date. The list is compiled from Google Analytics, looking at the "Top Content" report and sorting by unique pageviews. Last month's rank is shown in square brackets after the post title, or [-] if it wasn't in the top 25 last month.

1. Delete All Data in a MySQL Table [1] (July 16th 2004)
2. Howto Restart Apache [2] (December 22nd 2004)
3. Open firewall ports for MSN Messenger and ICQ [3] (February 13th 2004)
4. Windows Vista Black Screen After Login [10] (May 29th 2008)
5. How to check an MD5 hash on a file [5] (January 19th 2004)
6. Cross Table Update with MySQL [4] (March 1st 2004)
7. Windows Vista Black Screen After Login - Resolved [8] (June 26th 2008)
8. Formatting Dates and Times with MySQL [11] (July 17th 2004)
9. Install yum with rpm on CentOS [9] (October 16th 2007)
10. How to get and set form element values with jQuery [13] (November 13th 2008)
11. Using the HTTP_REFERER variable with PHP [12] (April 18th 2008)
12. The user is not associated with a trusted SQL Server connection [7] (June 21st 2008)
13. Create RSA and DSA Keys for SSH [14] (March 5th 2004)
14. Selectively dumping data with mysqldump [-] (October 17th 2008)
15. Backup/export bookmarks with Mozilla Firefox 3 [-] (June 24th 2008)
16. Access denied when logging into VMWare Infrastructure Web Access on Windows [16] (May 8th 2008)
17. VMWare Server Console Connection Refused [17] (February 10th 2008)
18. PHP Error Class 'SoapClient' not found [18] (September 25th 2007)
19. Errors Using mysqlimport to Import Data Into MySQL [15] (March 21st 2004)
20. Upper case and lower case strings with MySQL [-] (July 29th 2008)
21. Cross Table Delete with MySQL [20] (March 1st 2004)
22. Test if a file exists with the BASH shell [23] (August 27th 2008)
23. Reinstall TCP/IP on Windows XP [22] (August 8th 2007)
24. Howto log into an SSH Server Using PuTTY [19] (March 23rd 2004)
25. Installing mod_ssl on Apache on CentOS 5 [21] (September 20th 2007)

Visitor numbers

I get the visitor numbers from Google Analytics and saw a huge increase of 21% in visitor numbers and 25% in pageviews between December and January. The following table shows visitor numbers and pageviews for each month from October 2008 to January 2009.

RSS Subscribers

I use Feedburner/Google to serve my RSS feed and give an indication of visitor numbers. I curently have around 115 RSS subscribers, 20 more than in the last three to four months.

Changes made this month

I changed the way I write posts starting January 4th, with a scheduled system of PHP, MySQL, Javascript/jQuery and HTML/CSS each week instead of the somewhat random assortment of posts that were happening previously over a much wider range of topics, along with weekly and monthly filler posts in the form of weekly and monthly roundups.

I now post a new "on-topic" post each day (on-topic being PHP, MySQL, Javascript/jQuery and HTML/CSS) with the occasional "off-topic" post being site notices, monthly roundups and other stuff such as dealing with particular app issues, Linux issues, Windows issues etc.

I've also removed the Weekly Roundups, replacing them with a new system of monthly roundups where I cover all the posts from the previous month on the first day of the month, and the statistical information for the previous month on the second day of the month (i.e. this post).

Things to do

The ability for people to comment. Been meaning to do this one for a while now...