Improving MySQL database performance!

Most of the shared hosting users use different content management system for their websites. There are different types of content management systems. These content management systems use mysql database most of the time. A CMS can have degraded performance when the user’s database gets fragmented. Mysql Database fragmentation appears when you make lots of changes on your database cause lots of writes and updates. Periodically, these changes cause memory fragmentation on the database, mostly MyISAM storage engine performs tremendous slow on a fragmented condition! This tutorial should have the advises for shared hosting users, how often they should defragment their databases and how!

Continue reading “Improving MySQL database performance!”

How “Niceness” impacts shared servers!

A very well known word in linux server is “nice” value. I have seen many people discussing about the effectiveness of Apache/Mysql tweaking, but eventually, if the throughput of your linux system isn’t good enough, apahce/mysql tweaking can fail. In this article, I am going to try explaining how “Nice” value of linux system can impact the performance of linux shared servers.

Continue reading “How “Niceness” impacts shared servers!”

New achievement in Digitalpoint

Let me make a quick post about being a 700 posts club member in Digitalpoint. I am using Digitalpoint since 2007, and made these 700 posts in last 3 years. My username in Digitalpoint is “mellow-h”.

Digitalpoint is one of the first place where Mellowhost had started marketing. Most of our old customers are from Digitalpoint. We are still getting lots of users from Digitalpoint regularly visiting our site or purchasing hosting. I got around 90 positive iTrader in digitalpoint. Digitalpoint has gone under couple of re-organizing in last year. One of the key reason we fall back from digitalpoint is their re-organization didn’t work out. Currently our primary target is webhostingtalk and seeing pretty decent traffic everyday. I am planning to jump over couple of more forums beside WHT and digitalpoint has come in my mind again. Lets see how it works this time. I have always missed Digitalpoint for last 1 year after their re-organization, hope this is going to be pleasing back again.

And good luck to me for having those valuable 700 posts in DP after 3 years 😮

How to stop wp-cron.php from firing!

Recently, I have written an article about reducing the cpu usage for a wordpress blog. My post contains some information about the wp-cron.php, but it doesn’t explain how you can stop wp-cron.php from taking high CPU. Couple of our twitter followers and facebook clients were asking for a post describing how they can stop wp-cron.php from taking high CPU or firing up. Here are some small tricks to reduce the CPU usage from wp-cron.php.

Continue reading “How to stop wp-cron.php from firing!”