test/integration/app/config/ultrasphinx/development.conf.canonical in ultrasphinx-1.9 vs test/integration/app/config/ultrasphinx/development.conf.canonical in ultrasphinx-1.11

- old
+ new

@@ -1,18 +1,18 @@ -# Auto-generated at Sat Mar 08 03:07:27 -0500 2008. +# Auto-generated at Mon Mar 31 02:37:26 -0400 2008. # Hand modifications will be overwritten. # /Users/eweaver/Desktop/projects/ub/vendor/plugins/ultrasphinx/test/integration/app/config/ultrasphinx/default.base indexer { mem_limit = 256M } searchd { read_timeout = 5 max_children = 300 log = /tmp/sphinx/searchd.log - port = 3312 + port = 3313 max_matches = 100000 query_log = /tmp/sphinx/query.log seamless_rotate = 1 pid_file = /tmp/sphinx/searchd.pid address = 0.0.0.0 @@ -24,29 +24,32 @@ { sql_range_step = 5000 sql_query_post = sql_ranged_throttle = 0 -type = mysql -sql_query_pre = SET SESSION group_concat_max_len = 65535 -sql_query_pre = SET NAMES utf8 - + type = mysql + sql_query_pre = SET SESSION group_concat_max_len = 65535 + sql_query_pre = SET NAMES utf8 + sql_db = ultrasphinx_development sql_host = localhost sql_pass = sql_user = root sql_query_range = SELECT MIN(id) , MAX(id) FROM states -sql_query = SELECT (states.id * 5 + 0) AS id, CAST(GROUP_CONCAT(DISTINCT addresses.name SEPARATOR ' ') AS CHAR) AS address_name, 0 AS capitalization, 'Geo::State' AS class, 0 AS class_id, '' AS company, 0 AS company_facet, '' AS company_name, 0 AS company_name_facet, '' AS company_two, 0 AS company_two_facet, '' AS content, 18000 AS created_at, 0 AS deleted, '' AS email, '' AS login, '' AS mission_statement, '' AS name, '' AS state, 0 AS user_id FROM states LEFT OUTER JOIN addresses AS addresses ON states.id = addresses.state_id WHERE states.id >= $start AND states.id <= $end GROUP BY states.id +sql_query = SELECT (states.id * 5 + 0) AS id, CAST(GROUP_CONCAT(DISTINCT addresses.name SEPARATOR ' ') AS CHAR) AS address_name, 0 AS capitalization, 'Geo::State' AS class, 0 AS class_id, '' AS company, 0 AS company_facet, '' AS company_name, 0 AS company_name_facet, '' AS company_name_sortable, '' AS company_two, 0 AS company_two_facet, '' AS content, 18000 AS created_at, 0 AS deleted, '' AS email, 0 AS lat, 0 AS lng, '' AS login, '' AS mission_statement, '' AS mission_statement_sortable, '' AS name, '' AS state, 0 AS user_id FROM states LEFT OUTER JOIN addresses AS addresses ON states.id = addresses.state_id WHERE states.id >= $start AND states.id <= $end GROUP BY states.id sql_attr_float = capitalization sql_attr_uint = class_id sql_attr_uint = company_facet sql_attr_uint = company_name_facet +sql_attr_str2ordinal = company_name_sortable sql_attr_uint = company_two_facet sql_attr_timestamp = created_at sql_attr_bool = deleted -sql_attr_str2ordinal = mission_statement +sql_attr_float = lat +sql_attr_float = lng +sql_attr_str2ordinal = mission_statement_sortable sql_attr_uint = user_id sql_query_info = SELECT * FROM states WHERE states.id = (($id - 0) / 5) } @@ -56,29 +59,32 @@ { sql_range_step = 5000 sql_query_post = sql_ranged_throttle = 0 -type = mysql -sql_query_pre = SET SESSION group_concat_max_len = 65535 -sql_query_pre = SET NAMES utf8 - + type = mysql + sql_query_pre = SET SESSION group_concat_max_len = 65535 + sql_query_pre = SET NAMES utf8 + sql_db = ultrasphinx_development sql_host = localhost sql_pass = sql_user = root sql_query_range = SELECT MIN(id) , MAX(id) FROM sellers -sql_query = SELECT (sellers.id * 5 + 1) AS id, '' AS address_name, sellers.capitalization AS capitalization, 'Seller' AS class, 1 AS class_id, '' AS company, 0 AS company_facet, sellers.company_name AS company_name, CAST(CRC32(sellers.company_name) AS unsigned) AS company_name_facet, '' AS company_two, 0 AS company_two_facet, '' AS content, UNIX_TIMESTAMP(sellers.created_at) AS created_at, 0 AS deleted, '' AS email, '' AS login, sellers.mission_statement AS mission_statement, '' AS name, '' AS state, sellers.user_id AS user_id FROM sellers WHERE sellers.id >= $start AND sellers.id <= $end GROUP BY sellers.id +sql_query = SELECT (sellers.id * 5 + 1) AS id, '' AS address_name, sellers.capitalization AS capitalization, 'Seller' AS class, 1 AS class_id, '' AS company, 0 AS company_facet, sellers.company_name AS company_name, CAST(CRC32(sellers.company_name) AS unsigned) AS company_name_facet, sellers.company_name AS company_name_sortable, '' AS company_two, 0 AS company_two_facet, '' AS content, UNIX_TIMESTAMP(sellers.created_at) AS created_at, 0 AS deleted, '' AS email, 0 AS lat, 0 AS lng, '' AS login, sellers.mission_statement AS mission_statement, sellers.mission_statement AS mission_statement_sortable, '' AS name, '' AS state, sellers.user_id AS user_id FROM sellers WHERE sellers.id >= $start AND sellers.id <= $end GROUP BY sellers.id sql_attr_float = capitalization sql_attr_uint = class_id sql_attr_uint = company_facet sql_attr_uint = company_name_facet +sql_attr_str2ordinal = company_name_sortable sql_attr_uint = company_two_facet sql_attr_timestamp = created_at sql_attr_bool = deleted -sql_attr_str2ordinal = mission_statement +sql_attr_float = lat +sql_attr_float = lng +sql_attr_str2ordinal = mission_statement_sortable sql_attr_uint = user_id sql_query_info = SELECT * FROM sellers WHERE sellers.id = (($id - 1) / 5) } @@ -88,29 +94,32 @@ { sql_range_step = 5000 sql_query_post = sql_ranged_throttle = 0 -type = mysql -sql_query_pre = SET SESSION group_concat_max_len = 65535 -sql_query_pre = SET NAMES utf8 - + type = mysql + sql_query_pre = SET SESSION group_concat_max_len = 65535 + sql_query_pre = SET NAMES utf8 + sql_db = ultrasphinx_development sql_host = localhost sql_pass = sql_user = root sql_query_range = SELECT MIN(id) , MAX(id) FROM addresses -sql_query = SELECT (addresses.id * 5 + 2) AS id, '' AS address_name, 0 AS capitalization, 'Geo::Address' AS class, 2 AS class_id, '' AS company, 0 AS company_facet, '' AS company_name, 0 AS company_name_facet, '' AS company_two, 0 AS company_two_facet, CONCAT_WS(' ', addresses.line_1, addresses.line_2, addresses.city, addresses.province_region, addresses.zip_postal_code) AS content, 18000 AS created_at, 0 AS deleted, '' AS email, '' AS login, '' AS mission_statement, addresses.name AS name, state.name AS state, 0 AS user_id FROM addresses LEFT OUTER JOIN states AS state ON state.id = addresses.state_id WHERE addresses.id >= $start AND addresses.id <= $end GROUP BY addresses.id +sql_query = SELECT (addresses.id * 5 + 2) AS id, '' AS address_name, 0 AS capitalization, 'Geo::Address' AS class, 2 AS class_id, '' AS company, 0 AS company_facet, '' AS company_name, 0 AS company_name_facet, '' AS company_name_sortable, '' AS company_two, 0 AS company_two_facet, CONCAT_WS(' ', addresses.line_1, addresses.line_2, addresses.city, addresses.province_region, addresses.zip_postal_code) AS content, 18000 AS created_at, 0 AS deleted, '' AS email, RADIANS(addresses.lat) AS lat, RADIANS(addresses.lng) AS lng, '' AS login, '' AS mission_statement, '' AS mission_statement_sortable, addresses.name AS name, state.name AS state, 0 AS user_id FROM addresses LEFT OUTER JOIN states AS state ON state.id = addresses.state_id WHERE addresses.id >= $start AND addresses.id <= $end GROUP BY addresses.id sql_attr_float = capitalization sql_attr_uint = class_id sql_attr_uint = company_facet sql_attr_uint = company_name_facet +sql_attr_str2ordinal = company_name_sortable sql_attr_uint = company_two_facet sql_attr_timestamp = created_at sql_attr_bool = deleted -sql_attr_str2ordinal = mission_statement +sql_attr_float = lat +sql_attr_float = lng +sql_attr_str2ordinal = mission_statement_sortable sql_attr_uint = user_id sql_query_info = SELECT * FROM addresses WHERE addresses.id = (($id - 2) / 5) } @@ -120,29 +129,32 @@ { sql_range_step = 5000 sql_query_post = sql_ranged_throttle = 0 -type = mysql -sql_query_pre = SET SESSION group_concat_max_len = 65535 -sql_query_pre = SET NAMES utf8 - + type = mysql + sql_query_pre = SET SESSION group_concat_max_len = 65535 + sql_query_pre = SET NAMES utf8 + sql_db = ultrasphinx_development sql_host = localhost sql_pass = sql_user = root sql_query_range = SELECT MIN(id) , MAX(id) FROM users -sql_query = SELECT (users.id * 5 + 3) AS id, '' AS address_name, 0 AS capitalization, 'User' AS class, 3 AS class_id, specific_seller.company_name AS company, CAST(CRC32(specific_seller.company_name) AS unsigned) AS company_facet, '' AS company_name, 0 AS company_name_facet, REPLACE(sellers_two.company_name, '6', ' replacement ') AS company_two, CAST(CRC32(REPLACE(sellers_two.company_name, '6', ' replacement ')) AS unsigned) AS company_two_facet, '' AS content, 18000 AS created_at, users.deleted AS deleted, users.email AS email, users.login AS login, '' AS mission_statement, '' AS name, '' AS state, 0 AS user_id FROM users LEFT OUTER JOIN sellers AS specific_seller ON users.id = specific_seller.user_id LEFT OUTER JOIN sellers AS sellers_two ON users.id = sellers_two.user_id WHERE users.id >= $start AND users.id <= $end AND (deleted = '0') GROUP BY users.id +sql_query = SELECT (users.id * 5 + 3) AS id, '' AS address_name, 0 AS capitalization, 'User' AS class, 3 AS class_id, specific_seller.company_name AS company, CAST(CRC32(specific_seller.company_name) AS unsigned) AS company_facet, '' AS company_name, 0 AS company_name_facet, '' AS company_name_sortable, REPLACE(sellers_two.company_name, '6', ' replacement ') AS company_two, CAST(CRC32(REPLACE(sellers_two.company_name, '6', ' replacement ')) AS unsigned) AS company_two_facet, '' AS content, 18000 AS created_at, users.deleted AS deleted, users.email AS email, 0 AS lat, 0 AS lng, users.login AS login, '' AS mission_statement, '' AS mission_statement_sortable, '' AS name, '' AS state, 0 AS user_id FROM users LEFT OUTER JOIN sellers AS specific_seller ON users.id = specific_seller.user_id LEFT OUTER JOIN sellers AS sellers_two ON users.id = sellers_two.user_id WHERE users.id >= $start AND users.id <= $end AND (deleted = '0') GROUP BY users.id sql_attr_float = capitalization sql_attr_uint = class_id sql_attr_uint = company_facet sql_attr_uint = company_name_facet +sql_attr_str2ordinal = company_name_sortable sql_attr_uint = company_two_facet sql_attr_timestamp = created_at sql_attr_bool = deleted -sql_attr_str2ordinal = mission_statement +sql_attr_float = lat +sql_attr_float = lng +sql_attr_str2ordinal = mission_statement_sortable sql_attr_uint = user_id sql_query_info = SELECT * FROM users WHERE users.id = (($id - 3) / 5) } @@ -152,29 +164,32 @@ { sql_range_step = 5000 sql_query_post = sql_ranged_throttle = 0 -type = mysql -sql_query_pre = SET SESSION group_concat_max_len = 65535 -sql_query_pre = SET NAMES utf8 - + type = mysql + sql_query_pre = SET SESSION group_concat_max_len = 65535 + sql_query_pre = SET NAMES utf8 + sql_db = ultrasphinx_development sql_host = localhost sql_pass = sql_user = root sql_query_range = SELECT MIN(id) , MAX(id) FROM countries -sql_query = SELECT (countries.id * 5 + 4) AS id, '' AS address_name, 0 AS capitalization, 'Geo::Country' AS class, 4 AS class_id, '' AS company, 0 AS company_facet, '' AS company_name, 0 AS company_name_facet, '' AS company_two, 0 AS company_two_facet, '' AS content, 18000 AS created_at, 0 AS deleted, '' AS email, '' AS login, '' AS mission_statement, countries.name AS name, '' AS state, 0 AS user_id FROM countries WHERE countries.id >= $start AND countries.id <= $end GROUP BY countries.id +sql_query = SELECT (countries.id * 5 + 4) AS id, '' AS address_name, 0 AS capitalization, 'Geo::Country' AS class, 4 AS class_id, '' AS company, 0 AS company_facet, '' AS company_name, 0 AS company_name_facet, '' AS company_name_sortable, '' AS company_two, 0 AS company_two_facet, '' AS content, 18000 AS created_at, 0 AS deleted, '' AS email, 0 AS lat, 0 AS lng, '' AS login, '' AS mission_statement, '' AS mission_statement_sortable, countries.name AS name, '' AS state, 0 AS user_id FROM countries WHERE countries.id >= $start AND countries.id <= $end GROUP BY countries.id sql_attr_float = capitalization sql_attr_uint = class_id sql_attr_uint = company_facet sql_attr_uint = company_name_facet +sql_attr_str2ordinal = company_name_sortable sql_attr_uint = company_two_facet sql_attr_timestamp = created_at sql_attr_bool = deleted -sql_attr_str2ordinal = mission_statement +sql_attr_float = lat +sql_attr_float = lng +sql_attr_str2ordinal = mission_statement_sortable sql_attr_uint = user_id sql_query_info = SELECT * FROM countries WHERE countries.id = (($id - 4) / 5) } @@ -207,29 +222,32 @@ { sql_range_step = 5000 sql_query_post = sql_ranged_throttle = 0 -type = mysql -sql_query_pre = SET SESSION group_concat_max_len = 65535 -sql_query_pre = SET NAMES utf8 - + type = mysql + sql_query_pre = SET SESSION group_concat_max_len = 65535 + sql_query_pre = SET NAMES utf8 + sql_db = ultrasphinx_development sql_host = localhost sql_pass = sql_user = root sql_query_range = SELECT MIN(id) , MAX(id) FROM sellers WHERE sellers.updated_at > DATE_SUB(NOW(), INTERVAL 88200 SECOND) -sql_query = SELECT (sellers.id * 5 + 1) AS id, '' AS address_name, sellers.capitalization AS capitalization, 'Seller' AS class, 1 AS class_id, '' AS company, 0 AS company_facet, sellers.company_name AS company_name, CAST(CRC32(sellers.company_name) AS unsigned) AS company_name_facet, '' AS company_two, 0 AS company_two_facet, '' AS content, UNIX_TIMESTAMP(sellers.created_at) AS created_at, 0 AS deleted, '' AS email, '' AS login, sellers.mission_statement AS mission_statement, '' AS name, '' AS state, sellers.user_id AS user_id FROM sellers WHERE sellers.id >= $start AND sellers.id <= $end AND sellers.updated_at > DATE_SUB(NOW(), INTERVAL 88200 SECOND) GROUP BY sellers.id +sql_query = SELECT (sellers.id * 5 + 1) AS id, '' AS address_name, sellers.capitalization AS capitalization, 'Seller' AS class, 1 AS class_id, '' AS company, 0 AS company_facet, sellers.company_name AS company_name, CAST(CRC32(sellers.company_name) AS unsigned) AS company_name_facet, sellers.company_name AS company_name_sortable, '' AS company_two, 0 AS company_two_facet, '' AS content, UNIX_TIMESTAMP(sellers.created_at) AS created_at, 0 AS deleted, '' AS email, 0 AS lat, 0 AS lng, '' AS login, sellers.mission_statement AS mission_statement, sellers.mission_statement AS mission_statement_sortable, '' AS name, '' AS state, sellers.user_id AS user_id FROM sellers WHERE sellers.id >= $start AND sellers.id <= $end AND sellers.updated_at > DATE_SUB(NOW(), INTERVAL 88200 SECOND) GROUP BY sellers.id sql_attr_float = capitalization sql_attr_uint = class_id sql_attr_uint = company_facet sql_attr_uint = company_name_facet +sql_attr_str2ordinal = company_name_sortable sql_attr_uint = company_two_facet sql_attr_timestamp = created_at sql_attr_bool = deleted -sql_attr_str2ordinal = mission_statement +sql_attr_float = lat +sql_attr_float = lng +sql_attr_str2ordinal = mission_statement_sortable sql_attr_uint = user_id sql_query_info = SELECT * FROM sellers WHERE sellers.id = (($id - 1) / 5) } @@ -239,29 +257,32 @@ { sql_range_step = 5000 sql_query_post = sql_ranged_throttle = 0 -type = mysql -sql_query_pre = SET SESSION group_concat_max_len = 65535 -sql_query_pre = SET NAMES utf8 - + type = mysql + sql_query_pre = SET SESSION group_concat_max_len = 65535 + sql_query_pre = SET NAMES utf8 + sql_db = ultrasphinx_development sql_host = localhost sql_pass = sql_user = root sql_query_range = SELECT MIN(id) , MAX(id) FROM addresses -sql_query = SELECT (addresses.id * 5 + 2) AS id, '' AS address_name, 0 AS capitalization, 'Geo::Address' AS class, 2 AS class_id, '' AS company, 0 AS company_facet, '' AS company_name, 0 AS company_name_facet, '' AS company_two, 0 AS company_two_facet, CONCAT_WS(' ', addresses.line_1, addresses.line_2, addresses.city, addresses.province_region, addresses.zip_postal_code) AS content, 18000 AS created_at, 0 AS deleted, '' AS email, '' AS login, '' AS mission_statement, addresses.name AS name, state.name AS state, 0 AS user_id FROM addresses LEFT OUTER JOIN states AS state ON state.id = addresses.state_id WHERE addresses.id >= $start AND addresses.id <= $end GROUP BY addresses.id +sql_query = SELECT (addresses.id * 5 + 2) AS id, '' AS address_name, 0 AS capitalization, 'Geo::Address' AS class, 2 AS class_id, '' AS company, 0 AS company_facet, '' AS company_name, 0 AS company_name_facet, '' AS company_name_sortable, '' AS company_two, 0 AS company_two_facet, CONCAT_WS(' ', addresses.line_1, addresses.line_2, addresses.city, addresses.province_region, addresses.zip_postal_code) AS content, 18000 AS created_at, 0 AS deleted, '' AS email, RADIANS(addresses.lat) AS lat, RADIANS(addresses.lng) AS lng, '' AS login, '' AS mission_statement, '' AS mission_statement_sortable, addresses.name AS name, state.name AS state, 0 AS user_id FROM addresses LEFT OUTER JOIN states AS state ON state.id = addresses.state_id WHERE addresses.id >= $start AND addresses.id <= $end GROUP BY addresses.id sql_attr_float = capitalization sql_attr_uint = class_id sql_attr_uint = company_facet sql_attr_uint = company_name_facet +sql_attr_str2ordinal = company_name_sortable sql_attr_uint = company_two_facet sql_attr_timestamp = created_at sql_attr_bool = deleted -sql_attr_str2ordinal = mission_statement +sql_attr_float = lat +sql_attr_float = lng +sql_attr_str2ordinal = mission_statement_sortable sql_attr_uint = user_id sql_query_info = SELECT * FROM addresses WHERE addresses.id = (($id - 2) / 5) } @@ -271,28 +292,31 @@ { sql_range_step = 5000 sql_query_post = sql_ranged_throttle = 0 -type = mysql -sql_query_pre = SET SESSION group_concat_max_len = 65535 -sql_query_pre = SET NAMES utf8 - + type = mysql + sql_query_pre = SET SESSION group_concat_max_len = 65535 + sql_query_pre = SET NAMES utf8 + sql_db = ultrasphinx_development sql_host = localhost sql_pass = sql_user = root sql_query_range = SELECT MIN(id) , MAX(id) FROM users WHERE users.created_at > DATE_SUB(NOW(), INTERVAL 88200 SECOND) -sql_query = SELECT (users.id * 5 + 3) AS id, '' AS address_name, 0 AS capitalization, 'User' AS class, 3 AS class_id, specific_seller.company_name AS company, CAST(CRC32(specific_seller.company_name) AS unsigned) AS company_facet, '' AS company_name, 0 AS company_name_facet, REPLACE(sellers_two.company_name, '6', ' replacement ') AS company_two, CAST(CRC32(REPLACE(sellers_two.company_name, '6', ' replacement ')) AS unsigned) AS company_two_facet, '' AS content, 18000 AS created_at, users.deleted AS deleted, users.email AS email, users.login AS login, '' AS mission_statement, '' AS name, '' AS state, 0 AS user_id FROM users LEFT OUTER JOIN sellers AS specific_seller ON users.id = specific_seller.user_id LEFT OUTER JOIN sellers AS sellers_two ON users.id = sellers_two.user_id WHERE users.id >= $start AND users.id <= $end AND (deleted = '0') AND users.created_at > DATE_SUB(NOW(), INTERVAL 88200 SECOND) GROUP BY users.id +sql_query = SELECT (users.id * 5 + 3) AS id, '' AS address_name, 0 AS capitalization, 'User' AS class, 3 AS class_id, specific_seller.company_name AS company, CAST(CRC32(specific_seller.company_name) AS unsigned) AS company_facet, '' AS company_name, 0 AS company_name_facet, '' AS company_name_sortable, REPLACE(sellers_two.company_name, '6', ' replacement ') AS company_two, CAST(CRC32(REPLACE(sellers_two.company_name, '6', ' replacement ')) AS unsigned) AS company_two_facet, '' AS content, 18000 AS created_at, users.deleted AS deleted, users.email AS email, 0 AS lat, 0 AS lng, users.login AS login, '' AS mission_statement, '' AS mission_statement_sortable, '' AS name, '' AS state, 0 AS user_id FROM users LEFT OUTER JOIN sellers AS specific_seller ON users.id = specific_seller.user_id LEFT OUTER JOIN sellers AS sellers_two ON users.id = sellers_two.user_id WHERE users.id >= $start AND users.id <= $end AND (deleted = '0') AND users.created_at > DATE_SUB(NOW(), INTERVAL 88200 SECOND) GROUP BY users.id sql_attr_float = capitalization sql_attr_uint = class_id sql_attr_uint = company_facet sql_attr_uint = company_name_facet +sql_attr_str2ordinal = company_name_sortable sql_attr_uint = company_two_facet sql_attr_timestamp = created_at sql_attr_bool = deleted -sql_attr_str2ordinal = mission_statement +sql_attr_float = lat +sql_attr_float = lng +sql_attr_str2ordinal = mission_statement_sortable sql_attr_uint = user_id sql_query_info = SELECT * FROM users WHERE users.id = (($id - 3) / 5) }