Installing MySQL 5.6 using the MySQL yum repository
Oracle has released a MySQL Yum repository to make installing and updating MySQL server easier. Initially it supports Red Hat/Oracle Enterprise Linux/CentOS 6 and Fedora 18 and 19…
394 notes on Linux, tools and troubleshooting
Oracle has released a MySQL Yum repository to make installing and updating MySQL server easier. Initially it supports Red Hat/Oracle Enterprise Linux/CentOS 6 and Fedora 18 and 19…
MySQL 5.6 has a bug to watch for: running GRANT privileges in PhpMyAdmin may cause a slave to stop replicating (bug report: http://bugs.mysql.com/bug.php?id=68892). After using MySQL 5…
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.
mysqldump exports MySQL data in SQL format and is commonly used for backups. Normally these backups are not compressed.
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…
MySQL tip: find the ten most frequently used queries over a period using tcpdump or mysqlbinlog to collect and rank them.
An overview of if/else statements in Bash scripts and comparison conditions. Basic if syntax: if [ condition ] then ... fi.
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.
Apache worker suits heavily loaded web servers with limited resources because it uses less memory than Prefork. Enabling PHP support requires additional configuration.