Fulltext results:

50 MySQLベンチマーク(sysbench)

6 Hits, Last modified: 4 years ago

test=oltp \ --db-driver=mysql \ --oltp-table-size=10000 \ --mysql-password=kumolabo \ prepare </code> ... test=oltp \ --db-driver=mysql \ --oltp-table-size=10000 \ --mysql-password=kumolabo \ --num-threads=1 \... -size=N range size for range queries [100] --oltp-point-selects=N number of poin... croseconds to sleep after connection to database [10000] --oltp-user-delay-min=N minimum time

51 MySQLベンチマーク(mysqlslap)

5 Hits, Last modified: 10 years ago

ench|sysbench]]でベンチマークする。 ===== 実行 ===== 20スレッド 1000行データ 1000クエリ update(更新) <code> # mysqlslap --no-defaults \ --concurrency=20 \ --iteration=1 \ --engin... ad-type=update \ --auto-generate-sql-write-number=1000 \ --number-of-queries=1000 \ --user=root -p Enter password: innodb_flush_log_at_trx_commit=1 Benchm

09 Galera + innodb_flush_log_at_trx_commit

4 Hits, Last modified: 10 years ago

load-type=update --auto-generate-sql-write-number=1000 --number-of-queries=1000 --user=root -p Enter password: Benchmark Running for engine innodb Avera... load-type=update --auto-generate-sql-write-number=1000 --number-of-queries=1000 --user=root -p Enter password: Benchmark Running for engine innodb Avera

05 Percona Xtrabackup

3 Hits, Last modified: 6 years ago

sole> # time mysql hogehoge < hogehoge.sql real 1007m47.036s user 29m17.664s sys 2m41.508s </code> =... _xtrabackup-v2 --role 'joiner' --address '192.168.100.64' --auth 'root:mcaxP3bq' --datadir '/var/lib/my... srep_sst_xtrabackup --role 'joiner' --address '10.100.0.43' --aut h 'root:gmocl-mysql' --datadir '/var/

52 MySQLQ sysbench 1.0

3 Hits, Last modified: 4 years ago

ad_write.lua \ --db-driver=mysql \ --table-size=1000000 \ --mysql-host=localhost \ --mysql-user=roo... ad_write.lua \ --db-driver=mysql \ --table-size=100000 \ --mysql-host=localhost \ --mysql-user=root... enerator from current time Prime numbers limit: 10000 Initializing worker threads... Threads starte

01 Galera構築

2 Hits, Last modified: 8 years ago

SET GLOBAL wsrep_cluster_address='gcomm://192.168.100.10:4567'; </code> <color red>※2号機から実施</color> <co... ql start --wsrep_cluster_address="gcomm://192.168.100.10:4567" </code> ==== 確認 ==== <code> # mysql -u