Please find attached sql-test.py. This script requires mysql to be installed on the test platform and to be run with sudo if the user is not root.
It will create a database called test_db and a table called test in the local mySQL instance. It will then update and select from the test table every 10 seconds. It is currently set to loop 60 times giving 10 minutes of coverage. It outputs current system time and iteration of the loop. This script should be run at the same time as the zcat command. The problem can be found when the timing of each iteration goes beyond 11 seconds The script was written using Python 2.6.5 and has been tested using Python 2.7.3 ** Attachment added: "python test script to show mySQL response times" https://bugs.launchpad.net/ubuntu/+source/linux/+bug/1064521/+attachment/3392797/+files/sql-test.py -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1064521 Title: Kernel I/O scheduling writes starving reads, local DoS To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/linux/+bug/1064521/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
