mySQL Question.

[Jake]

We have mySQL running as a process, and have been told to change it to a threaded application instead. I dont know much about mySQL at all so I was wondering how to go about changing this. Thanks,

[Shaman]

The question is...

"which operating system"?

[Martin]

I would love to be able to do this for NT...

[Jake]

Hi Shaman,

Here is our server software: Apache/1.3.12 (Unix) (Red Hat/Linux) PHP/4.0.0 mod_perl/1.21 Thanks,

[Edited by Jake on 07-01-2000 at 01:00 AM]

[Shaman]

Then all you should have to do is recompile MySQL with the threading enabled. All Linux systems come with a compiler.

Or, if you prefer to use binary, check out [url]http://www.mysql.com[/url] and see if they have a threaded version available for download.

I always compile my own. {shrug}

[Jake]

Great, thanks Shaman :)

[John]

Jake,

Has it helped at all?

[Jake]

Yes John... We seemed to have fixed things finally :) After upgrading the processors to Dual 550's, and re-building our db each week things have begun to speed up quite conciderably.

[John]

Glad you have got it fixed. Was it using MySQL with the threading enabled that helped, or was it a combination of all the factors?

[Jake]

I would have to say that it was a combination of everything. We are still working on using vB to its full potential though, but we are a lot more happier with the preformace after doing all that is listed above.