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

Tagged with: , , , ,
Posted in Webserver

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:

Tagged with: , ,
Posted in Database, Server

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:

Tagged with: , ,
Posted in Database