MySQL SlapをNDB対して実行して、メモリー割り当て変化の簡単な確認
[root@misc bin]# /usr/local/mysql/bin/mysqlslap --no-defaults --create-schema=SLAP --engine=ndb --auto-generate-sql --auto-generate-sql-add-autoincrement --engine=ndb --number-int-cols=3 --number-char-cols=5 --concurrency=10 --auto-generate-sql-write-number=10000 --auto-generate-sql-execute-number=10000 --auto-generate-sql-load-type=mixed -h 192.168.56.114 -u admin -p Enter password: Benchmark Running for engine ndb Average number of seconds to run all queries: 135.323 seconds Minimum number of seconds to run all queries: 135.323 seconds Maximum number of seconds to run all queries: 135.323 seconds Number of clients running queries: 10 Average number of queries per client: 10000 [root@misc bin]#
Node, …
[さらに読む]