Skip to content

Instantly share code, notes, and snippets.

@mrkurt
Created December 20, 2008 03:20
Show Gist options
  • Save mrkurt/38221 to your computer and use it in GitHub Desktop.
Save mrkurt/38221 to your computer and use it in GitHub Desktop.
source entry_source
{
type = mysql
strip_html = 0
index_html_attrs =
sql_host = localhost
sql_user = ###
sql_pass = ###
sql_db = ###
sql_port = 3306 # optional, default is 3306
sql_query = SELECT entry_id, entry_author_id, entry_ping_count, entry_excerpt, entry_atom_id, entry_status, entry_tangent_cache, entry_keywords, entry_category_id, entry_comment_count, entry_convert_breaks, UNIX_TIMESTAMP(entry_created_on) as entry_created_on, entry_pinged_urls, entry_text_more, entry_text, entry_modified_by, UNIX_TIMESTAMP(entry_authored_on) as entry_authored_on, entry_allow_pings, entry_blog_id, entry_to_ping_urls, entry_template_id, entry_allow_comments, entry_basename, UNIX_TIMESTAMP(entry_modified_on) as entry_modified_on, entry_class, entry_title, entry_week_number, entry_created_by FROM mt_entry WHERE entry_status = "2"
sql_group_column = entry_blog_id
sql_date_column = entry_modified_on
sql_date_column = entry_created_on
sql_date_column = entry_authored_on
sql_query_info = SELECT * from mt_entry where entry_id = $id
}
index entry_index
{
source = entry_source
path = /home/kurt/ars-technica-mt-bits/index/entry_index
morphology = stem_en
}
source comment_source
{
type = mysql
strip_html = 0
index_html_attrs =
sql_host = localhost
sql_user = movabletype
sql_pass = m0v4bl3typ3
sql_db = movabletype_small
sql_port = 3306 # optional, default is 3306
sql_query = SELECT comment_id, comment_commenter_id, comment_junk_score, comment_ip, comment_author, comment_parent_id, comment_entry_id, comment_email, UNIX_TIMESTAMP(comment_created_on) as comment_created_on, comment_text, comment_junk_status, comment_modified_by, comment_url, comment_blog_id, comment_visible, comment_last_moved_on, UNIX_TIMESTAMP(comment_modified_on) as comment_modified_on, comment_junk_log, comment_created_by FROM mt_comment WHERE comment_visible = "1"
sql_group_column = comment_blog_id
sql_group_column = comment_entry_id
sql_date_column = comment_modified_on
sql_date_column = comment_created_on
sql_query_info = SELECT * from mt_comment where comment_id = $id
}
index comment_index
{
source = comment_source
path = /home/kurt/ars-technica-mt-bits/index/comment_index
morphology = stem_en
}
#############################################################################
## indexer settings
#############################################################################
indexer
{
# memory limit
# can be specified in bytes, kilobytes (mem_limit=1000K) or megabytes (mem_limit=10M)
# will grow if set unacceptably low
# will warn if set too low, hurting the performance
# optional, default is 32M
mem_limit = 32M
}
#############################################################################
## searchd settings
#############################################################################
searchd
{
# port on which search daemon will listen
port = 3312
# log file
# searchd run info is logged here
log = /home/kurt/ars-technica-mt-bits/index/searchd.log
# query log file
# all the search queries are logged here
query_log = /home/kurt/ars-technica-mt-bits/index/query.log
# client read timeout, seconds
read_timeout = 5
# maximum amount of children to fork
# useful to control server load
max_children = 30
# a file which will contain searchd process ID
# used for different external automation scripts
# MUST be present
pid_file = /home/kurt/ars-technica-mt-bits/index/searchd.pid
# maximum amount of matches this daemon would retrieve from each index
# and serve to client
#
# this parameter affects per-client memory usage slightly (16 bytes per match)
# and CPU usage in match sorting phase; so blindly raising it to 1 million
# is definitely NOT recommended
#
# default is 1000 (just like with Google)
max_matches = 1000
}
# --eof--
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment