Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 95160 invoked from network); 17 Jun 2007 12:10:47 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 17 Jun 2007 12:10:47 -0000 Received: (qmail 48771 invoked by uid 500); 17 Jun 2007 12:10:50 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 48726 invoked by uid 500); 17 Jun 2007 12:10:50 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 48716 invoked by uid 99); 17 Jun 2007 12:10:50 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 17 Jun 2007 05:10:50 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 17 Jun 2007 05:10:46 -0700 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id D9F42714062 for ; Sun, 17 Jun 2007 05:10:25 -0700 (PDT) Message-ID: <2370738.1182082225873.JavaMail.jira@brutus> Date: Sun, 17 Jun 2007 05:10:25 -0700 (PDT) From: "Kurt Huwig (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Created: (DERBY-2836) Documentation of derby.storage.pageSize should mention that the default is dynamic MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Documentation of derby.storage.pageSize should mention that the default is dynamic ---------------------------------------------------------------------------------- Key: DERBY-2836 URL: https://issues.apache.org/jira/browse/DERBY-2836 Project: Derby Issue Type: Improvement Components: Documentation Affects Versions: 10.2.2.0 Reporter: Kurt Huwig The documention of derby.storage.pageSize at docs/html/tuning/rtunproper40688.html says: Default 4096 bytes. But this page docs/html/tuning/ctunperf816059.html hints, that this default is not necessarily the one to be used: "Derby autotunes the database pagesize. If you have long columns, the default pagesize for the table is set to 32K. Otherwise, the default is 4K." Also the documentation of derby.storage.pageCacheSize at docs/html/tuning/rtunproper81359.html does not mention this: "When increasing the size of the page cache, you typically have to allow more memory for the Java heap when starting the embedding application (taking into consideration, of course, the memory needs of the embedding application as well). For example, using the default page size of 4K, a page cache size of 2000 pages will require at least 8 MB of memory (and probably more, given the overhead)." We had one machine crashing, because we expected the page size to be the default of 4096. After 2 hours of testing, I found out that for my particular example, the page size is set to 32K. So having a note added would have at least saved me some time and hassle. I recommend to add the sentence "Derby autotunes the database pagesize. If you have long columns, the default pagesize for the table is set to 32K. Otherwise, the default is 4K." to both the documentation of derby.storage.pageSize and derby.storage.pageCacheSize -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.