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,
Sphinx Question
Re: Sphinx Question
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.
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.
Re: Sphinx Question
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
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
Re: Sphinx Question
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?
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?
Re: Sphinx Question
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
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
Re: Sphinx Question
Thanks, Yes, you are right. After adding cron to reindex its working fine.
Re: Sphinx Question
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,
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,
Re: Sphinx Question
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
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