How to redirect stdout and stderr to log file
How to redirect standard output and standard error to a log file. Correct syntax: command > /path/to/log 2>&1. This redirects stdout to the log and stderr to stdout.
THE KNOWLEDGE BASE
All articles.
392 notes on Linux, tools and troubleshooting
How to compress mysqldump output with gzip/bzip2
mysqldump exports MySQL data in SQL format and is commonly used for backups. Normally these backups are not compressed.
How to list stored procedures and show procedure code in MySQL
To list the stored procedures in MySQL and display their procedure code, follow these steps. Listing MySQL stored procedures: list the procedures in the system. mysql> SHO…
Find top frequently using queries on MySQL
MySQL tip: find the ten most frequently used queries over a period using tcpdump or mysqlbinlog to collect and rank them.
If / else statements on bash script
An overview of if/else statements in Bash scripts and comparison conditions. Basic if syntax: if [ condition ] then ... fi.
How to install Apache2 worker MPM, FCGI and APC on CentOS
Apache on CentOS uses Prefork by default with the PHP module. Under heavy loads, switching to Apache worker with PHP fcgi (PHP fastcgi) can reduce memory use.
How to install Apache worker + PHP FastCGI and PHP-FPM on Ubuntu 12.04 LTS
Apache worker suits heavily loaded web servers with limited resources because it uses less memory than Prefork. Enabling PHP support requires additional configuration.
How to copy a table in MySQL
In MySQL, a table's structure and data can be copied easily. For example, create table_new with the structure and data from table_name as follows.
List of default ports used by Zimbra Mail Server
The network ports used by Zimbra mail server fall into two groups. 1. External Access - Ports accessed by Clients or services outside the Zimbra system.