全文検索:
- 52 MySQLQ sysbench 1.0
- 1897 other: 2025506 total: 1945811... eads... Threads started! Total operations: 47201506 (4719062.27 per second) 46095.22 MiB transferre... 01s total number of events: 47201506 Latency (ms): min: ... fairness: events (avg/stddev): 47201506.0000/0.00 execution time (avg/stddev): 4.8
- 51 MySQLベンチマーク(mysqlslap)
- います。 5.1.4より下のバージョンは[[01_linux:11_データベース:01_mysql:50_sysbench|sysbench]]でベンチマークする。 ===== 実行 ===== 20... ueries: 20 Average number of queries per client: 50 </code> ===== mysqlslap オプション ===== <code> # mys... nSSL docs, implies --ssl). --ssl-cert=name X509 cert in PEM format (implies --ssl). --ssl-ciph... er to use (implies --ssl). --ssl-key=name X509 key in PEM format (implies --ssl). --ssl-verif
- 05 Percona Xtrabackup
- .sql real 1007m47.036s user 29m17.664s sys 2m41.508s </code> === rsync === <code console> # time rs... 0m10.285s # time rm -rvf /var/lib/mysql/* real 1m50.781s user 0m0.011s sys 0m4.002s # time innoback... 'datadir') called at /usr/bin/innobackupex line 2450 main::copy_back(0) called at /usr/bin/innobackup
- 02 MySQL max_connections
- | | max_connections | 500 | | max_delayed_threads ... ===== 対応 (max_connectionsを増やす) ===== <code console> mysql> set global max_connections=450; </code>
- 09 Galera + innodb_flush_log_at_trx_commit
- ueries: 20 Average number of queries per client: 50 </code> === innodb_flush_log_at_trx_commit=2 ===... ueries: 20 Average number of queries per client: 50 </code> ===== 2.障害試験 ===== [[http://planet.mysq
- 50 MySQLベンチマーク(sysbench)
- ====== 50 MySQLベンチマーク(sysbench) ====== [[01_linux:11_データベース:01_mysql:51_mysqlslap|mysqlslap]]はMySQL 5... -db=STRING PostgreSQL database name [sbtest] </code> [[https://blog.apar.jp/linux/3350/|参考サイト]]
- 13 mysql56 + galera3
- _received_bytes=6637093 #wsrep_repl_data_bytes=265035226 #wsrep_incoming_address="" wsrep_provider=
- 14 MariaDB
- -------+----------+ | innodb_log_file_size | 50331648 | | innodb_log_files_in_group | 2 |
- 15 InnoDB テーブルロック
- -----------+-------+ | innodb_lock_wait_timeout | 50 | +--------------------------+-------+ 1 row i