RE: AW: Why I can't get response

liu xiaotao Fri, 01 Apr 2005 00:05:01 -0800

About answer to 1th question: Can you tell me why maxdb needn't reorganize index? Whether does Maxdb generate the disk fragment in data processing time?

About answer to 2th question: Where can I found this information? Whether will Maxdb distribute some feature to display this informaion? You know,it is important to performance tuning.

About answer to 4th question: In fact,in my test which is tpc-c maxdb don't work well because of deadlock;even if we changed these parameters。If we reduced the REQUEST_TIMEOUT's value, the rollback was too much.If we change the value of DEADLOCK_DETECTION,we didn't see any new phenomenon.Can you explain how to use the DEADLOCK_DETECTION and what's the meaning of it?

From: "Zabach, Elke" <[EMAIL PROTECTED]>
To: "liu xiaotao" <[EMAIL PROTECTED]>, <[email protected]>
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 Hotmail。 http://www.hotmail.com


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

RE: AW: Why I can't get response

Reply via email to