Managing Mysql:phpmyadmin usage on the web

1. Hardware environment:
　　
Hard disk: 9.2 G; Memory: 128 M; Network card: EEpor100
　　
2. Software
　　
Operating system: RedHat 6.2
　　
3. Optimize Redhat 6.2
　　
Select when installing
FTP and DNS
　　
Edit File/etc/hosts
　　
To
202.104.131.100 info.langoit.com.cn Info
　　
Edit File/etc/named.conf
　　
To
　　
Generated by named-bootconf.pl
　　
Options {
Directory "/var/named";
Forwarders {202.104.131.98;};
Forwards only;
Query-source address * port 53;
};
　　
//
A caching only nameserver config
//
Zone "." In {
Type hint;
File "named.ca";
};
　　
Zone "0.0.127.in-addr.arpa" in {
Type master;
File "Named.local";
};
　　　　
Edit File/etc/resolv.conf
　　
To
Search langoit.com.cn
NameServer 202.104.131.98
NameServer 202.96.134.133
　　
Optimizing the Linux kernel:
　　
Remove the No RPM package:
　　
To stop a running process first
　　
Cd/etc/rc.d/init.d
　　
./sendmail Stop
./APMD Stop
./kudzu Stop
　　
Rpm-e--nodeps sendmail kudzu nfs-utils
　　
Edit File/usr/src/linux/include/linux/tasks.h
　　
Edit line 14th (vi +14):
　　
Nr_tasks 5120---> 3072
Min_tasks_left_for_root---> 24
　　
Edit File/usr/src/linux/makefile
　　
Edit line 18th (vi +18):
　　
HOSTCC =GCC
--->
HOSTCC =egcs
　　
Edit line 25th (vi +25):
　　
CC =$ (cross_compile) gcc-d__kernel__-i$ (Hpath)
--->
CC =$ (cross_compile) egcs-d__kernel__-i$ (Hpath)
　　
Edit line 90th (vi +90):
　　
Cflags =-wall-wstrict-prototypes-o2-fomit-frame-pointer
--->
Cflags =-wall-wstrict-prototypes-o9-funroll-loops-ffast-math-malign-double-mcpu=
Pentiumpro-march=pentiumpro-fomit-frame-pointer-fno-exceptions
　　
Edit line 19th (vi +19):
　　
Hostcflags =-wall-wstrict-prototypes-o2-fomit-frame-pointer
--->
Hostcflags =-wall-wstrict-prototypes-o9-funroll-loops-ffast-math-malign-double-mcpu=
Pentiumpro-march=pentiumpro-fomit-frame-pointer-fno-exceptions
　　
To set the kernel:
　　
Make Xconfig
　　
You can set it up according to your system
　　
Under the/usr/src/linux/directory
　　
Make DEP
Make clean
Make Bzlilo
Make modules
Make Modules_install
　　
4. Installation and optimization Mm,mysql,apache,php,phpmyadmin,perl,mode_perl
　　
1) file
Mm:mm-1.1.3.tar.gz
Mysql:mysql-3.22.32.tar.gz
Apache:apache_1.3.12.tar.gz
Php:php-4.0.0.2.0.5.tar.gz
Phpmyadmin:phpmyadmin_2.0.5.tar.gz
Mode_perl:mod_perl-1.24.tar.gz
Perl-dbi:dbi-1.14.tar.gz
Dbd-oracle-1.06.tar.gz
Msql-mysql-modules-1.2214.tar.gz
Data-dumper-2.101.tar.gz
Data-showtable-3.3.tar.gz
Eperl:eperl-2.2.14.tar.gz
Perl:perl-5.6.0.tar.gz
　　
Extract files:
　　
TAR-ZXPF file name
　　
Note: All of the following precompilation and installation must be in the software directory to be installed
　　
#) Installation mm
./configure \
--disable-shared \
--prefix=/usr
Make
Make Test
Make install
Make clean
　　
# MySQL Installation and configuration
　　
# Pre-compilation of MySQL
　　
cc= "Egcs" \
optim= "-o9-funroll-loops-ffast-math-malign-double-mcpu=pentiumpro \
-march=pentiumpro-fomit-frame-pointer-fno-exceptions "\
./configure \
--prefix=/mysql \
　　
#) Install MySQL
　　
Make
Make install
Make clean
　　
#) Configure MySQL
　　
/mysql/bin/mysql_install_db
　　
Initializing the database
Cp/mysql/share/mysql/mysql.server/etc/rc.d/init.d/mysql
Cd/etc/rc.d/rc3.d
Ln-s.. /init.d/mysql S70mysql
　　
Load MySQL at system startup
　　
#) Pre-compilation of Apache
　　
cc= "Egcs" \
optim= "-o9-funroll-loops-ffast-math-malign-double-mcpu=pentiumpro \
-march=pentiumpro-fomit-frame-pointer-fno-exceptions "\
cflags= "-ddynamic_module_limit=0" \
./configure \
--prefix=/apache \
　　
# Pre-compilation of PHP
　　
cc= "Egcs" \
optim= "-o9-funroll-loops-ffast-math-malign-double-mcpu=pentiumpro \