-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Brian Aker wrote: > Hi! > A few places to look: > 971.1.47 (replication)
Hi again! OK, so I had to make a few quick changes to the automation suite to support non-integer revisions, but those have been made and I am happy (and relieved) to report that replication (r971.1.47) is NOT the cause of the regression... yeah, Jay! \o/ +----------------+-------------+-------------+ | version | concurrency | tps | +----------------+-------------+-------------+ | trunk-989 | 2 | 1050.630000 | | trunk-989 | 4 | 1417.433333 | | trunk-989 | 8 | 1942.686667 | | trunk-989 | 16 | 2612.166667 | | trunk-989 | 32 | 3389.150000 | | trunk-989 | 64 | 3944.433333 | | trunk-989 | 128 | 3924.076667 | | trunk-989 | 256 | 2964.776667 | | trunk-989 | 512 | 1981.050000 | | trunk-989 | 1024 | 1273.133333 | | trunk-989 | 2048 | 563.350000 | | trunk-971.1.47 | 2 | 1049.383333 | | trunk-971.1.47 | 4 | 1407.180000 | | trunk-971.1.47 | 8 | 1930.036667 | | trunk-971.1.47 | 16 | 2604.316667 | | trunk-971.1.47 | 32 | 3379.230000 | | trunk-971.1.47 | 64 | 3889.433333 | | trunk-971.1.47 | 128 | 3910.143333 | | trunk-971.1.47 | 256 | 2933.186667 | | trunk-971.1.47 | 512 | 2021.323333 | | trunk-971.1.47 | 1024 | 1282.256667 | | trunk-971.1.47 | 2048 | 589.543333 | +----------------+-------------+-------------+ > 971.1.63 (first introduction of Bitmap) Running this rev now...it may turn out to be the cause, and if so, I will dig down into Padraig and Monty's Bitmap changes to see which specific revision contains the culprit :) /me loves automated benching... Cheers, Jay > Cheers, > -Brian > > > > On May 1, 2009, at 9:11 PM, Jay Pipes wrote: > > Hi! > > Somewhere in r990, we have had a significant regression, most evident in > concurrency levels greater than 128 concurrent connections: > > +-----------+-------------+-------------+ > | version | concurrency | tps | > +-----------+-------------+-------------+ > | trunk-989 | 2 | 1050.630000 | > | trunk-989 | 4 | 1417.433333 | > | trunk-989 | 8 | 1942.686667 | > | trunk-989 | 16 | 2612.166667 | > | trunk-989 | 32 | 3389.150000 | > | trunk-989 | 64 | 3944.433333 | > | trunk-989 | 128 | 3924.076667 | > | trunk-989 | 256 | 2964.776667 | > | trunk-989 | 512 | 1981.050000 | > | trunk-989 | 1024 | 1273.133333 | > | trunk-989 | 2048 | 563.350000 | > | trunk-990 | 2 | 1038.133333 | > | trunk-990 | 4 | 1381.933333 | > | trunk-990 | 8 | 1897.276667 | > | trunk-990 | 16 | 2547.196667 | > | trunk-990 | 32 | 3331.570000 | > | trunk-990 | 64 | 3896.483333 | > | trunk-990 | 128 | 3850.016667 | > | trunk-990 | 256 | 2331.543333 | > | trunk-990 | 512 | 1862.316667 | > | trunk-990 | 1024 | 1103.903333 | > | trunk-990 | 2048 | 436.976667 | > +-----------+-------------+-------------+ > > The above TPS column is the average of 3 iterations of a readonly > sysbench workload for the revision/concurrency pair. > > Unfortunately, r990 was a very big revision with a lot of changes: > > http://bazaar.launchpad.net/~drizzle-developers/drizzle/development/revision/990 > > > This makes it very difficult to tell what precisely has caused the > regression. I'd like to suggest that going forward, we really try to > keep the size of merges and commits small so that it is easier to tell > where regressions occur. > > Anyone interested in looking through the commit diff above is welcome to > suggest ideas where regression may have occurred...but it might be, like > Brian says, death by a thousand cuts... > > Cheers! > > Jay > -- > _______________________________________________________ > Brian "Krow" Aker, brian at tangent.org > Seattle, Washington > http://krow.net/ <-- Me > http://tangent.org/ <-- Software > _______________________________________________________ > You can't grep a dead tree. > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkn8fRMACgkQ2upbWsB4UtFJgQCeLo+APXkyFe8y3RVNLLD3AM7Y BBsAniCk43VLejdM2PCjpZhm7t8MUh2N =PWnJ -----END PGP SIGNATURE----- _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
