全文検索:
- 52 MySQLQ sysbench 1.0 @01_linux:11_データベース:01_mysql
- 4797901.95 Threads fairness: events (avg/stddev): 60805.9375/188.35 execution time (avg/stddev): 299.8689/0.00 </code> ===== CPU/Memory/File... 9996.71 Threads fairness: events (avg/stddev): 9203.0000/0.00 execution time (avg/stddev): 9.9967/0.00 </code> ==== Memory ==== <code>
- 18 CentOS7 MariaDB @01_linux:11_データベース:01_mysql
- f ProtectHome=true ↓↓↓ ProtectHome=false PrivateDevices=false ↓↓↓ PrivateDevices=true </code> <code> sed -i 's/^ProtectSystem=full/ProtectSystem=off/g' /... /systemd/system/mariadb.service sed -i 's/^PrivateDevices=false/PrivateDevices=true/g' /usr/lib/systemd/system/mariadb.service grep '^PrivateDevices\|^Prote
- 50 MySQLベンチマーク(sysbench) @01_linux:11_データベース:01_mysql
- 6.24ms Threads fairness: events (avg/stddev): 11273.0000/0.00 execution time (avg/stddev): 59.8877/0.00 </code> ==== sysbench Option =
- 08 MySQLシステム変数 @01_linux:11_データベース:01_mysql
- ====== 08 MySQLシステム変数 ====== [[https://dev.mysql.com/doc/refman/5.6/ja/innodb-parameters.html]] {{tag
- 19 MySQL ログローテート @01_linux:11_データベース:01_mysql
- usr/bin/mysqladmin && /usr/bin/mysqladmin ping &>/dev/null then /usr/bin/mysqladmin --default
- 01 PostgreSQL streaming replica @01_linux:11_データベース:02_postgresql
- yum -y install postgresql13-contrib postgresql13-devel ===== 自動起動 defautl: disabled ===== systemct