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…)
Archive for January, 2009
Jan
30
2009
MySQL – Steps for Better SQL Performance
Last updated: January 30th, 2009
Jan
25
2009
Linux: How to play .avi files on CentOS?
Last updated: January 26th, 2009Easy 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…)
Jan
24
2009
PHP: Personal Home Page
Last updated: January 24th, 2009Personal 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…)
Jan
20
2009
windows command prompt mysql start stop
Last updated: April 8th, 2009To 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
Jan
17
2009
Nagios – a Windows, Linux, Unix network monitoring tool
Last updated: January 25th, 2009What is Nagios?
Nagios is a network monitoring tool which helps you identify problems in your network and fix them helping you offer extensive support.
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…)
Jan
08
2009
How to find if mod_rewrite is enabled in Apache server?
Last updated: January 8th, 2009Different 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…)
- How to check if linux server can send out email via command line?
- Reverse DNS and Junk Email
- Linux: How to upgrade PHP from 5.1 to 5.2 in CentOS5?
- Linux: How to list or allow access to ports ?
- MySQL: ‘Access denied for user ‘root’@'localhost’ (using password: YES)’
- MySQL: How to stop, start or restart mysql?
- Linux: Case sensitive MySQL table names
- Apache: [warn] NameVirtualHost *:80 has no VirtualHosts
- JAVA: public class naming
- MySQL: Default collation latin1_swedish_ci (swedish case insensitive)
-
.htaccess
Apache
Apache installation
Apache Server
asterisk
cakePHP
CentOS
CGI
command prompt
Configuration error
CSS
Fedora
Gunzip
http
httpd.conf
java
jQuery
LINUX
Linux Beginner
linux notes
Linux Run Level
linux tricks
mplayer
my.cnf
MySql
Nagios
OpenVPN
Operating System
Perl
PHP
php.ini
PHP error
phpMyAdmin
RedHat
Run Level
SELinux
shell scripting
ssl
subversion
svn
ubuntu
virtual hosting
windows
xml
zend
