全文検索:
- 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.
- 16 Kubernetes + DRBD Linstor @06_virtualization:05_container
- 環境 ====== 今回はKubernetesのworkerノード3台で、Linstor ^ name ^ IP ^ Disk ^ DRBD用 ^ |node1|172.16.0.65|/dev/sda... | StoragePool | Node | Driver | PoolName | FreeCapacity | TotalCapacity | CanSnapshots | State | SharedName | |============================================... esource | StoragePool | VolNr | MinorNr | DeviceName | Allocated | InUse | State | |=========
- 2021.08.03 KVM IOPS limit @50_dialy:2021:08
- <disk type='block' device='disk'> <driver name='qemu' type='raw' cache='none' io='native'/> ... <target dev='vda' bus='virtio'/> <alias name='virtio-disk0'/> <address type='pci' domain... t body='<VM><ID>300</ID><UID>0</UID><GID>0</GID><UNAME>oneadmin</UNAME><GNAME>oneadmin</GNAME><NAME>matsuitest</NAME><PERMISSIONS><OWNER_U>1</OWNER_U><OWNER_M
- MySQLコマンド @02_freebsd:04_database:01_mysql
- INSERT ON *.* TO user; データベースレベル GRANT ALL ON db_name.* TO user; GRANT SELECT, INSERT ON mydb.* TO user... '; </code> ==== ユーザ名＆ホストの変更 ==== <code> mysql> RENAME USER 'FROM_USER'@'192.168.0.%' TO 'TO_USER'@'192.... BLE hoge_tbl ( id int PRIMARY KEY AUTO_INCREMENT, name text ); </code> ==== テーブルのコピー ==== <code console... code> ==== テーブル名変更 ==== <code> ALTER TABLE tbl_name RENAME [TO] new_tbl_name; </code> ==== テーブル情報を表示(
- 20 Kubernetes GlusterFS Galera Wordpress @06_virtualization:05_container
- apiVersion: v1 kind: PersistentVolume metadata: name: wordpress-pv labels: name: wordpress-pv spec: accessModes: - ReadWriteMany capacity: s... labels: io.kompose.service: wordpress-pvc name: wordpress-pvc spec: accessModes: - ReadWrite... storage: 1Gi selector: matchLabels: name: wordpress-pv status: {} </code> === 作成 ===
- 2023.12.14 React-adminとDjangoの連携 @50_dialy:2023:12
- b import models class Product(models.Model): name = models.CharField(max_length=200) price = mo... ield() def __str__(self): return self.name </code> === マイグレーションファイル作成 === $ docker-comp... s = [ migrations.CreateModel( name='Product', fields=[ (... =True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField
- fio @01_linux:09_ベンチマーク
- ンチマーク ===== ==== シーケンシャルwrite ==== # fio -filename=/tmp/fio2g -direct=1 -rw=write -bs=4k -size=2G -numjobs=64 -runtime=10 -group_reporting -name=fio ==== ランダムwrite ==== # fio -filename=/tmp/fio2g -direct=1 -rw=randwrite -bs=4k -size=2G -numjobs=64 -runtime=10 -group_reporting -name=fio ==== シーケンシャルread ==== # fio -filename=/tm
- 18 Kubernetes GlusterFS @06_virtualization:05_container
- ====== 18 Kubernetes GlusterFS ====== ^ hostname ^ IP ^ |g-master|172.16.0.103| |g-work01|172.16.0.93| ... .yaml> apiVersion: v1 kind: Endpoints metadata: name: glusterfs labels: storage.k8s.io/name: glusterfs storage.k8s.io/part-of: kubernetes-complete... - addresses: - ip: 172.16.0.93 hostname: g-work01 - ip: 172.16.0.153 hostna
- PostgreSQLコマンド @02_freebsd:04_database:02_posgresql
- QLユーザは、データベースの作成が許可されます。 | |-U|[接続ユーザ名]| |(--username)|PostgreSQLに接続するユーザ名を指定します。| |~|上記コマンドではpostgres(... ==== postgres=# select * from pg_shadow ; usename | usesysid | usecreatedb | usesuper | usecatupd ... er)|[オーナ名]|作成するデータベースの所有者となるユーザを指定します。| |-U(--username)|[接続ユーザ名]|PostgreSQLに接続するユーザ名を指定します。| ===== Post... スタム、tがtar、pがテキスト) -例(バックアップ) pg_dump database_name > database_name.sql -例(リストア) createdb にてdatab
- color plugin @dokuwiki:plugin
- efined('DOKU_INC')) define('DOKU_INC',realpath(dirname(__FILE__).'/../../').'/'); if(!defined('DOKU_PL... 'date' => '2009-06-24', 'name' => 'Color Plugin with ODT', 'des... ])) { $stylename = "ColorizedText".count($this->odt_styles); ... $this->odt_styles[$style_index] = $stylename; $color = $color?'fo:color="'
- 41 CentOS7 NIC名変更 @01_linux:01_net
- それをethに変更してみます。 ===== grub変更 ===== grubに「biosdevname=0 net.ifnames=0」を追加 <code> # cp -p /etc/default/g... ntos/root rd.lvm.lv=centos/swap rhgb quiet biosdevname=0 net.ifnames=0" GRUB_DISABLE_RECOVERY="true" </c... 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{addre
- 04 Postfix+MySQL+Postfix AdminでバーチャルSMTPサーバの構築 @01_linux:03_mail
- = <code> # vi /etc/postfix/main.cf 70 myhostname = test.flateight.com 92 myorigin = $myhostname 107 #inet_interfaces = all 109 inet_interfaces = $myhostname, localhost 155 #mydestination = $myhostname, localhost.$mydomain, localhost 158 mydestination =
- 05 FormServiceProvider @11_php:02_framework
- unction() use($app) { $data = array( 'name' => 'Your name', 'email' => 'Your email', ); $form = $app['form.factory']->createBuilder('form', $data) ->add('name') ->add('email') ->add('gender', ... {{ form_widget(form) }} <input type="submit" name="submit" /> </form> </body> </html> </code> ====
- 02 グラフ表示(Highcharts.js) @14_web
- 当ドメインをクリックでグラフ表示 155 $('#domain .domainname').click(function(){ 156 var gr... }); </code> ==== jsonデータ ==== <code> [ {"name":"running","tooltip":{"valueSuffix":"\u53f0"}, "d... 0,59],[1553355604000,59],[1553442005000,59]] },{ "name":"stopped","tooltip":{"valueSuffix":"\u53f0"}, "d... 5000,4],[1553355604000,4],[1553442005000,4]] },{ "name":"cpu","tooltip":{"valueSuffix":"\u500b"}, "data"
- 01 PostgreSQL streaming replica @01_linux:11_データベース:02_postgresql
- で高可用性と読取に対するスケールアウトを実現するストリーミングレプリケーションを作成 ^hostname^IP^ |pg1001|172.16.0.51| |pg1002|172.16.0.52| |pg... 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.
