十二、查看端口、测试、应用 Mysql:
netstat -nat
mysql -uroot -p
mysql> show processlist; -- 查看当前正在执行的任务
mysql> show variables; -- 查看系统变量
mysql> show variables like 'max%'; -- 查看max开头的系统变量
mysql> show status; -- 查看当前系统状态
mysql> show status like 'qcache%'; -- 查看与qcache相关的系统状态
mysql> show status like 'max%'; -- 查看与max相关的系统状态
mysql> show master status; -- 查看主从关系中主服务器状态
mysql> show slave status; -- 查看主从关系中从服务器状态
至此,可以使用MYSQL了,如果需要开放3306端口,则:
CENTOS打开3306端口:
加入#/sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
保存#/etc/rc.d/init.d/iptables save
查看打开的端口# /etc/init.d/iptables status 【或#service iptables status】
********************************************************************************
附1:f配置参考:
********************************************************************************
# 优化 Mysql 配置文件
# 以4核cpu 8G内存的硬件配置来优化参数: vim /etc/f
#
# This is for a large system with memory of 1G-2G where the system runs mainly
# MySQL.
# .............略掉注释
[client]
#password = your_password
port = 3306
socket = /usr/local/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /usr/local/mysql/mysql.sock
datadir=/mysqldata
basedir=/usr/local/mysql
skip-name-resolve #此参数务必加,否则远程连接会很慢。
skip-external-locking
key_buffer_size = 4096M
max_allowed_packet = 2M
table_open_cache = 1024
sort_buffer_size = 2M
read_buffer_size = 32M
read_rnd_buffer_size = 32M
myisam_sort_buffer_size = 128M
thread_cache_size = 64
query_cache_size = 128M
lower_case_table_names = 1
skip-name-resolve
max_connections = 1024
character-set-server = utf8
collation-server = utf8_general_ci
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin
expire_logs_days = 10
# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1
# 以下这些参数可开启。如果应用程序要用到innodb表的话。
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /usr/local/mysql/data
#innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
#innodb_log_group_home_dir = /usr/local/mysql/data
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 384M
#innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 100M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 32M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[myisamchk]
key_buffer_size = 1024M
sort_buffer_size = 512M
read_buffer = 32M
write_buffer = 64M
[mysqlhotcopy]
interactive-timeout
****************************************************************************
附2:可能出现的错误:
****************************************************************************
0、make编译过程中,如出现“警告:提领类型双关的指针将破坏强重叠规则”错误,可以忽略。
#以下错误在centos6.2(已配置好gcc)不会出现。主要是针对centOS5.6之类的系统:
1、错误:Could NOT find Curses
先删除掉CMakeCache.txt ,再yum install ncurses-devel即可。
[root@localhost mysql-5.5.20]# rm CMakeCache.txt
2:出现如下错误:
/usr/local/src/mysql-5.5.20/sql/: In function ‘void handle_connections_sockets()’:
/usr/local/src/mysql-5.5.20/sql/:5131: 错误:从类型 ‘size_socket*’ 到类型 ‘socklen_t*’ 的转换无效
/usr/local/src/mysql-5.5.20/sql/:5131: 错误: 初始化实参 3,属于 ‘int accept(int, sockaddr*, socklen_t*)’
/usr/local/src/mysql-5.5.20/sql/:5198: 错误:从类型 ‘int*’ 到类型 ‘socklen_t*’ 的转换无效
/usr/local/src/mysql-5.5.20/sql/:5198: 错误: 初始化实参 3,属于 ‘int getsockname(int, sockaddr*, socklen_t*)’
make[2]: *** [sql/CMakeFiles/sql.dir/.o] 错误 1
make[1]: *** [sql/CMakeFiles/sql.dir/all] 错误 2
make: *** [all] 错误 2
--------------------------------
这个是gcc的版本问题,
安装GCC4.4.6【镜像站点gcc-4.6.2编译时有问题】
1.对gcc-4.4.6.tar.gz解压configure,configure出错,需要安装3个依赖包gmp、mpfr和MPC。
由于MPFR依赖GMP,而MPC依赖GMP和MPFR,所以要先安装GMP,其次MPFR,最后才是MPC。
gcc版本太旧会出现:.o错误,安装最新版http://gcc-uk.internet.bs/releases/【镜像站点gcc-4.6.2编译时有问题,因此不建议用更新的版本4.6.2】,
【注:centOS6.2不需要再安装GCC以及以下3个软件了】
1、 GMP,下载:/
2、 MPFR:下载:/mpfr-3.0.0/mpfr-3.0.0.tar.bz2
3、 MPC 0.9【0.8.1不行】下载:/?prog=mpc&page=download
详细安装GCC参/traindiy/blog/item/0ad6cc5cfb26645cfaf2c05e.html
1.1安装GMP
gmp安装gmp-4.3.2.tar.gz
./configure --prefix=/usr/local/gmp
make
make install
1.2安装MPFR
MPFR安装mpfr-3.0.0.tar.bz2
注意configure时候,加入
./configure --with-gmp=/usr/local/gmp --prefix=/usr/local/mpfr,因为mpfr需要gmp。
1.3安装MPC:
./configure --prefix=/usr/local/mpc --with-gmp=/usr/local/gmp --with-mpfr=/usr/local/mpfr
2.解压后目录gcc-4.4.6,具体安装参/traindiy/blog/item/0ad6cc5cfb26645cfaf2c05e.html
注意:如果需要把/usr/local/lib路径加入到/etc/ld.so.conf中。进一步执行ldconfig.