Re: mysql scaling questions

2007-12-31 Thread Ivan Voras
Kris Kennaway wrote: > Gergely CZUCZY wrote: >>> It looks like myisam is doing huge numbers of concurrent reads of the >>> same file which is running into exclusive locking in the kernel >>> (vnode interlock and lockbuilder mtxpool). Does it not do any >>> caching of the data in userspace but rel

Re: mysql scaling questions

2007-12-31 Thread Bruce Evans
On Mon, 31 Dec 2007, Ivan Voras wrote: Kris Kennaway wrote: It's a general question. It looks like myisam either has a design deficiency in this regard or it has poor defaults. If it can be made to improve caching of the data in userland then performance should improve. Isn't this common fo