I am a new to use Hammerora tool. I've installed it and mysql in linux centos. I followed the qs quide and hammerora_mysql_oltp_v1.5.pdf. when I tried running it, i always get the MySQL TPM value 0 although i can get NOPM value in Test Result. I cannot find out the reason why i cannot get TPM value. The transaction counter shows nothing when i tried to use it. Pls help me get your suggessions.
regards, Ko Ko
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Please see reply in other thread. Namely check that your storage engine supports transactions such as innodb. Hammerora gets the transaction rate from MySQL and therefore it appears as though either your storage engine or MySQL environment is not updating the transaction statistics
Cheers,
Steve
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thank you very much for the reply.
Now I can retrieve TPM value.
One more error now I am facing is: "Virtual Users remain active in background, waiting for exit" when I use autopilot after creating database schema. I destroyed the virtual users after creating schema before running autopilot.
Pls guide me.
regards,
Ko Ko
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The autopilot mode is essentially a way that you can run a sequence of tests back to back with a different number of virtual users each time without having to run the tests manually. As such it makes most sense running tests with autopilot when you have selected the Timed tests and have the results recorded to your logfile. This way you can leave a sequence of tests running and come back and pick up the results at a later point.
Once a schema creation has completed you will see green ticks for all users showing it is complete - at this point you should destroy the virtual users and clear the screen. The you should load the timed driver script - with the correct menu option. Then you can run this script with Autopilot, Autopilot should not start if anything else is running. Once you are in autopilot mode you should only see this message between tests to show that the abort signal has been received but the virtual user is still active (usually you see this with Oracle when it is processing a checkpoint)
If a thread is still active please check with the command SHOW PROCESSLIST to identify what it is doing. One potential if a connection is remaining from the schema creation is bug 3286502 - this is fixed in version 2.7 which is almost complete will be released very soon.
Cheers,
Steve
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Although you mention here that the transaction counter shows values and this is based on the same transaction data.
Another thing to check is by using the following statement periodically to see if the transaction values are increasing:
show global status where Variable_name = 'Handler_commit' or Variable_name = 'Handler_rollback'
If this does increase then the MySQL Data that is needed is there, if not and the storage engine is innodb then please report that this is the case here, also it is very useful to give details of the version of MySQL, OS, system etc that you are using in case it is an issue with a specific version or as can be the case it has been introduced in a new version.
Also are you running the tests manually or are you using autopilot? If running autopilot does the test report an error in the logfile? When using autopilot it is important to ensure that the autopilot test period is long enough to allow the full ramp up and test time to complete in the test script. For example if you have a 2 minute rampup and 5 minute test then a 10 minute autopilot time interval would be recommended. If the autopilot time is too short it will stop the test before it is complete and in this case an error will be reported in the console that the logfile could not be written to (as the virtual user has been closed) and also no NOPM or TPM value will be reported as autopilot requested the virtual user to finish the test before the values have been collected - this is to be expected and can be resolved by increasing the autopilot time interval to allow the tests to fully complete.
Please update on your situation and configuration.
Cheers,
Steve
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
That is good news and your update is always beneficial for anyone searching on the same issue. The TPM and NOPM will always be 0 for a timed test with 1 virtual user as the first virtual user always times the test and takes the measurements without running the workload so if you are timing the test you need at least 2 virtual users configured to be meaningful with one virtual user doing the timing with the other virtual user running the workload.
Cheers,
Steve
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
2011-06-09 14:49:16 SGT
hi Steve,
I am a new to use Hammerora tool. I've installed it and mysql in linux centos. I followed the qs quide and hammerora_mysql_oltp_v1.5.pdf. when I tried running it, i always get the MySQL TPM value 0 although i can get NOPM value in Test Result. I cannot find out the reason why i cannot get TPM value. The transaction counter shows nothing when i tried to use it. Pls help me get your suggessions.
regards, Ko Ko
Hi,
Please see reply in other thread. Namely check that your storage engine supports transactions such as innodb. Hammerora gets the transaction rate from MySQL and therefore it appears as though either your storage engine or MySQL environment is not updating the transaction statistics
Cheers,
Steve
Thank you very much for the reply.
Now I can retrieve TPM value.
One more error now I am facing is: "Virtual Users remain active in background, waiting for exit" when I use autopilot after creating database schema. I destroyed the virtual users after creating schema before running autopilot.
Pls guide me.
regards,
Ko Ko
Hi,
The autopilot mode is essentially a way that you can run a sequence of tests back to back with a different number of virtual users each time without having to run the tests manually. As such it makes most sense running tests with autopilot when you have selected the Timed tests and have the results recorded to your logfile. This way you can leave a sequence of tests running and come back and pick up the results at a later point.
Once a schema creation has completed you will see green ticks for all users showing it is complete - at this point you should destroy the virtual users and clear the screen. The you should load the timed driver script - with the correct menu option. Then you can run this script with Autopilot, Autopilot should not start if anything else is running. Once you are in autopilot mode you should only see this message between tests to show that the abort signal has been received but the virtual user is still active (usually you see this with Oracle when it is processing a checkpoint)
If a thread is still active please check with the command SHOW PROCESSLIST to identify what it is doing. One potential if a connection is remaining from the schema creation is bug 3286502 - this is fixed in version 2.7 which is almost complete will be released very soon.
Cheers,
Steve
Hi Steve / Ko Ko,
I am facing the same problem as above.
I have set mysql to InnoDB but the TPM and NOPM value is still 0.
Would you please to advice further?
Thanks,
Hi,
I'll continue the discussion here rather than thread
https://sourceforge.net/projects/hammerora/forums/forum/292312/topic/4779967
Although you mention here that the transaction counter shows values and this is based on the same transaction data.
Another thing to check is by using the following statement periodically to see if the transaction values are increasing:
show global status where Variable_name = 'Handler_commit' or Variable_name = 'Handler_rollback'
If this does increase then the MySQL Data that is needed is there, if not and the storage engine is innodb then please report that this is the case here, also it is very useful to give details of the version of MySQL, OS, system etc that you are using in case it is an issue with a specific version or as can be the case it has been introduced in a new version.
Also are you running the tests manually or are you using autopilot? If running autopilot does the test report an error in the logfile? When using autopilot it is important to ensure that the autopilot test period is long enough to allow the full ramp up and test time to complete in the test script. For example if you have a 2 minute rampup and 5 minute test then a 10 minute autopilot time interval would be recommended. If the autopilot time is too short it will stop the test before it is complete and in this case an error will be reported in the console that the logfile could not be written to (as the virtual user has been closed) and also no NOPM or TPM value will be reported as autopilot requested the virtual user to finish the test before the values have been collected - this is to be expected and can be resolved by increasing the autopilot time interval to allow the tests to fully complete.
Please update on your situation and configuration.
Cheers,
Steve
Hi,
Thanks very much for your advice, it works. As additional, I installed MySQL with InnoDB is set as the default Storage.
Now both Manually and Autopilot are running OK.
Only if virtual user = 1, it always display 0 values on NOPM and TPM.
Thanks.
Hi,
That is good news and your update is always beneficial for anyone searching on the same issue. The TPM and NOPM will always be 0 for a timed test with 1 virtual user as the first virtual user always times the test and takes the measurements without running the workload so if you are timing the test you need at least 2 virtual users configured to be meaningful with one virtual user doing the timing with the other virtual user running the workload.
Cheers,
Steve