Wopular, Webmaster | featured news

Relieving High Server Load by Blocking Search Bots

Coding

Over the years, whenever the site was slow to load up, I always went through the same routine. I checked traffic logs to see if it was due to a sudden increase in traffic. If not, I would look at the mysql slow query log to see if there were slow queries bogging up the database. If that wasn’t the culprit, then I would take a look at the access logs to see if there were any irregular activities from search engine bots.

 

Downtime & How to Make a Repair Job on MySQL Go Faster

Screw Driver

The site crashed yesterday morning at around 9am, although it’s hardly noticable until a couple hours later. I didn’t notice it until I started picking stories to feature on the homepage. Whenever i tried to feature an article, it would stop the site from loading up.

From that, I knew that the MySQL database must be checking for corrupt tables. And if it’s doing that, a crash must have occurred. Checking out stats at my ISP confirmed that the server was restarted at 9am.

 

AddThis Removes "via @addthis" Suffix in Tweets

AddThis

I just noticed in the last couple of days that the sharing platform AddThis has removed “via @addthis” at the end of tweets using their widget. I use AddThis throughout the site. It’s a handy little widget that allows users to share articles through any social bookmarking/sharing site, like Facebook, Twitter, StumbleUpon and Pinterest.

As a website owner, I use it to tweet articles to my Twitter account. I used to manually get rid of the “via @addthis” suffix each time to give me more available characters and to make the tweet cleaner.

 

Facebook, Please Fix Your Comment Moderation Issues

I’ve switched over to Facebook’s comment system a while back. I did it for two reasons. First, offloading comments to a third party takes the load off my server. Second, I’m hoping to get some Facebook traffic juice.

The first part worked out. I disabled Drupal’s commenting system, which resulted in less cron jobs and queries to the database.

The second part hasn’t quite worked out. My Facebook referrals have mostly stayed the same. I’m also noticing less comments, which is a surprise. I figured since most people are on Facebook already, I would get more.

 

Facebook Added Website Comment Notifications to User Page

I just started noticing this recently. It’s a nice touch. Before, you would have to go into a specific comment moderation page to keep track of comments. Now, it’s all tied into your profile page, just like when someone likes or comments on your status updates.

Months ago, I converted my commenting system to Facebook’s. I had my reservations before. Most of it is that because it’s javascript based, the comments will not be crawled by Google. All Google sees is the javascript code, not the actual comments.

 

Subscribe to this RSS topic: Syndicate content