1 INSERTING 5 RECORDS IN TARGET DB
2 +---------------------------------------+
9 +---------------------------------------+
10 \e[?1034hSQL> SELECT * FROM t1;
11 +------------+---------------------+------------+
13 +------------+---------------------+------------+
19 +------------+---------------------+------------+
22 SQL> CACHING THROUGH SITE1
23 cachetable -U root -P manager -t t1
25 Statement Executed: Rows Affected = 1
26 Statement Executed: Rows Affected = 1
27 Statement Executed: Rows Affected = 1
28 Statement Executed: Rows Affected = 1
29 Statement Executed: Rows Affected = 1
36 INSERTING 5 RECORDS IN CACHED TABLE t1 AT CSQL
37 Statement Executed: Rows Affected = 1
38 Statement Executed: Rows Affected = 1
39 Statement Executed: Rows Affected = 1
40 Statement Executed: Rows Affected = 1
41 Statement Executed: Rows Affected = 1
42 INSERTING 5 RECORDS AT NON CACHED TABLE t2 AT CSQL
43 Statement Executed: Rows Affected = 1
44 Statement Executed: Rows Affected = 1
45 Statement Executed: Rows Affected = 1
46 Statement Executed: Rows Affected = 1
47 Statement Executed: Rows Affected = 1
54 UPDATING 5 RECORDS IN CACHED TABLE t1 AT CSQL
55 Statement Executed: Rows Affected = 5
56 UPDATING 5 RECORDS AT NON CACHED TABLE t2 AT CSQL
57 Statement Executed: Rows Affected = 5
64 DELETING 7 RECORDS IN CACHED TABLE t1 AT CSQL
65 Statement Executed: Rows Affected = 7
66 DELETING 7 RECORDS AT NON CACHED TABLE t2 AT CSQL
67 Statement Executed: Rows Affected = 7
74 +---------------------------------------+
81 +---------------------------------------+
82 \e[?1034hSQL> DROP TABLE t1;
84 SQL> Statement Executed