Steve Shaw

Show:

What's happening?

  • Followup: RE: enq: TX - row lock contention

    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 of...

    2009-10-01 19:37:34 UTC in Hammerora

  • Followup: RE: enq: TX - row lock contention

    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

  • Followup: RE: hammerora.ctl core dump

    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

  • Followup: RE: Record transaction counter with MySQL

    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

  • Followup: RE: Record transaction counter with MySQL

    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

  • Followup: RE: Error in Wish85: Unable to Alloc (sobe) bytes

    Hi, If this is on a Linux system you may have hit the limit according to the system enforced stack size you can increase this with the command "ulmit -s" up to the system wide value in /etc/security/limits.conf Cheers, Steve.

    2009-08-18 17:10:46 UTC in Hammerora

  • Followup: RE: Error in Thread tid00000CDC - invalid com

    Hi, Hammerora is fully multithreaded so all the users run their workload concurrently and independently (unless you choose to communicate between them - see some of the built in scripts for examples such as the multithreaded TPC-C schema creation) by default each user starts running its workload 1/2 second after the previous to prevent a login storm although this is configurable to any...

    2009-08-14 15:07:48 UTC in Hammerora

  • Followup: RE: Error in Thread tid00000CDC - invalid com

    Hi, It looks like you are missing the following line at the start before you call the Oratcl commands package require Oratcl Cheers, Steve.

    2009-08-13 20:46:40 UTC in Hammerora

  • Followup: RE: Log file?

    Hi, Under the Vritual User Options there is 2 check boxes, one that says "Show Output" and the other that says "log Output to Temp". "Log Output to Temp" is greyed out until you check show output based on the premise that if you are going to record all of the output in a file then you should also view what you are logging. It is worth noting that the output is...

    2009-06-25 15:46:54 UTC in Hammerora

  • Followup: RE: hammerora.ctl core dump

    Hi, That is great, glad the problem is resolved and many thanks for posting the update with the solution which is always the most useful bit if anyone encounters the same issue. Yes, in theory an RPM install would be a possibility. I use the graphical installer to keep it as consistent as possible between OS's as the install is the same on Windows as it is on Linux and if I have the...

    2009-06-12 18:49:48 UTC in Hammerora

About Me

  • 2003-06-02 (6 years ago)
  • 792007
  • smshaw (My Site)
  • Steve Shaw

  • SQL-based SQL-based

Send me a message