SmartCJ Support Forum

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,

Hi, yes, admin can setup sphinx on any server

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.

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

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?

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

Thanks, Yes, you are right. After adding cron to reindex its working fine.

Great)

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,

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