Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- indexer
- {
- }
- searchd
- {
- listen = 127.0.0.1:9312
- log = /home/zequez/projects/ruby/1/log/searchd.log
- query_log = /home/zequez/projects/ruby/1/log/searchd.query.log
- pid_file = /home/zequez/projects/ruby/1/log/searchd.development.pid
- }
- source cimg_core_0
- {
- type = mysql
- sql_host = localhost
- sql_user = root
- sql_pass =
- sql_db = p1_development
- sql_sock = /var/run/mysqld/mysqld.sock
- sql_query_pre = UPDATE `cimgs` SET `delta` = 0 WHERE `delta` = 1
- sql_query_pre = SET NAMES utf8
- sql_query_pre = SET TIME_ZONE = '+0:00'
- sql_query = SELECT SQL_NO_CACHE `cimgs`.`id` * CAST(1 AS SIGNED) + 0 AS `id` , `cimgs`.`search_cache` AS `search_cache`, `cimgs`.`id` AS `sphinx_internal_id`, 0 AS `sphinx_deleted`, 3966122353 AS `class_crc`, `cimgs`.`approved` AS `approved` FROM `cimgs` WHERE (`cimgs`.`id` >= $start AND `cimgs`.`id` <= $end AND `cimgs`.`delta` = 0) GROUP BY `cimgs`.`id` ORDER BY NULL
- sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `cimgs` WHERE `cimgs`.`delta` = 0
- sql_attr_uint = sphinx_internal_id
- sql_attr_uint = sphinx_deleted
- sql_attr_uint = class_crc
- sql_attr_bool = approved
- sql_query_info = SELECT * FROM `cimgs` WHERE `id` = (($id - 0) / 1)
- }
- index cimg_core
- {
- source = cimg_core_0
- path = /home/zequez/projects/ruby/1/db/sphinx/development/cimg_core
- charset_type = utf-8
- }
- source cimg_delta_0 : cimg_core_0
- {
- type = mysql
- sql_host = localhost
- sql_user = root
- sql_pass =
- sql_db = p1_development
- sql_sock = /var/run/mysqld/mysqld.sock
- sql_query_pre =
- sql_query_pre = SET NAMES utf8
- sql_query_pre = SET TIME_ZONE = '+0:00'
- sql_query = SELECT SQL_NO_CACHE `cimgs`.`id` * CAST(1 AS SIGNED) + 0 AS `id` , `cimgs`.`search_cache` AS `search_cache`, `cimgs`.`id` AS `sphinx_internal_id`, 0 AS `sphinx_deleted`, 3966122353 AS `class_crc`, `cimgs`.`approved` AS `approved` FROM `cimgs` WHERE (`cimgs`.`id` >= $start AND `cimgs`.`id` <= $end AND `cimgs`.`delta` = 1) GROUP BY `cimgs`.`id` ORDER BY NULL
- sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `cimgs` WHERE `cimgs`.`delta` = 1
- sql_attr_uint = sphinx_internal_id
- sql_attr_uint = sphinx_deleted
- sql_attr_uint = class_crc
- sql_attr_bool = approved
- sql_query_info = SELECT * FROM `cimgs` WHERE `id` = (($id - 0) / 1)
- }
- index cimg_delta : cimg_core
- {
- source = cimg_delta_0
- path = /home/zequez/projects/ruby/1/db/sphinx/development/cimg_delta
- }
- index cimg
- {
- type = distributed
- local = cimg_delta
- local = cimg_core
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement