Archive for January, 2009

Jan
30
2009

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
(more…)

  • Share/Save/Bookmark
Jan
25
2009

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. (more…)

  • Share/Save/Bookmark
Jan
24
2009

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. (more…)

  • Share/Save/Bookmark
Jan
20
2009

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/Save/Bookmark
Jan
17
2009

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. (more…)

  • Share/Save/Bookmark
Jan
12
2009

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. (more…)

  • Share/Save/Bookmark
Jan
08
2009

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 (more…)

  • Share/Save/Bookmark