MySQL 关于OpenSSL证书支持检查方式
1、mysql编译参数:
#cat /usr/local/mysql/bin/mysqlbug|grep configure
# This is set by configure
CONFIGURE_LINE="./configure '--prefix=/usr/local/mysql' '--with-openssl' '--enable-thread-safe-client' '--enable-local-infile' '--with-charset=gbk' '-with-extra-charsets=gb2312,gbk'"
表示编译中支持openssl;
2.检查MY配置文件:
#find / -name my.cnf|xargs cat|grep ssl
结果如下:
ssl-ca=/usr/local/mysql/var/ca-cert.pem
ssl-cert=/usr/local/mysql/var/server-cert.pem
ssl-key=/usr/local/mysql/var/server-key.pem
表示有支持。
3.检查mysql数据库是否启用openssl
3.1 不进入数据库方式
#/usr/local/mysql/bin/mysqladmin -uroot -p VARIABLES | grep -i ssl
| have_openssl | YES |
表示openssl启用
3.2 进入数据库方式
mysql> SHOW VARIABLES LIKE '%ssl%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_openssl | YES |
表示openssl启用
4. 检查数据库版本
4.1 外部检查
4.1.1 #mysql -V
4.1.2 #mysql --help | grep Distrib
4.2 内部检查
4.2.1
mysql> status;
4.2.2
select version();
另外资料:
http://blog.csdn.net/hy2003fly/archive/2006/12/31/1471261.aspx
1、nginx编译参数:
#/usr/local/nginx/sbin/nginx -V
2、apache编译参数:
# cat /usr/local/apache/build/config.nice
3、php编译参数:
# /usr/local/php/bin/php -i |grep configure
4、mysql编译参数:
# cat /usr/local/mysql/bin/mysqlbug|grep configure
相关文档:
grant replication slave on *.* to backup@192.168.188.128 identified by "123456";
grant replication slave on *.* to backup@192.168.188.8 identified by "123456";
service mysql stop
server_id = 1
log-bin = mysql-bin
log-error=mysql-error
master-host = 192.168.188.8
master-user = ba ......
数据库的优化是系统优化的重要方面,而数据库优化的基础是基于统计数据,下面的这些命令可以帮助我们了解数据库的状态。比如用show table status from ecl where rows>10000;可以看哪些数据库表比较大,然后看看这些表的设置、索引等是否有问题。
1. show tables或show tables from dat ......
在mysql的slow query log中,可能存在类似这样的特殊记录:
# Time: 100127 23:17:01
# User@Host: root[root] @ [127.0.0.1]
# Query_time: 18446744073709.351562 Lock_time: 0.000129 Rows_sent: 1 Rows_examined: 11030
SET timestamp=1264663021;
SELECT dummy.id AS dummy_id
from dummy&nbs ......