Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- indexer
- {
- }
- searchd
- {
- listen = 127.0.0.1:9307:mysql41
- log = /vagrant/rlu/log/test.searchd.log
- query_log = /vagrant/rlu/log/test.searchd.query.log
- pid_file = /vagrant/rlu/log/test.sphinx.pid
- workers = threads
- binlog_path = /vagrant/rlu/tmp/binlog/test
- }
- source answer_core_0
- {
- type = pgsql
- sql_host = localhost
- sql_user = developer
- sql_pass = developer
- sql_db = rlu_test
- sql_query_pre = SET TIME ZONE UTC
- sql_query = SELECT "answers"."id" * 8 + 0 AS "id", "answers"."body" AS "body", "users"."email" AS "author", "answers"."id" AS "sphinx_internal_id", 'Answer' AS "sphinx_internal_class", 0 AS "sphinx_deleted", "answers"."user_id" AS "user_id", extract(epoch from "answers"."created_at")::int AS "created_at", extract(epoch from "answers"."updated_at")::int AS "updated_at" FROM "answers" LEFT OUTER JOIN "users" ON "users"."id" = "answers"."user_id" WHERE ("answers"."id" BETWEEN $start AND $end) GROUP BY "answers"."id", "answers"."body", "users"."email", "answers"."id", "answers"."user_id", "answers"."created_at", "answers"."updated_at"
- sql_query_range = SELECT COALESCE(MIN("answers"."id"), 1), COALESCE(MAX("answers"."id"), 1) FROM "answers"
- sql_attr_uint = sphinx_internal_id
- sql_attr_uint = sphinx_deleted
- sql_attr_uint = user_id
- sql_attr_timestamp = created_at
- sql_attr_timestamp = updated_at
- sql_attr_string = sphinx_internal_class
- sql_field_string = author
- }
- index answer_core
- {
- type = plain
- path = /vagrant/rlu/db/sphinx/test/answer_core
- docinfo = extern
- source = answer_core_0
- }
- source comment_core_0
- {
- type = pgsql
- sql_host = localhost
- sql_user = developer
- sql_pass = developer
- sql_db = rlu_test
- sql_query_pre = SET TIME ZONE UTC
- sql_query = SELECT "comments"."id" * 8 + 1 AS "id", "comments"."body" AS "body", "users"."email" AS "author", "comments"."id" AS "sphinx_internal_id", 'Comment' AS "sphinx_internal_class", 0 AS "sphinx_deleted", "comments"."user_id" AS "user_id", extract(epoch from "comments"."created_at")::int AS "created_at", extract(epoch from "comments"."updated_at")::int AS "updated_at" FROM "comments" LEFT OUTER JOIN "users" ON "users"."id" = "comments"."user_id" WHERE ("comments"."id" BETWEEN $start AND $end) GROUP BY "comments"."id", "comments"."body", "users"."email", "comments"."id", "comments"."user_id", "comments"."created_at", "comments"."updated_at"
- sql_query_range = SELECT COALESCE(MIN("comments"."id"), 1), COALESCE(MAX("comments"."id"), 1) FROM "comments"
- sql_attr_uint = sphinx_internal_id
- sql_attr_uint = sphinx_deleted
- sql_attr_uint = user_id
- sql_attr_timestamp = created_at
- sql_attr_timestamp = updated_at
- sql_attr_string = sphinx_internal_class
- sql_field_string = author
- }
- index comment_core
- {
- type = plain
- path = /vagrant/rlu/db/sphinx/test/comment_core
- docinfo = extern
- source = comment_core_0
- }
- source question_core_0
- {
- type = pgsql
- sql_host = localhost
- sql_user = developer
- sql_pass = developer
- sql_db = rlu_test
- sql_query_pre = SET TIME ZONE UTC
- sql_query = SELECT "questions"."id" * 8 + 2 AS "id", "questions"."title" AS "title", "questions"."body" AS "body", "users"."email" AS "author", "questions"."id" AS "sphinx_internal_id", 'Question' AS "sphinx_internal_class", 0 AS "sphinx_deleted", "questions"."user_id" AS "user_id", extract(epoch from "questions"."created_at")::int AS "created_at", extract(epoch from "questions"."updated_at")::int AS "updated_at" FROM "questions" LEFT OUTER JOIN "users" ON "users"."id" = "questions"."user_id" WHERE ("questions"."id" BETWEEN $start AND $end) GROUP BY "questions"."id", "questions"."title", "questions"."body", "users"."email", "questions"."id", "questions"."user_id", "questions"."created_at", "questions"."updated_at"
- sql_query_range = SELECT COALESCE(MIN("questions"."id"), 1), COALESCE(MAX("questions"."id"), 1) FROM "questions"
- sql_attr_uint = sphinx_internal_id
- sql_attr_uint = sphinx_deleted
- sql_attr_uint = user_id
- sql_attr_timestamp = created_at
- sql_attr_timestamp = updated_at
- sql_attr_string = sphinx_internal_class
- sql_field_string = title
- sql_field_string = author
- }
- index question_core
- {
- type = plain
- path = /vagrant/rlu/db/sphinx/test/question_core
- docinfo = extern
- source = question_core_0
- }
- source user_core_0
- {
- type = pgsql
- sql_host = localhost
- sql_user = developer
- sql_pass = developer
- sql_db = rlu_test
- sql_query_pre = SET TIME ZONE UTC
- sql_query = SELECT "users"."id" * 8 + 3 AS "id", "users"."email" AS "author", "users"."id" AS "sphinx_internal_id", 'User' AS "sphinx_internal_class", 0 AS "sphinx_deleted", "users"."id" AS "user_id", extract(epoch from "users"."created_at")::int AS "created_at", extract(epoch from "users"."updated_at")::int AS "updated_at" FROM "users" WHERE ("users"."id" BETWEEN $start AND $end) GROUP BY "users"."id", "users"."email", "users"."id", "users"."id", "users"."created_at", "users"."updated_at"
- sql_query_range = SELECT COALESCE(MIN("users"."id"), 1), COALESCE(MAX("users"."id"), 1) FROM "users"
- sql_attr_uint = sphinx_internal_id
- sql_attr_uint = sphinx_deleted
- sql_attr_uint = user_id
- sql_attr_timestamp = created_at
- sql_attr_timestamp = updated_at
- sql_attr_string = sphinx_internal_class
- sql_field_string = author
- }
- index user_core
- {
- type = plain
- path = /vagrant/rlu/db/sphinx/test/user_core
- docinfo = extern
- source = user_core_0
- }
- index answer
- {
- type = distributed
- local = answer_core
- }
- index comment
- {
- type = distributed
- local = comment_core
- }
- index question
- {
- type = distributed
- local = question_core
- }
- index user
- {
- type = distributed
- local = user_core
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement