全文検索:
- 10 InnoDBパフォーマンス @01_linux:11_データベース:01_mysql
- _pool_sizeは、DBのみ動作の場合物理メモリの70%~80%程度 innodb_log_files_in_group×innodb_log_file_size < innodb_buffer_pool_size innodb_data_file_path = ibdata1:1G innodb_log_file_size=256M innodb_log_files_in_group=20 下記のようにib_lobfileを分割して保存する
- 52 MySQLQ sysbench 1.0 @01_linux:11_データベース:01_mysql
- ddev): 299.8689/0.00 </code> ===== CPU/Memory/Fileio ===== ==== CPU ==== <code> # sysbench cpu run ... on time (avg/stddev): 4.8033/0.00 </code> ==== Fileio ==== <code> sysbench fileio --file-total-size=1G --file-test-mode=rndrw --time=300 --max-requests=0 prepare sysbench fileio --fil
- 32 CentOS5でTLS1.2 Apache PHP @01_linux:02_www
- ode> xml/apr_xml.c:35:19: error: expat.h: No such file or directory xml/apr_xml.c:66: error: expected sp... enable-setenvif \ --enable-authn-alias \ --enable-file-cache \ --enable-disk-cache \ --enable-mem-cache ... 60,62c60,62 < httpd=${HTTPD-/usr/sbin/httpd} < pidfile=${PIDFILE-/var/log/httpd/${prog}.pid} < lockfile=${LOCKFILE-/var/lock/subsys/${prog}} --- > httpd=${HTT
- 51 MySQLベンチマーク(mysqlslap) @01_linux:11_データベース:01_mysql
- ONS] Default options are read from the following files in the given order: /etc/my.cnf /etc/mysql/my.cn... Don't read default options from any option file. --defaults-file=# Only read default options from the given file #. --defaults-extra-file=# Read this file after t
- 91 ZabbixのMySQLが遅い @01_linux:04_監視:zabbix
- ==== テーブル分割して、innodb_buffer_pool_sizeとinnodb_log_file_sizeを増やしてみる <code console> # vi /etc/my.cnf innodb_file_per_table innodb_buffer_pool_size=512M innodb_log_file_size=128M </code> innodb_buffer_pool_sizeは、DBのみ動作の場合物理メモリの70%~80%程度 innodb_log_files_in_group×innodb_log_file_size < innodb_buffer_po
- 13 CentOS6メール設定 @01_linux:03_mail
- ----------------- (76行目に追加) Patch0: postfix-2.6.1-files.patch Patch1: postfix-alternatives.patch Patch2:... x-vda-v11-2.9.5.patch (152行目に追加) %patch0 -p1 -b .files %patch1 -p1 -b .alternatives %patch2 -p1 -b .lar... stname ## 証明書 smtpd_use_tls = yes smtpd_tls_cert_file = /etc/pki/tls/certs/mail.pem smtpd_tls_key_file = /etc/pki/tls/certs/mail.pem smtpd_tls_session_cache_
- 22 Ceph create-volume でエラー @01_linux:13_storage
- /ceph/keyring,/etc/ceph/keyring.bin,: (2) No such file or directory 2020-09-02 18:30:09.744 7f8fd77c0700... map /var/lib/ceph/osd/ceph-0/activate.monmap --keyfile - --bluestore-block-wal-path /dev/optane/waldb --... /ceph/keyring,/etc/ceph/keyring.bin,: (2) No such file or directory 2020-09-02 18:30:10.730 7f4ea281a700... map /var/lib/ceph/osd/ceph-0/activate.monmap --keyfile - --bluestore-block-wal-path /dev/optane/waldb --
- 16 unboundでキャッシュサーバ @01_linux:01_net
- username: "unbound" directory: "/etc/unbound" logfile: "/var/log/unbound.log" use-syslog: no log-queries: no log-time-ascii: yes pidfile: "/var/run/unbound/unbound.pid" root-hints: "/etc... roundrobin: yes minimal-responses: yes dlv-anchor-file: "/etc/unbound/dlv.isc.org.key" trusted-keys-file: /etc/unbound/root.key val-clean-additional: yes val-
- 83 PHP複数バージョンを共存 @01_linux:02_www
- げるだけです。 <color red> ※注意 \\ .htaccessで設定する場合に、ちゃんとFilesMatchでphpファイルを指定しないと、\\ 全てのファイルに対して、suphpでアクセスする事... ode> ==== php7.1が利用したい場合 ==== <code|.htaccess> <FilesMatch "\.php$"> SetHandler x-httpd-php71 </FilesMatch> </code> ==== php5.6が利用したい場合 ==== <code|.htaccess> <FilesMatch "\.php$"> SetHandler x-httpd-php56 </Fi
- 08 qcow2 バックアップ 外部へ取得する場合(online external) @01_linux:08_仮想化:kvm
- ode> # virsh dumpxml testvm . . . <disk type='file' device='disk'> <driver name='qemu' type='qcow2'/> <source file='/var/lib/libvirt/images/testvm.testsnap' index='3'/> <backingStore type='file' index='2'> <format type='qcow2'/> <source file='/var/lib/libvirt/images/testvm.qcow2'/>
- BINDでキャッシュサーバ @01_linux:01_net
- doc/bind*/sample/ for example named configuration files. // // DO NOT EDIT THIS FILE - use system-config-bind or an editor // to create named.conf - edits to this file will be lost on // caching-nameserver package ... directory "/var/named"; dump-file "/var/named/data/cache_dump.db";
- 82 CentOS 5.8 + Apache 2.2 + PHP 5.3 + suPHP 0.7.1 @01_linux:02_www
- /usr/local/etc/suphp.conf === <code> [global] logfile=/var/log/httpd/suphp_log loglevel=info webserver_... min_uid=500 min_gid=100 ; Security options allow_file_group_writeable=false allow_file_others_writeable=false allow_directory_group_writeable=false allow_dir... <code> # This is the Apache server configuration file providing suPHP support. # It contains the config
- KVMでWindowsを動かし、virtio化 @01_linux:08_仮想化
- oドライバ]]も一緒に定義しておく <code console> <disk type='file' device='disk'> <driver name='qemu' type='qcow2'/> <source file='/tmp/test.img'/> <target dev='vdb' bus='virtio'/> </disk> <disk type='file' device='cdrom'> <driver name='qemu'/> <source file='/CDROM/virtio-win-0.1-30.iso'/> <target de
- 14 MariaDB @01_linux:11_データベース:01_mysql
- iaDB [(none)]> show global variables like 'innodb_file_per_table'; +-----------------------+-------+ | V... alue | +-----------------------+-------+ | innodb_file_per_table | ON | +-----------------------+----... [(none)]> show global variables like 'innodb_log_file_%'; +---------------------------+----------+ | Va... ------------------------+----------+ | innodb_log_file_size | 50331648 | | innodb_log_files_in_grou
- 02 Postfix + amavisd + clamav @01_linux:03_mail
- qr'^\.(exe-ms|dll)$', # banned file(1) types, rudimentary ↓ コメントアウト。exe,dllも送信できる... qr'^\.(exe-ms|dll)$', # banned file(1) types, rudimentary </code> === 添付ファイルがはじかれるので、この部分をコメントアウト === <code> $banned_filename_re = new_RE( ### BLOCKED ANYWHERE # qr'^UNDE... qr'^\.(exe-ms|dll)$', # banned file(1) types, rudimentary # qr'^\.(exe|lha|tnef|cab|d