Re: some problem of InnoDB performance optimization

2010-03-22 Thread Timo
HI Peter: Thanks for your answer. I have understand your answer. Thank you very much. ―― Best regards Timo Seven blog: http://zauc.wordpress.com #请翻墙浏览,或者指定hosts到74.200.243.252### UNIX System Admin 2010/3/23 Peter Zaitsev > Hi, > > Lets see If I can help.

Re: some problem of InnoDB performance optimization

2010-03-22 Thread Peter Zaitsev
Hi, Lets see If I can help. Overly long queries (transactions > in general) are bad for performance as a lot of unpurged versions > accumulate. > > In this sentence, I don't know the meaning about 'unpureged version > accumulate' > When rows are updated new versions are created. They are later

some problem of InnoDB performance optimization

2010-03-21 Thread Timo
Hi everyone: I read the presentation about InnodDB performance optimization what Heikki Tuuri written in april23 2007. But now I have some sentences don't know how to understanding. Can you help me? Overly long queries (transactions in general) are bad for performance as a lot of unpurged v