innodb and vbulletin 1.1

Hello, I have a few questions. First I work on a very high traffic site that uses vbulletin 1.1 to run its bb. The bb is very high traffic around 60-200 concurrent users. We are starting to run into some serious locking issues, and I am thinking about converting the high use tables(maby all)

Re: Server Problems

You may want to check your /tmp partion. it may be creating some temp tables. -t, --tmpdir=path Path for temporary files. It may be useful if your default /tmp directory resides on a partition too small to hold temporary tables. Byron [EMAIL PROTECTED] wrote: > Hello All, > > Background

thread_cache_size on linux

Hello, I am trying to tune mysql on linux for a web based application. Reading the docs I found thread_cache_size I checked what it was set to by default and found that it was 0. In the docs it says That it doesn't make much difference if you have a good thread implementation. So my ques

thread_cache_size on linux

I am trying to tune mysql on linux for a web based application. Reading throw the docs I found thread_cache_size I checked what it was set to by default and found that it was 0. In the docs it says That it doesn't make much difference if you have a good thread implementation. So my major question