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.