Page 1 of 1

Search Candidates

Posted: 01 Sep 2008, 10:12
by agus
Hi All,

I have a problem on my cats server
Server :
Cats-0.80.tar.gz
Linux Centos 4.5
Mysql, php, apache (centos), gcc
Memori 1 GB
CPU 4 Processor Xeon
Hardisk 36 GB SCSI

When i searching candidates its slowly and i see via top mysql take 100% CPU Usage, and the result response about 4-5 minutes,
how i can fix this? our cats server for LAN not publish to internet.

Thanks for advice

Re: Search Candidates

Posted: 01 Sep 2008, 11:07
by RussH
Hiya,

you're doing full-text search through uploaded CV's (resumes?). This is why people install sphinx;

http://www.opencats.org/wiki/index.php5 ... stallation

The Sphinx part is at the bottom of that page.

Re: Search Candidates

Posted: 01 Sep 2008, 11:45
by agus
Hi RussH,

Thanks for the advice i will try first, our specifications server it's recommend or not? i am afraid my server not enough for cats specification

:)

Thank you

Re: Search Candidates

Posted: 01 Sep 2008, 14:19
by RussH
agus wrote:Hi RussH,

Thanks for the advice i will try first, our specifications server it's recommend or not? i am afraid my server not enough for cats specification

:)

Thank you
Don't worry - I run CATS on an old Netfinity - Dual 800Mhz PIII CPU's with 1Gb RAM, so I'd say your spec is fine!

Re: Search Candidates

Posted: 01 Sep 2008, 16:54
by Jos
how many cv's have you stored?

Re: Search Candidates

Posted: 02 Sep 2008, 02:55
by agus
Hi Jos

Thanks for the reply, on my server i calculate the attachments directory is 5 GB with database 500 MB, i have try to install Sphinx, i will post later for the result, do you have another any idea to increase performance on searching candidates?


Thank you very much

Re: Search Candidates

Posted: 02 Sep 2008, 18:53
by Jos
I just readed your other post. Installing sphinx solved your issue.