2009 January

MySQL – Steps for Better SQL Performance

Steps to make MySQL produce optimized results

» Identify the queries that execute slowly
» Watch for Opened Sql connections
» Carry benchmark test on Queries
» Execute queries with Explain statement to the performance of each queries
Continue Reading…

Share

Linux: How to play .avi files on CentOS?

Easy steps to play.avi file in a Linux box

Searching on google I came across this link initially but didn’t understand what it really did and so skipped the link. It was after searching for various other .avi files I came across this link again which made the mplayer installation an easier task. Continue Reading…

Share

PHP: Personal Home Page

Personal Home Page – PHP Hypertext Processor

1997 – PHP/FI 2 solely handled by Rasmus

1998 – Zeev and Andi teamed up with Rasmus to give a new face to PHP by rewriting the core engine and a facility to interface with different technologies using API giving rise to the next version PHP 3. PHP 3 continuously parsed the scripts when they were getting executed. Continue Reading…

Share

windows command prompt mysql start stop

To start MySQL service from Windows command prompt

c:\mysql\bin> net start mysql

To stop MySQL service from Windows command prompt

c:\mysql\bin> net stop mysql

Share

Nagios – a Windows, Linux, Unix network monitoring tool

What is Nagios?

Nagios is a network monitoring tool which helps you identify problems in your network and fix them helping you offer extensive support.nagios-whitebg-212x50

It is used to monitor both Windows and Linux/Unix based networks in addition to monitoring the web services, NNTP, POP, PING, processor load, disk usage, applications, switches, routers, firewalls, print services that run on it and the list extends. Continue Reading…

Share

What is the difference between a Cookie and a Session?

cookie is a text file that is stored on the client in name => value pairs to identify subsequent requests from the client by the server. Max. size of cookie file is 4k and it is stored on the client’s hard disk. Cookies are used as a mechanism to establish state and to track user behavior. Continue Reading…

Share

How to find if mod_rewrite is enabled in Apache server?

Different hosting locations have different settings for mod_rewrrite module. In some locations it is turned ON by default and for some it isn’t.

If you are hosting your application in your local host or on a dedicated server, then it is a matter of editing httpd.conf file within Apache server folder. Ensure that Continue Reading…

Share