sourcode

via:
adurdin

mtop เอาไว้ monitor การทำงานของ MySQL ครับ

ปล. สำหรับ 64bit server นะครับ

# get http://pkgs.repoforge.org/perl-Curses/perl-Curses-1.28-1.el5.rf.x86_64.rpm
# rpm -ivh perl-Curses-1.28-1.el5.rf.x86_64.rpm
# wget http://pkgs.repoforge.org/mtop/mtop-0.6.6-1.2.el5.rf.noarch.rpm
# rpm -ivh mtop-0.6.6-1.2.el5.rf.noarch.rpm
# mtop –dbuser=root -p

fashion show by MARC JACOBS Spring/Summer 2012 at Marc Jacobs 1st floor Siam Discovery

mini concert by Palmy

Thank Club21 Thailand for this wonderful fashion show!

# aptitude install libaio-dev libaio1

# cd /usr/src
# wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.21-debian5.0-x86_64.deb/from/http://mysql.oss.eznetsols.org/
# dpkg -i ysql-5.5.21-debian5.0-x86_64.deb
# ln -s /opt/mysql/server-5.5 /usr/local/mysql
# ln -s /opt/mysql/server-5.5/bin/* /usr/local/bin/
# cp /opt/mysql/server-5.5/support-files/my-medium.cnf /etc/mysql/my.cnf
# ln -s /etc/mysql/my.cnf /etc/my.cnf
# nano /etc/mysql/my.cnf

[client]
#password = your_password
port = 3306
socket = /var/run/mysqld/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port = 3306
socket = /var/run/mysqld/mysql.sock
user = root
basedir = /usr/local/mysql
datadir = /var/lib/mysql
tmpdir = /tmp
log_error = /var/log/mysql.err
skip-external-locking
….

# cp /opt/mysql/server-5.5/support-files/mysql.server /etc/init.d/mysql
# chmod +x /etc/init.d/mysql
# update-rc.d mysql defaults
# mkdir /var/lib/mysql
# cd /opt/mysql/server-5.5/scripts/
# ./mysql_install_db –user=root –ldata=/var/lib/mysql/
# /etc/init.d/mysql start
# /usr/local/mysql/bin/mysqladmin -u root password ‘newpassword’

## test
# mysql -u root -p

## finalize
# mysql_upgrade -u root -p

source:
http://www.badllama.com/comment/1
https://wiki.archlinux.org/index.php/MySQL