07-15-2015 06:56:46:895 : ************************** Summary **************************
07-15-2015 06:56:46:896 : All DML operations ran in multiple threads with thread count = 10
07-15-2015 06:56:46:897 : All the timings are in hour:min:second:millisecond
07-15-2015 06:56:46:897 : Total distinct database interactions: 9
07-15-2015 06:56:46:898 : 0- operation type: CREATE, count:1
07-15-2015 06:56:46:899 : 1- operation type: INSERT, count:60000001
07-15-2015 06:56:46:901 : 2- operation type: UPDATE, count:200000
07-15-2015 06:56:46:903 : 3- operation type: UPDATE_INDEX, count:200000
07-15-2015 06:56:46:906 : 4- operation type: SELECT, count:200000
07-15-2015 06:56:46:908 : 5- operation type: DELETE, count:200000
07-15-2015 06:56:46:910 : 6- operation type: CTAS, count:1
07-15-2015 06:56:46:912 : 7- operation type: DROP, count:1
07-15-2015 06:56:46:915 : 8- operation type: DROP, count:1
07-15-2015 06:56:46:932 : Total time for the test: 7:31:45:791.0
07-15-2015 06:56:46:933 : Number of operations: 60800005
07-15-2015 06:56:46:937 : Average time for all operations: 0:0:0:0.4458188942583146
07-15-2015 06:56:46:939 : Average transactions/second for all operations: 2243
07-15-2015 06:56:46:941 :
07-15-2015 06:56:46:944 : Number of create operations: 1
07-15-2015 06:56:46:946 : Total time for create operations: 0:0:0:307.0
07-15-2015 06:56:46:948 : Average time for all create operations: 0:0:0:307.0
07-15-2015 06:56:46:951 : Average transactions/second for all create operations: 3
07-15-2015 06:56:46:953 :
07-15-2015 06:56:46:955 : Number of create table as select operations: 1
07-15-2015 06:56:46:958 : Total time for create table as select operations: 0:31:29:121.0
07-15-2015 06:56:46:960 : Average time for all create table as select operations: 0:31:29:121.0
07-15-2015 06:56:46:962 : Average transactions/second for all create table as select operations: 0
07-15-2015 06:56:46:964 :
07-15-2015 06:56:46:966 : Number of drop operations: 2
07-15-2015 06:56:46:968 : Total time for drop operations: 0:0:1:71.0
07-15-2015 06:56:46:971 : Average time for all drop operations: 0:0:0:535.5
07-15-2015 06:56:46:973 : Average transactions/second for all drop operations: 1
07-15-2015 06:56:46:975 :
07-15-2015 06:56:46:977 : Number of insert operations: 60000001
07-15-2015 06:56:46:980 : Total time for insert operations: 6:51:31:743.0
07-15-2015 06:56:46:984 : Average time for all insert operations: 0:0:0:0.4115290431411826
07-15-2015 06:56:46:986 : Average transactions/second for all insert operations: 2429
07-15-2015 06:56:46:988 : Total bytes of data inserted: 1158196632
07-15-2015 06:56:46:991 : Average bytes of data inserted/second (bytes/second): 46906
07-15-2015 06:56:46:993 :
07-15-2015 06:56:46:995 : Number of update operations in non-indexed table: 200000
07-15-2015 06:56:46:997 : Total time for update operations in non-indexed table: 0:1:41:826.0
07-15-2015 06:56:47:000 : Average time for all update operations in non-indexed table: 0:0:0:0.50913
07-15-2015 06:56:47:002 : Average transactions/second for all update operations in non-indexed table: 1964
07-15-2015 06:56:47:004 :
07-15-2015 06:56:47:006 : Number of update operations in indexed table: 200000
07-15-2015 06:56:47:009 : Total time for update operations in indexed table: 0:2:25:359.0
07-15-2015 06:56:47:011 : Average time for all update operations in indexed table: 0:0:0:0.726795
07-15-2015 06:56:47:013 : Average transactions/second for all update operations in indexed table: 1375
07-15-2015 06:56:47:017 :
07-15-2015 06:56:47:019 : Number of select operations: 200000
07-15-2015 06:56:47:022 : Total time for select operations: 0:1:19:136.0
07-15-2015 06:56:47:024 : Average time for all select operations: 0:0:0:0.39568
07-15-2015 06:56:47:025 : Average transactions/second for all select operations: 2527
07-15-2015 06:56:47:028 :
07-15-2015 06:56:47:031 : Number of delete operations: 200000
07-15-2015 06:56:47:033 : Total time for delete operations: 0:3:17:228.0
07-15-2015 06:56:47:035 : Average time for all delete operations: 0:0:0:0.98614
07-15-2015 06:56:47:038 : Average transactions/second for all delete operations: 1014
07-15-2015 06:56:47:040 : *************************************************************