-
Hi,
All the data is in the Oracle Database you are testing so you can get the results from there. If you run the AWR tests it will take snapshots for you and report the average TPM figure between the snapshots you took. If you then generate the AWR report you will see that the number hammerora reports corresponds precisely with the number reported in the AWR report load profile section. You...
2010-01-14 12:44:38 UTC in Hammerora
-
Anu,
A slight delay in replies at the moment as I am on vacation until 26th Jan.
Anyway good luck with the diploma, here are the answers to your questions.
1. Storage Space - it depends on the tests you are running. If it is TPCC I advise about 100MB per warehouse but you need some additional room for adding rows as the test is run and therefore it depends on the performance of your system...
2010-01-14 12:40:21 UTC in Hammerora
-
Hi,
You can run hammerora.tcl in silent mode, hammerora is a GUI application and therefore the errors you see are failures in TK commands. In terms of silent mode what we mean is rather than trying to run hammerora in silent mode or trying to hack some sections of the hammerora is code is you load the default driver script in the GUI and then use the save function from the menu to save the...
2010-01-14 12:23:13 UTC in Hammerora
-
Hi,
I'm currently on vacation so some delay in replies.
My recommendation to achieve the most consistent results is to take advantage of the rampup time i.e. let all the users log on and run the workload and observe the transaction counter increasing until it gets to a steady point. This is the where you should take the AWR snapshots to get the same results for multiple tests. I would not...
2010-01-14 12:11:46 UTC in Hammerora
-
Hi,
You can run all of the scripts both the in-built ones and your own without the GUI by using the standard TCL shell ie tclsh8.5 in the hammerora bin directory. However in silent mode you have a challenge of how you monitor the individual threads, their output, whether errors are detected and from which threads the errors came. That is the main reason why this feature has not been...
2010-01-07 17:37:09 UTC in Hammerora
-
Hi,
The option for keyandthink is by default set to "on or off", the reason is because the values are the same as the ones in the TPC-C specification. There is nothing to stop you experimenting with changing it though in the driver script, just one of the advantages of Open Source! I would say though that to use the 'official values' you do need a huge database with hundreds...
2009-10-01 19:37:34 UTC in Hammerora
-
Hi,
Yes the warehouse assignment code is random so you can end up with multiple users per warehouse. The main question is are you using keying and thinking time to simulate what takes place in a real TPC-C type test or are you running with keying and thinking time turned off? If keying and thinking time is turned off even a single user has the ability to drive a a significant amount of CPU...
2009-09-24 15:17:07 UTC in Hammerora
-
Hi,
It is important to note that a core dump indicates that something within TCL itself is breaking. First thing to check is that you have the OS resources to support the users you want to configure, the most common limit is the stack size, so as the root user set the system limit
etc/security/limits.conf
#* soft core 0
#* hard rss.
2009-09-24 14:54:22 UTC in Hammerora
-
Hi,
The requirement for innodb is not a restriction of Hammerora as such, however innodb is the only storage engine with full transactional support in current production releases of MySQL. For that reason in the database creation script includes the clause ENGINE = INNODB for the tables so it generates a meaningful transactional test. There is nothing to stop you saving the creation script...
2009-09-02 20:19:26 UTC in Hammerora
-
Hi,
Slight delay in the reply, just back from vacation!
Hammerora doesn't implement logging of the transaction counter at present from the design perspective that the database under test itself should be able to provide these statistics in a more comprehensive manner. Admittedly Oracle provides a complete way to do this with its AWR reports however MySQL provides statistics dependent on the...
2009-09-01 19:36:21 UTC in Hammerora
