Server

TinyWeb - Smallest web server for Windows

TinyWeb - Smallest web server for Windows

I was searching for the smallest web server for Windows which has acceptable features and can be used in production environment. Well TinyWeb by RitLabs is an incredibly small web-server for Windows with its executable file of only 67.2KB! And despite such small size, its very fast and efficient.

Read More

How to reduce server load by MySQL caching and optimization

How to reduce server load by MySQL caching and optimization

As the web traffic starts growing, the CMS based websites take more time to load and therefore MySQL server needs to be optimized or at least it should utilize available server resources judiciously in order to meet the future traffic demands. Database caching can significantly improve your CMS performance during peak hours. Although the main factor that affects database performance is how queries have been written but still significant performance boost can be achieved by tweaking MySQL settings. Lets learn how to tweak MySQL settings to optimize and improve its caching in order to get optimum performance and reduce server load.

Read More

How to create backup of MySQL databases using command line on linux server

How to create backup of MySQL databases using command line on linux server

In this post we will show you how to backup your databases in MySQL on your linux server. You must be thinking why is this important? The reason is that most websites make use of a content management system (such as Drupal, Joomla!, Wordpress, phpBB). Content management Systems need databases to store content, articles or posts along with all the necessary settings. Generally these content management systems are written in PHP/Perl and use MySQL as their data backend, so it is very important to create backup of the database at regular intervals.

Read More