liu xiaotao wrote:
>
> I've ever ask some question but can't get reponse.So I ask this question
> again, who can help me?
>
> I want to ask four question about MaxDB 7.5.Please help me!
>
> One,are there index reorganiztion and merge function in maxdb? And how to
> use it?
NO reorganization in MaxDB needed.
What do you mean with 'merge-function'? A function like substr/length or
something having to do with some kind of reorganization (see above)?
>
> Two,how to get information about the execution plan in maxdb? (It shuold
> not be explain functon,which is too simple).
Only explain available for users.
For developers some other info is available, but in a
non-user-read/understandable form.
>
> Three,can you give me a test case which will generate a deadlock and be
> tested by maxdb,then maxdb cancel one of the transactions which generate
> deadlock.
As with all all database systems, a testcase will be:
Transaction A Transaction B
Update record xyz
Update record abc
Try to update/read
(with isolation level > 0)
record abc
Try to update/read
(with isolation level > 0)
record xyz
>
> Four,whether maxdb has function to kill deadlock by user and where can I
> find it?
To kill if deadlock happened? None
To help shortening waiting times: see installation parameter REQUEST_TIMEOUT
To help finding DEADLOCKS (if it is not such easy one with exactly two tasks
concerned. See parameter DEADLOCK_DETECTION, which will (per default) have an
acceptable value of 4.
Elke
SAP Labs Berlin
>
> _________________________________________________________________
> 与联机的朋友进行交流，请使用 MSN Messenger: http://messenger.msn.com/cn
>
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
