aptitude search ping
use information_schema;查询所有数据的大小:select concat(round(sum(data_length/1024/1024),2),'MB') as data from tables;查看指定数据库的大小:select concat(round(sum(data_length/1024/1024),2),'MB') as data from tables wher
show count(1) from TABLENAME;
cd /etc/apache2/site-enable/rep -rl 'test.com' ./*意为查询apache虚拟主机中是否包含test.com的域名
mysql> select * from information_schema.processlist as p where p.command = 'Binlog Dump'; 或mysql> show slave hosts;(此方法需要在从服务启动时指定--report-host=HOSTNAME选项,此处HOSTNAME为任意名称。)
Copyright © 2005-2025 51CTO.COM 版权所有 京ICP证060544号