パフォーマンスへの影響のテスト
データをさまざまな整合性レベルで読み取るクエリーの実行とトレース。
トレースを行うと、要求に関連したすべてのアクティビティーが記録されます。以下の手順ではトレースを使用して、異なる整合性レベル（CL）を使用するレプリケーション係数3のキースペースに対するクエリーを示します。
- ONEは3つのレプリカのうち1つからの応答を処理します。
- QUORUMは3つのレプリカのうち2つからの応答を処理します。
- ALLは3つのレプリカすべてからの応答を処理します。
手順
-
cqlshコマンドラインで、クラスター内のデータ分散に3つのレプリカの使用を指定するキースペースを作成します。
CREATE KEYSPACE cycling_alt WITH replication = {'class':'SimpleStrategy', 'replication_factor':3}; -
テーブルを作成し、値をいくつか挿入します。
USE cycling_alt; CREATE TABLE cycling_alt.tester ( id int PRIMARY KEY, col1 int, col2 int ); INSERT INTO cycling_alt.tester (id, col1, col2) VALUES (0, 0, 0);
-
トレースをオンにし、CONSISTENCYコマンドを使用して、整合性レベルがONE（デフォルト）であることを確認します。
TRACING on; CONSISTENCY;
出力は以下のとおりです。Current consistency level is 1. -
テーブルにクエリーして、プライマリ・キーの値を読み取ります。
SELECT * FROM cycling_alt.tester WHERE id = 0;
出力にはトレース情報が含まれます。id | col1 | col2 ----+------+------ 0 | 0 | 0 (1 rows) Tracing session: 983f3ae0-fdfe-11e6-8b40-23a5e4e49022 activity | timestamp | source | source_elapsed | client ------------------------------------------------------------------------------------------------------------------------------+----------------------------+----------------+----------------+----------- Execute CQL3 query | 2017-02-28 21:40:59.918000 | 10.200.176.228 | 0 | 127.0.0.1 Parsing SELECT * FROM cycling_alt.tester WHERE id = 0; [Native-Transport-Requests-1] | 2017-02-28 21:40:59.918000 | 10.200.176.228 | 248 | 127.0.0.1 Preparing statement [Native-Transport-Requests-1] | 2017-02-28 21:40:59.918000 | 10.200.176.228 | 473 | 127.0.0.1 speculating read retry on /10.200.176.229 [Native-Transport-Requests-1] | 2017-02-28 21:40:59.920000 | 10.200.176.228 | 2339 | 127.0.0.1 Sending READ message to /10.200.176.229 message size 134 bytes [MessagingService-Outgoing-/10.200.176.229-Small] | 2017-02-28 21:40:59.921000 | 10.200.176.228 | 2660 | 127.0.0.1 Executing single-partition query on tester [ReadStage-3] | 2017-02-28 21:40:59.923000 | 10.200.176.228 | 4706 | 127.0.0.1 Acquiring sstable references [ReadStage-3] | 2017-02-28 21:40:59.923000 | 10.200.176.228 | 4841 | 127.0.0.1 Merging memtable contents [ReadStage-3] | 2017-02-28 21:40:59.923000 | 10.200.176.228 | 4910 | 127.0.0.1 Read 1 live and 0 tombstone cells [ReadStage-3] | 2017-02-28 21:40:59.923000 | 10.200.176.228 | 5192 | 127.0.0.1 REQUEST_RESPONSE message received from /10.200.176.229 [MessagingService-Incoming-/10.200.176.229] | 2017-02-28 21:40:59.924000 | 10.200.176.228 | 5644 | 127.0.0.1 Processing response from /10.200.176.229 [RequestResponseStage-3] | 2017-02-28 21:40:59.924000 | 10.200.176.228 | 6116 | 127.0.0.1 Initiating read-repair [RequestResponseStage-3] | 2017-02-28 21:40:59.924000 | 10.200.176.228 | 6256 | 127.0.0.1 READ message received from /10.200.176.228 [MessagingService-Incoming-/10.200.176.228] | 2017-02-28 21:40:59.968000 | 10.200.176.229 | 19 | 127.0.0.1 Executing single-partition query on tester [ReadStage-1] | 2017-02-28 21:40:59.969000 | 10.200.176.229 | 711 | 127.0.0.1 Acquiring sstable references [ReadStage-1] | 2017-02-28 21:40:59.969000 | 10.200.176.229 | 781 | 127.0.0.1 Merging memtable contents [ReadStage-1] | 2017-02-28 21:40:59.969000 | 10.200.176.229 | 824 | 127.0.0.1 Read 1 live and 0 tombstone cells [ReadStage-1] | 2017-02-28 21:40:59.969000 | 10.200.176.229 | 1056 | 127.0.0.1 Enqueuing response to /10.200.176.228 [ReadStage-1] | 2017-02-28 21:40:59.969000 | 10.200.176.229 | 1118 | 127.0.0.1 Sending REQUEST_RESPONSE message to /10.200.176.228 message size 113 bytes [MessagingService-Outgoing-/10.200.176.228-Small] | 2017-02-28 21:40:59.970000 | 10.200.176.229 | 1704 | 127.0.0.1 Request complete | 2017-02-28 21:40:59.924664 | 10.200.176.228 | 6664 | 127.0.0.1トレース結果には
SELECT文を完了するために行うすべてのアクションが表示されます。 -
整合性レベルをQUORUMに変更し、QUORUM整合性レベルで読み取り時に発生したことをトレースします。
CONSISTENCY quorum; SELECT * FROM cycling_alt.tester WHERE id = 0;
id | col1 | col2 ----+------+------ 0 | 0 | 0 (1 rows) Tracing session: c96811a0-fdfe-11e6-8b40-23a5e4e49022 activity | timestamp | source | source_elapsed | client -----------------------------------------------------------------------------------------------------------------------------+----------------------------+----------------+----------------+----------- Execute CQL3 query | 2017-02-28 21:42:22.394000 | 10.200.176.228 | 0 | 127.0.0.1 READ message received from /10.200.176.228 [MessagingService-Incoming-/10.200.176.228] | 2017-02-28 21:42:22.369000 | 10.200.176.23 | 20 | 127.0.0.1 Executing single-partition query on tester [ReadStage-2] | 2017-02-28 21:42:22.370000 | 10.200.176.23 | 1119 | 127.0.0.1 Acquiring sstable references [ReadStage-2] | 2017-02-28 21:42:22.370000 | 10.200.176.23 | 1188 | 127.0.0.1 Merging memtable contents [ReadStage-2] | 2017-02-28 21:42:22.370000 | 10.200.176.23 | 1272 | 127.0.0.1 Read 1 live and 0 tombstone cells [ReadStage-2] | 2017-02-28 21:42:22.371000 | 10.200.176.23 | 1895 | 127.0.0.1 Read 1 live and 0 tombstone cells [ReadStage-2] | 2017-02-28 21:42:22.371000 | 10.200.176.23 | 2052 | 127.0.0.1 Enqueuing response to /10.200.176.228 [ReadStage-2] | 2017-02-28 21:42:22.371000 | 10.200.176.23 | 2095 | 127.0.0.1 Sending REQUEST_RESPONSE message to /10.200.176.228 message size 96 bytes [MessagingService-Outgoing-/10.200.176.228-Small] | 2017-02-28 21:42:22.372000 | 10.200.176.23 | 2413 | 127.0.0.1 Parsing SELECT * FROM cycling_alt.tester WHERE id = 0; [Native-Transport-Requests-1] | 2017-02-28 21:42:22.395000 | 10.200.176.228 | 421 | 127.0.0.1 Preparing statement [Native-Transport-Requests-1] | 2017-02-28 21:42:22.395000 | 10.200.176.228 | 656 | 127.0.0.1 Executing single-partition query on tester [ReadStage-2] | 2017-02-28 21:42:22.395000 | 10.200.176.228 | 1159 | 127.0.0.1 Acquiring sstable references [ReadStage-2] | 2017-02-28 21:42:22.395000 | 10.200.176.228 | 1288 | 127.0.0.1 Merging memtable contents [ReadStage-2] | 2017-02-28 21:42:22.395000 | 10.200.176.228 | 1344 | 127.0.0.1 reading digest from /10.200.176.23 [Native-Transport-Requests-1] | 2017-02-28 21:42:22.396000 | 10.200.176.228 | 1514 | 127.0.0.1 Read 1 live and 0 tombstone cells [ReadStage-2] | 2017-02-28 21:42:22.396000 | 10.200.176.228 | 1584 | 127.0.0.1 speculating read retry on /10.200.176.229 [Native-Transport-Requests-1] | 2017-02-28 21:42:22.396000 | 10.200.176.228 | 1781 | 127.0.0.1 Sending READ message to /10.200.176.229 message size 135 bytes [MessagingService-Outgoing-/10.200.176.229-Small] | 2017-02-28 21:42:22.396000 | 10.200.176.228 | 1981 | 127.0.0.1 Sending READ message to /10.200.176.23 message size 135 bytes [MessagingService-Outgoing-/10.200.176.23-Small] | 2017-02-28 21:42:22.396000 | 10.200.176.228 | 2243 | 127.0.0.1 REQUEST_RESPONSE message received from /10.200.176.229 [MessagingService-Incoming-/10.200.176.229] | 2017-02-28 21:42:22.399000 | 10.200.176.228 | 4734 | 127.0.0.1 Processing response from /10.200.176.229 [RequestResponseStage-3] | 2017-02-28 21:42:22.399000 | 10.200.176.228 | 4869 | 127.0.0.1 REQUEST_RESPONSE message received from /10.200.176.23 [MessagingService-Incoming-/10.200.176.23] | 2017-02-28 21:42:22.404000 | 10.200.176.228 | 38 | 127.0.0.1 Processing response from /10.200.176.23 [RequestResponseStage-2] | 2017-02-28 21:42:22.405000 | 10.200.176.228 | 4559 | 127.0.0.1 Initiating read-repair [RequestResponseStage-2] | 2017-02-28 21:42:22.405000 | 10.200.176.228 | 4711 | 127.0.0.1 READ message received from /10.200.176.228 [MessagingService-Incoming-/10.200.176.228] | 2017-02-28 21:42:22.443000 | 10.200.176.229 | 19 | 127.0.0.1 Executing single-partition query on tester [ReadStage-1] | 2017-02-28 21:42:22.444000 | 10.200.176.229 | 346 | 127.0.0.1 Acquiring sstable references [ReadStage-1] | 2017-02-28 21:42:22.444000 | 10.200.176.229 | 418 | 127.0.0.1 Merging memtable contents [ReadStage-1] | 2017-02-28 21:42:22.444000 | 10.200.176.229 | 477 | 127.0.0.1 Read 1 live and 0 tombstone cells [ReadStage-1] | 2017-02-28 21:42:22.444000 | 10.200.176.229 | 854 | 127.0.0.1 Read 1 live and 0 tombstone cells [ReadStage-1] | 2017-02-28 21:42:22.444000 | 10.200.176.229 | 975 | 127.0.0.1 Enqueuing response to /10.200.176.228 [ReadStage-1] | 2017-02-28 21:42:22.444000 | 10.200.176.229 | 1039 | 127.0.0.1 Sending REQUEST_RESPONSE message to /10.200.176.228 message size 96 bytes [MessagingService-Outgoing-/10.200.176.228-Small] | 2017-02-28 21:42:22.445000 | 10.200.176.229 | 1617 | 127.0.0.1 Request complete | 2017-02-28 21:42:22.400017 | 10.200.176.228 | 6017 | 127.0.0.1 -
整合性レベルをALLに変更して、SELECT文を再実行します。
CONSISTENCY ALL; SELECT * FROM cycling_alt.tester WHERE id = 0;
id | col1 | col2 ----+------+------ 0 | 0 | 0 (1 rows) Tracing session: ea9a9aa0-fdfe-11e6-8b40-23a5e4e49022 activity | timestamp | source | source_elapsed | client -----------------------------------------------------------------------------------------------------------------------------+----------------------------+----------------+----------------+----------- Execute CQL3 query | 2017-02-28 21:43:18.090000 | 10.200.176.228 | 0 | 127.0.0.1 READ message received from /10.200.176.228 [MessagingService-Incoming-/10.200.176.228] | 2017-02-28 21:43:18.065000 | 10.200.176.23 | 41 | 127.0.0.1 Executing single-partition query on tester [ReadStage-1] | 2017-02-28 21:43:18.065000 | 10.200.176.23 | 369 | 127.0.0.1 Acquiring sstable references [ReadStage-1] | 2017-02-28 21:43:18.065000 | 10.200.176.23 | 428 | 127.0.0.1 Merging memtable contents [ReadStage-1] | 2017-02-28 21:43:18.065000 | 10.200.176.23 | 518 | 127.0.0.1 Read 1 live and 0 tombstone cells [ReadStage-1] | 2017-02-28 21:43:18.066000 | 10.200.176.23 | 771 | 127.0.0.1 Read 1 live and 0 tombstone cells [ReadStage-1] | 2017-02-28 21:43:18.066000 | 10.200.176.23 | 852 | 127.0.0.1 Enqueuing response to /10.200.176.228 [ReadStage-1] | 2017-02-28 21:43:18.066000 | 10.200.176.23 | 893 | 127.0.0.1 Sending REQUEST_RESPONSE message to /10.200.176.228 message size 96 bytes [MessagingService-Outgoing-/10.200.176.228-Small] | 2017-02-28 21:43:18.066000 | 10.200.176.23 | 1344 | 127.0.0.1 Parsing SELECT * FROM cycling_alt.tester WHERE id = 0; [Native-Transport-Requests-1] | 2017-02-28 21:43:18.090000 | 10.200.176.228 | 451 | 127.0.0.1 Preparing statement [Native-Transport-Requests-1] | 2017-02-28 21:43:18.091000 | 10.200.176.228 | 774 | 127.0.0.1 reading digest from /10.200.176.23 [Native-Transport-Requests-1] | 2017-02-28 21:43:18.091000 | 10.200.176.228 | 1256 | 127.0.0.1 reading digest from /10.200.176.229 [Native-Transport-Requests-1] | 2017-02-28 21:43:18.092000 | 10.200.176.228 | 1562 | 127.0.0.1 Sending READ message to /10.200.176.23 message size 135 bytes [MessagingService-Outgoing-/10.200.176.23-Small] | 2017-02-28 21:43:18.092000 | 10.200.176.228 | 1941 | 127.0.0.1 Executing single-partition query on tester [ReadStage-3] | 2017-02-28 21:43:18.094000 | 10.200.176.228 | 4066 | 127.0.0.1 Acquiring sstable references [ReadStage-3] | 2017-02-28 21:43:18.094000 | 10.200.176.228 | 4213 | 127.0.0.1 Merging memtable contents [ReadStage-3] | 2017-02-28 21:43:18.094000 | 10.200.176.228 | 4323 | 127.0.0.1 Read 1 live and 0 tombstone cells [ReadStage-3] | 2017-02-28 21:43:18.095000 | 10.200.176.228 | 4595 | 127.0.0.1 REQUEST_RESPONSE message received from /10.200.176.23 [MessagingService-Incoming-/10.200.176.23] | 2017-02-28 21:43:18.095000 | 10.200.176.228 | 5123 | 127.0.0.1 Processing response from /10.200.176.23 [RequestResponseStage-4] | 2017-02-28 21:43:18.096000 | 10.200.176.228 | 5730 | 127.0.0.1 Sending READ message to /10.200.176.229 message size 135 bytes [MessagingService-Outgoing-/10.200.176.229-Small] | 2017-02-28 21:43:18.096000 | 10.200.176.228 | 5916 | 127.0.0.1 REQUEST_RESPONSE message received from /10.200.176.229 [MessagingService-Incoming-/10.200.176.229] | 2017-02-28 21:43:18.099000 | 10.200.176.228 | 8493 | 127.0.0.1 Processing response from /10.200.176.229 [RequestResponseStage-3] | 2017-02-28 21:43:18.099000 | 10.200.176.228 | 9062 | 127.0.0.1 READ message received from /10.200.176.228 [MessagingService-Incoming-/10.200.176.228] | 2017-02-28 21:43:18.143000 | 10.200.176.229 | 19 | 127.0.0.1 Executing single-partition query on tester [ReadStage-2] | 2017-02-28 21:43:18.144000 | 10.200.176.229 | 689 | 127.0.0.1 Acquiring sstable references [ReadStage-2] | 2017-02-28 21:43:18.144000 | 10.200.176.229 | 862 | 127.0.0.1 Merging memtable contents [ReadStage-2] | 2017-02-28 21:43:18.144000 | 10.200.176.229 | 906 | 127.0.0.1 Read 1 live and 0 tombstone cells [ReadStage-2] | 2017-02-28 21:43:18.144000 | 10.200.176.229 | 1182 | 127.0.0.1 Read 1 live and 0 tombstone cells [ReadStage-2] | 2017-02-28 21:43:18.144000 | 10.200.176.229 | 1280 | 127.0.0.1 Enqueuing response to /10.200.176.228 [ReadStage-2] | 2017-02-28 21:43:18.144000 | 10.200.176.229 | 1326 | 127.0.0.1 Sending REQUEST_RESPONSE message to /10.200.176.228 message size 96 bytes [MessagingService-Outgoing-/10.200.176.228-Small] | 2017-02-28 21:43:18.144001 | 10.200.176.229 | 1521 | 127.0.0.1 Request complete | 2017-02-28 21:43:18.100053 | 10.200.176.228 | 10053 | 127.0.0.1