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.
THE KNOWLEDGE BASE
All articles.
389 notes on Linux, tools and troubleshooting
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.
How to fix error Table upgrade required. Please do "REPAIR TABLE" (2045019)
If you have upgraded Zimbra Collaboration Server (ZCS) to version 7 and encounter the error below: Table upgrade required. Please do "REPAIR TABLE" (2045019), from mysqlcheck, as in this example: D…
How to disable IPv6 on CentOS
There are several ways to disable IPv6. The recommended method is to edit /etc/sysctl.conf rather than disable the IPv6 module, which causes problems with SELinux and other components…
How to change default OS MTA to the ZCS Postfix
System email on a Zimbra server normally uses the system MTA. To send system mail using the Zimbra mailer instead of the default OS MTA, follow these steps. Backup default OS MTA [root@E