Sphinx Question

tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Sphinx Question

Post by tubeman »

Hi,
If i'm using a separate mysql dedicated server for my sites can I implement Sphinx? I was seeing Docs, is there any changes incase of using Sphinx on seperate mysql server? Please let me know. Thanks.

Regards,
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Sphinx Question

Post by admin »

Hi, yes, admin can setup sphinx on any server
Don't forget to run script update
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Sphinx Question

Post by tubeman »

Hi,
Suppose I am using a seperate mysql server for my scj sites and I ask admin to setup sphinx on mysql server then

1.) Where do I need to create folder "scj/sphinx"? Will it be on the mysql server or front end server where the site is hosted?
2.) If the folder needs to be created on mysql server, then for each site I must create a new folder? Am slightly confused on this.

Please let me know. Thanks.
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Sphinx Question

Post by admin »

1. anywhere at the same server where sphinx is

2. you can use the same folder, just all the sphinx files for all Dbs gonna be in the same folder
Don't forget to run script update
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Sphinx Question

Post by tubeman »

Hi,
I'm using Sphinx 2.2.11-id64-release (95ae9a6) with version 2x of the script. I got admin to follow the docs and successfully connected to Sphinx. In admin area under List thumbs when I search for a term in Sphinx field example "blonde" I get only 2 thumbs on page 1 and when browsing to other pages I get different numbers of thumbs on each page. Even when searching on site I just get 2 thumbs. If I do a normal search just by ALt (title) I get accurate results. Any idea what could be wrong here and how do I debug this issue?
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Sphinx Question

Post by admin »

most likely You didn't reindex sphinx

for example

you have gallery ids 1,2,3,4,5
sphinx indexes DB
then you delete some galleries like so now DB has 1,2,5
when SmartCJ queries sphinx it returns ids 1,2,3,4,5 the script anticipates to get the same amount from DB, but DB returns only 3 items
Don't forget to run script update
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Sphinx Question

Post by tubeman »

Thanks, Yes, you are right. After adding cron to reindex its working fine.
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Sphinx Question

Post by admin »

Great)
Don't forget to run script update
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Sphinx Question

Post by tubeman »

Hi,
When using sphinx does the rotation on site happen only when we run indexer? Also in rotation logs what does this mean:

2020-07-07 23:17:01: No page cache 1761876269 (0.015614986419678, 0.0061600208282471)
2020-07-07 23:17:01: No page cache 1443613618 (0.015776872634888, 0.00015902519226074)

I'm seeing this alot in the logs on a few sites.

Regards,
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Sphinx Question

Post by admin »

Hi, no, rotation happens when you run rotation.php

indexer exists to update sphinx DB for searches

No page index happens when it tries to count pages that are not in cache anymore. You can safely ignore such messages
Don't forget to run script update
Post Reply