Re: InnoDB and accesslog/ watchdog
Gerhard-
It would also be helpful if anybody could compare the use of InnoDB vs my patch.
Showing my ignorance. Is there a posted standard for Drupal performance testing? The last time I did some tests, I just used apache benchmark (copying something I had seen Killes do previously). Simpletest and the wget method (http://drupal.org/node/11521) don't seem to cover overall performance. - Ken Rickard
Ken Rickard wrote:
It would also be helpful if anybody could compare the use of InnoDB vs my patch.
Showing my ignorance. Is there a posted standard for Drupal performance testing? The last time I did some tests, I just used apache benchmark (copying something I had seen Killes do previously).
I think everybody uses apache benchmark. In this special case the question probably should be resolved by a simple php script that does inserts into a table and you benchmark it using ab. something like: <?php require_once './includes/bootstrap.inc'; drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL); for ($i = 0; $i < 1000; $i++) { db_query("INSERT INTO watchdog (uid, type, message, severity, link, hostname, timestamp, referer) values (1, 'test', '<em>benchmarking</em> INSERT INTO watchdog', '1', 'nothing', '127.0.0.1', UNIX_TIMESTAMP(), 'http://localhost/~killes/index.php')"); } This test should be done where: 1) the table is a full myISAM table (several 100k of lines at least) on drupal.org watchdog has 200k (over one week) lines, accesslog has 900k (over 48 hours). We would probably like to keep access logs for longer, but have limited it to 48 hours because we fear that we'd get bogged down if we have a larger table. So about 3.5 Mio entries would be cool, that would be one week of logs. 2) the table is a rather empty myISAM table. This would simulate the merge patch. 3) a full InnoDB table, comparable to 1). This would simulate your setup. It would also be interesting to observe's mysql memory requirements during the test as well as other server parameters.
Simpletest and the wget method (http://drupal.org/node/11521) don't seem to cover overall performance.
For this special case a difference in overall Drupal performance will be difficult to establish. There are only a few inserts per page load and I don't expect the change to be huge. Cheers, Gerhard
On 8/15/06, Ken Rickard <agentrickard@gmail.com> wrote:
Showing my ignorance. Is there a posted standard for Drupal performance testing? The last time I did some tests, I just used apache benchmark (copying something I had seen Killes do previously).
Whatever is done, detailed discussion of method and results and ideas would fit perfectly in the benchmarking group: http://groups.drupal.org/benchmarking-drupal Regards, Greg -- Greg Knaddison | Growing Venture Solutions Denver, CO | http://growingventuresolutions.com Technology Solutions for Communities, Individuals, and Small Businesses
On 15 Aug 2006, at 20:22, Greg Knaddison - GVS wrote:
Showing my ignorance. Is there a posted standard for Drupal performance testing? The last time I did some tests, I just used apache benchmark (copying something I had seen Killes do previously).
Whatever is done, detailed discussion of method and results and ideas would fit perfectly in the benchmarking group:
... or on the development mailing list, for that matter. (Gosh, don't we have several performance related groups/fora already? Last time I checked we had 3 or 4 such groups already. Looks like now we might have 5 ...) -- Dries Buytaert :: http://www.buytaert.net/
On 15-Aug-06, at 2:48 PM, Dries Buytaert wrote:
Whatever is done, detailed discussion of method and results and ideas would fit perfectly in the benchmarking group:
... or on the development mailing list, for that matter.
(Gosh, don't we have several performance related groups/fora already? Last time I checked we had 3 or 4 such groups already. Looks like now we might have 5 ...)
Benchmarking is not performance (it's related, obviously). You might want to benchmark your p2 webserver. And no, there is one group, called high performance -- http://groups.drupal.org/high-performance And, the lovely part about groups is that you can cross post. Groups are a great way to filter. You don't have to agree :P -- Boris Mann Vancouver 778-896-2747 San Francisco 415-367-3595 SKYPE borismann http://www.bryght.com
participants (5)
-
Boris Mann -
Dries Buytaert -
Gerhard Killesreiter -
Greg Knaddison - GVS -
Ken Rickard