服务器server

服务器 server ✅

# from import_export.admin import DEFAULT_FORMATS, SKIP_ADMIN_LOG, TMP_STORAGE_CLASS

from import_export.admin import DEFAULT_FORMATS,ImportMixin

npm config set registry http://172.28.149.223/repository/aliyunnpm/

sudo npm install -g vue-cli

sudo npm install -g vue

ssh root@172.28.137.66

密码：pega#1234

/data/uwsgi_ini/Ats_Web_Vue

mysql -u root -p

Root

show databases;

use ats_web_vue;

show tables;

desc OverlayList_overlaytimeline;

ALTER TABLE OverlayList_overlaytimeline  DROP nowDatetime;

delete from UserInfo_user_projects where project_id='';

alter table OverlayList_overlay add columndelayTime char(20) default ‘0’ AFTER `aid`； #(在哪个字段后面添加)  

alter table OverlayList_overlaytimeline add addTime create_time AFTER ‘id’ ;

delete from OverlayList_overlaytimeline

ALTER TABLE ShareNotes_sharecomments CONVERT TO CHARACTER SET utf8mb4;

ShareNotes_sharecomments

数据库内存大小

SELECT sum(DATA_LENGTH)+sum(INDEX_LENGTH) FROM information_schema.TABLES where TABLE_SCHEMA='数据库名';

得到的结果是以字节为单位，除1024为K，除1048576为M。

39.8125M

46.7176M

服务器文件内存大小

root@psh-ats-02:~# df -h

Filesystem      Size  Used Avail Use% Mounted on

udev            5.9G     0  5.9G   0% /dev

tmpfs           1.2G  125M  1.1G  11% /run

/dev/sda4        19G   15G  3.0G  84% /

tmpfs           5.9G  8.0K  5.9G   1% /dev/shm

tmpfs           5.0M     0  5.0M   0% /run/lock

tmpfs           5.9G     0  5.9G   0% /sys/fs/cgroup

/dev/sda2       361M  118M  221M  35% /boot

/dev/sda1       511M  3.5M  508M   1% /boot/efi

/dev/sda5       208G   70G  128G  36% /data

tmpfs           1.2G     0  1.2G   0% /run/user/0

root@psh-ats-02:~# cd ../data

root@psh-ats-02:/data# du -d 1 -h

16K ./lost+found

62M ./backup

28G ./software

65M ./cronjobs_log

154M ./scm-server

338M ./Python3-env

981M ./mysqldb

33G ./scm_repositories

2.9G ./ats

343M ./uwsgi_ini

4.2G ./django

135M ./vue-node

70G .

root@psh-ats-02:/data# 

/data/django/Ats_Web_Vue_Test/static/img/detail/20220113/279b5fddac624d1b8184c4d5996e4a75.jpeg

scp -r /Users/mac/Downloads/ root@172.28.137.66:/root/data/django/Ats_Web_Vue_Test/static/img/detail/20220113/279b5fddac624d1b8184c4d5996e4a75.jpeg

scp -r /Users/mac/Downloads/node-v14.17.0/include root@172.28.137.66:/root/.node-gyp/14.17.0/

scp -r /Users/mac/Downloads/ root@172.28.137.66:/data/django/Ats_Web_Vue_Test/static/img/detail/20220113/

scp -r root@172.28.137.66:/data/django/Ats_Web_Vue_Test/static/img/detail/20220113/279b5fddac624d1b8184c4d5996e4a75.jpeg /Users/mac/Desktop/