On Mon, Feb 23, 2009 at 4:03 PM, Scott Marlowe
<scott.marlowe@gmail.com> wrote:
> Hi list,
>
> We are running postgresql 8.3.5 and are trying to stress test our LMS.
> The problem is when our stress tester (Jmeter) inserts around 10,000 rows
> (in 3 hours) over 2 tables (5000 rows each table) the CPU of the sql server
> hits 100% over all 4 cores for all future inserts.
And just to clarify, this is user / system CPU usage, not IO wait, right?
I am unable to post the jmeter file as it contains sensitive user/pass details, but they simply login to a forum and create a new forum post, then logout.
SQL wise this performs several SELECT's and 3 INSERT'S over 3 different tables.
How does one create an SQL test case?
LMS is Learning Management System, in this case Moodle (
moodle.org)
Yes this is user space CPU usage.
Running iostat -k 2 shows:
Device: tps kB_read/s kB_wrtn/s kB_read kB_wrtn
sda 31.50 0.00 456.00 0 912
so not alot of disk writes.