Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- indexer
- {
- }
- searchd
- {
- address = 127.0.0.1
- port = 3312
- log = /Users/aroberts/Source/doggo/log/searchd.log
- query_log = /Users/aroberts/Source/doggo/log/searchd.query.log
- pid_file = /Users/aroberts/Source/doggo/log/searchd.development.pid
- max_matches = 20000
- }
- source dog_core_0
- {
- type = mysql
- sql_host = localhost
- sql_user = root
- sql_pass =
- sql_db = dog_dev
- sql_query_pre = UPDATE `dogs` SET `delta` = 0 WHERE `delta` = 1
- sql_query_pre = SET NAMES utf8
- sql_query = SELECT `dogs`.`id` * 1 + 0 AS `id` , CAST(`dogs`.`state` AS CHAR) AS `state`, CAST(`dogs`.`breed` AS CHAR) AS `breed`, CAST(`dogs`.`call_name` AS CHAR) AS `call_name`, CAST(`dogs`.`registered_name` AS CHAR) AS `registered_name`, CAST(`dogs`.`registration` AS CHAR) AS `registration`, CAST(`dogs`.`collaborator` AS CHAR) AS `collaborator`, CAST(`dogs`.`coat_color` AS CHAR) AS `coat_color`, CAST(`dogs`.`gender` AS CHAR) AS `gender`, CAST(`dogs`.`id` AS CHAR) AS `dog_id`, CAST(`dogs`.`broad_number` AS CHAR) AS `broad_number`, CAST(`dogs`.`collaborator_number` AS CHAR) AS `collaborator_number`, CAST(`dogs`.`notes` AS CHAR) AS `notes`, CAST(`dogs`.`related_dogs_health` AS CHAR) AS `related_dogs_health`, CAST(GROUP_CONCAT(DISTINCT CONCAT_WS(' ', `people`.`first_name`, `people`.`middle_name`, `people`.`last_name`) SEPARATOR ' ') AS CHAR) AS `owner_name`, CAST(GROUP_CONCAT(DISTINCT CONCAT_WS(' ', `people`.`address1`, `people`.`address2`, `people`.`city`, `people`.`state`, `people`.`postal_code`, `people`.`country`) SEPARATOR ' ') AS CHAR) AS `owner_address`, CAST(GROUP_CONCAT(DISTINCT `people`.`state` SEPARATOR ' ') AS CHAR) AS `owner_state`, CAST(GROUP_CONCAT(DISTINCT `people`.`phone` SEPARATOR ' ') AS CHAR) AS `owner_phone`, CAST(GROUP_CONCAT(DISTINCT `people`.`mobile_phone` SEPARATOR ' ') AS CHAR) AS `owner_mobile_phone`, CAST(GROUP_CONCAT(DISTINCT `people`.`email` SEPARATOR ' ') AS CHAR) AS `owner_email`, CAST(CONCAT_WS(' ', `vets_dogs`.`first_name`, `vets_dogs`.`last_name`) AS CHAR) AS `vet_name`, CAST(CONCAT_WS(' ', `vets_dogs`.`address1`, `vets_dogs`.`address2`, `vets_dogs`.`city`, `vets_dogs`.`state`, `vets_dogs`.`postal_code`, `vets_dogs`.`country`) AS CHAR) AS `vet_address`, CAST(`vets_dogs`.`phone` AS CHAR) AS `vet_phone`, CAST(`vets_dogs`.`mobile_phone` AS CHAR) AS `vet_mobile_phone`, CAST(`vets_dogs`.`email` AS CHAR) AS `vet_email`, CAST(GROUP_CONCAT(DISTINCT `diseases`.`name` SEPARATOR ' ') AS CHAR) AS `disease_name`, CAST(GROUP_CONCAT(DISTINCT `samples`.`lsid` SEPARATOR ' ') AS CHAR) AS `sample_lsid`, CAST(GROUP_CONCAT(DISTINCT `samples`.`freezer_address` SEPARATOR ' ') AS CHAR) AS `sample_freezer_address`, `dogs`.`id` AS `sphinx_internal_id`, 3110174621 AS `class_crc`, '3110174621' AS `subclass_crcs`, 0 AS `sphinx_deleted`, UNIX_TIMESTAMP(`dogs`.`born_on`) AS `born_on`, UNIX_TIMESTAMP(`dogs`.`created_at`) AS `created_at` FROM `dogs` LEFT OUTER JOIN `ownerships` ON (`dogs`.`id` = `ownerships`.`dog_id`) LEFT OUTER JOIN `people` ON (`people`.`id` = `ownerships`.`owner_id`) AND (`people`.`type` = 'Owner' ) LEFT OUTER JOIN `people` vets_dogs ON `vets_dogs`.id = `dogs`.vet_id AND (`vets_dogs`.`type` = 'Vet' ) LEFT OUTER JOIN `diagnoses` ON (`dogs`.`id` = `diagnoses`.`dog_id`) LEFT OUTER JOIN `diseases` ON (`diseases`.`id` = `diagnoses`.`disease_id`) LEFT OUTER JOIN `samples` ON samples.dog_id = dogs.id WHERE `dogs`.`id` >= $start AND `dogs`.`id` <= $end AND `dogs`.`delta` = 0 GROUP BY `dogs`.`id` ORDER BY NULL
- sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `dogs` WHERE `dogs`.`delta` = 0
- sql_attr_uint = sphinx_internal_id
- sql_attr_uint = class_crc
- sql_attr_uint = sphinx_deleted
- sql_attr_timestamp = born_on
- sql_attr_timestamp = created_at
- sql_attr_multi = uint subclass_crcs from field
- sql_query_info = SELECT * FROM `dogs` WHERE `id` = (($id - 0) / 1)
- }
- index dog_core
- {
- source = dog_core_0
- path = /Users/aroberts/Source/doggo/db/sphinx/development/dog_core
- morphology = stem_en
- charset_type = utf-8
- 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
- min_infix_len = 3
- enable_star = 1
- }
- source dog_delta_0 : dog_core_0
- {
- type = mysql
- sql_host = localhost
- sql_user = root
- sql_pass =
- sql_db = dog_dev
- sql_query_pre =
- sql_query_pre = SET NAMES utf8
- sql_query = SELECT `dogs`.`id` * 1 + 0 AS `id` , CAST(`dogs`.`state` AS CHAR) AS `state`, CAST(`dogs`.`breed` AS CHAR) AS `breed`, CAST(`dogs`.`call_name` AS CHAR) AS `call_name`, CAST(`dogs`.`registered_name` AS CHAR) AS `registered_name`, CAST(`dogs`.`registration` AS CHAR) AS `registration`, CAST(`dogs`.`collaborator` AS CHAR) AS `collaborator`, CAST(`dogs`.`coat_color` AS CHAR) AS `coat_color`, CAST(`dogs`.`gender` AS CHAR) AS `gender`, CAST(`dogs`.`id` AS CHAR) AS `dog_id`, CAST(`dogs`.`broad_number` AS CHAR) AS `broad_number`, CAST(`dogs`.`collaborator_number` AS CHAR) AS `collaborator_number`, CAST(`dogs`.`notes` AS CHAR) AS `notes`, CAST(`dogs`.`related_dogs_health` AS CHAR) AS `related_dogs_health`, CAST(GROUP_CONCAT(DISTINCT CONCAT_WS(' ', `people`.`first_name`, `people`.`middle_name`, `people`.`last_name`) SEPARATOR ' ') AS CHAR) AS `owner_name`, CAST(GROUP_CONCAT(DISTINCT CONCAT_WS(' ', `people`.`address1`, `people`.`address2`, `people`.`city`, `people`.`state`, `people`.`postal_code`, `people`.`country`) SEPARATOR ' ') AS CHAR) AS `owner_address`, CAST(GROUP_CONCAT(DISTINCT `people`.`state` SEPARATOR ' ') AS CHAR) AS `owner_state`, CAST(GROUP_CONCAT(DISTINCT `people`.`phone` SEPARATOR ' ') AS CHAR) AS `owner_phone`, CAST(GROUP_CONCAT(DISTINCT `people`.`mobile_phone` SEPARATOR ' ') AS CHAR) AS `owner_mobile_phone`, CAST(GROUP_CONCAT(DISTINCT `people`.`email` SEPARATOR ' ') AS CHAR) AS `owner_email`, CAST(CONCAT_WS(' ', `vets_dogs`.`first_name`, `vets_dogs`.`last_name`) AS CHAR) AS `vet_name`, CAST(CONCAT_WS(' ', `vets_dogs`.`address1`, `vets_dogs`.`address2`, `vets_dogs`.`city`, `vets_dogs`.`state`, `vets_dogs`.`postal_code`, `vets_dogs`.`country`) AS CHAR) AS `vet_address`, CAST(`vets_dogs`.`phone` AS CHAR) AS `vet_phone`, CAST(`vets_dogs`.`mobile_phone` AS CHAR) AS `vet_mobile_phone`, CAST(`vets_dogs`.`email` AS CHAR) AS `vet_email`, CAST(GROUP_CONCAT(DISTINCT `diseases`.`name` SEPARATOR ' ') AS CHAR) AS `disease_name`, CAST(GROUP_CONCAT(DISTINCT `samples`.`lsid` SEPARATOR ' ') AS CHAR) AS `sample_lsid`, CAST(GROUP_CONCAT(DISTINCT `samples`.`freezer_address` SEPARATOR ' ') AS CHAR) AS `sample_freezer_address`, `dogs`.`id` AS `sphinx_internal_id`, 3110174621 AS `class_crc`, '3110174621' AS `subclass_crcs`, 0 AS `sphinx_deleted`, UNIX_TIMESTAMP(`dogs`.`born_on`) AS `born_on`, UNIX_TIMESTAMP(`dogs`.`created_at`) AS `created_at` FROM `dogs` LEFT OUTER JOIN `ownerships` ON (`dogs`.`id` = `ownerships`.`dog_id`) LEFT OUTER JOIN `people` ON (`people`.`id` = `ownerships`.`owner_id`) AND (`people`.`type` = 'Owner' ) LEFT OUTER JOIN `people` vets_dogs ON `vets_dogs`.id = `dogs`.vet_id AND (`vets_dogs`.`type` = 'Vet' ) LEFT OUTER JOIN `diagnoses` ON (`dogs`.`id` = `diagnoses`.`dog_id`) LEFT OUTER JOIN `diseases` ON (`diseases`.`id` = `diagnoses`.`disease_id`) LEFT OUTER JOIN `samples` ON samples.dog_id = dogs.id WHERE `dogs`.`id` >= $start AND `dogs`.`id` <= $end AND `dogs`.`delta` = 1 GROUP BY `dogs`.`id` ORDER BY NULL
- sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `dogs` WHERE `dogs`.`delta` = 1
- sql_attr_uint = sphinx_internal_id
- sql_attr_uint = class_crc
- sql_attr_uint = sphinx_deleted
- sql_attr_timestamp = born_on
- sql_attr_timestamp = created_at
- sql_attr_multi = uint subclass_crcs from field
- sql_query_info = SELECT * FROM `dogs` WHERE `id` = (($id - 0) / 1)
- }
- index dog_delta : dog_core
- {
- source = dog_delta_0
- path = /Users/aroberts/Source/doggo/db/sphinx/development/dog_delta
- }
- index dog
- {
- type = distributed
- local = dog_delta
- local = dog_core
- }
Add Comment
Please, Sign In to add comment