cd / mkdir data docker run -d -p 9000:9000 -v /var/run/docker.sock:/var/run/docker.sock -v /data:/data --restart=always --name portainer 6053537/portainer-ce:latest
分类: 码农
mysql 查看某数据库中所有表的行数
模糊计数
select table_name,table_rows from information_schema.tables where TABLE_SCHEMA = '<datebase_name>' order by table_rows desc;
精确计数
1.执行以下语句select concat( 'select "', table_name, '", count(*) from ', TABLE_SCHEMA, '.', table_name, ' union all' ) from information_schema.tables where TABLE_SCHEMA='<datebase_name>';2.复制第1步语句的查询结果,粘贴之后将最后一个
union all
替换为;
select "<table1_name>", count(*) from <datebase_name>.<table1_name> union all select "<table2_name>", count(*) from <datebase_name>.<table2_name> union all ... select "<tablen_name>", count(*) from <datebase_name>.<tablen_name>;3. 复制第2步语句的查询结果,然后运行,查询结果如下:
+-------------+-------------+ | <table1_name> | count(*) | +-------------+-------------+ | <table1_name> | <table1_rows> | | <table2_name> | <table2_rows> | | ... | ... | | <tablen_name> | <tablen_rows> | +--------------------------+----------+* 拓展:直接统计总数
select sum(sum1) from ( select count(*) as sum1 from <datebase_name>.<table1_name> union all select count(*) as sum1 from <datebase_name>.<table2_name> union all ... select count(*) as sum1 from <datebase_name>.<tablen_name>) as total;查询结果如下:
+--------------------------+ | sum(sum1) | +--------------------------+ |<total_rows>| +--------------------------+
Visual Studio Code Server 设置登录界面为中文
© Sunplace,2023
1. 修改<vscode-server-dir>/out/node/i18n/index.js
(0, i18next_1.init)({ lng: "zh-cn", fallbackLng: "zh-cn",2. 修改<vscode-server-dir>/out/node/routes/login.js
const locale = req.args["locale"] || "zh-cn";3. 重启vscode(需事先安装配置supervisor)
supervisorctl restart vscode
Visual Studio Code Server 进程守护
[MD]
© Sunplace,2023
目录
1. 准备工作
1.1. 安装VS Code Server
网上千篇一律,不再赘述
参考链接:https://juejin.cn/post/6966772881552310303
1.2. 安装supervisor
2. 配置文件
在/etc/supervisord.conf末尾加上
[program:vscode]
command=/bin/sh code-server
directory=<vscode-server-dir>/bin
environment=ASPNETCORE_ENVIRONMENT=Production
stopsignal=INT
autostart=true
autorestart=true
startsecs=1
stderr_logfile=/var/log/vscode.err.log
stdout_logfile=/var/log/vscode.out.log
3. 重新加载supervisor
supervisorctl update
supervisorctl reload
supervisorctl start vscode
4. 启动VS Code Server
cd /usr/vscode/bin
./code-server
vsftpd搭建中的关键配置
本文最后更新于(2023-4-4 19:38:30),链接可能失效,内容可能难以复现。请注意甄别。
mkdir -p /var/www useradd -d /var/www/ftp -s /sbin/nologin <ftpuser> chmod -R 755 /var/www/ftp passwd <ftpuser> echo "/sbin/nologin" >> /etc/shells/etc/vsftpd/vsftpd.conf
anonymous_enable=NO local_enable=YES local_root=<website_root_dir> write_enable=YES local_umask=022 dirmessage_enable=YES xferlog_enable=YES chroot_local_user=YES chroot_list_enable=YES chroot_list_file=/etc/vsftpd/chroot_list listen_ipv6=YES pam_service_name=vsftpd userlist_enable=NO userlist_deny=NO tcp_wrappers=YES # userlist_file=/etc/vsftpd/user_list pasv_enable=Yes pasv_max_port=20000 pasv_min_port=21000