RE: AW: Why I can't get response

[liu xiaotao]

Thanks for your answer,I have repeat your suggesion.It's good.
But I want to ask more question,can you give me some examples,which 
deadlock depth are correspond to DEADLOCK_DETECTION's value which is 
1,2,3,4 or 5.


From: "Zabach, Elke" <[EMAIL PROTECTED]>
To: "liu xiaotao" <[EMAIL PROTECTED]>, <maxdb@lists.mysql.com>
CC: <[EMAIL PROTECTED]>
Subject: AW: Why I can't get response
Date: Fri, 1 Apr 2005 08:48:08 +0200
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]

_________________________________________________________________
免费下载 MSN Explorer:   http://explorer.msn.com/lccn/  

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]