On Mon, Feb 23, 2009 at 5:20 PM, Scott Marlowe <scott.marl...@gmail.com>wrote:
> On Mon, Feb 23, 2009 at 12:42 AM, Jordan Tomkinson <jor...@moodle.com> > wrote: > > > > > > On Mon, Feb 23, 2009 at 4:29 PM, Scott Marlowe <scott.marl...@gmail.com> > > wrote: > >> > >> Oh yeah, what OS is this? Version and all that. > > > > I should probably clarify that the high cpu only exists while the jmeter > > tests are running, once the tests are finished the cpu returns to 0% > (this > > isnt a production server yet, so no other queries other than my tests) > > I have not yet tried other SQL queries to see if they are affected, i > > suspect it may only be related to the two forum tables the test focuses > on > > but I may be incorrect - the database is filling up with data again now > so I > > can test this tomorrow. > > Sorry, I had gotten the impression the CPU usage continued after the > test. That it's 100% during the test is quite understandable. So > does it start lower than 4x100% Then climb during the tests? Is the > throughput dropping off over time? > As per the spreadsheet ( http://spreadsheets.google.com/pub?key=pu_k0R6vNvOVP26TRZdtdYw) CPU usage is around 50% and starts climbing over 3 hours until we have just under 10,000 rows of data then stays at 99% for the duration of all future tests. Once the rows are removed the tests start back down at 50% usage again.
