Author Topic: (SOLVED) Lastest Dev patch: 015-08-26 bart39 Mrg: PR 1843 MARIADB  (Read 11650 times)

ruhllatio

  • Guest
Re: Lastest Dev patch: 015-08-26 bart39 Mrg: PR 1843 MARIADB
« Reply #15 on: 2015-08-29, 09:50:00 am »
Okay, the big difference there is censor is on MariaDB 10 (5.6) and you are on 5.5, dildo.  Scottia, are you 5.5 as well?  I'm positive the SphinxSE engine is upgraded in the 5.6 version vice the 5.5 one.  Unless you all upgraded to 10, I think I might have generate a second configuration file for Maria (and possibly all MySQL) 5.5 users.  Not hard... would someone be willing to try?

Offline scottia

  • Decent Indexer
  • ***
  • Posts: 53
  • Helpful: +3/-0
Re: Lastest Dev patch: 015-08-26 bart39 Mrg: PR 1843 MARIADB
« Reply #16 on: 2015-08-29, 10:03:21 am »
Maria 10.0.21 here

ruhllatio

  • Guest
Re: Lastest Dev patch: 015-08-26 bart39 Mrg: PR 1843 MARIADB
« Reply #17 on: 2015-08-29, 10:09:09 am »
What version of Sphinx?  2.2.9 is the current.  Might want to upgrade to that if you're not in the 2.2.x release train first.  Reason I say that is because the new config file will save a lot of HDD and memory space if you can get your installation working with it.  I would recommend trying this first.  Trust me, you really do want the memory savings.  Sphinx is a HOG.

Provided you can't update Sphinx, attached is the old config file with filename support added.  I am not re-adding guid as it is completely unnecessary.  Please do all the normal steps to rebuild the index etc using this config file instead and let me know the results.

Offline scottia

  • Decent Indexer
  • ***
  • Posts: 53
  • Helpful: +3/-0
Re: Lastest Dev patch: 015-08-26 bart39 Mrg: PR 1843 MARIADB
« Reply #18 on: 2015-08-29, 10:54:05 am »
upgrading to 2.2.9 has it working now. i upgraded from 2.1.9

i did not use the config you posted.  do i need it?

Offline dildo_baggins

  • Prolific Indexer
  • ****
  • Posts: 112
  • Helpful: +8/-0
Re: Lastest Dev patch: 015-08-26 bart39 Mrg: PR 1843 MARIADB
« Reply #19 on: 2015-08-29, 11:00:48 am »
upgraded to 10.2 of maria/sphinx 2.29 and didnt work but... i found the fix :)

it worked for me now and heres why.  with percona the plugin allows the max memory beyond the 1028M.  for MARIA the max is 2047M in our documentation we have it changed to 2048 (this should be amended to be a max of 1028M (up to 2047 is the max that can be added).  whenever i change the max above 2047/restart sphinx serach no results are given.

i.e.

# Memory limit, in bytes, kiloytes (16384K) or megabytes (256M)
   # Default is 32M, max is 2047M, recommended is 256M to 1024M
   # !*: http://sphinxsearch.com/docs/current.html#conf-mem-limit
   mem_limit      = 1024M


GOOD to go!
« Last Edit: 2015-08-29, 11:04:15 am by dildo_baggins »

ruhllatio

  • Guest
Re: Lastest Dev patch: 015-08-26 bart39 Mrg: PR 1843 MARIADB
« Reply #20 on: 2015-08-29, 11:03:21 am »
i did not use the config you posted.  do i need it?

Nope.  I'd prefer you didn't use it.  Was just a test.

ruhllatio

  • Guest
Re: Lastest Dev patch: 015-08-26 bart39 Mrg: PR 1843 MARIADB
« Reply #21 on: 2015-08-29, 11:06:36 am »
# Memory limit, in bytes, kiloytes (16384K) or megabytes (256M)
   # Default is 32M, max is 2047M, recommended is 256M to 1024M
   # !*: http://sphinxsearch.com/docs/current.html#conf-mem-limit
   mem_limit      = 1024M

GOOD to go!

Odd.  The config in dev branch has both rt_mem_limit and mem_limit set to 1024M.  Can the two not exceed 2047M together?

Offline dildo_baggins

  • Prolific Indexer
  • ****
  • Posts: 112
  • Helpful: +8/-0
Re: Lastest Dev patch: 015-08-26 bart39 Mrg: PR 1843 MARIADB
« Reply #22 on: 2015-08-29, 11:10:52 am »
just going by what the misc/sphinxsearch/readme recommended:

Edit the sphinx.conf file:

Everything should be good by default for linux, but you can get better performance by changing some settings. Specifically the rt_mem_limit and mem_limit settings, setting those to 2048M if you have the RAM will make a difference

Offline dildo_baggins

  • Prolific Indexer
  • ****
  • Posts: 112
  • Helpful: +8/-0
Re: Lastest Dev patch: 015-08-26 bart39 Mrg: PR 1843 MARIADB
« Reply #23 on: 2015-08-29, 11:16:05 am »
and so the shire is at peace.  the great ruhllatio hath vanquished the great dragon SphinxSE .

sorry to raise your blood pleasure.  you guys rule!

Offline censor

  • Junior Indexer
  • **
  • Posts: 22
  • Helpful: +3/-0
Re: Lastest Dev patch: 015-08-26 bart39 Mrg: PR 1843 MARIADB
« Reply #24 on: 2015-08-29, 11:31:32 am »
^--- what he says.