SP Blogger

Make Money Online, Blogging Tips, SEO, Investment Guide, Financial Planning…

I am getting ‘Akismet has detected a problem. A server or network problem prevented Akismet from checking xxx comments. They have been temporarily held for moderation and will be automatically re-checked in xx mins.’ issue lately… This issue happens once in a while. And the longest last for 1 day. I had to delete all the spam comments manually by clicking ‘Check for Spam’. It is okay now as the time of writing this article. Hmm… Any idea what went wrong?

Anyway, I discovered another stuff ~ wp_commentmeta is the biggest size table in my WordPress database. What does wp_commentmeta store? After checking here and there. It has _wp_trash_meta_status data in meta_key. And lot of akismet_result, akismet_history, akismet_as_submitted, akismet_user_result and akismet_user entries too. wp_comments is only 8.5MB while wp_commentmeta is using more than 40MB database storage space. And it has more rows than wp_comments. Do these entries have any value at all?

After did some testings, I found out that wp_trash_meta data will be generated when you spam or trash a comment. And will be deleted after you delete the comment permanently. So the wp_commentmeta is clean. However, it will get bigger and bigger if you are using Akismet WordPress Plugin. Akismet will create 3 entries in wp_commentmeta on each comment. 5 entries if you spam the comment yourself manually.

I prefer a small and clean WordPress database. So it is time to clean it up. I used these entries to check and delete those unwanted entries.

Clean up wp_commentmeta entries that have no relation to wp_comments

select count(*) from wp_commentmeta where comment_ID not in
(select comment_ID from wp_comments)

delete from wp_commentmeta where comment_ID not in
(select comment_ID from wp_comments)

Clean up all Akismet wp_commentmeta entries

select count(*) from wp_commentmeta where meta_key like ‘%akismet%’

delete from wp_commentmeta where meta_key like ‘%akismet%’

Only performs these scripts in phpMyAdmin if you know what you are doing…

Mudajaya Target Price ~ Updated 24-08-2011

24 Aug

Mudajaya target price was downgraded by both CIMB Securities and OSK Research. The main reason ~ delays at Chhattisgarh. CIMB Securities lowers it by 7.3% from RM7.44 to RM6.88 (before ex-bonus) == RM5.95 to RM5.50 (ex-bonus), pegged to 20% RNAV discount. OSK Research downgraded it even further from RM5.48 to RM4.15 based on a 30% discount to SOP.


MUDAJYA past 2 months stock price

Mudajaya Target Price
RM 5.50 ~ CIMB Securities
RM 4.15 ~ OSK Research

With current uncertain economy situation, Mudajaya stock price is unlikely will go back to historical high at RM4.08 any time soon…

How to recover from Google Panda Update?

18 Aug

How to recover from Google Panda Update? I tried lot of methods like optimizing my website by fixing HTML issues on Google Webmaster Tools. De-index all the category and tag pages from Google search index. All the paged pages (like page 2, page 3) are de-indexed too. But none of them are helping to improve the traffic in my case. So what did I do to improve my blog traffic?


JayceOoi.com daily unique visitors

Finally, JayceOoi.com is getting back some traffic after international Google Panda Update on April. Recovery is hard and pain. Why? I had to write more quality articles to replace those lost traffic. Yes, the latest increased traffic is coming from new articles. I did not manage to gain back those lost traffic on certain keywords. They are gone forever. But this is not end of the world, we still can write better and more quality articles, right?

Which keywords should I use?

02 Aug

I have a new smartphone ~ Samsung Galaxy S II. It is a great phone but bad compare to HTC HD2 in SEO term. Why? The official Samsung Galaxy S II keywords does not always return the search result that I want. Samsung Galaxy S (SGS1) results were returned some time. Therefore, I used Google Trends to check its search volume.


Samsung Galaxy S II search volume

Based on Google Trends, Samsung Galaxy S2 is the most frequent search keywords compare to official Samsung Galaxy S II keywords. So you know which keywords should I use now?

I mentioned that Western Union rate is based on Google AdSense payment date previously. I can double confirm it again. I just withdrew 2 Google AdSense payments by using Western Union service through RHB Bank. Both of them have different rate.


2 Google AdSense payments

Err… USD is getting weaker again. I got RM 2321.19 for USD 771.77 (May) and RM 2292.66 for USD 781.13 (June). I should get higher earning in RM for June earning but in other way round due to weaker USD currency rate.

By the way, you need to withdraw Google AdSense earning from Western Union within 60 days. Else the payment will revert back to Google and your future Google AdSense payment will be on hold. Do remember that.

How is your Google AdSense earning nowadays?


Page 5 of 95<<34567>>



Email Updates

Enter your Email to subscribe:


Subscribe to SP Blogger feeds