跟老美真难沟通...

传说中的奥运购票系统,老美设计的数据库,性能我就不想说什么了.在j仅30万并发注册情况下的等待事件...

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
enq: US - contention	353,366	10,219	29	39.0	Other
enq: SQ - contention	2,396	5,453	2,276	20.8	Configuration
log file sync	187,840	4,058	22	15.5	Commit
row cache lock	8,852	2,087	236	8.0	Concurrency
buffer busy waits	76,388	1,920	25	7.3	Concurrency

很明显的undo问题，热点块。。。跟老美交流居然说一点问题没有，我晕

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/76846/viewspace-1001912/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/76846/viewspace-1001912/