全文検索:
- 50 MySQLベンチマーク(sysbench)
- p options: --oltp-test-mode=STRING test type to use {simple,complex,nontrx,sp} [complex] --o... er of records in test table [10000] --oltp-dist-type=STRING random numbers distribution {unifo
- 01 Galera構築
- pported with wsrep query_cache_size=0 query_cache_type=0 # Override bind-address # In some systems bind
- 09 Galera + innodb_flush_log_at_trx_commit
- s=10 --auto-generate-sql --auto-generate-sql-load-type=update --auto-generate-sql-write-number=1000 --nu... s=10 --auto-generate-sql --auto-generate-sql-load-type=update --auto-generate-sql-write-number=1000 --nu
- 51 MySQLベンチマーク(mysqlslap)
- \ --auto-generate-sql \ --auto-generate-sql-load-type=update \ --auto-generate-sql-write-number=1000 \ ... auto-generated tables. --auto-generate-sql-load-type=name Specify test load type: mixed, update, write, key, or
- 04 MyISAMからInnoDBへ変換
- ==== FULLTEXT はMyISAMでしかサポートされてない。 <code> The used table type doesn't support FULLTEXT indexes </code>