yangvipguang

1、统计top 10的buffer pool占用内存的表
select * from innodb_buffer_stats_by_table order by pages desc limit 10;

2、统计mysql物理文件的物理io写入字节数(可以定位出一个表的读写io占比和实际的平均写入量来判断占用io资源）
select * from io_global_by_file_by_bytes limit 10;

3、当前运行的所有事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX\G

4、表信息

yangvipguang

" Specify a directory for plugins
" - For Neovim: stdpath('data') . '/plugged'
" - Avoid using standard Vim directory names like 'plugin'
call plug#begin('~/.vim/plugged')

" Make sure you use single quotes

" Shorthand notation; fetches https://github.com/junegunn/vim-easy-align
Plug 'junegunn/vim-easy-align'

yangvipguang

" Specify a directory for plugins
" - For Neovim: stdpath('data') . '/plugged'
" - Avoid using standard Vim directory names like 'plugin'
call plug#begin('~/.vim/plugged')

" Make sure you use single quotes

" Shorthand notation; fetches https://github.com/junegunn/vim-easy-align
Plug 'junegunn/vim-easy-align'

yangvipguang

scriptencoding utf-8
" ============================================================================
" Author: yangguang
" Version: v1.1.0
" Update Time: 2020-01-01

" ============================================================================
" Vundle initialization
" Avoid modify this section, unless you are very sure of what you are doing

yangvipguang

server{
        listen 80;
        server_name example.com www.example.com;
        return 301 https://www.example.com$request_uri;
}
server {
        listen 443 ssl http2;
        server_name example.com www.example.com;

        root   /var/www/html/example.com/;

yangvipguang

//1、Dokcer 环境
//2、切换workspace
//3、分配node 节点执行任务


pipeline {
    //agent { 
   //     node{
   //     label 'node2'
   //     customWorkspace '/tmp'

yangvipguang

user nginx;
worker_processes 4;
worker_cpu_affinity 0001 0010 0100 1000;
error_log /etc/nginx/logs/error_nginx.log crit;
pid /run/nginx.pid;
worker_rlimit_nofile 51200;

events {
    use epoll;
    worker_connections 51200;

yangvipguang

ubuntu
apt-get install gcc automake autoconf libtool pkg-config gettext perl python flex bison gperf lcov doxygen  libgmp-dev  build-essential

yangvipguang

scriptencoding utf-8
" ============================================================================
" Author: TaoBeier
" Blog: http://moelove.info
" Version: v1.1.0
" Update Time: 2016-09-25

" ============================================================================
" Vundle initialization
" Avoid modify this section, unless you are very sure of what you are doing

yangvipguang

# 服务器型号
dmidecode | grep "Product" > server.temp.info
serverModelInfo="服务器型号:"
while read lineStr
do 
    temp=`echo ${lineStr##*:}` 
    serverModelInfo="${serverModelInfo}${temp} "
done < server.temp.info
# 操作系统
os=`cat /etc/centos-release`