全文検索:
- 51 MySQLベンチマーク(mysqlslap) @01_linux:11_データベース:01_mysql
- generated tables. --auto-generate-sql-load-type=name Specify test load type: mi... on in server/client protocol. -c, --concurrency=name Number of clients to simulate for query to run. --create=name File or string to use create tables. --create-schema=name Schema to run tests in.
- 41 CentOS7 NIC名変更 @01_linux:01_net
- ACTION=="add",ATTR{address}=="xx:xx:xx:xx:xx:xx",NAME="eth0" SUBSYSTEM=="net", ACTION=="add",ATTR{address}=="xx:xx:xx:xx:xx:xx",NAME="eth1" SUBSYSTEM=="net", ACTION=="add",ATTR{address}=="xx:xx:xx:xx:xx:xx",NAME="eth2" SUBSYSTEM=="net", ACTION=="add",ATTR{address}=="xx:xx:xx:xx:xx:xx",NAME="eth3" </code> ==== 対応 ==== ethX以外の名前付けて、PCIパス指定
- 01 PostgreSQL streaming replica @01_linux:11_データベース:02_postgresql
- List of databases Name | Owner | Encoding | Collate | Ctype | Ac... esql.auto.conf primary_conninfo = へ追加 application_name=postgresql ## Secondaryは下記をコメントアウト # grep synchr... 51 -U postgres testdb -c "UPDATE actor set first_name='BBB' where actor_id=1" UPDATE 1 $ psql -h 172.... * FROM actor where actor_id=1" actor_id | first_name | last_name | last_update -------
- fio @01_linux:09_ベンチマーク
- size=2G -numjobs=64 -runtime=10 -group_reporting -name=fio ==== ランダムwrite ==== # fio -filename=/tmp/... size=2G -numjobs=64 -runtime=10 -group_reporting -name=fio ==== シーケンシャルread ==== # fio -filename=/tm... size=2G -numjobs=64 -runtime=10 -group_reporting -name=fio ==== ランダムwrite ==== # fio -filename=/tmp/... size=2G -numjobs=64 -runtime=10 -group_reporting -name=fio ==== 結果 ==== 下記はシーケンシャルwriteの一例 ブロックサイズ4k
- 19 HPE Insight Management Agents Trap Alarm @01_linux:12_ツール
- ead/Write Authorized Management Station IP or DNS name (Blank to skip): Enter Read Only Authorized Management Station IP or DNS name (Blank to skip): Enter default SNMP trap communi... to skip): Enter SNMP trap destination IP or DNS name (One word; Blank to skip): The system contact is... -c -f <(echo -e "${EXCLUDE}")) -le 0 ] ;then NAME=${HOST}${HOSTNAME} if [ "${TO}" = "ZABBIX" ]
- 29 Ceph Dashboard @01_linux:13_storage
- {"username": "admin", "lastUpdate": 1592953680, "name": null, "roles": ["administrator"], "password": "... metheus: image: prom/prometheus container_name: prometheus environment: TZ: Asia/Tokyo... a: image: grafana/grafana:7.3.0 container_name: grafana environment: - TZ=Asia/Tokyo ... rter: image: prom/node-exporter container_name: node-exporter ports: - 9100:9100 r
- 29 screenに外からコマンド @01_linux:99_その他
- $THREAD ] do N=`printf "%02d" "${i}"` SCREEN_NAME=${ZONE}-${N} LOG="${LOGDIR}/${ZONE}_${N}.log" ... pr $i + 1` if [ -n "`screen -ls | grep ${SCREEN_NAME}`" ]; then echo "already have session_name. ${SCREEN_NAME}" continue 2 fi screen -R ${SCREEN_NAME} sleep 1 screen -d ${SCREEN_NAME}
- 22 Ceph create-volume でエラー @01_linux:13_storage
- y Running command: /usr/bin/ceph --cluster ceph --name client.bootstrap-osd --keyring /var/lib/ceph/boot... k Running command: /usr/bin/ceph --cluster ceph --name client.bootstrap-osd --keyring /var/lib/ceph/boot... ar/lib/ceph/osd/ceph-0/keyring --create-keyring --name osd.0 --add-key AQAgZk9fqxUgKRAA8gJEbwtnuVb91YJHV... borted) ** stderr: in thread 7f600913da80 thread_name:ceph-osd stderr: 2020-09-02 18:30:10.567 7f60091
- 14 MariaDB @01_linux:11_データベース:01_mysql
- '; +------------------------+--------+ | Variable_name | Value | +------------------------+---... le'; +-----------------------+-------+ | Variable_name | Value | +-----------------------+------... --------------------------+----------+ | Variable_name | Value | +-----------------------... -------------------------+-----------+ | Variable_name | Value | +------------------------
- 60 CentOS OpenVPN @01_linux:01_net
- rt KEY_CN=changeme ← 行頭に#を追加してコメントアウト #export KEY_NAME=changeme ← 行頭に#を追加してコメントアウト #export KEY_OU=change... IENT LIST Updated,Mon Mar 10 16:16:53 2014 Common Name,Real Address,Bytes Received,Bytes Sent,Connected ... 4:03:54 2014 ROUTING TABLE Virtual Address,Common Name,Real Address,Last Ref 10.8.0.6,client1,210.172.14... 0 END kill client1 ← client1強制切断 SUCCESS: common name 'client1' found, 1 client(s) killed status ← VPN
- 古いyumを利用したい @01_linux:01_net
- tOS-Base.repo @@ -13,8 +13,9 @@ [base] name=CentOS-$releasever - Base -mirrorlist=http://mi... 23,8 +24,9 @@ #released updates [update] name=CentOS-$releasever - Updates -mirrorlist=http:/... uced in the build but not released [addons] name=CentOS-$releasever - Addons -mirrorlist=http://... tional packages that may be useful [extras] name=CentOS-$releasever - Extras -mirrorlist=http://
- 古いyumを利用したい @01_linux:01_net
- tOS-Base.repo @@ -13,8 +13,9 @@ [base] name=CentOS-$releasever - Base -mirrorlist=http://mi... 23,8 +24,9 @@ #released updates [update] name=CentOS-$releasever - Updates -mirrorlist=http:/... uced in the build but not released [addons] name=CentOS-$releasever - Addons -mirrorlist=http://... tional packages that may be useful [extras] name=CentOS-$releasever - Extras -mirrorlist=http://
- 01 Galera構築 @01_linux:11_データベース:01_mysql
- tions #wsrep_provider_options= # Logical cluster name. Should be the same for all nodes. wsrep_cluster_name="onapp_db_cluster" # Group communication system ... er_address="gcomm://:4567" # Human-readable node name (non-unique). Hostname by default. #wsrep_node_name= # Base replication <address|hostname>[:port] of t
- 15 InnoDB テーブルロック @01_linux:11_データベース:01_mysql
- ct * from lock_test; +----+--------+-----+ | id | name | age | +----+--------+-----+ | 1 | tanaka | ... k_test ( id int primary key auto_increment, name varchar(32) not null, age int not null ) engin... DB default charset=utf8; insert into lock_test (name, age) values ('tanaka', 20), ('suzuki', 30), (... sec) mysql> UPDATE lock_test SET age = 21 WHERE name = 'tanaka'; Query OK, 1 row affected (0.00 sec) R
- 50 MySQLベンチマーク(sysbench) @01_linux:11_データベース:01_mysql
- {simple,complex,nontrx,sp} [complex] --oltp-sp-name=STRING name of store procedure to call in SP test mode [] --oltp-read-only=[on|off] g... ds to sleep after each request [0] --oltp-table-name=STRING name of test table [sbtest] --oltp-table-size=N number of records in test t
