When run yum search xxx, got the following Error
Error Value: database disk image is malformed
A: run the following commands as ‘root’ and one by one
yum clean metadata
yum clean dbcache
yum makecache
Sphinx search for wiki /opt/sphinx/etc/sphinx.conf (my e.g.)
source src1
{
type = mysql
sql_host = localhost
sql_user = wiki1
sql_pass = wikipass
sql_db = mediawiki
sql_query = SELECT page_id, page_title, page_namespace, old_id, old_text \
FROM mywiki_page,mywiki_revision,mywiki_text \
WHERE rev_id=page_latest AND old_id=rev_text_id
sql_attr_uint = page_namespace
sql_attr_uint = old_id
sql_attr_timestamp = date_added
sql_ranged_throttle = 0
sql_query_info = SELECT * FROM GL_text WHERE old_id=$id
}
source src1throttled : src1
{
sql_ranged_throttle = 100
}
index wikipedia
{
source = src1
path = /opt/sphinx/var/data/wikipedia
docinfo = extern
mlock = 0
morphology = none
min_word_len = 1
charset_type = sbcs
html_strip = 0
}
index wikipediastemmed : wikipedia
{
path = /opt/sphinx/var/data/wikipediastemmed
morphology = stem_en
}
indexer
{
mem_limit = 512M
}
searchd
{
log = /opt/sphinx/var/log/searchd.log
query_log = /opt/sphinx/var/log/query.log
read_timeout = 5
client_timeout = 300
max_children = 30
pid_file = /opt/sphinx/var/log/searchd.pid
max_matches = 1000
seamless_rotate = 1
preopen_indexes = 0
unlink_old = 1
mva_updates_pool = 1M
max_packet_size = 8M
max_filters = 256
max_filter_values = 4096
}