Hi together
I have only one question: why my memory consumption on the server is only 8.5 MB with an .sps file with 215 MB? Docs say, .sps would be load in memory…
ver: 2.7.0 GA / Windows Server 2016
best regards
Peter
my config:
source srcWissen
{
type = mysql
sql_db = *
sql_port = *
sql_query = SELECT SQL_NO_CACHE id,Begriff,wKey,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,tWissenTempl.Text AS Text,tWissenTempl.posOben AS posOben FROM tWissen,tWissenTempl WHERE tWissenTempl.Template = tWissen.Template
sql_host = localhost
sql_user = *
sql_pass = *
sql_field_string = Begriff
sql_field_string = wKey
sql_field_string = Text
sql_field_string = T1
sql_field_string = T2
sql_field_string = T3
sql_field_string = T4
sql_field_string = T5
sql_field_string = T6
sql_field_string = T7
sql_field_string = T8
sql_field_string = T9
sql_field_string = T10
sql_field_string = T11
sql_field_string = T12
sql_field_string = T13
sql_field_string = T14
sql_attr_uint = posOben
sql_query_pre = SET NAMES utf8
}index tWissen
{
source = srcWissen
path = d:/sphIndex/sphWissen
charset_table = 0…9, A…Z->a…z, _, a…z, U+A8->U+B8, U+B8, U+C0…U+DF->U+E0…U+FF, U+E0…U+FF, U+40
ignore_chars = U+0060
min_word_len = 2
min_prefix_len = 0
min_infix_len = 0
preopen = 1
#mlock = 1
}searchd
{
listen = 3360:mysql41
log = d:/sphIndex/Log/sphWissen.log
read_timeout = 5
pid_file = d:/sphIndex/Log/sphWissen.pid
workers = thread_pool
net_workers = 1
mysql_version_string = 5.1.73
binlog_path =
seamless_rotate = 1
qcache_max_bytes = 256000000
qcache_thresh_msec = 10
qcache_ttl_sec = 600
}indexer
{
mem_limit = 64M
write_buffer = 16M
}