What is Mytop

Mytop  is a tool written in Perl for monitoring MySQL databases. Similar to how top monitors system processes, mytop monitors MySQL threads and the database's overall performance, allowing system administrators or developers to get some insight on how applications are interacting with a database.

Download and Install Mytop Requirements

Mytop will using Perl, DBI, Term::ReadKey, Term::ANSIColor and Time::HiRes installed on the server first.

In This Tutorial, We will start to install and configure Apache Webserver, PHP and Mysql from Source / tar.gz in O/S OpenSUSE 11.1 x86_64 bit O/s
If you are searching how to install apache php and mysql for linux o/s 32bit, please click HERE

So I assume you already have OpenSUSE11 installed, up and running.
This tutorial also can be implemented in other O/S such as : Centos and Fedora or other 64bit Linux O/S.

Login into your server with root access.

I just want to install a MySQL server to support euck korean charset.
Here is a short how to configure it.
Login into your server as root

Compile MySQL

#cd /root/mysql-5.0.88
#./configure --prefix=/usr/local/mysql --with-extra-charsets=complex
#make && make install

Edit my.cnf

#cp /usr/local/mysql/share/mysql/my-small.cnf /usr/local/mysql/my.cnf
#vi /usr/local/mysql/my.cnf

what is nginx ?

nginx (pronounced as "engine X") is a lightweight, high performance web server/reverse proxy and e-mail (IMAP/POP3) proxy, licensed under a BSD-like license. It runs on UNIX, GNU/Linux, BSD variants, Mac OS X, Solaris, and Microsoft Windows[1].

What is php-fpm ?

PHP-FPM (FastCGI Process Manager) is an alternative PHP FastCGI implementation with some additional features useful for sites of any size, especially busy sites.

Installing MySQL

In This tutorial, I assume you already have Apache 2.2, PHP 5.2.11 and MySQL 5.1.40 installed in your FreeBSD server using FreeBSD Ports.

I Will try to reconfigure PHP to using Mod_FCGI / FastCGI instead of using mod_php5.

mod_fcgid has a new process management strategy, which concentrates on reducing the number of fastcgi server, and kick out the corrupt fastcgi server as soon as possible. It is a binary compatibility alternative to Apache module mod_fastcgi; so your existing fastcgi programs do not need to be recompiled. mod_fcgid supports suEXEC.

What is LiteSpeed Web Server ?

LiteSpeed Web Server is the leading high-performance, high-scalability web server. It is completely Apache interchangeable so LiteSpeed Web Server can quickly replace a major bottleneck in your existing web delivery platform. With its comprehensive range of features and easy-to-use web administration console, LiteSpeed Web Server can help you conquer the challenges of deploying an effective web serving architecture.

In this tutorial i assume you already have Apache 2.x , PHP 5.2.x and MySQL 5.x installed and running in your server.
If your server is a brandnew server. You need to follow this URL to install a complete Apache, PHP and MySQL

If you have a site like Youtube site or any other tube site, and you want to configure your PHP to support FFMPEG.
Here is a detail how to compile and configure FFMPEG and PHP-FFMPEG so your php will support any script like flvtool, mplayer, libogg, libvorbis, libmp3lame, xvidcore, libtheora, faac, faad2 and libmp4v2

In this tutorial, all my configuration is running in OpenSUSE server.
I also confirmed that this tutorial also working with Fedora/Centos/RHEL server.

What is Plugin Architecture ?

The Plugin Architecture for Cacti was designed to be both simple in nature and robust enough to allow freedom to do almost anything in Cacti. Cacti itself is designed nicely enough that integrating into it is fairly easy with very little modifications necessary.

What is the different between Cacti Plugins and Plugin Architecture?

Cacti Plugins is plugins to support cacti itself, Plugin architecture is just design to manage cacti plugins and install cacti plugin on the fly.

Today i've configure mysql from source and found that i can't make mysql smoothly
it shows error: redeclaration of C++ built-in type ‘bool’....

So after searching google i finally can solved this problem :
The simple way is ;

1. reconfigure mysql

[code]#./configure --prefix=/usr/local/[/code]

2. type make to continue

[code]#make && make install[/code]

After make install finished without any problem.
We can safely start mysql daemon.

You're done.