,,,,,,
显示
mpstat, 3, 3 {
, mysql,解释
mysql
显示mysql
mysql
=====在祝辞mysqladmin变量- u用户名-ppassword
======在祝辞mysqladmin exlended -stautus -u username -ppassword
/etc/my.cnf
my.cnf
sql
0.01
mysqldmpslow
mysqldmpslow --help
entertime
sql
mysqldumpslow
explain
explain
explain
index_stuname
sql
profiling
sql
CPU
ERROR 1040
max_xonnections
/etc/my.cnf
mysql
/etc/my.cnf文件,在[mysqld]下面添加如下内容,如设置最大连接数为1024
mysql
mysqlinteractive_time7200
1
2
3
wait_timeout
wait_timeout
/etc/my.cnf文件,在[mysqld]下面添加如下内容
MySQL Server
MyISAM
838860
/etc/my.cnf文件,在[mysqld]下面添加如下内容
MySQL Server
QC
MySQL
SQL
SQL
’Qcache
Query Cache
cache blocksSQLQuery free_blocks SELECT Query Cache Query Cache
query_cache
query_cache_type
1024 byte
0
1
2
/etc/my.cnf,
MYSQL
=Qcache_free_blocks/Qcache_total_blocks * 100%20%=(query_cache_size – Qcache_free_memory)/query_cache_size * 100%25%=Qcache_hits/(Qcache_hits
Query Cache
/etc/my.cnf文件,在[mysqld]下面添加如下内容
MySQL Server
MYSQLhost
/etc/my.cnf文件,在[mysqld]下面添加如下内容
MySQL Server
mysql
mysql
cpu
CPU
MySQL
QC
SQL
’Qcache
Query Cache
cache blocksquery_cache
query_cache_type
1024 byte
0
1
2
/etc/my.cnf,
MYSQL
mysql
EXPLAIN
SQL
mysql>set profiling=1; null null