全文検索:
- 52 MySQLQ sysbench 1.0
- .0009s total number of events: 9203 Latency (ms): min: ... ds fairness: events (avg/stddev): 9203.0000/0.00 execution time (avg/stddev): 9.99... 0 sum: 4803.32 Threads fairness: events (avg/stddev): ... 6.0000/0.00 execution time (avg/stddev): 4.8033/0.00 </code> ==== Fileio ==== <code> sysbench f
- 03 InnoDBテーブル分割
- ====== 03 InnoDBテーブル分割 ====== InnoDB のデータファイルは,MyISAM テーブルと異なって,デフォルトでは ibdata1 というファイルにデータが蓄積されていくとこ
- 05 Percona Xtrabackup
- time mysql hogehoge < hogehoge.sql real 1007m47.036s user 29m17.664s sys 2m41.508s </code> === rsyn
- 09 Galera + innodb_flush_log_at_trx_commit
- | | 3883 | AAAA | +-------+------+ 17977 rows in set (0.03 sec) </code> {{tag>mysql innodb Galera}}
- 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 | +
- 50 MySQLベンチマーク(sysbench)
- sbtest charset=utf8; Query OK, 1 row affected (0.03 sec) mysql> GRANT ALL ON sbtest.* TO 'sbtest'@'lo