There are many howtos for compiling kernels, but most of them don’t work. Why? It’s not that they are wrong. The problem is that every linux distribution has its own idiosyncrasies. There is no howto that works for all cases. This document…
Blog Archives
Apache+PHP statically linked and MySQL compile howto
What does “statically linked” mean PHP can be run in two different modes: CGI module Apache (SAPI) module I won’t explain CGI module because it’s not part of this howto. Apache module is a library, usually shared object (.so file) which…
MRTG – mysql queries per second
A useful thing is to monitor the load on your MySQL database server. To check mysql queries per second you’ll need a simple helper script:
Dump database to text file and then restore it
The mysqldump command dumps databases/tables to standart output. You can use pipe redirect to save it to file: mysqldump [options] >dump.sql When you dump a database there are some options of mysqladmin you need to understand: