Centos 5.5 x64
【MySQL】关于table cache的相关参数
一、状态值和变量：
1.1
在MySQL的show status中有2个状态值：Open_tables和Opened_tables。这2个值代表的意思如下：
Open_tables ：代表当前打开表的数量。
Opened_tables：代表自从MySQL启动后，打开表的数量。
CentOS 5.5 x64 PPTPD Server
Install the poptop repository
rpm -Uvh http://poptop.sourceforge.net/yum/stable/rhel5/pptp-release-current.noarch.rpm
Installing Unstable/Beta
# Install the poptop repository first # poptop-beta updates ppp to 2.4.5-8.1.rhel5 from 2.4.4 [root@PPTP-SRVR yum.repos.d]# yum --enablerepo=poptop-beta install pptpd Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * addons: mirror.aarnet.edu.au * base: mirror.aarnet.edu.au * extras: mirror.aarnet.edu.au * updates: mirror.aarnet.edu.au poptop-beta | 2.3 kB 00:00 poptop-beta/primary_db | 7.8 kB 00:00 Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package pptpd.x86_64 0:1.3.4-2.rhel5.1 set to be updated --> Processing Dependency: ppp = 2.4.5 for package: pptpd --> Running transaction check ---> Package ppp.x86_64 0:2.4.5-8.1.rhel5 set to be updated --> Finished Dependency Resolution Dependencies Resolved ================================================================================ Package Arch Version Repository Size ================================================================================ Installing: pptpd x86_64 1.3.4-2.rhel5.1 poptop-beta 82 k Updating for dependencies: ppp x86_64 2.4.5-8.1.rhel5 poptop-beta 354 k Transaction Summary ================================================================================ Install 1 Package(s) Upgrade 1 Package(s) Total download size: 436 k Is this ok [y/N]: y Downloading Packages: (1/2): pptpd-1.3.4-2.rhel5.1.x86_64.rpm | 82 kB 00:01 (2/2): ppp-2.4.5-8.1.rhel5.x86_64.rpm | 354 kB 00:06 -------------------------------------------------------------------------------- Total 43 kB/s | 436 kB 00:10 warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, key ID 862acc42 poptop-beta/gpgkey | 1.5 kB 00:00 Importing GPG key 0x862ACC42 "PPTP Software Signing Key < This e-mail address is being protected from spambots. You need JavaScript enabled to view it >" from /etc/pki/rpm-gpg/RPM-GPG-KEY-PPTP Is this ok [y/N]: y Running rpm_check_debug Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Updating : ppp 1/3 Installing : pptpd 2/3 Cleanup : ppp 3/3 Installed: pptpd.x86_64 0:1.3.4-2.rhel5.1 Dependency Updated: ppp.x86_64 0:2.4.5-8.1.rhel5 Complete! [root@PPTP-SRVR yum.repos.d]# # I also tried to install the stable one which required the following
Intalling Poptop Stable
# Install the poptop repository first (see section above) # you need to remove ppp because installing the stable # Poptop server is a downgrade of ppp from 2.4.4 to 2.4.3. [root@PPTP-SRVR yum.repos.d]# yum remove pptpd ppp Loaded plugins: fastestmirror Setting up Remove Process Resolving Dependencies --> Running transaction check ---> Package ppp.x86_64 0:2.4.5-8.1.rhel5 set to be erased --> Processing Dependency: ppp >= 2.3.7 for package: wvdial --> Processing Dependency: ppp >= 2.4.2 for package: rp-pppoe ---> Package pptpd.x86_64 0:1.3.4-2.rhel5.1 set to be erased --> Running transaction check ---> Package rp-pppoe.x86_64 0:3.5-32.1 set to be erased ---> Package wvdial.x86_64 0:1.54.0-5.2.2.1 set to be erased --> Finished Dependency Resolution Dependencies Resolved ================================================================================ Package Arch Version Repository Size ================================================================================ Removing: ppp x86_64 2.4.5-8.1.rhel5 installed 737 k pptpd x86_64 1.3.4-2.rhel5.1 installed 174 k Removing for dependencies: rp-pppoe x86_64 3.5-32.1 installed 249 k wvdial x86_64 1.54.0-5.2.2.1 installed 268 k Transaction Summary ================================================================================ Remove 4 Package(s) Reinstall 0 Package(s) Downgrade 0 Package(s) Is this ok [y/N]: y Downloading Packages: Running rpm_check_debug Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Erasing : ppp 1/4 warning: /etc/ppp/pap-secrets saved as /etc/ppp/pap-secrets.rpmsave warning: /etc/ppp/chap-secrets saved as /etc/ppp/chap-secrets.rpmsave Erasing : pptpd 2/4 Erasing : wvdial 3/4 Erasing : rp-pppoe 4/4 Removed: ppp.x86_64 0:2.4.5-8.1.rhel5 pptpd.x86_64 0:1.3.4-2.rhel5.1 Dependency Removed: rp-pppoe.x86_64 0:3.5-32.1 wvdial.x86_64 0:1.54.0-5.2.2.1 Complete! [root@PPTP-SRVR yum.repos.d]# yum --enablerepo=poptop-stable install pptpd Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * addons: mirror.aarnet.edu.au * base: mirror.aarnet.edu.au * extras: mirror.aarnet.edu.au * updates: mirror.aarnet.edu.au Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package pptpd.x86_64 0:1.3.4-2.fc5 set to be updated --> Processing Dependency: ppp = 2.4.3 for package: pptpd --> Running transaction check ---> Package ppp.x86_64 0:2.4.3-7.fc5 set to be updated --> Finished Dependency Resolution Dependencies Resolved ================================================================================ Package Arch Version Repository Size ================================================================================ Installing: pptpd x86_64 1.3.4-2.fc5 poptop-stable 82 k Installing for dependencies: ppp x86_64 2.4.3-7.fc5 poptop-stable 384 k Transaction Summary ================================================================================ Install 2 Package(s) Upgrade 0 Package(s) Total download size: 467 k Is this ok [y/N]: y Downloading Packages: (1/2): pptpd-1.3.4-2.fc5.x86_64.rpm | 82 kB 00:01 (2/2): ppp-2.4.3-7.fc5.x86_64.rpm | 384 kB 00:07 -------------------------------------------------------------------------------- Total 45 kB/s | 467 kB 00:10 Running rpm_check_debug Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Installing : ppp 1/2 Installing : pptpd 2/2 Installed: pptpd.x86_64 0:1.3.4-2.fc5 Dependency Installed: ppp.x86_64 0:2.4.3-7.fc5 Complete! [root@PPTP-SRVR yum.repos.d]#
Refs: http://wingloon.com/2007/11/06/pptp-server-installation-in-centos-5/
http://poptop.sourceforge.net/dox/redhat-howto.phtml
http://www.anindya.com/installing-configuring-pptp-vpn-rhel-centos/