インデックス作成と更新

DB

Oracle (12R1) --データ準備set time onset timing on drop table tab1 purge;create table tab1(col1 int,col2 int,col3 int);alter table tab1 add constraint tab1p primary key (col1); declare beginfor i in 1..1000000 loop insert into tab1 values(…

2019-09-22

統計情報移行中の更新

DB

Oracle (12R1) --データ準備 drop table tab1 purge;create table tab1(col1 int,col2 int); declare beginfor i in 1..10000 loop insert into tab1 values(i,i); commit;end loop;end;/ exec dbms_stats.gather_table_stats('TEST','TAB1'); select * from…

2019-09-05

PostgreSQL

OS

Ubuntu (16)apt updateapt -y install postgresql (18) apt updateapt -y install postgresql Debian (9)apt updateapt -y install postgresql CentOS (7) --yum リポジトリの追加yum install -y https://download.postgresql.org/pub/repos/yum/9.4/redhat/…

2019-09-05

サービス起動

OS

Ubuntu (16)systemctl list-unit-files systemctl status postgresqlsystemctl enable postgresqlsystemctl stop postgresqlsystemctl start postgresql (18)systemctl list-unit-files systemctl status postgresqlsystemctl enable postgresqlsystemctl st…

2019-09-04

デフォルトエディタの変更

OS

Ubuntu https://linuxfan.info/set-default-editor-ubuntu-debian (16)apt -y install vimapt -y install nano update-alternatives --list editorupdate-alternatives --config editor (18) apt -y install vimapt -y install nano update-alternatives --l…

2019-09-03

パスワードなしsudo

OS

Ubuntu (16)visudo test ALL=(ALL) NOPASSWD: ALL (18)visudo test ALL=(ALL) NOPASSWD: ALL Debian (9) apt -y install sudo visudo test ALL=(ALL) NOPASSWD: ALL CentOS (7) visudo test ALL=(ALL) NOPASSWD: ALL Windows Server (2012R2) https://hrkwor…

2019-09-03

ユーザ追加

OS

Ubuntu (16) cat /etc/passwduseradd -d /home/test -s /bin/bash testpasswd testmkdir /home/test (18)cat /etc/passwduseradd -d /home/test -s /bin/bash testpasswd testmkdir /home/test Debian (9)cat /etc/passwduseradd -d /home/test -s /bin/bash…

2019-09-01

輻輳制御アルゴリズム

OS

Ubuntu (16)sysctl net.ipv4.tcp_congestion_control net.ipv4.tcp_congestion_control = cubic (18)sysctl net.ipv4.tcp_congestion_control net.ipv4.tcp_congestion_control = cubic Debian (9)sysctl net.ipv4.tcp_congestion_control net.ipv4.tcp_cong…