tracing

gistfile1.txt

Davids-MacBook-Air:~ daveo$ ssh cassandra04
Welcome to Ubuntu 12.10 (GNU/Linux 3.5.0-45-generic x86_64)

 * Documentation:  https://help.ubuntu.com/
New release '13.10' available.
Run 'do-release-upgrade' to upgrade to it.

 __          ___    _ _____      _____  _____   ____  _____
 \ \        / / |  | |_   _|    |  __ \|  __ \ / __ \|  __ \
  \ \  /\  / /| |__| | | |______| |__) | |__) | |  | | |  | |
   \ \/  \/ / |  __  | | |______|  ___/|  _  /| |  | | |  | |
    \  /\  /  | |  | |_| |_     | |    | | \ \| |__| | |__| |
     \/  \/   |_|  |_|_____|    |_|    |_|  \_\\____/|_____/


Last login: Wed May 14 19:37:16 2014 from 76.103.30.207
daveo@cassandra04:~$ ifconfig bond0 | grep inet
          inet addr:10.84.189.183  Bcast:10.84.189.255  Mask:255.255.255.128
          inet6 addr: fe80::225:90ff:fe59:3b6e/64 Scope:Link
daveo@cassandra04:~$ cqlsh 10.84.189.183 -k whi_production
Connected to prod at 10.84.189.183:9160.
[cqlsh 4.1.1 | Cassandra 2.0.7 | CQL spec 3.1.1 | Thrift protocol 19.39.0]
Use HELP for help.
cqlsh:whi_production> tracing on;
Now tracing requests.
cqlsh:whi_production> select count(*) from followers where user_id = 121321312 LIMIT 10;

 count
-------
     0

(1 rows)


Tracing session: 443f9ef0-db9f-11e3-9e89-a7a3b545c482

 activity                                                                   | timestamp    | source        | source_elapsed
----------------------------------------------------------------------------+--------------+---------------+----------------
                                                         execute_cql3_query | 19:38:04,256 | 10.84.189.183 |              0
 Parsing select count(*) from followers where user_id = 121321312 LIMIT 10; | 19:38:04,257 | 10.84.189.183 |            958
                                                        Preparing statement | 19:38:04,258 | 10.84.189.183 |           1811
                                          Sending message to /10.84.189.143 | 19:38:04,258 | 10.84.189.183 |           2268
                                       Message received from /10.84.189.183 | 19:38:04,261 | 10.84.189.143 |             94
                              Executing single-partition query on followers | 19:38:04,262 | 10.84.189.143 |           1207
                                               Acquiring sstable references | 19:38:04,262 | 10.84.189.143 |           1305
                                                Merging memtable tombstones | 19:38:04,262 | 10.84.189.143 |           1355
                                  Bloom filter allows skipping sstable 6516 | 19:38:04,263 | 10.84.189.143 |           1437
                                  Bloom filter allows skipping sstable 5719 | 19:38:04,263 | 10.84.189.143 |           1492
  Skipped 0/2 non-slice-intersecting sstables, included 0 due to tombstones | 19:38:04,263 | 10.84.189.143 |           1533
                                 Merging data from memtables and 0 sstables | 19:38:04,263 | 10.84.189.143 |           1543
                                         Read 0 live and 0 tombstoned cells | 19:38:04,263 | 10.84.189.143 |           1588
                                       Enqueuing response to /10.84.189.183 | 19:38:04,263 | 10.84.189.143 |           1702
                                          Sending message to /10.84.189.183 | 19:38:04,263 | 10.84.189.143 |           2162
                                       Message received from /10.84.189.143 | 19:38:04,265 | 10.84.189.183 |           9103
                                    Processing response from /10.84.189.143 | 19:38:04,265 | 10.84.189.183 |           9467
                                                           Request complete | 19:38:04,265 | 10.84.189.183 |           9651


cqlsh:whi_production>