db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-1412) Possible values for derby.storage.rowLocking Derby engine is not currently documented eventhough the property is
Date Tue, 30 Sep 2008 19:15:44 GMT

    [ https://issues.apache.org/jira/browse/DERBY-1412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12635815#action_12635815
] 

Kim Haase commented on DERBY-1412:
----------------------------------

I have a couple of questions about this property that I can't figure out from the source code:

1) Is the scope system-wide, database-wide, and/or at the conglomerate level? These are not
mutually exclusive; it could be all three.

http://db.apache.org/derby/docs/dev/devguide/cdevconcepts23810.html says, "You typically set
lock granularity for the entire Derby system". But it doesn't state that this is the only
scope allowed.

2) Is the property static or dynamic -- that is, must you reboot Derby or the database for
the change to take effect, or does it take effect immediately?

See http://db.apache.org/derby/docs/dev/tuning/ctunproper22250.html for information on how
these features apply to other properties.



> Possible values for derby.storage.rowLocking Derby engine is not currently documented
eventhough the property is
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1412
>                 URL: https://issues.apache.org/jira/browse/DERBY-1412
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.4.1.3
>            Reporter: Francois Orsini
>            Assignee: Kim Haase
>            Priority: Minor
>
> Possible values for derby.storage.rowLocking Derby engine is not currently documented
eventhough the property is at:
> http://db.apache.org/derby/docs/10.1/devguide/cdevconcepts23810.html
> 'derby.storage.rowLocking' basically disable RLL (row-level locking) in the engine.
> The possible values for 'derby.storage.rowLocking' which are 'true', 'false' and the
default value are not documented at:
> http://db.apache.org/derby/docs/10.1/tuning/ctunproper22250.html
> Extract from the source code related to 'derby.storage.rowLocking' derby engine property
definition:
>    /**
>     * In cloudscape products which support Row Level Locking (rll), use this
>     * property to disable rll.  Application's which use rll will use more
>     * system resources, so if an application knows that it does not need rll
>     * then it can use this system property to force all locking in the system
>     * to lock at the table level.
>     *
>     * This property can be set to the boolean values "*true*" or "*false*".     * Setting
the property to true is the same as not setting the property at
>     * all, and will result in rll being enabled.  Setting the property to
>     * false disables rll.
>     *
>     **

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message