{"id":507,"date":"2014-09-12T09:19:03","date_gmt":"2014-09-12T00:19:03","guid":{"rendered":"\/blog\/?p=507"},"modified":"2023-09-21T09:38:41","modified_gmt":"2023-09-21T00:38:41","slug":"%ea%b2%80%ec%83%89%ec%97%94%ec%a7%84-sphinx-%ec%82%ac%ec%9a%a9%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=507","title":{"rendered":"\uac80\uc0c9\uc5d4\uc9c4 sphinx \uc0ac\uc6a9\ubc29\ubc95"},"content":{"rendered":"\n

\uc18c\uac1c<\/span><\/b><\/p>

<\/div>

MySQL\uc5d0\uc11c \ub370\uc774\ud130 \uac80\uc0c9\uc2dc \ub370\uc774\ud130\uac00 \ub9ce\uc740 \uacbd\uc6b0 \uc790\ub8cc\ub97c \uac80\uc0c9\ud558\ub294\ub370 \uc18c\ubaa8\ub418\ub294 \uc2dc\uac04\uc774 \ud06c\ub2e4.<\/span><\/p>\n<\/span>

MySQL\uc758 \ub370\uc774\ud130\ub97c \ubcc4\ub3c4\uc758 \uac80\uc0c9\uc5d4\uc9c4\uc774 \uc778\ub371\uc2f1\ud558\uc5ec \uc778\ub371\uc2f1\uc744 \uac80\uc0c9\ud568\uc73c\ub85c\uc11c \uc2dc\uac04 \uc18c\ubaa8\ub97c \uc904\uc77c \uc218 \uc788\ub2e4.<\/span><\/p>\n<\/span>

\uc5ec\uae30\uc11c\ub294 \uc624\ud508\uc18c\uc2a4 \ud504\ub85c\uadf8\ub7a8\uc778 Sphinx \uac80\uc0c9 \uc5d4\uc9c4\uc744 \ub3c4\uc785\ud574\ubcf4\uace0, Sphinx \uac80\uc0c9\uc5d4\uc9c4\uacfc MySQL, \uadf8\ub9ac\uace0 PHP\uc640 \ud568\uaed8 \uc0ac\uc6a9\ud574\ub3c4\ub85d \ud55c\ub2e4.<\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

\uc124\uce58 \ud658\uacbd<\/span><\/b><\/span><\/p>

<\/div>


<\/p>\n<\/span>

OS : Debian 7 64Bit<\/span><\/p>\n<\/span>

S\/W : <\/span>MySQL : 5.6.11 \/ PHP 5.4.4-14<\/span><\/p>

\uc124\uce58\ud560 S\/W : Sphinx 2.0.8<\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>


<\/span><\/b><\/p>\n<\/span>

Sphinx \uc124\uce58<\/span><\/b><\/p>

<\/div>


<\/p>

1. \ud30c\uc77c \ubc1b\uae30<\/span><\/b><\/span><\/p>\n<\/span>

Sphinx \ud30c\uc77c\uc740 <\/span>Sphinx \ud648\ud398\uc774\uc9c0<\/span><\/a><\/span>\ub97c \ud1b5\ud574\uc11c \ubc1b\ub3c4\ub85d \ud55c\ub2e4.<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

Sphinx \uc555\ucd95 \ud30c\uc77c\uc774 \uc544\ub798 \uacbd\ub85c\uc5d0 \uc788\ub2e4\ub294 \uc124\uc815 \ud558\uc5d0 \uc124\uce58\ub97c \uc9c4\ud589\ud558\uba70, s<\/span>phinx-2.0.8-release\ud30c\uc77c\uc744 \uc55e\uc73c\ub85c sphinx\ub77c\uace0 \uc9c0\uce6d\ud558\uaca0\ub2e4.<\/span><\/p>\n<\/span>

\/home\/download\/sphinx.tar.gz <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>\n<\/span>


<\/span><\/b><\/p>\n<\/span>


<\/b><\/p>\n<\/span>

2. \uc555\ucd95 \ud574\uc81c<\/span><\/b><\/p>\n<\/span>

cd \/home\/download<\/span><\/p>\n<\/span>

tar xvfz sphinx.tar.gz<\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>\n<\/span>


<\/b><\/p>\n<\/span>


<\/b><\/p>\n<\/span>

3. \uc124\uce58 \ud658\uacbd \uc124\uc815<\/span><\/b><\/p>\n<\/span>

cd \/home\/download\/sphinx<\/span><\/p>\n<\/span>

.\/configure --prefix=\/usr\/local\/sphinx<\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>\n<\/span>


<\/b><\/p>\n<\/span>

--prefix \uc635\uc158\uc740 \uc124\uce58\uc2dc \uc124\uce58\ub418\ub294 \ud30c\uc77c\uc758 \uacbd\ub85c\ub97c \uc9c0\uc815\ud558\ub294 \uac83\uc73c\ub85c \uc5ec\uae30\uc11c\ub294 \/usr\/local\/sphinx\uc5d0 \uc124\uce58\ud558\ub3c4\ub85d \ud658\uacbd \uc124\uc815\uc744 \ubc14\uafbc\ub2e4.<\/span><\/p>


<\/p>


<\/p>

\ub9cc\uc57d \uc124\uce58 \uc9c4\ud589\uc2dc \uc124\uce58\uac00 \uc548\ub418\ub294 \uacbd\uc6b0 \uc544\ub798\ucc98\ub7fc make\uc640 gcc, g++\uc774 \uc124\uce58 \ub418\uc9c0 \uc54a\uc558\uc744 \uc218 \uc788\ub2e4.<\/span><\/p>

\uc544\ub798 \uba85\ub839\uc5b4\ub97c \ud1b5\ud574 \ud504\ub85c\uadf8\ub7a8\uc744 \uc124\uce58\ud574\uc900\ub2e4.<\/span><\/p>

apt-get install gcc<\/span><\/p>

apt-get install g++<\/span><\/p>

apt-get install make<\/span><\/p>

apt-get install build-essential<\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

4. \uc124\uce58<\/span><\/b><\/p>\n<\/span>

make -j4 install <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>\n<\/span>


<\/p>\n<\/span>

-j4\ub294 \uba40\ud2f0 \ucf54\uc5b4\uc778 \uacbd\uc6b0\uc5d0 \uc801\uc6a9\ub418\uba74 CPU \ud65c\uc6a9\ub960\uc744 \ub192\uc5ec \ub354 \ube60\ub974\uac8c \uc124\uce58\ud574\ub3c4\ub85d \ud574\uc8fc\ub294 \uc635\uc158\uc774\ub2e4.<\/span><\/p>\n<\/span>


<\/b><\/p>\n<\/span>


<\/b><\/p>\n<\/span>

5. \ud658\uacbd \uc124\uc815 \ud30c\uc77c \ubcf5\uc0ac<\/span><\/b><\/p>\n<\/span>

cd \/usr\/local\/sphinx\/etc<\/span> <\/span><\/p>\n<\/span>

cp sphinx-min.conf.dist sphinx.conf<\/span><\/p><\/td><\/tr><\/tbody><\/table>


<\/b><\/p>\n<\/span>

Sphinx\uc758 \ud658\uacbd \uc124\uc815 \ud30c\uc77c\uc744 \uc2e4\uc81c\ub85c \uc0ac\uc6a9\ud560 \uc774\ub984\uc778 sphinx.conf\uba85\uc73c\ub85c \ubcf5\uc0ac\ud55c\ub2e4.<\/span><\/p>


<\/p>

\uc774\uc81c Sphinx \ud504\ub85c\uadf8\ub7a8\uc744 \uc124\uce58\ud588\ub2e4.<\/span><\/p>

\ub2e4\uc74c 2\ubd80\uc5d0\uc11c\ub294 \uac04\ub2e8\ud55c \uc608\uc81c\uc640 \ud568\uaed8 Sphinx\uc640 MySQL\uc758 \uc5f0\ub3d9 \ubc0f \ud14c\uc2a4\ud2b8\ub97c \ud574\ubcf4\ub3c4\ub85d \ud558\uaca0\ub2e4.<\/span><\/p>


<\/p>

\uc18c\uac1c<\/span><\/b><\/span><\/p>

<\/div>

1\ubd80\uc5d0\uc11c \uc124\uce58\uc5d0 \uc774\uc5b4 2\ubd80\uc5d0\uc11c\ub294 Sphinx\uc640 MySQL\uc744 \uc5f0\ub3d9\ud574\ubcf4\uace0 MySQL\ucc98\ub7fc \ucffc\ub9ac\ubb38\uc744 \ud1b5\ud574 \uac04\ub2e8\ud55c \uac80\uc0c9\uc744 \ud574\ubcf4\ub3c4\ub85d \ud558\uc790.<\/span><\/p>\n<\/span>

\ucc38\uace0\ub85c \ub0b4\uc6a9\uc774 \ub9ce\uc544 \ubcf4\uc774\ub098 \ubcf5\uc7a1\ud558\uc9c4 \uc54a\ub2e4.<\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

1. SQL \ub370\uc774\ud130 \uc0bd\uc785<\/span><\/b><\/p>

<\/div>

\uc6b0\uc120 \uac04\ub2e8\ud55c \ud14c\uc2a4\ud2b8\ub97c \uc704\ud574 \uc544\ub798\uc758 \ud30c\uc77c\uc744 \ubc1b\uc544 MySQL\uc5d0 \ub123\ub3c4\ub85d \ud55c\ub2e4.<\/span>
<\/p>\n<\/span>

(Sphinx\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 example.sql\uc740 \ub370\uc774\ud130\uac00 \uc601\uc5b4\ub85c\ub9cc \ub418\uc5b4 \uc788\uc73c\ubbc0\ub85c \ud55c\uae00 \ud14c\uc2a4\ud2b8\uac00 \uc548\ub41c\ub2e4. \uac01\uc790 \uc54c\uc544\uc11c \ucc38\uace0 \uc790\ub8cc\ub85c \ud65c\uc6a9\ud558\ub3c4\ub85d \ud55c\ub2e4.)<\/span><\/p>\n<\/span>


<\/p>\n<\/span>\n<\/span>


<\/p>\n<\/span>

\"\" test.sql<\/span><\/a><\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

\uc544\ub798\uc758 \uba85\ub839\uc5b4\ub97c \ud1b5\ud574 test DB\uc5d0 \ub370\uc774\ud130\ub97c \ub123\ub3c4\ub85d \ud55c\ub2e4.<\/span><\/p>\n<\/span>

\ub9cc\uc57d test DB\uac00 \uc5c6\ub2e4\uba74, \uc218\ub3d9\uc73c\ub85c \ub9cc\ub4e4\uc5b4\uc918\uc57c \ud55c\ub2e4. \ub9cc\uc57d \ub2e4\ub978 DB\uc5d0 \ub123\uace0 \uc2f6\ub2e4\uba74 test\uba85\uc744 \ubc14\uafb8\uba74 \ub41c\ub2e4.<\/span><\/p>\n<\/span>

\uc880\ub354 \uc790\uc138\ud55c\uac74 <\/span>2013\/06\/21 - [Database\/MySQL] - [MySQL] MySQL DB\uc640 Table \ubc31\uc5c5 \ubc0f \ubcf5\uc6d0 \uad00\ub9ac<\/span><\/a> \uae00\uc744 \uc77d\ub3c4\ub85d \ud558\uc790.<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

mysql -u\uc544\uc774\ub514 -p test < test.sql <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>\n<\/span>


<\/p>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>


<\/p>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>

\ucc38\uace0\ub85c SQL \uc608\uc81c \ub370\uc774\ud130\ub294 \uc544\ub798\uc640 \uac19\uc740 \ub0b4\uc6a9\uc774\uba70, \ub370\uc774\ud130\ub294 \uc778\ud130\ub137\uc5d0 \ub5a0\ub3c4\ub294 SQL \ud30c\uc77c\uc744 \uc608\uc81c\uc5d0 \ub9de\uac8c \uc218\uc815\ud558\uc600\ub2e4.<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

<\/span><\/span><\/p>\n<\/span>


<\/p>\n<\/span>

<\/span><\/span><\/p>\n<\/span>


<\/p>\n<\/span>\n<\/span>


<\/p>\n<\/span>


<\/span><\/b><\/p>\n<\/span>

2. Sphinx \uc124\uc815<\/span><\/b><\/p>

\n<\/span>


<\/p>\n<\/span>

sphinx.conf \ud30c\uc77c\uc744 \uc124\uc815\ud558\ub294\ub370 \uc870\uae08 \ub9ce\uc740 \ub0b4\uc6a9\uc774 \uc788\ub2e4.<\/span><\/p>\n<\/span>

\uc774\uc81c \uc124\uc815\ud30c\uc77c\uc744 \uc5b4\ub5bb\uac8c \uc124\uc815\ud560\uc9c0 \ucd5c\ub300\ud55c \uac04\ub2e8\ud558\uac8c \uc124\uba85\ud558\uaca0\ub2e4.<\/span><\/p>\n<\/span>


<\/span><\/p>\n<\/span>

\uc544\ub798 \ub0b4\uc6a9\uc911 \ub2e4\ub8e8\uc9c0 \uc54a\uc740 \uc124\uc815\uc774 \uc788\uc73c\ub2c8 \ucca8\ubd80\ub41c \ud30c\uc77c\uc774\ub098, \ub354\ubcf4\uae30\ub97c \ud1b5\ud574 \ud655\uc778\ud558\uc5ec \uc608\uc81c\ub97c \uc9c4\ud589\ud558<\/span>\ub3c4\ub85d \ud55c\ub2e4.<\/span><\/p>\n<\/span>\n<\/span>


<\/p>\n<\/span>\n<\/span>


<\/p>\n<\/span>\n<\/span>


<\/p>\n<\/span>

\"\" sphinx.conf<\/span><\/a><\/span><\/p>\n<\/span>


<\/p>\n<\/span>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

1. \uc124\uc815\ud30c\uc77c \uc5f4\uae30<\/span><\/b><\/p>\n<\/span>


<\/p>\n<\/span>

\uc124\uc815 \ud30c\uc77c\uc744 \uc5f0\ub2e4.<\/span><\/p>\n<\/span>

vi \/usr\/local\/sphinx\/etc\/sphinx.conf <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

2. source \uc124\uc815<\/span><\/b><\/span><\/p>\n<\/span>


<\/p>\n<\/span>

sphinx.conf \ub0b4\uc6a9\uc911 source \ubd80\ubd84\uc774\ub2e4.<\/span><\/p>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>

source <\/span>zipcode<\/span><\/p>\n<\/span>

{<\/span><\/p>\n<\/span>

<\/span>type<\/span> <\/span>= mysql<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

<\/span>sql_host<\/span> <\/span>= localhost<\/span><\/p>\n<\/span>

<\/span>sql_user<\/span> <\/span>= <\/span>DB\uc544\uc774\ub514<\/span><\/p>\n<\/span>

<\/span>sql_pass<\/span> <\/span>= <\/span>DB\ud328\uc2a4\uc6cc\ub4dc<\/span><\/p>\n<\/span>

<\/span>sql_db<\/span> <\/span>= <\/span>DB\uba85<\/span><\/p>\n<\/span>

<\/span>sql_port<\/span> <\/span>= 3306<\/span> <\/span># optional, default is 3306<\/span><\/p>\n<\/span>

<\/span>sql_sock<\/span> <\/span>= \/tmp\/mysql.sock<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

<\/span>sql_query_pre = SET NAMES utf8<\/span><\/p>\n<\/span>

<\/span>sql_query = <\/span>SELECT sn, zipcode, state, city, suburb, address FROM zipcode<\/span> <\/span><\/p>\n<\/span>


<\/p>\n<\/span>

<\/span>sql_field_string<\/span> <\/span>= zipcode<\/span><\/p>\n<\/span>

<\/span>sql_field_string<\/span> <\/span>= state<\/span><\/p>\n<\/span>

<\/span>sql_field_string<\/span> <\/span>= city<\/span><\/p>\n<\/span>

<\/span>sql_field_string<\/span> <\/span>= suburb<\/span><\/p>\n<\/span>

<\/span>sql_field_string<\/span> <\/span>= address<\/span><\/p>\n<\/span>

}<\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>\n<\/span>


<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

source \ubd80\ubd84\uc5d0\uc11c\ub294 \uc778\ub371\uc2a4\uba85\uc744 \uc9c0\uc815\ud558\uace0, \uc5b4\ub5a4 \ub370\uc774\ud130\ub97c \uc778\ub371\uc2f1 \ud560 \uac83\uc774\uc9c0 \ub4f1\ub4f1 \uc124\uc815\ud558\ub294 \ubd80\ubd84\uc774\ub2e4.<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

source\uba85 : zipcode (\ud14c\uc774\ube14\uba85\uc73c\ub85c \ud558\ub294 \uac83\uc774 \ud3b8\ud558\ub2e4.)<\/span><\/p>\n<\/span>

sql_query_pre : \ud55c\uae00 \ub370\uc774\ud130\ub97c \uc704\ud574 utf8\ub85c \uc124\uc815\ud55c\ub2e4.<\/span><\/p>\n<\/span>

sql_query : \uc5b4\ub5a4 \ub370\uc774\ud130\ub97c \uc778\ub371\uc2f1 \ud558\uae30 \uc704\ud574\uc11c\ub294 MySQL\ub85c\ubd80\ud130 \ub370\uc774\ud130\ub97c \uac00\uc838\uc640\uc57c \ud55c\ub2e4. \uc790\uc2e0\uc774 Sphinx\ub97c \ud1b5\ud574 \uac80\uc0c9 \ud560 \ub370\uc774\ud130 \ub0b4\uc6a9, \uac80\uc0c9 \uacb0\uacfc\uc5d0 \ud45c\uc2dc\ud560 \ub0b4\uc6a9\uc744 \ud3ec\ud568\ud558\ub3c4\ub85d MySQL \ucffc\ub9ac\ubb38\uc744 \uc791\uc131\ud558\uba74 \ub41c\ub2e4. <\/span>\ub2e8, \uccab\ubc88\uc9f8 \ud544\ub4dc\ub294 \uc808\ub300\ub85c \uc911\ubcf5\ub418\uc9c0 \uc54a\ub294 Primary Key \ub610\ub294 Unique Key \uac12\uc744 \uc918\uc57c \ud55c\ub2e4. \ub530\ub77c\uc11c \uc774\ub7f0 \ud544\ub4dc\uac00 \uc5c6\ub2e4\uba74 DB\uc5d0 \ub9cc\ub4e4\uc5b4\uc57c \ud55c\ub2e4.<\/span><\/p>\n<\/span>

sql_field_string : Sphnx\uac00 \ub370\uc774\ud130\ub97c \ub2e4\ub8e8\uae30 \uc704\ud574 \ud544\uc694\ud55c \uc120\uc5b8\uc774\ub77c\uace0 \uc0dd\uac01\ud558\uba74 \ub41c\ub2e4. \uc989, \ub370\uc774\ud130 \ud0c0\uc785\uc744 \uc9c0\uc815\ud574\uc8fc\ub294 \uac83\uc73c\ub85c int, string, float \ub4f1 \uc774\ub77c\uace0 \uc0dd\uac01\ud558\uba74 \ub41c\ub2e4.<\/span><\/p>\n<\/span>

sql_field_string \uc678\uc5d0 \uc544\ub798\uc640 \uac19\uc740 \ub370\uc774\ud130 \ud0c0\uc785\uc774 \uc788\ub2e4.<\/span><\/p>\n<\/span>

sql_attr_uint<\/span><\/p>\n<\/span>

sql_attr_bigint<\/span><\/p>\n<\/span>

sql_attr_timestamp<\/span><\/p>\n<\/span>

...<\/span><\/p>\n<\/span>

...<\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

\uc77c\ub2e8\uc740 \uc815\uc0c1\uc801\uc778 \uc2e4\ud589\uc774 \ub418\ub294\uc9c0 \ud655\uc778\ud558\uae30 \uc704\ud55c \ucc28\uc6d0\uc774\ubbc0\ub85c <\/span>\ub370\uc774\ud130 \ud615\ud0dc\uc5d0 \ub530\ub978 \ucc28\uc774\uc640 \uadf8\uc5d0\ub300\ud55c \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ub2e4\uc74c 3\ubd80\uc5d0\uc11c \ub2e4\ub8e8\ub3c4\ub85d \ud558\uaca0\ub2e4. <\/span>(\uc911\uc694\ud558\uae30 \ub54c\ubb38\uc5d0 \ud544\uc218\uc801\uc73c\ub85c \ubd10\uc57c \ud560 \uac83\uc774\ub2e4.)<\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>


<\/p><\/div>

<\/table>\n<\/span>

2. index \uc124\uc815<\/span><\/b><\/p>\n<\/span>

index \uc124\uc815\uc5d0\ub294 \ud55c\uae00 \uc124\uc815, \uac80\uc0c9 \ubc29\ubc95 \ub4f1\ub4f1\uc758 \uc124\uc815\uc744 \ub2e4\ub8e8\uac8c \ub41c\ub2e4.<\/span><\/p>\n<\/span>


<\/b><\/p>\n<\/span>

sphinx.conf \ub0b4\uc6a9\uc911 index \ubd80\ubd84\uc774\ub2e4.<\/span><\/p>

index <\/span>zipcode<\/span><\/p>\n<\/span>

{<\/span><\/p>\n<\/span>

<\/span>source<\/span> <\/span>= zipcode<\/span><\/p>\n<\/span>

<\/span>path<\/span> <\/span>= \/usr\/local\/sphinx\/var\/data\/<\/span>zipcode<\/span><\/p>\n<\/span>

<\/span>docinfo<\/span> <\/span>= extern<\/span><\/p>\n<\/span>

<\/span>charset_type<\/span> <\/span>= <\/span>utf-8<\/span><\/p>\n<\/span>

<\/span>charset_table = <\/span>0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

<\/span>ngram_len = 1<\/span><\/p>\n<\/span>

<\/span>ngram_chars =  <\/span>U+4E00..U+9FBB,\n U+3400..U+4DB5, U+20000..U+2A6D6, U+FA0E, U+FA0F, U+FA11, U+FA13, \nU+FA14, U+FA1F, U+FA21, U+FA23, U+FA24, U+FA27, U+FA28, U+FA29, \nU+3105..U+312C, U+31A0..U+31B7, U+3041, U+3043, U+3045, U+3047, U+3049, \nU+304B, U+304D, U+304F, U+3051, U+3053, U+3055, U+3057, U+3059, U+305B, \nU+305D, U+305F, U+3061, U+3063, U+3066, U+3068, U+306A..U+306F, U+3072, \nU+3075, U+3078, U+307B, U+307E..U+3083, U+3085, U+3087, U+3089..U+308E, \nU+3090..U+3093, U+30A1, U+30A3, U+30A5, U+30A7, U+30A9, U+30AD, U+30AF, \nU+30B3, U+30B5, U+30BB, U+30BD, U+30BF, U+30C1, U+30C3, U+30C4, U+30C6, \nU+30CA, U+30CB, U+30CD, U+30CE, U+30DE, U+30DF, U+30E1, U+30E2, U+30E3, \nU+30E5, U+30E7, U+30EE, U+30F0..U+30F3, U+30F5, U+30F6, U+31F0, U+31F1, \nU+31F2, U+31F3, U+31F4, U+31F5, U+31F6, U+31F7, U+31F8, U+31F9, U+31FA, \nU+31FB, U+31FC, U+31FD, U+31FE, U+31FF, U+AC00..U+D7A3, U+1100..U+1159, \nU+1161..U+11A2, U+11A8..U+11F9, U+A000..U+A48C, U+A492..U+A4C6<\/span><\/font><\/p>\n<\/span>


<\/p>\n<\/span>

} <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

index\uba85 : source\uba85\uacfc \ub3d9\uc77c\ud558\uac8c \ud574\uc900\ub2e4.<\/span><\/p>\n<\/span>

path : \uc778\ub371\uc2a4\ud55c \ud30c\uc77c\uc774 \uc800\uc7a5\ub418\ub294 \uc7a5\uc18c\ub2e4. \uc704\uce58\ub294 \uc0c1\uad00\uc5c6\uc9c0\ub9cc \ub370\uc774\ud130\uba85\uc740 \uc27d\uac8c \uc54c\uc544\ubcf4\uae30 \uc704\ud574 source\uba85\uacfc \ub3d9\uc77c\ud558\uac8c \ucc98\ub9ac\ud574 \uc8fc\ub3c4\ub85d \ud55c\ub2e4.<\/span><\/p>\n<\/span>

charset_type : \ud55c\uae00 \uc124\uc815\uc744 \uc704\ud574 utf-8\ub85c \ud574\uc900\ub2e4.<\/span><\/p>\n<\/span>

charset_table : sphinx.conf.dist \ud30c\uc77c\uc744 \uc5f4\uc5b4\ubcf4\uba74 utf-8 \uae30\ubcf8\uac12\uc73c\ub85c \uc774\ubbf8 \uc704\ucc98\ub7fc \uc124\uc815\ub418\uc5b4 \uc788\ub2e4. \uadf8\ub300\ub85c \ubcf5\uc0ac\ud574 \uc0ac\uc6a9\ud55c\ub2e4.<\/span><\/p>\n<\/span>

ngram_len : \ud55c\uae00 \uac80\uc0c9\uc744 \uc704\ud574 ngram\uc744 \uc124\uc815\ud574\uc57c \ud55c\ub2e4. 1\uac12\uc73c\ub85c \uc124\uc815\ud55c\ub2e4.<\/span><\/p>\n<\/span>

ngram_chars : ngram\uc744 \uac80\uc0c9\ud558\uae30 \uc704\ud574 \ub098\ub20c \ub2e8\uc704\ub97c \uc124\uc815\ud55c\ub2e4. \ud55c\uad6d\uc5b4, \uc911\uad6d\uc5b4, \uc77c\ubcf8\uc5b4 \ubaa8\ub450 \uac80\uc0c9\uc774 \uac00\ub2a5\ud558\ub3c4\ub85d CJK\ub97c \uc0ac\uc6a9\ud558\uba70 \ub41c\ub2e4.<\/span><\/p>\n<\/span>

(CJK <\/span>http:\/\/sphinxsearch.com\/wiki\/doku.php?id=charset_tables#cjk_ngram_characters<\/span><\/a>)<\/span><\/p>\n<\/span>


<\/p>\n<\/span>\n<\/span>


<\/p>

n-gram\uc774\ub780?<\/span><\/p><\/div>


<\/div>

<\/div>
3. rt \uc124\uc815<\/span><\/b><\/div>

<\/b><\/div>
rt\ub97c \uc774\uc6a9\ud558\uba74 \uc778\ub371\uc2f1\ub41c \ub370\uc774\ud130\ub97c \uc2e4\uc2dc\uac04\uc73c\ub85c \uc218\uc815 \ud560 \uc218 \uc788\ub2e4\ub294\ub370, \uc0ac\uc6a9\ud574 \ubcf8\uc801\uc774 \uc5c6\uc73c\uba70, \ubcf8 \uae00\uc5d0\uc11c rt\ubd80\ubd84\uc744 \ub2e4\ub8e8\uc9c0 \uc54a\uc73c\ubbc0\ub85c \ud328\uc2a4\ud55c\ub2e4. <\/span><\/div>
(\uadf8\ub0e5 \uae30\ubcf8\uc73c\ub85c \ub450\uac70\ub098, \uc0ad\uc81c\ud558\uac70\ub098 \uc8fc\uc11d\ucc98\ub9ac\ud55c\ub2e4.)<\/span><\/div>
<\/table>\n<\/span>


<\/p>\n<\/span>

sphinx.conf \ub0b4\uc6a9\uc911 type\uc774 rt\uc778 index \ubd80\ubd84\uc774\ub2e4.<\/span><\/p>

index zipcodert<\/span><\/p>\n<\/span>

{<\/span><\/p>\n<\/span>

<\/span>type<\/span> <\/span>= rt<\/span><\/p>\n<\/span>

<\/span>rt_mem_limit<\/span> <\/span>= 32M<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

<\/span>path<\/span> <\/span>= \/usr\/local\/sphinx\/var\/data\/zipcodert<\/span><\/p>\n<\/span>

<\/span>charset_type<\/span> <\/span>= utf-8<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

<\/span>rt_field<\/span> <\/span>= state<\/span><\/p>\n<\/span>

} <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>
<\/div>


<\/div>

<\/div>

\uadf8\uc678 sphinx.conf \ub0b4\uc6a9<\/span><\/p>


<\/div>

<\/b><\/span><\/div>

<\/b><\/span><\/div>
2. Sphinx \uc778\ub371\uc2f1<\/span><\/b><\/span>
<\/div>


<\/p><\/b><\/span><\/div>

MySQL\ub85c\ubd80\ud130 \uac80\uc0c9 \ubc0f \uac80\uc0c9 \uacb0\uacfc\ub97c \uc904 \ub370\uc774\ud130\ub97c Sphinx\uc5d0\uc11c \uac80\uc0c9\uc774 \ub418\ub3c4\ub85d \uc778\ub371\uc2f1\uc744 \ud558\ub3c4\ub85d \ud55c\ub2e4.<\/span><\/div>
\uba85\ub839\uc5b4\ub294 indexer\ub97c \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4.<\/span><\/div>

<\/span><\/div>
indexer \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uae30 \uc704\ud574 \uc544\ub798 \uc704\uce58\ub85c \uc774\ub3d9\ud55c\ub2e4.<\/span><\/div>
\ub9cc\uc57d \uc5b4\ub290 \uc704\uce58\uc5d0\uc11c\ub4e0 indexer \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\ub824\uba74 \ub2e4\uc74c \uae00\uc744 \ucc38\uace0\ud558\ub3c4\ub85d \ud55c\ub2e4. <\/span>

2013\/06\/22 - [Linux Debian 7] - [Debain] PATH \uc124\uc815<\/span><\/a><\/p>\n<\/span>


<\/p><\/span><\/div>

cd \/usr\/local\/sphinx\/bin <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>\n<\/span>


<\/p>\n<\/span>

\uc778\ub371\uc2f1\uc744 \ud55c\ub2e4.<\/span><\/p><\/span>

.\/indexer --all <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>\n<\/span>


<\/p>\n<\/span>

\uc544\ub798\uc640 \uac19\uc740 \uc778\ub371\uc2f1 \uacb0\uacfc\uac00 \ub098\ud0c0\ub09c\ub2e4.<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

<\/span><\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

\uadf8\uc678 \uc544\ub798\uc640 \uac19\uc740 \uc635\uc158\uc774 \uc788\ub2e4.<\/span><\/p>\n<\/span>


<\/span><\/p>\n<\/span>

--all : \uc124\uc815\ub41c \ubaa8\ub4e0 \ub9ac\uc2a4\ud2b8<\/span>\ub97c \uc778\ub371\uc2f1 \ud55c\ub2e4.<\/span><\/p><\/span><\/div>

--rotate : searchd \ud504\ub85c\uc138\uc2a4\uac00 \uc11c\ube44\uc2a4 \uc911\uc77c\ub54c \uc0ac\uc6a9\ud55c\ub2e4.<\/span><\/div>
--merge : \uc778\ub371\uc2f1\ub41c \ud30c\uc77c\uc744 \ud569\uce5c\ub2e4.<\/span><\/div>

<\/div>
\uc790\uc138\ud55c \uc0ac\uc6a9\uc740 \ub098\uc911\uc5d0 \uc124\uba85\ud558\uaca0\ub2e4.<\/span><\/div>

<\/div>

<\/div>

<\/div>
3. SphinxQL \uc0ac\uc6a9<\/span><\/b>
<\/div>


<\/p><\/b><\/div>

MySQL\ucc98\ub7fc Sphinx\ub3c4 SphinxQL\uc774\ub77c\ub294 \uac83\uc774 \uc788\ub2e4.<\/span><\/div>
\uc774\uc81c SphinxQL\uc744 \uc0ac\uc6a9\ud574\uc11c \uac80\uc0c9\uc774 \uc815\uc0c1\uc801\uc73c\ub85c \ub418\ub294\uc9c0 \ud655\uc778\ud558\ub3c4\ub85d \ud558\uc790.<\/span><\/div>

<\/div>
\uc6b0\uc120 Sphinx\uc5d0 \uc811\uc18d\ud558\uae30 \uc704\ud574 searchd\ub97c \uc2e4\ud589\uc2dc\ud0a4\ub3c4\ub85d \ud55c\ub2e4. searchd\uac00 \uc911\ub2e8\ub418\uc5b4 \uc788\ub2e4\uba74 \uc811\uc18d\uc774 \uac70\ubd80\ub41c\ub2e4.<\/span><\/div>

cd \/usr\/local\/sphinx\/bin<\/span><\/p>\n<\/span>

.\/searchd <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>\n<\/span>


<\/p>\n<\/span>

\uc811\uc18d\ud558\ub3c4\ub85d \ud55c\ub2e4.<\/span><\/p>\n<\/span>

mysql -h0 -P9306 <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>\n<\/span>


<\/p><\/div>

<\/span><\/span><\/p>\n<\/span>


<\/p>\n<\/span>

SphinxQL\uc740 MySQL\uc758 \ucffc\ub9ac\ubb38\uacfc\ub294 \uc870\uae08 \ub2e4\ub974\ub098 \uc544\uc8fc \uae30\ubcf8\uc801\uc778 SELECT \ubb38\uc740 \uac19\uc73c\ubbc0\ub85c \uc77c\ub2e8 \uc544\ub798\ucc98\ub7fc \ud55c\ub2e4.<\/span><\/p>\n<\/span>

\ucc38\uace0\ud560 \uc810\uc740 FROM \ub4a4\uc5d0 \uc624\ub294 Table\uba85\uc740 \uc544\uae4c sphinx.conf \uc124\uc815\uc5d0 \uc0ac\uc6a9\ud588\ub358 index\uba85\uc744 \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4\ub294 \uc810\uc774\ub2e4.<\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

SELECT * FROM zipcode; <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

\uc774\uc81c \uc544\ub798\ucc98\ub7fc \uac80\uc0c9 \uacb0\uacfc\uac00 \ub098\uc624\uba74 Sphinx\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc2e4\ud589\ub41c \uac83\uc774\ub2e4.<\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

<\/span><\/span><\/p>\n<\/span>


<\/p><\/div>


<\/p>\n<\/span>


<\/p><\/div><\/div>

Sphinx 3\ubd80\uc5d0\uc11c\ub294 SphixQL\uacfc \uc124\uc815\ud30c\uc77c\uc758 \uc0c1\uc138\ud55c \uc124\uc815\uc5d0 \ub300\ud574 \uc124\uba85\ud558\uaca0\ub2e4.<\/span><\/p>


<\/p>

\uc18c\uac1c<\/span><\/b><\/p>

<\/div>


<\/p>\n<\/span>

2\ubd80\uc5d0\uc11c\ub294 \uac04\ub2e8\ud55c \uc608\uc81c\ub97c \ud1b5\ud574 Sphinx\ub97c \ud65c\uc6a9\ud55c \uac80\uc0c9\uc744 \ud574\ubd24\ub2e4. (\uc2e4\uc81c\ub85c \uac80\uc0c9\uc740 \uc544\ub2c8\uace0 \ucd9c\ub825\uc77c \ubfd0\uc774\uc5c8\ub2e4!!)<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

\uc774\uc81c SphinxQL\uc744 \ud1b5\ud574 \uac80\uc0c9\uc744 \ud558\uace0, \uc6d0\ud558\ub294 \uacb0\uacfc\uac12\uc744 \uac00\uc838\uc624\ub3c4\ub85d \ud658\uacbd\uc124\uc815\uac12\uc744 \ubcc0\uacbd\ud558\ub3c4\ub85d \ud574\ubcf4\uc790.<\/span><\/p>\n<\/span>

\uc5ec\uae30\uc11c\ub294 <\/span>2\ubd80\uc5d0\uc11c \uc0ac\uc6a9\ud55c test.sql \uc608\uc81c\ub97c \uac00\uc9c0\uace0 \uac80\uc0c9\ud574\ubcf4\ub3c4\ub85d \ud55c\ub2e4.<\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>


<\/span><\/b><\/p>\n<\/span>

\uac04\ub2e8\ud55c \uac80\uc0c9<\/span><\/b><\/p>

<\/div>


<\/span><\/p>\n<\/span>

MySQL\uc5d0\uc11c \uac80\uc0c9\uc2dc\uc5d0\ub294 \ud544\ub4dc\uba85='\ucc3e\uc744\uac12' \ud615\uc2dd\uc73c\ub85c \uc0ac\uc6a9\ud588\uc5c8\ub2e4.<\/span><\/p>\n<\/span>

\ud558\uc9c0\ub9cc SphinxQL\uc5d0\uc11c\ub294 MATCH() \ub77c\ub294 \uac83\uc744 \uc0ac\uc6a9\ud55c\ub2e4.<\/span><\/p>\n<\/span>


<\/span><\/p>\n<\/span>

\uc544\ub798\ucc98\ub7fc \uac80\uc0c9\uc744 \ud558\ub3c4\ub85d \ud558\uc790.<\/span><\/p>\n<\/span>

SELECT * FROM zipcode WHERE MATCH('\ud64d\uc131');<\/span><\/p><\/td><\/tr><\/tbody><\/table>\n<\/span>


<\/p>\n<\/span>


<\/p>

<\/span><\/span><\/p>\n<\/span>


<\/p>


<\/div>
\uac80\uc0c9\ud55c \uacb0\uacfc\uac00 \ub098\ud0c0\ub0ac\ub2e4.<\/span><\/div>
\uc774\ucc98\ub7fc MATCH()\ub97c \uc0ac\uc6a9\ud558\uba74 \ub418\ub294\ub370, \uaf2d '' \uc0ac\uc774\uc5d0 \uac80\uc0c9\uc5b4\ub97c \ub123\ub3c4\ub85d \ud55c\ub2e4.<\/span><\/div>

<\/div>
\uacb0\uacfc\ub97c \ubcf4\uba74 <\/span>20\uac1c\uc758 \uac80\uc0c9\uacb0\uacfc \uac12\uc744 \uac00\uc838\uc628 \uac83\uc744 \ubcfc \uc218 \uc788\ub2e4.<\/span><\/div><\/div>
20\uac1c \uc774\uc0c1\uc758 \uacb0\uacfc\uac12\uc744 \uc6d0\ud558\uba74 <\/span>LIMIT\ub97c \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4.<\/span><\/div>
\n<\/span>

SELECT * FROM zipcode WHERE MATCH('\ud64d\uc131') LIMIT 100;<\/span> <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>\n<\/span>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

\uc774\uc81c 2\uac1c \uc774\uc0c1\uc758 \ub2e8\uc5b4 \uac80\uc0c9\uc744 \ud574\ubcf4\uc790<\/span><\/p>\n<\/span>\n<\/span>

SELECT * FROM zipcode WHERE MATCH('\ud64d\uc131 \uac08\uc0b0');<\/span> <\/span><\/p><\/td><\/tr><\/tbody><\/table>\n<\/span>\n<\/span>


<\/p>\n<\/span>

<\/span><\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

\uc774\ucc98\ub7fc \uc5ec\ub7ec\uac1c\ub97c \uac80\uc0c9 \ud560 \uc218 \uc788\ub2e4. \ud558\uc9c0\ub9cc \uc544\ub798\ucc98\ub7fc \ub744\uc5b4 \uc4f0\uae30 \uc5c6\uc774 \ub2e4\uc2dc \uc785\ub825\ud574 \ubcf4\uc790<\/span><\/p>

SELECT * FROM zipcode WHERE MATCH('\ud64d\uc131\uac08\uc0b0');<\/span> <\/span><\/p><\/td><\/tr><\/tbody><\/table><\/div>


<\/p>\n<\/span>


<\/p>\n<\/span>

<\/span><\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

\uacb0\uacfc\uac12\uc774 \ub3d9\uc77c\ud558\ub2e4\ub294 \uac83\uc744 \uc54c \uc218 \uc788\ub2e4.<\/span><\/p>\n<\/span>

\uc774\uac83\uc774 \ubc14\ub85c n-gram \uac80\uc0c9\ubc29\uc2dd\uc758 \ud2b9\uc9d5\uc774\ub2e4. <\/span><\/p>\n<\/span>

'\ud64d\uc131\uac08\uc0b0', '\uac08\uc0b0\ud64d\uc131', '\ud64d\uc0b0\uac08\uc131', '\uac08\ud64d\uc0b0\uc131' \ub4f1\ub4f1 \uae00\uc790 \uc21c\uc11c\ub97c \ubcc0\uacbd\ud574\ub3c4, \ub3d9\uc77c\ud55c \uac80\uc0c9 \uacb0\uacfc\ub97c \uac00\uc838\uc624\ub294 \uac83\uc744 \uc54c\uac8c \ub420 \uac83\uc774\ub2e4.<\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

<\/span><\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>


<\/span><\/b><\/p>\n<\/span>

\uad6c\ubb38 \uac80\uc0c9 (Parse Search)<\/span><\/b><\/p>

<\/div>


<\/p>\n<\/span>

\uc77c\ub2e8 \uc544\ub798\ucc98\ub7fc \uac80\uc0c9\ud574\ubcf4\uc790<\/span><\/p>

SELECT * FROM zipcode WHERE MATCH('\uc11c\uc0b0');<\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>\n<\/span>


<\/p>\n<\/span>

<\/span><\/span><\/p>\n<\/span>


<\/span><\/p>\n<\/span>

\uac80\uc0c9\ud574\ubcf4\uba74 \uc11c\uc6b8\ub3c4 \ub098\uc624\uace0, \uc804\ubd81\ub3c4 \ub098\uc628\ub2e4.<\/span><\/p>\n<\/span>

\uc804\ubd81\uc774 \ub098\uc628 Row\ub97c \ubcf4\uba74 <\/span><\/p>\n<\/span>

\uc804\ubd81 \uc804\uc8fc\uc2dc \uc644<\/span>\uc0b0<\/span>\uad6c <\/span>\uc11c<\/span>\uc11c<\/span>\ud559\ub3d9 <\/span>\uc0b0<\/span> 81 \ub77c\uace0 \ub418\uc5b4\uc788\ub2e4. \uc989 \uc11c\uc640 \uc0b0\uc790\uac00 \ucd1d 4\uac1c \ud3ec\ud568\ub418\uc5b4 \uc788\uae30 \ub54c\ubb38\uc5d0 \uc0c1\uc704 \uacb0\uacfc\uac12\uc73c\ub85c \ub098\uc628\uac83\uc774\ub2e4. <\/span><\/p>\n<\/span>

1\uc704\ub85c \ub098\uc628 Row\ub294 5\uc790\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\uc74c\uc744 <\/span>\ud559\uc778 \ud560 \uc218 \uc788\ub2e4. <\/span><\/p>\n<\/span>

\uc774\ucc98\ub7fc \uc77c\uce58\ud558\ub294 \uac80\uc0c9\uc774 \uba87\uac1c\uc774\uace0, \uc5bc\ub9c8\ub098 \uc5f0\uad00\uc131\uc774 \uc788\ub294\uc9c0\uc5d0 \ub530\ub77c weight\uac12\uc774 \uacb0\uc815\uc774 \ub418\uba74 \uac00\uc7a5 \ub192\uc740 weight\uac12 \uc21c\uc73c\ub85c \uc815\ub82c\ub418\uc5b4 \uac80\uc0c9 \uacb0\uacfc\uac00 \ub098\uc624\ub294 \uac83\uc774\ub2e4.<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

\uadf8\ub7fc \uc774\uc81c \uad6c\ubb38\uc73c\ub85c \uac80\uc0c9\ud558\uae30 \uc704\ud574 \uac80\uc0c9\uc5b4 \uc591 \uc606\uc5d0 \ub530\uc634\ud45c\ub97c \ubd99\uc774\ub3c4\ub85d \ud558\uc790.<\/span><\/p>\n<\/span>\n<\/span>

SELECT * FROM zipcode WHERE MATCH('\"\uc11c\uc0b0\"');<\/span> <\/span><\/p><\/td><\/tr><\/tbody><\/table>\n<\/span>\n<\/span>


<\/p>\n<\/span>


<\/p><\/div>

<\/span><\/span><\/p>\n<\/span>


<\/p>
<\/div>

\uc6d0\ud558\ub294 \uac12\uc774 \ub098\uc624\ub294 \uac83\uc744 \uc54c \uc218 \uc788\ub2e4.<\/span><\/div>
\uc774\ucc98\ub7fc \uc30d\ub530\uc634\ud45c\ub85c \uac80\uc0c9\uc5b4\ub97c \uac10\uc2f8\uc8fc\uba74 \uad6c\ubb38\uc73c\ub85c \uac80\uc0c9\uc774 \ub41c\ub2e4.<\/span><\/div>
\uc751\uc6a9\uc73c\ub85c \uc544\ub798\ucc98\ub7fc \uac80\uc0c9\uc5b4 2\uac1c\ub97c \uac01\uac01 \ub530\uc634\ud45c\ub85c \ucc98\ub9ac\ud574\uc8fc\uace0, \uc27c\ud45c \uc5c6\uc774 \uac80\uc0c9\ud574\uc8fc\uba74 \uc6d0\ud558\ub294 \uac12\uc744 \uc27d\uac8c \ucc3e\uc744 \uc218 \uc788\uac8c\ub41c\ub2e4.<\/span><\/div>

SELECT * FROM zipcode WHERE MATCH('\"\uc11c\uc0b0\" \"\uace0\ubd81\"');<\/span> <\/span><\/p><\/td><\/tr><\/tbody><\/table><\/div>


<\/div>

<\/div>

<\/span><\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>


<\/p><\/div>


<\/div>
\ud544\ub4dc \uac80\uc0c9 (Field Search)<\/span><\/b>
<\/div>


<\/p>\n<\/span>

\uacf5\uc8fc\ub77c\uace0 \uac80\uc0c9\ud574\ubcf4\uc790<\/span><\/p><\/div>

SELECT * FROM zipcode WHERE MATCH('\"\uacf5\uc8fc\"');<\/span><\/p><\/td><\/tr><\/tbody><\/table>\n<\/span>


<\/p>
<\/div>

<\/span><\/span><\/p>\n<\/span>


<\/p>\n<\/span>

\ubaa8\ub4e0 \ud544\ub4dc\uc5d0\uc11c \uacf5\uc8fc\ub77c\ub294 \uac80\uc0c9\uc5b4\ub97c \ucc3e\uac8c\ub41c\ub2e4.<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

\ub9cc\uc57d \ub0b4\uac00 \uc6d0\ud558\ub294 \uac83\uc774 suburb\uc5d0 \uc788\ub294 \uacf5\uc8fc\ub77c\uace0 \ud55c\ub2e4\uba74 \ud544\ub4dc\uba85\uc744 \uba85\uc2dc\ud574\uc8fc\uba74 \ub41c\ub2e4.<\/span><\/p>\n<\/span>

\ud544\ub4dc \uac80\uc0c9\uc2dc\uc5d0\ub294 \ud544\ub4dc\uba85 \uc55e\uc5d0 @\ub97c \ubd99\uc774\uace0 \ud55c\uce78 \ub6f0\uba74 \ub41c\ub2e4.<\/span><\/p>\n<\/span>\n<\/span>

SELECT * FROM zipcode WHERE MATCH('@suburb \"\uacf5\uc8fc\"');<\/span> <\/span><\/p><\/td><\/tr><\/tbody><\/table>\n<\/span>\n<\/span>


<\/p>\n<\/span>


<\/p><\/div>

<\/span><\/span><\/p>\n<\/span>


<\/p>\n<\/span>

\ub9cc\uc57d \uac80\uc0c9\ud560 \ud544\ub4dc\uac00 2\uac1c \uc774\uc0c1\uc774\ub77c\uba74 \uc544\ub798\ucc98\ub7fc \uac00\ub85c\uc548\uc5d0 \ud544\ub4dc\uba85\uc744 \uc801\uace0 \uc27c\ud45c\ub85c \uad6c\ubd84\ud574 \uc8fc\uba74 \ub41c\ub2e4. <\/span>\uc8fc\uc758\ud560\uc810\uc740 \uc27c\ud45c\ub4a4\uc5d0 \uacf5\ubc31\uc774 \uc5c6\uc5b4\uc57c \ud55c\ub2e4\ub294 \uc810\uc774\ub2e4.<\/span><\/p>

SELECT * FROM zipcode WHERE MATCH('@(city,suburb) \"\uacf5\uc8fc\"');<\/span> <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p><\/div>


<\/div>

<\/div>
\ud544\ub4dc\ubcc4 \uc6b0\uc120 \uac80\uc0c9<\/span><\/b>
<\/div>


<\/p>\n<\/span>

\uc5ec\ub7ec \ud544\ub4dc\ub97c \uac80\uc0c9\ud588\uc744\ub54c, \uac80\uc0c9\ub41c \ub2e8\uc5b4\uac00 \uac00\uc7a5 \ub9ce\uc740 \ub370\uc774\ud130\ubd80\ud130 \ub098\uc624\uac8c \ub41c\ub2e4.<\/span><\/p>

\ub9cc\uc57d \uac80\uc0c9\uc2dc title\uc5d0 \uc77c\uce58\ub41c \uac12\uc774 \ub2e4\ub978 \ud544\ub4dc\uc5d0\uc11c \uc77c\uce58\ub41c \uac12\ubcf4\ub2e4 \ub354 \uc911\uc694\ud55c \uac80\uc0c9 \uacb0\uacfc\uac12\uc744 \uac00\uc9c0\uace0 \uc788\uae30 \ub54c\ubb38\uc5d0 \uc0c1\uc704 \uacb0\uacfc\uac12\uc73c\ub85c \ucd9c\ub825\ud574 \uc918\uc57c \ud55c\ub2e4\uba74 <\/span>\ud544\ub4dc\ubcc4\ub85c weight\uac12\uc744 \uc8fc\uba74 \ub41c\ub2e4.<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

\uc77c\ub2e8 \uc544\ub798\ucc98\ub7fc \uac80\uc0c9\ud574\ubcf4\uc790<\/span><\/p>\n<\/span>\n<\/span>

SELECT title, publisher FROM book WHERE MATCH ('\"\uc5b4\ub9b0\uc774\"');<\/span><\/p><\/td><\/tr><\/tbody><\/table>\n<\/span>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

<\/span><\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

\uac80\uc0c9 \uacb0\uacfc\uc5d0\uc11c title\uc5d0 \uc5b4\ub9b0\uc774 \ub77c\ub294 \uac12\uc774 \uc5c6\uc74c\uc5d0\ub3c4 publisher\uc5d0\uc11c \uc5b4\ub9b0\uc774\uac00 \uc788\uae30\uc5d0 \uc0c1\uc704\ub85c \ub4e4\uc5b4\uc654\ub2e4.<\/span><\/p>

\ucc45\uc744 \ucc3e\uace0 \uc2f6\uc740\ub370, \uc81c\uacf5\uc0ac\uc758 \ucc45 \uacb0\uacfc\uac12\uc744 \uac00\uc838\uc624\ub294 \uac83\uc740 \uac80\uc0c9\uc5d0 \ube44\ud6a8\uc728\uc801\uc774\ub2e4.<\/span><\/p>\n<\/span>


<\/p>

\uc544\ub798\ucc98\ub7fc weight\uac12\uc744 \uc918\ubcf4\uc790.<\/span><\/p>\n<\/span>

SELECT title, publisher FROM book WHERE MATCH ('\"\uc5b4\ub9b0\uc774\"') OPTION FIELD_WEIGHTS=(title=2,publisher=1);<\/span><\/p><\/td><\/tr><\/tbody><\/table>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

<\/span><\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

\ud544\ub4dc title\uc5d0 2\uac12\uc744 \uc8fc\uace0, publisher\uc5d0\ub294 1\uac12\uc758 weight \uac12\uc744 \uc8fc\uc5c8\ub2e4. (1\uac12\uc740 \uae30\ubcf8\uac12\uc73c\ub85c \uba85\uc2dc\ud558\uc9c0 \uc54a\uc544\ub3c4 \ub41c\ub2e4.)<\/span><\/p>\n<\/span>

\ub530\ub77c\uc11c \ub9cc\uc57d title\uc5d0 \uc5b4\ub9b0\uc774\uac00 \uc77c\uce58\ud558\uba74 weight\uac12\uc774 publisher\uc5d0\uc11c \uc77c\uce58\ud558\ub294 \uac12\ubcf4\ub2e4 \ucee4\uc9c0\uac8c \ub418\uc5b4 \uac80\uc0c9 \uacb0\uacfc\uc5d0 \uc0c1\uc704\ub85c \ub098\uc628\ub2e4.<\/span><\/p>\n<\/span>


<\/p>

\uc774\uc81c \uac80\uc0c9\uc2dc \ucc45 \uc704\uc8fc\ub85c \uac80\uc0c9\uc744 \ud558\ub3c4\ub85d \ud55c \uac83\uc774\ub2e4.<\/span><\/p>\n<\/span>


<\/b><\/span><\/p>\n<\/span>


<\/b><\/span><\/p>\n<\/span>

\uc640\uc77c\ub4dc\uce74\ub4dc \uac80\uc0c9 (Wildcard Search)<\/span><\/b><\/span><\/font><\/p>

<\/div>


<\/p>\n<\/span>

\ub9cc\uc57d\uc5d0 \uc77c\ubd80\ubd84\uc744 \uac80\uc0c9\ud574\uc57c \ud55c\ub2e4\uba74, \uc640\uc77c\ub4dc\uce74\ub4dc\ub97c \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4.<\/span><\/p>\n<\/span>

\uc608\ub97c \ub4e4\uba74 \uc544\ub798\ucc98\ub7fc \uac80\uc0c9 \ud55c\ub2e4\uba74 \uc624\ub85c\uc9c0 7000\uac12\ub9cc\uc744 \ucc3e\uac8c \ub41c\ub2e4.<\/span><\/p>\n<\/span>

SELECT title,price FROM book WHERE MATCH('@price 7000');<\/span> <\/span><\/p><\/td><\/tr><\/tbody><\/table>\n<\/span>


<\/p>


<\/p>\n<\/span>

<\/span><\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>

\ud558\uc9c0\ub9cc \uc640\uc77c\ub4dc\uce74\ub4dc\uc778 *\uc744 \uc0ac\uc6a9\ud574\uc11c \uc544\ub798\ucc98\ub7fc \uac80\uc0c9\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \uacb0\uacfc\ub97c \uc5bb\uc744 \uc218 \uc788\ub2e4.<\/span><\/p>\n<\/span>\n<\/span>

SELECT title,price FROM book WHERE MATCH('@price *7000');<\/span> <\/span><\/p><\/td><\/tr><\/tbody><\/table>\n<\/span>\n<\/span>


<\/p>


<\/p>\n<\/span>

<\/span><\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

\ubc14\ub85c \uc55e\uc5d0 *\uc744 \ubd99\uc774\uba74 \uac80\uc0c9\uc5b4\uc640 \uc77c\ucc28\ud558\ub294 \uac12\uacfc \ub354\ubd88\uc5b4 *\uac00 \ubd99\uc740 \ubd80\ubd84\uc5d0\uc11c \uc77c\uce58\ud558\ub294 \ubaa8\ub4e0 \uacb0\uacfc\uac12\uc744 \uac00\uc838\uc624\uac8c \ub41c\ub2e4.<\/span><\/p>\n<\/span>

\ud558\uc9c0\ub9cc \uc640\uc77c\ub4dc\uce74\ub4dc\ub97c \uc0ac\uc6a9\ud558\ub824\uba74 sphinx.onf \ud30c\uc77c\uc5d0 \uc124\uc815\uc744 \ub530\ub85c \ud574\uc918\uc57c \ud55c\ub2e4.<\/span><\/p>\n<\/span>

\uc124\uc815\uc744 \ud574\uc8fc\uc9c0 \uc54a\ub294\ub2e4\uba74, *\uac12\uc744 \uc778\uc2dd\ud558\uc9c0 \ubabb\ud558\uac8c \ub41c\ub2e4.<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

\uc124\uc815\uc740 \ub2e4\uc74c\uacfc \uac19\uc774 \ud55c\ub2e4.<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

index \uc778\ub371\uc2a4\uba85<\/span><\/p>\n<\/span>

{<\/span><\/p>\n<\/span>

...<\/span><\/p>\n<\/span>

...<\/span><\/p>\n<\/span>

charset_table = 0..9..........<\/span><\/p>\n<\/span>

...<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

enable_star=1<\/span><\/p>\n<\/span>

min_infix_len=2<\/span><\/p>\n<\/span>

#min_prefix_len=2<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

...<\/span><\/p>\n<\/span>

...<\/span><\/p>\n<\/span>

} <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>\n<\/span>


<\/p>\n<\/span>

enable_star\ub294 \uc640\uc77c\ub4dc\uce74\ub4dc\ub97c \uc0ac\uc6a9\ud55c\ub2e4\ub294 \uac83\uc73c\ub85c 1\uac12\uc774\uba74 \uc0ac\uc6a9\ud55c\ub2e4\ub294 \ub73b\uc774\ub2e4.<\/span><\/p>\n<\/span>

min_infix_len\uacfc min_prefix_len\uc758 \uae38\uc774\ub294 \ucd5c\uc18c \uba87\uac1c\uc758 \uac12\uc73c\ub85c \ucabc\uac24 \uac83\uc778\uac00\uc774\ub2e4.<\/span><\/p>\n<\/span>

\uc608\ub97c \ub4e4\uba74 test\ub97c 2\ub85c \ucabc\uac1c\uba74, te, es, st, tes, est, test \ub4f1\uc73c\ub85c \ucd5c\uc18c \ud06c\uae30\uc778 2\ubd80\ud130 \uc778\ub371\uc2f1\uc744 \ud574\ub450\ub294 \uac83\uc774\ub2e4.<\/span><\/p>

\ub530\ub77c\uc11c \ub9cc\uc57d *st \ub77c\uace0 \uac80\uc0c9\ud558\uba74 test\uac00 \uac80\uc0c9\ub418\ub294 \uac83\uc774\ub2e4.<\/span><\/p>

infix\uc640 prefix\uc758 \ucc28\uc774\uc810\uc740 \ub2e4\uc74c \uc0ac\uc774\ud2b8\ub97c \ucc38\uace0\ud55c\ub2e4. <\/span><\/p>

http:\/\/sphinxsearch.com\/docs\/manual-2.0.8.html#conf-min-prefix-len<\/span><\/a><\/p>\n<\/span>


<\/span><\/p>

\ucc38\uace0\ub85c, enable_star=1\uac12\uc73c\ub85c \ud558\uba74 \ubaa8\ub4e0 \ud544\ub4dc\uc5d0 \uc801\uc6a9\ub41c\ub2e4. \ub9cc\uc57d, \ud2b9\uc815\ud55c \ud544\ub4dc\ub9cc \uc640\uc77c\ub4dc\uce74\ub4dc\ub97c \uc0ac\uc6a9\ud55c\ub2e4\uba74 \uc544\ub798\ucc98\ub7fc \uc124\uc815 \ud560 \uc218 \uc788\ub2e4.<\/span><\/p>


<\/p>

infix_fields = price, \ub4f1\ub4f1 \ud544\ub4dc\uba85<\/span><\/p>

prefix_fields = content, \ub4f1\ub4f1 \ud544\ub4dc\uba85<\/span> <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>\n<\/span>

\uc8fc\uc758\ud560 \uc810\uc73c\ub85c\ub294 min_infix_len\uc640 min_prefix_len\uc740 \ub3d9\uc2dc\uc5d0 \uc0ac\uc6a9 \ud560 \uc218 \uc5c6\uc73c\ubbc0\ub85c \ub458\uc911 \ud558\ub098\ub9cc \uc120\ud0dd\ud574\uc57c \ud55c\ub2e4. <\/span><\/p>

(\ub2e8, infix_fields \ucc98\ub7fc \ud544\ub4dc\ubcc4 \uc124\uc815\uc744 \ud55c\ub2e4\uba74 \ub3d9\uc2dc\uc0ac\uc6a9 \uac00\ub2a5)<\/span><\/p>


<\/p>


<\/p>\n<\/span>

\uc815\ub82c<\/span><\/b><\/p>

<\/div>


<\/p>\n<\/span>

MySQL\uc5d0\uc11c \ucc98\ub7fc \uc815\ub82c \uae30\ub2a5\uc774 \ud544\uc694 \ud560\ub54c ORDER BY \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4.<\/span><\/p>\n<\/span>

\ud558\uc9c0\ub9cc \uc870\uae08 \ub2e4\ub978\uc810\uc740 \ubc18\ub4dc\uc2dc ASC\ub098 DESC \ub458\uc911 \ud558\ub098\ub97c \ubc18\ub4dc\uc2dc \uc368\uc918\uc57c \ud55c\ub2e4. \ubcf4\ud1b5 MySQL\uc5d0\uc11c\ub294 ASC\ub97c \uc0dd\ub7b5\ud558\uace0 \uc4f0\ub294\ub370, Sphinx\uc5d0\uc11c\ub294 \uc0dd\ub7b5\uc744 \ud560 \uc218 \uc5c6\ub2e4\ub294 \uac83\uc774\ub2e4.<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

\uc774\uc81c \uc544\ub798\ucc98\ub7fc \uc815\ub82c\ud574\ubcf4\uc790.<\/span><\/p>\n<\/span>\n<\/span>

SELECT * FROM shop ORDER BY price DESC;<\/span><\/p><\/td><\/tr><\/tbody><\/table>\n<\/span>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

<\/span><\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

\uac00\uaca9\uc774 \ub192\uc740 \uc21c\uc73c\ub85c \uc798 \uc815\ub82c\ub418\uc5b4 \uc788\ub2e4.<\/span><\/p>\n<\/span>

\uadf8\ub7fc \uc774\uc81c \uc815\ub82c\ud560 \ud544\ub4dc\ub97c s_price\ub85c \ubc14\uafd4 \ub2e4\uc2dc \uac80\uc0c9\ud574\ubcf4\uc790.<\/span><\/p>\n<\/span>

SELECT * FROM shop ORDER BY s_price DESC;<\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

<\/span><\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

\ubd84\uba85 price\uc640 s_price\ub294 \ud544\ub4dc\uba85\ub9cc \ub2e4\ub97c\ubfd0 \uac19\uc740 \uac12\uc744 \uac00\uc9c4 \ud544\ub4dc\uc774\uc9c0\ub9cc, \uc815\ub82c\ub41c \uacb0\uacfc\uac12\uc740 \uc11c\ub85c \ub2e4\ub974\ub2e4.<\/span><\/p>

\uc774\uc81c \uc774\ub7f0 \uc774\uc720\ub97c \uc7a0\uc2dc \uc124\uba85\ud574\ubcf4\uae30 \uc704\ud574 sphinx.conf\uc5d0 \uc124\uc815\ub41c \uac12\uc744 \ubcfc \ud544\uc694\uac00 \uc788\ub2e4.<\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p>\n<\/span>

source shop<\/span><\/p>\n<\/span>

{<\/span><\/p>\n<\/span>

...<\/span><\/p>\n<\/span>

...<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

         sql_query_pre = SET NAMES utf8<\/span><\/p>\n<\/span>

         sql_query = SELECT sn, price, price AS s_price, pack_count, item_name, npc_name FROM shop WHERE sphinx_yn='Y'<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

    <\/span>     sql_attr_bigint         = price<\/span><\/p>\n<\/span>

         sql_field_string        = s_price<\/span><\/p>\n<\/span>

         sql_field_string        = pack_count<\/span><\/p>\n<\/span>

         sql_field_string        = pack_count<\/span><\/p>\n<\/span>

         sql_field_string        = item_name<\/span><\/p>\n<\/span>

         sql_field_string        = npc_name<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

...<\/span><\/p>\n<\/span>

...<\/span><\/p>\n<\/span>

}<\/span><\/p><\/td><\/tr><\/tbody><\/table>\n<\/span>


<\/p>

Sphinx\uc5d0\uc11c\ub294 \ud06c\uac8c 2\uac1c\uc758 \ud0c0\uc785\uc774 \uc788\ub294\ub370 <\/span>Attribute\uc640 Field\ub2e4.<\/span><\/div>

<\/div>
Attribute : Full-Text \uae30\ub2a5 \uc5c6\uc74c. \uc815\ub82c, \ud544\ud130 \uae30\ub2a5 \uc788\uc74c.<\/span><\/div>
Field : Full-Text \uae30\ub2a5\uc744 \uc9c0\uc6d0.<\/span><\/div>

<\/div>
\uc124\uc815\uc744 \ubcf4\uba74 <\/span>2\uac1c\uc758 \ud0c0\uc785 sql_arttr_bigint\uc640 sql_field_string\uc774 \uac01\uac01 price\uc640 s_price\uc758 \ud0c0\uc785\uc73c\ub85c \uc120\uc5b4\ub418\uc5b4 \uc788\ub2e4.<\/span><\/div>
price\ub294 Attribute\ub85c, s_price\ub294 Field\ub85c \uc120\uc5b8\ub41c \uac83\uc774\ub2e4.<\/span><\/div>

<\/span><\/div>
\ub530\ub77c\uc11c \uc815\ub82c\uc744 \ud560\ub54c\ub294 sql_attr_bigint \ud0c0\uc785\uc73c\ub85c \uc120\uc5b8\ub41c price\ub85c \ud574\uc57c \ub418\ub294 \uac83\uc774\ub2e4.<\/span><\/div>
\uadf8\ub9ac\uace0 \uc544\ub798\ucc98\ub7fc price\ub85c \uac80\uc0c9\uc744 \ud55c\ub2e4\uba74 \uc5c6\ub294 \ud544\ub4dc\ub77c\uace0 \uc5d0\ub7ec\uac00 \ucd9c\ub825\ub41c\ub2e4.<\/span><\/div>

SELECT * FROM shop WHERE MATCH('@price 1000000'); <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>\n<\/span>


<\/p>


<\/p><\/span><\/div>

<\/span><\/span><\/p>\n<\/span>


<\/p>
<\/div>

\ud558\uc9c0\ub9cc, Full-Text\ub97c \ud1b5\ud55c \uac80\uc0c9\uc774 \uc548\ub418\ub294 \uac83\ubfd0\uc774\ub2e4. \uc989, MATCH() \ud568\uc218\ub97c \ud1b5\ud55c \uac80\uc0c9\uc774 \uc548\ub418\ub294 \uac83\uc774\ub2e4.<\/span><\/div>

<\/div>
\uc544\ub798 \uba85\ub839\uc5b4\ucc98\ub7fc \uc77c\ubc18\uc801\uc778 MySQL \ucffc\ub9ac\ubb38\ucc98\ub7fc \uac80\uc0c9\uc744 \ud558\uba74, \uac00\ub2a5\ud558\ub2e4.<\/span><\/div>
\ub530\ub77c\uc11c \uad6c\uac04 \uac80\uc0c9\uc774\ub77c\ub358\uc9c0, \ub0a0\uc9dc \ub4f1\uc758 \uc815\ub82c \ub4f1\uc774 \ud544\uc694\ud55c \uacbd\uc6b0\uc5d0 Attribute \ud0c0\uc785\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc774\ub2e4.<\/span><\/div>
\n<\/span>

SELECT * FROM shop WHERE price>= 72 and price <= 200;<\/span> <\/span><\/p><\/td><\/tr><\/tbody><\/table>\n<\/span>\n<\/span>


<\/p><\/div>


<\/p>\n<\/span>

<\/span><\/span><\/p>\n<\/span>


<\/p>\n<\/span>\n<\/span>


<\/p>

\uc774 \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud568\uc73c\ub85c\uc11c, \ud2b9\uc815 \uad6c\uac04\uc758 \uac12\ub4e4\uc774\ub098, \uc815\ub82c\ub4f1\uc744 \ud1b5\ud574 \uacb0\uacfc\uac12\uc744 \uad6c\ud560 \uc218 \uc788\ub2e4.<\/span><\/div>
\ub530\ub77c\uc11c \uac80\uc0c9\ud560 \ub300\uc0c1\uc774 \uc5b4\ub290 \ud544\ub4dc\uc778\uc9c0, \uac80\uc0c9\ud558\uc9c0\uc54a\uace0 \uacb0\uacfc\uac12\uc5d0\ub9cc \ub098\uc640\ub3c4 \ub418\ub294 \ud544\ub4dc\uc778\uc9c0, \uac80\uc0c9\uc2dc \uc5b4\ub5a4 \uc720\ud615\uc758 \uac80\uc0c9\uc744 \ud5c8\uc6a9 \ud560\uc9c0\uc5d0 \ub530\ub77c, \ud0c0\uc785\uc744 \uc798 \uace8\ub77c\uc57c \ud560 \uac83\uc774\ub2e4.<\/span><\/div>

<\/span><\/div>
\uc608\ub97c \ub4e4\uba74 \ub0a0\uc9dc \ub370\uc774\ud130\uc758 \uacbd\uc6b0 \uac80\uc0c9\ud560 \ud544\ub4dc\uac00 \uc544\ub2c8\uace0, \uacb0\uacfc\uac12\uc5d0\ub9cc \ucd9c\ub825\uc774 \ub418\ub294 \uac12\uc774\ub77c\uba74, \uad73\uc774 Attribute \ud0c0\uc785\uc774 \uc544\ub2cc Field \ud0c0\uc785\uc73c\ub85c \ud574\ub3c4 \ub420 \uac83\uc774\ub2e4.<\/span><\/div>
\ud558\uc9c0\ub9cc, \uc815\ub82c, \uad6c\uac04 \ub4f1\uc758 \uac80\uc0c9\uc774 \ud544\uc694\ud558\ub2e4\uba74, sql_attr_timestamp\ub85c \uc120\uc5b8\ud574\uc57c \ub420 \uac83\uc774\ub2e4.<\/span><\/div><\/div>

<\/div>

<\/div>

<\/div>\n<\/span>

\uc774\uc0c1\uc73c\ub85c \uac04\ub2e8\ud55c SphinxQL\uc758 \uc0ac\uc6a9\ubc95\uc744 \uc0ac\uc6a9\ud574 \ubd24\ub2e4.<\/span><\/p>\n<\/span>

\ub354 \ub2e4\uc591\ud55c \uc635\uc158\uacfc \ubc29\ubc95\uc740 Sphinx \ud648\ud398\uc774\uc9c0\uc758 \ubb38\uc11c\ub97c \ud1b5\ud574 \ucc38\uc870\ud558\uba74 \ub418\uaca0\ub2e4.<\/span><\/p>\n<\/span>


<\/p>\n<\/span>

xQL Reference : <\/span>http:\/\/sphinxsearch.com\/docs\/manual-2.0.8.html#sphinxql-reference<\/span><\/a><\/p>\n<\/span>

Full-Text Query : <\/span>http:\/\/sphinxsearch.com\/docs\/manual-2.0.8.html#extended-syntax<\/span><\/a><\/p>\n<\/span>


<\/span><\/p>\n<\/span>

\ucc38\uace0\ub85c \uc5ec\uae30\uc11c \ub2e4\ub8ec xQL\uc740 SphinxAPI\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\ubcf4\ub2e4 \ube60\ub974\ub2e4\uace0 \ud55c\ub2e4.<\/span><\/p>\n<\/span>

\ub2e4\uc74c 4\ubd80\uc5d0\uc11c\ub294 \uc778\ub371\uc2f1\uc744 \ud558\ub294 \ubc29\ubc95\uc744 \ub2e4\ub8e8\uaca0\ub2e4.<\/span><\/p>\n<\/span>


<\/p>\n<\/span>


<\/p><\/div>

<\/span><\/span><\/p>\n<\/span>


<\/p>\n<\/span>

<\/span><\/span><\/p>\n<\/span>


<\/p>
<\/div>

\ucd9c\ucc98 : <\/span>http:\/\/sphinxsearch.com\/blog\/2010\/04\/25\/sphinxapi-vs-sphinxql-benchmark\/<\/span><\/a><\/div>

<\/div>

<\/div>

<\/div>

<\/div>
2013\/05\/20 - [Database\/Sphinx \uac80\uc0c9\uc5d4\uc9c4] - [Sphinx] \uac80\uc0c9 \uc5d4\uc9c4 Sphinx 1\ubd80 - Sphinx \uc124\uce58<\/span><\/a><\/div>

2013\/05\/31 - [Database\/Sphinx \uac80\uc0c9\uc5d4\uc9c4] - [Sphinx] \uac80\uc0c9 \uc5d4\uc9c4 Sphinx 2\ubd80 - Sphinx\uc640 MySQL \uc5f0\ub3d9 \ubc0f \ud14c\uc2a4\ud2b8<\/span><\/a><\/p>\n<\/span>

2013\/06\/23 - [Database\/Sphinx \uac80\uc0c9\uc5d4\uc9c4] - [Sphinx] \uac80\uc0c9 \uc5d4\uc9c4 Sphinx 4\ubd80 - \uc778\ub371\uc2f1 \uc124\uc815\uacfc \ub370\ubaac \uc124\uc815<\/span><\/a><\/p>

2013\/07\/01 - [Linux Debian 7\/Sphinx \uac80\uc0c9 \uc5d4\uc9c4] - [Debian] \uac80\uc0c9 \uc5d4\uc9c4 Sphinx 5\ubd80 - PHP\uc640\uc758 \uc5f0\uacb0<\/span><\/a><\/p>


<\/a><\/p>
<\/div>


<\/div>
-------------------------------------------------------<\/span><\/div>
\uc548\ub155\ud558\uc138\uc694 \ub2d8\uc744 \uc704\ud55c \uacf5\uac04<\/span><\/div>

<\/div>
-------------------------------------------------------<\/span><\/div>

<\/div>

<\/div>
\ud574\ub2f9 DB\uac00 \uc5c6\uae30\ub54c\ubb38\uc5d0 \uc9c1\uc811 \ud14c\uc2a4\ud2b8\ub294 \ud558\uc9c0 \ubabb\ud558\uc600\uc73c\uba70, \uc815\ud655\ud55c \uc0c1\ud669\uc744 \uc54c \uc218 \uc5c6\uae30 \ub54c\ubb38\uc5d0 \ucd94\uce21\uc758 \uae00\uc744 \uc62c\ub9bd\ub2c8\ub2e4.<\/span><\/div>

<\/div>
\ud604\uc7ac \ube14\ub85c\uadf8\uc5d0 \uc788\ub294 conf\ud30c\uc77c\uacfc sql\ubb38\uc744 \uc774\uc6a9\ud588\uc744\ub54c \uac80\uc0c9\uc774 \uc798 \ub418\ub294 \uac83\uc73c\ub85c \ubcf4\uc544, \uc774 \ud30c\uc77c\ub4e4\uc744 \ud1b5\ud574 \uc11c\ubc84\uc5d0 \uc801\uc6a9\ub41c \uac12\uacfc \ube44\uad50\ud574\ubcf4\uc154\uc57c \ub420\uac83 \uac19\uc2b5\ub2c8\ub2e4.<\/span><\/div>

<\/div>
\uc608\n\ub97c \ub4e4\uba74 \ube14\ub85c\uadf8\uc5d0 \uc62c\ub824\uc9c4 test.sql\uc5d0\uc11c shop \ud14c\uc774\ube14\uc758 \ub0b4\uc6a9\uc744 \"\uc544\uc774\ud3f05 \ucc28\ub7c9\uc6a9 \ucf00\uc774\ube14\", \"\uc544\uc774\ud3f05 \ucf00\uc774\ube14\"\ub85c \uace0\uce58\uace0 \n\ube14\ub85c\uadf8\uc758 conf\ud30c\uc77c\uc744 \uc774\uc6a9\ud574\uc11c \ud14c\uc2a4\ud2b8\ud55c \uacb0\uacfc \uc81c\ub300\ub85c \uac80\uc0c9\ub418\uc5b4 \ub098\uc624\ub294 \uac83\uc744 \ud655\uc778\ud588\uc2b5\ub2c8\ub2e4. (\uc544\ub798 \uc774\ubbf8\uc9c0 \ucc38\uc870)<\/span><\/div>

<\/div>

<\/span><\/span><\/p>


<\/p>
<\/div>


<\/div>

<\/span><\/span><\/p>


<\/p>
<\/div>

\ucc38\uace0\ub85c \uc544\ub798\uc758 \uae00\uc744 \ub0a8\uae30\uc168\ub294\ub370\uc694...<\/span><\/div>
---------------------------------------------<\/span><\/div>
\uc2a4\ud551\ud06c\uc2a4 \uac80\uc0c9\uc5d4\uc9c4 db\uc5d0 \ubd99\uc5b4\uc11c \ucffc\ub9ac\ub97c \ub0a0\ub824\ubcf4\uba74 <\/span><\/div>
\uc544\uc774\ud3f05 \ucc28\ub7c9\uc6a9 \ucf00\uc774\ube14,\uc544\uc774\ud3f05 \ucf00\uc774\ube14 \uc774\ub7f0 \ubb38\uc790\uc5f4\uc744 \uac00\uc9c0\ub294 \ub808\ucf54\ub4dc\ub294 \ud2c0\ub9bc\uc5c6\uc774 \uc874\uc7ac\ud558\ub294\ub370 \ub9d0\uc774\uc8e0. <\/span><\/div>
---------------------------------------------<\/span><\/div>
\uc774\ub807\uac8c \uc4f0\uc2e0 \ub73b\uc740 \ub2e8\uc21c\ud788 select * from xxx\uc73c\ub85c \ub370\uc774\ud130\uac00 \uc788\ub294\uc9c0 \ud655\uc778 \ud558\uc2e0 \uac70\ub77c\uba74 \uc55e\uc11c \ub9d0\uc500\ub4dc\ub9b0 \uac83\ucc98\ub7fc xQL\uc744 \uc0ac\uc6a9\ud574\uc11c \uc704 \uc774\ubbf8\uc9c0 \ucc98\ub7fc \uc815\ud655\ud55c \ucffc\ub9ac\ubb38\uc744 \ud1b5\ud574 \uacb0\uacfc\uac12\uc774 \uc798 \ub098\uc624\ub294\uc9c0 \uba3c\uc800 \ud655\uc778\ud574\uc57c \ud569\ub2c8\ub2e4.<\/span><\/div><\/div>

<\/div>
\ub9cc\uc57d \uc11c\ubc84\uc5d0 \uc801\uc6a9\ub418\uc788\ub294 \uac12\uc774 \uc704\uc640 \uac19\uc740 \ucffc\ub9ac\ubb38\uc73c\ub85c \uac80\uc0c9\uc774 \uc548\ub418\ub2e4\uba74 \ubd84\uba85, Sphinx \uc124\uc815\uc774 \uc798 \ubabb \ub41c \uac83\uc785\ub2c8\ub2e4.<\/span><\/div>
\uc77c\ub2e8 \ube14\ub85c\uadf8\uc5d0 \uc788\ub294 \uae30\ubcf8\uc801\uc778 conf\uac12\uacfc sql\ub85c \ud14c\uc2a4\ud2b8\ub97c \ud574\ubcf4\uc2dc\uace0, \uc11c\ubc84\uc5d0 \uc801\uc6a9\ub41c \uac12\uc73c\ub85c conf\uac12\uc744 \ud558\ub098\uc529 \ubcc0\uacbd, \ub2e4\uc2dc \uc778\ub371\uc2f1 \ud558\uc2dc\uba74\uc11c \uc6d0\uc778\uc744 \ucc3e\uc73c\uc2dc\ub294\uac8c \ube60\ub97c \ub4ef \ud569\ub2c8\ub2e4.<\/span><\/div><\/div>
\ud558\uc9c0\ub9cc \ucffc\ub9ac\ubb38\uc774 \uacb0\uacfc\uac12\uc744 \uc798 \uac00\uc838\uc628\ub2e4\uba74, API\uc5d0\uc11c \ubb38\uc81c\uac00 \uc0dd\uae34\ub2e4\ub294 \uac83\uc778\ub370 API\uc5d0 \ubcf4\ub0b4\ub294 \ucffc\ub9ac\ubb38\uc744 \ub85c\uace0\ub85c \ucc0d\uc5b4\uc11c \ub2e4\uc2dc \ud55c\ubc88 \ud655\uc778\ud558\uc2dc\ub294\uac8c \uc88b\uaca0\uc2b5\ub2c8\ub2e4.<\/span><\/div>

<\/div>

<\/div>
PS. xQL\uc774 \uc544\ub2cc API \ubc29\uc2dd\uc744 \ub3c4\uc785\ud558\uc2e0\uac83 \uac19\uc740\ub370, API \ubd80\ubd84\uc740 \uacbd\ud5d8\uc774 \uc5c6\uc5b4 \ub3c4\uc6c0\uc744 \ubabb\ub4dc\ub9ac\uaca0\ub124\uc694. <\/span>xQL\ub85c \uc624\uc2dc\ub294 \uac83\uc774 \uc5b4\ub5a0\uc2e0\uc9c0 ^^;;<\/span> <\/span>

<\/span>
\uc18c\uac1c<\/span><\/b>


<\/p>

3\ubd80\uc5d0\uc11c\ub294 \uac80\uc0c9\uc744 \ud1b5\ud574 \uacb0\uacfc\uac12\uc744 \uac00\uc838\uc654\ub2e4.<\/span><\/p>

\uc774\uc81c 4\ubd80\uc5d0\uc11c\ub294 \ub370\uc774\ud130\ub97c \uc778\ub371\uc2f1\ud558\ub294 \ubc29\ubc95\uacfc, \ub370\ubaac \ub4f1\ub85d\uc744 \ud1b5\ud55c \uc8fc\uae30\uc801\uc778 \uc778\ub371\uc2f1 \uc124\uc815\uc744 \ud1b5\ud574, Sphinx\uc758 \uc778\ub371\uc2a4 \ub370\uc774\ud130\ub97c \uc720\uc9c0 \ud558\ub294 \ubc29\ubc95\uc744 \ub2e4\ub8e8\uaca0\ub2e4.<\/span><\/p>


<\/p>

\uba85\ub839\uc5b4\ub97c PATH\uc5d0 \ub4f1\ub85d\ud558\uc9c0 \uc54a\uc558\ub2e4\uba74 \uc544\ub798 \ub9c1\ud06c\ub97c \ud1b5\ud574\uc11c \ub4f1\ub85d\uc744 \ud574\uc8fc\uac70\ub098, <\/span><\/p>

2013\/06\/22 - [Linux Debian 7] - [Debain] \uc5b4\ub290 \uc704\uce58\uc5d0\uc11c\ub4e0 \ud504\ub85c\uadf8\ub7a8 \uc2e4\ud589\uc2dc\ud0a4\ub3c4\ub85d PATH \uc124\uc815\ud558\uae30<\/span><\/a><\/span><\/p>

\uc544\ub798\ucc98\ub7fc \uba85\ub839\uc5b4\uac00 \uc788\ub294 \ub514\ub809\ud1a0\ub9ac\uc5d0\uac00\uc11c \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud558\uba74 \ub41c\ub2e4.<\/span><\/p>

cd \/usr\/local\/sphinx\/bin<\/span><\/p>

.\/indexer --all --rotate --merge --quient --silent --config<\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>


<\/p>


<\/p>

\uc804\uccb4 \uc778\ub371\uc2f1<\/span><\/b><\/p>


<\/p>

\uc804\uccb4 \uc778\ub371\uc2f1\uc740 \ub9d0 \uadf8\ub300\ub85c, \ud658\uacbd\uc124\uc815\uc5d0 \uc788\ub294 \ubaa8\ub4e0 \uc778\ub371\uc2a4\ub97c \uc778\ub371\uc2f1 \ud558\ub294 \uac83\uc774\ub2e4.<\/span><\/p>

indexer --all<\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>

\ub9cc\uc57d, SphinxQL\uc744 \uc0ac\uc6a9\ud558\uae30 \uc704\ud574, \ud639\uc740 \uc11c\ube44\uc2a4 \uc81c\uacf5\uc744 \uc704\ud574 searchd \ud504\ub85c\uc138\uc2a4\ub97c \uc2e4\ud589\uc2dc\ucf30\ub2e4\uba74, \ud56d\uc0c1 --rotate\ub97c \ucd94\uac00\ub85c \ubd99\uc5ec\uc8fc\uba74 \ub41c\ub2e4. \uadf8\ub807\uc9c0 \uc54a\ub2e4\uba74 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud560 \uac83\uc774\ub2e4.<\/span><\/p>

indexer --all --rotate <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>

\uc804\uccb4 \uc778\ub371\uc2f1\uc740 \ubaa8\ub4e0 \uc778\ub371\uc2a4\uc758 \ub370\uc774\ud130\ub97c \uc778\ub371\uc2f1\ud558\uae30\ub54c\ubb38\uc5d0 \uc778\ub371\uc2a4\uc758 \ud06c\uae30\uc640 \ub370\uc774\ud130\uc758 \ud06c\uae30\uc5d0 \uc758\ud574 \uc2dc\uac04\uc774 \uacb0\uc815\ub420 \uac83\uc774\ub2e4.<\/span><\/p>

(main + delta \ubc29\uc2dd\uc778 \uacbd\uc6b0 \uc804\uccb4 \uc778\ub371\uc2f1 \ud558\uace0\ub098\uc11c merge \uba85\ub839\uc5b4\ub97c \ud574\uc918\uc57c delta\uc5d0\uc11c \uc778\ub371\uc2f1\ub41c \ub370\uc774\ud130\ub97c Sphinx\uc5d0 \ubc18\uc601\ud558\uac8c \ub41c\ub2e4.)<\/span><\/p>


<\/p>


<\/p>


<\/p>

\ubd80\ubd84 \uc778\ub371\uc2f1<\/span><\/b><\/p>


<\/p>

\ud658\uacbd\uc124\uc815\uc5d0 \uc124\uc815\ub41c \uc778\ub371\uc2a4 \ub9ac\uc2a4\ud2b8\uac00 \ub9ce\ub2e4\uba74, \uc804\uccb4 \uc778\uc5d1\uc2a4\ubcf4\ub2e4\ub294 \ud2b9\uc815 \uc778\ub371\uc2a4\ub9cc\uc744 \uc778\ub371\uc2f1 \ud568\uc73c\ub85c\uc11c \uc2dc\uac04\uc744 \uc904\uc77c \uc218 \uc788\ub2e4.<\/span><\/p>

indexer \uc778\ub371\uc2a4\uba85 <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>

\uc608\ub97c \ub4e4\uba74, \uc608\uc81c\uc5d0\uc11c \uc81c\uacf5\ub41c sphinx.conf\uc5d0\ub294 zipcode, book, delta, shop\uc774\ub77c\ub294 4\uac00\uc9c0\uc758 \uc778\ub371\uc2a4\uac00 \uc788\ub2e4.<\/span><\/p>

\uc774 \uc774\ub984\uc744 \ud1b5\ud574 \uc778\ub371\uc2f1\uc744 \ud558\uba74 \ub418\ub294 \uac83\uc774\ub2e4.<\/span><\/p>

indexer delta<\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>


<\/p>


<\/span><\/span><\/b><\/p>

\uc778\ub371\uc2a4 \uc5c5\ub370\uc774\ud2b8 (Delta Index Updates)<\/span><\/b><\/p>


<\/p>

\uc778\ub371\uc2a4 \uc5c5\ub370\uc774\ud2b8\ub294 3\uac00\uc9c0\uac00 \uc788\ub2e4.<\/span><\/p>

\uc704\uc5d0 \ub098\uc628 \uac83\ucc98\ub7fc \ub370\uc774\ud130\uac00 \uc801\uc740\uacbd\uc6b0 \uc804\uccb4 \ub610\ub294 \ubd80\ubd84 \uc778\ub371\uc2f1\uc744 \ud1b5\ud574 \uc778\ub371\uc2a4 \uc804\uccb4\ub97c \ucc98\uc74c\ubd80\ud130 \ub2e4\uc2dc  \uc0dd\uc131\ud558\ub294 \ubc29\ubc95\uacfc \ub77c\uc774\ube0c \uc778\ub371\uc2f1, \uadf8\ub9ac\uace0 Delta \ubc29\uc2dd \uc778\ub371\uc2f1\uc774 \uc788\ub2e4.<\/span><\/p>

\uc5ec\uae30\uc11c\ub294 Delta \uc5c5\ub370\uc774\ud2b8 \ubc29\ubc95\uc744 \uc18c\uac1c\ud55c\ub2e4.<\/span><\/p>


<\/span><\/p>

Delta \uc5c5\ub370\uc774\ud2b8\ub294  Main + Delta \ubc29\uc2dd\uc73c\ub85c, \uba3c\uc800 \uc8fc\ub41c \uc778\ub371\uc2a4\ub97c Main\uc774 \uac16\uac8c\ud558\uace0, MySQL\uc5d0 \ucd94\uac00\ub41c \ub370\uc774\ud130\ub97c Delta\uc5d0\uc11c \uc778\ub371\uc2f1 \ud558\ub3c4\ub85d \ud55c\ub2e4.<\/span><\/p>

\uadf8\ub9ac\uace0\ub098\uc11c Delta\uc758 \ub370\uc774\ud130\ub97c Main\uc5d0 \uac74\ub124\uc8fc\uc5b4 \ub370\uc774\ud130\ub97c \ud569\uce5c\ub2e4.<\/span><\/p>

\ub530\ub77c\uc11c \ucd94\uac00\ub41c \ub370\uc774\ud130\ub9cc \uc778\ub371\uc2f1\ud558\uba74 \ub418\ubbc0\ub85c \uc778\ub371\uc2a4 \uc804\uccb4\ub97c \uc778\ub371\uc2f1 \ud560 \ud544\uc694\uac00 \uc5c6\ub2e4.<\/span><\/p>


<\/p>

\uc608\uc81c\ub85c \ucca8\ubd80\ud55c sphinx.conf\uc5d0 \uc788\ub294 \uc778\ub371\uc2a4\ub4e4 \uc911\uc5d0 shop \uc778\ub371\uc2a4\uac00 Delta \uc5c5\ub370\uc774\ud2b8 \ubc29\uc2dd\uc744 \uc0ac\uc6a9\ud55c\ub2e4.<\/span><\/p>

 source shop<\/span><\/p>

 {<\/span><\/p>

         type                    = mysql<\/span><\/p>


<\/p>

         sql_host                = localhost<\/span><\/p>

         sql_user                = debian<\/span><\/p>

         sql_pass                = anne$1929<\/span><\/p>

         sql_db                  = test<\/span><\/p>

         sql_port                = 3306  # optional, default is 3306<\/span><\/p>

         sql_sock                = \/tmp\/mysql.sock<\/span><\/p>


<\/p>

         sql_query_pre = SET NAMES utf8<\/span><\/p>

         sql_query = SELECT sn, price, price AS s_price, pack_count, item_name, npc_name FROM shop <\/span>WHERE sphinx_yn='Y'<\/span><\/p>


<\/p>

         sql_attr_bigint         = price<\/span><\/p>

         sql_field_string        = s_price<\/span><\/p>

         sql_field_string        = pack_count<\/span><\/p>

         sql_field_string        = item_name<\/span><\/p>

         sql_field_string        = npc_name<\/span><\/p>


<\/p>

 #       sql_query_info          = SELECT * FROM shop WHERE sn=$id<\/span><\/p>

 }<\/span><\/p>


<\/p>

 source delta : shop<\/span><\/p>

 {<\/span><\/p>

         sql_query_pre = SET NAMES utf8<\/span><\/p>

         sql_query = SELECT sn, price, price AS s_price, pack_count, item_name, npc_name FROM shop <\/span>WHERE sphinx_yn='N'<\/span><\/p>

       <\/span>  sql_query_post = UPDATE shop SET sphinx_yn='Y' WHERE sphinx_yn='N'<\/span><\/p>

         sql_query_killlist = SELECT sn FROM shop WHERE sphinx_yn='D'<\/span><\/p>

 }<\/span><\/p>


<\/p>


<\/p>

 index shop<\/span><\/p>

 {<\/span><\/p>

         source                  = shop<\/span><\/p>

         path                    = \/usr\/local\/sphinx\/var\/data\/shop<\/span><\/p>

         docinfo                 = extern<\/span><\/p>

         charset_type            = utf-8<\/span><\/p>

         charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F<\/span><\/p>


<\/p>

          ...<\/span><\/p>

          ...<\/span><\/p>


<\/p>

 }<\/span><\/p>

 index delta : shop<\/span><\/div>
 {<\/span><\/div>
         source                  = delta<\/span><\/div>
         path                    = \/usr\/local\/sphinx\/var\/data\/dalta<\/span><\/div>
         docinfo                 = extern<\/span><\/div>
         charset_type            = utf-8<\/span><\/div>
         charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F<\/span><\/div>

<\/div>
          ...<\/span><\/div>
          ...<\/span><\/div>

<\/div>
 }<\/span><\/div><\/div>

<\/div><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>


<\/p>

\uc124\uc815\uc744 \ubcf4\uba74 main + delta\uc5d0\uc11c main\uc5d0 \ud574\ub2f9\ud558\ub294 \uac83\uc774 shop\ub2e4. \uadf8\ub9ac delta\uc5d0 \ud574\ub2f9\ud558\ub294 \uac83\uc774 delta\uc774\ub2e4.<\/span><\/p>

\uc790\uc2ec \uc544\ub798\uc758 \ucffc\ub9ac \uc77c\ubd80\ubd84\uc744 \ubcf4\uba74 \uc544\ub798\ucc98\ub7fc \ub418\uc5b4 \uc788\ub2e4.<\/span><\/p>


<\/p>

main\uc758 sql_query : ... WHERE sphinx_yn='Y'<\/span><\/p>

delta\uc758 sql_query : ... WHERE sphinx_yn='N'<\/span><\/p>

delta\uc758 sql_query_post : UPDATE shop SET sphinx_yn='Y' WHERE sphinx_yn='N'<\/span><\/p>


<\/p>

\uc989, MySQL\uc5d0\uc11c main\uc774 \uc778\ub371\uc2f1\ud558\ub294 \ubd80\ubd84\uc740 Y\uac12\uc774\uace0 delta\uc5d0\uc11c \uc778\ub371\uc2f1 \ud558\ub294 \ubd80\ubd84\uc740 N\uac12 \ubd80\ubd84\uc774\ub2e4.<\/span><\/p>

\uadf8\ub9ac\uace0 delta\uac00 \uc778\ub371\uc2a4\ub97c  \ub9c8\uce58\uba74 sql_query_post\ub97c \ud1b5\ud574 N\uac12\uc744 Y\uac12\uc73c\ub85c \ubc14\uafd4\uc90c\uc73c\ub85c\uc11c \ub2e4\uc2dc\ub294 delta \uc778\ub371\uc2f1\ud560\ub54c \uc778\ub371\uc2a4 \ubc94\uc704\uc5d0 \uc7a1\ud788\uc9c0 \uc54a\ub3c4\ub85d \ud574\uc900\ub2e4.<\/span><\/p>

\uc774\ub85c\uc11c \ucd94\uac00\ub41c \ub370\uc774\ud130\ub97c \uc778\ub371\uc2a4\ud558\ub294 \uac83\uc774\ub2e4.<\/span><\/p>


<\/p>

\ub2e4\uc74c\uc740 \uc774 \uacfc\uc815\uc744 \uba85\ub839\uc5b4\ub85c \ub098\ud0c0\ub0b8 \uac83\uc774\ub2e4. (\uc11c\ube44\uc2a4\uc911\uc774\uba74 --rotate \ucd94\uac00\ud560 \uac83)<\/span><\/p>


<\/p>

1. delta \uc778\ub371\uc2f1<\/span><\/p>

indexer delta <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>

2. main + delta \uc778\ub371\uc2a4 \ub370\uc774\ud130 \ud569\uce58\uae30<\/span><\/p>

indexer --merge shop delta <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>


<\/p>

\ub9cc\uc57d MySQL\uc5d0\uc11c \uc77c\ubd80 \ub370\uc774\ud130\uac00 \ubcc0\uacbd\ub41c \uac83\uc744 Sphinx\uc5d0 \ubc18\uc601\ud558\ub824\uba74 \ubcc0\uacbd\ub41c \ub370\uc774\ud130\uc758 sphinx_yn\uac12\uc744 delta\uc5d0\uc11c \uc778\ub371\uc2f1 \ud560 \uc218 \uc788\ub3c4\ub85d Y\uac12\uc744 N\uac12\uc73c\ub85c \ubcc0\uacbd\ub9cc \ud574\uc8fc\uba74 \ub370\uc774\ud130\ub97c \uc5c5\ub370\uc774\ud2b8 \ud560 \uc218 \uc788\ub2e4.<\/span><\/p>


<\/p>

\ub9cc\uc57d, MySQL\uc758 \ub370\uc774\ud130\uc911 \uc77c\ubd80\uac00 \uc0ad\uc81c \ub410\ub2e4\uba74, \uc804\uccb4, \ud639\uc778 \ubd80\ubd84 \uc778\ub371\uc2f1\uc744 \ud574\uc57c\ud55c\ub2e4. \ud558\uc9c0\ub9cc \uc0ad\uc81c\ud558\uae30\uc804\uc5d0 Sphinx\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uba3c\uc800 \ube7c\ub3c4\ub85d \ud560 \uc218 \uc788\ub2e4.<\/span><\/p>

\ubc14\ub85c delta\uc758 sql_query_killlist\uac00 \uadf8 \uc5ed\ud560\uc744 \ud55c\ub2e4.<\/span><\/p>

delta\uc758 sql_query_killlist : SELECT sn FROM shop WHERE sphinx_yn='D'<\/span><\/p>

sphinx_yn\uc758 \uac12\uc744 D\ub85c \ud574\ub450\uba74, killlist\uc758 \uc778\ub371\uc2a4 \ubc94\uc704\ub0b4\ub85c \ub4e4\uc5b4\uc628\ub2e4. \uc774\ub54c, \uc778\ub371\uc2a4\uc758 \uae30\uc900\uc774 \ub418\ub294 id\uac12\uc744 \ub118\uaca8\uc8fc\uae30\ub9cc \ud558\uba74 \ub41c\ub2e4. (\uc5ec\uae30 \uc608\uc81c\uc5d0\uc11c\ub294 id\uac00 sn\uac12\uc774\ub2e4.)<\/span><\/p>

\uc774\uc81c delta\ub97c \uc778\ub371\uc2f1\ud558\uace0 merge\uc9c0\ub97c \ud558\uba74 \ub370\uc774\ud130\uac00 \uc0ac\ub77c\uc838\uc788\ub2e4.<\/span><\/p>


<\/p>


<\/p>


<\/p>

\uc2dc\uc791 \ub4f1\ub85d<\/span><\/b><\/span><\/font><\/p>

<\/div>


<\/p>

\ub9ac\ub205\uc2a4\uac00 \uc7ac\uc2dc\uc791 \ud588\uc744 \uacbd\uc6b0 Sphinx\uac00 \uc790\ub3d9\uc73c\ub85c \uc11c\ube44\uc2a4\ub97c \uc2dc\uc791\ud558\uac8c \ub9cc\ub4e4\uae30 \uc704\ud574\uc11c \uac04\ub2e8\ud55c \uc258\uc2a4\ud06c\ub9bd\ud2b8\ub97c \ub4f1\ub85d \ud574\uc57c\ud55c\ub2e4.<\/span><\/p>


<\/p>

\uba3c\uc800, \uc2dc\uc791\ud560 \uc2a4\ud06c\ub9bd\ud2b8\ub294 init.d\uc5d0 \uc704\uce58\ud574 \uc788\uc5b4\uc57c \ud558\ubbc0\ub85c \ub514\ub809\ud1a0\ub9ac\ub97c \uc774\ub3d9\ud55c\ub2e4.<\/span><\/p>

cd \/etc\/init.d<\/span><\/p>

vi searchd<\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>


<\/p>

\ud30c\uc77c \ub0b4\uc6a9\uc740 \uc544\ub798\ucc98\ub7fc \uc801\ub294\ub2e4. (\ub9cc\uc57d \ud658\uacbd \uc124\uc815\uc774 \uae30\ubcf8\ub514\ub809\ud1a0\ub9ac\uc5d0 \uc5c6\ub2e4\uba74, --config \uc635\uc158\uc73c\ub85c \ud658\uacbd\uc124\uc815 \uc704\uce58\ub97c \uc7a1\uc544\uc8fc\ub3c4\ub85d \ud55c\ub2e4.)<\/span><\/p>

#!\/bin\/bash<\/span><\/p>

\/usr\/local\/sphinx\/bin\/searchd<\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>


<\/p>

\uc2dc\uc2a4\ud15c\uc774 \ud30c\uc77c\uc5d0 \uc811\uadfc \uac00\ub2a5\ud1a0\ub85d \uad8c\ud55c\uc744 \uc124\uc815\ud55c\ub2e4.<\/span><\/div>

chmod 755 searchd<\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>


<\/p>

\uc774\uc81c \ub370\ube44\uc548\uc744 \uc7ac\uc2dc\uc791\ud574\ub3c4 searchd\uac00 \uc790\ub3d9\uc73c\ub85c \uc2dc\uc791\ub41c\ub2e4.<\/span><\/p>

\ub9cc\uc57d \uc11c\ube44\uc2a4\ub85c\ub3c4 \ub9cc\ub4e4\uace0 \uc2f6\ub2e4\uba74 \ub2e4\uc74c \uae00\uc744 \ucc38\uace0 \ud55c\ub2e4.<\/span><\/p>

2013\/05\/04 - [Linux Debian 7] - [Debian] \ubd80\ud305\uc2dc script \ubc0f \uc11c\ube44\uc2a4 \uc2dc\uc791\ud558\ub3c4\ub85d \ub4f1\ub85d\ud558\uae30<\/span><\/a><\/span><\/p>


<\/p>


<\/p>


<\/p>

Crontab \ub4f1\ub85d<\/span><\/b><\/p>

<\/div>


<\/p>

\uc77c\uc815 \uc2dc\uac04\ub9c8\ub2e4 \uc5c5\ub370\uc774\ud2b8\ub97c \ud574\uc57c \ud560 \uacbd\uc6b0 crontab\uc5d0 \ub4f1\ub85d\ud558\uc5ec \uc5c5\ub370\uc774\ud2b8\ub97c \uc2e4\ud589\uc2dc\ud0ac \uc218 \uc788\ub2e4.<\/span><\/p>


<\/p>

1. \uc804\uccb4 \uc5c5\ub370\uc774\ud2b8<\/span><\/b><\/p>

\uba3c\uc800 \uc804\uccb4 \uc5c5\ub370\uc774\ub97c \ub9cc\ub4e4\uae30 \uc704\ud574 Shellscript\ub97c \ub9cc\ub4e4\ub3c4\ub85d \ud558\uc790.<\/span><\/p>

cd \/usr\/local\/sphinx\/bin<\/span><\/p>

vi sphinx_total_updater.sh<\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>

sphinx_total_updater.sh \ub0b4\uc6a9\uc5d0\ub294 \uc544\ub798\ucc98\ub7fc \uc804\uccb4 \uc5c5\ub370\uc774\ud2b8 \uba85\ub839\uc5b4\ub97c \ub123\ub3c4\ub85d \ud55c\ub2e4.<\/span><\/p>

#!\/bin\/bash<\/span><\/p>

\/usr\/local\/sphinx\/bin\/indexer --all --rotate<\/span><\/p>

sleep 2<\/span><\/p>

\/usr\/local\/sphinx\/bin\/indexer --merge shop delta --rotate <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>


<\/p>


<\/p><\/div>

2. \ubd80\ubd84 \uc5c5\ub370\uc774\ud2b8<\/span><\/b><\/p>

\ubd80\ubd84\uc801\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8\ub97c \ud558\uae30 \uc704\ud574 Shellscript\ub97c \ub9cc\ub4e4\ub3c4\ub85d \ud558\uc790.<\/span><\/p>

cd \/usr\/local\/sphinx\/bin<\/span><\/p>

vi sphinx_partial_updater.sh<\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>

sphinx_partial_updater.sh \ub0b4\uc6a9\uc5d0\ub294 \uc544\ub798\ucc98\ub7fc \ubd80\ubd84 \uc5c5\ub370\uc774\ud2b8 \uba85\ub839\uc5b4\ub97c \ub123\ub3c4\ub85d \ud55c\ub2e4.<\/span><\/p>

#!\/bin\/bash<\/span><\/p>

\/usr\/local\/sphinx\/bin\/indexer delta --rotate<\/span><\/p>

sleep 2<\/span><\/p>

\/usr\/local\/sphinx\/bin\/indexer --merge shop delta --rotate <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>


<\/p>

3. Crontab \ub4f1\ub85d<\/span><\/b><\/p>

crontab -e <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>

\ub9cc\ub4e0 \uc2a4\ud06c\ub9bd\ud2b8 \uacbd\ub85c\ub97c \ud1b5\ud574 \ud06c\ub860\uc744 \uc2e4\ud589\ud558\ub3c4\ub85d \ud55c\ub2e4. (\uc544\ub798\uc758 \uc608\ub294 \ub9e4 \ubd84\ub9c8\ub2e4 \uc2e4\ud589\ud55c\ub2e4.)<\/span><\/p>

* * * * * \/usr\/local\/sphinx\/bin\/sphinx_total_updater.sh<\/span><\/p>

* * * * * \/usr\/local\/sphinx\/bin\/sphinx_partial_updater.sh <\/span><\/p><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>

\uc77c\uc815\ud55c \uc2dc\uac04 \uc124\uc815 \ub4f1\uc740 \ub2e4\uc74c \ub9c1\ud06c\ub97c \ucc38\uace0\ud558\ub3c4\ub85d \ud55c\ub2e4.<\/span><\/p>

2013\/01\/09 - [Linux] - [Linux] crontab<\/span><\/a><\/p>


<\/p>


<\/p>


<\/p>

\uc774\uc0c1\uc73c\ub85c Sphinx \uac80\uc0c9 \uc5d4\uc9c4\uc744 \ud1b5\ud574 \ub370\uc774\ud130\ub97c \uc778\ub371\uc2f1\ud558\uace0, \uc5c5\ub370\uc774\ud2b8 \ubc0f \uc0ad\uc81c \uadf8\ub9ac\uace0, \ub9ac\ub205\uc2a4\uac00 \uc54c\uc544\uc11c \uc5c5\ub370\uc774\ud2b8 \ub418\ub3c4\ub85d \ud588\ub2e4.<\/span><\/p>

\ub2e4\uc74c 5\ubd80\uc5d0\uc11c\ub294 \uc6f9\uc11c\ube44\uc2a4\ub97c \uc704\ud574 PHP\uc640\uc758 \uc5f0\uacb0 \ubd80\ubd84\uc744 \ub2e4\ub8e8\uaca0\ub2e4.<\/span><\/p>


<\/p>

1. \uc18c\uac1c<\/span><\/b><\/p>

4\ubd80\uae4c\uc9c0 \ud588\ub2e4\uba74, \ud604\uc7ac Sphinx \uac80\uc0c9 \uc5d4\uc9c4\uc774 \uc124\uce58\ub418\uc5b4 \uc788\uace0, \uc608\uc81c test.sql \ub370\uc774\ud130\ub97c \ud1b5\ud574 \uac80\uc0c9\ub3c4 \uc798 \ub420 \uac83\uc774\ub2e4.<\/span><\/p>

PHP\uc5d0\uc11c MySQL \uc811\uc18d\uc744 \ud1b5\ud574<\/span> \uc0ac\uc6a9\ud588\ub358 \uac83\ucc98\ub7fc \uc0ac\uc6a9\ud558\uba74 \ub418\ubbc0\ub85c \uc544\uc8fc \uac04\ub2e8\ud558\ub2e4.<\/span><\/p>


<\/p>


<\/p>


<\/p>

2. \uc811\uc18d<\/span><\/b><\/p>

\uc544\ub798\uc640 \uac19\uc740 mysql_connect\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc811\uc18d\ud558\ub294 \uc608\uc81c\uc774\ub2e4.<\/span><\/p>


<\/p>

\uc544\uc27d\uac8c\ub3c4 \ud604\uc7ac Sphinx\ub294 ID\uc640 Password\ub97c \uc124\uc815 \ud560 \uc218 \uc5c6\ub2e4\uace0 \ud55c\ub2e4.<\/span><\/p>

\ub530\ub77c\uc11c ID\uc640 Password\ub294 \ube44\uc6cc\ub450\uace0 \uc811\uc18d\ud558\uba74 \ub41c\ub2e4.<\/span><\/p>


<\/p>

<meta charset=\"utf-8\"><\/span><\/p>

<?php<\/span><\/p>


<\/span><\/p>


<\/p>

 $hostname = \"127.0.0.1:9306\";<\/span><\/p>

 $username = \"\";<\/span><\/p>

 $passwd = \"\";<\/span><\/p>

 $dbname = \"test\";<\/span><\/p>

 $connect = mysql_connect($hostname, $username, $passwd) or die(\"Failed\");<\/span><\/p>

 $result = mysql_select_db($dbname, $connect);<\/span><\/p>

 echo \"\uc811\uc18d \uc5ec\ubd80? : \".$result;<\/span><\/p>


<\/p>

 mysql_query(\"set names utf8\");     \/\/ \uacb0\uacfc\uac12\uc774 \ud55c\uae00\uc778 \uacbd\uc6b0 \uc0ac\uc6a9<\/span><\/p>


<\/p>

 $sql=\"SELECT title FROM book LIMIT 10\";<\/span><\/p>

 $rs =  mysql_query($sql, $connect);   \/\/ sql\ubb38 \uc2e4\ud589<\/span><\/p>


<\/p>

 while($info=mysql_fetch_array($rs)){<\/span><\/p>

         echo $info['title'].\"<br>\";<\/span><\/p>

 }<\/span><\/p>


<\/p>

 ?><\/span><\/p>


<\/div><\/td>\n<\/tr>\n<\/tbody><\/table>


<\/p>

\uc6f9\ube0c\ub77c\uc6b0\uc800\ub97c \ud1b5\ud574 \uc544\ub798\ucc98\ub7fc \uc811\uc18d\ud558\uba74 \uac04\ub2e8\ud558\uac8c \uac80\uc0c9\ub41c \uacb0\uacfc\uac00 \ub098\uc628\ub2e4.<\/span><\/p>


<\/p>

<\/span><\/span><\/p>


<\/p>


<\/p>

\uc774\uc81c \uac80\uc0c9 \uc5d4\uc9c4 \uc11c\ube44\uc2a4\uac00 \ubaa8\ub450 \uc644\ub8cc\ub418\uc5c8\ub2e4.<\/span><\/p>

MySQL\uc774 like \ubb38\uc73c\ub85c \ud798\ub4e4\uac8c \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud558\ub294 \uac83\ubcf4\ub2e4 Sphinx\ub97c \uc0ac\uc6a9\ud558\uba74 \ubb34\ucc99 \ube60\ub974\uace0, \uc815\ud655\ud55c \uacb0\uacfc\uac12\uc744 \ub0b4\uc900\ub2e4.<\/span><\/p>

\ub530\ub77c\uc11c \ub370\uc774\ud130\uac00 \ub9ce\ub2e4\uba74, \uac80\uc0c9 \uc5d4\uc9c4\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \ud070 \uc774\uc775\uc774 \ub420 \uac83\uc774\ub2e4.<\/span><\/p><\/div>


<\/p>\n","protected":false},"excerpt":{"rendered":"

\uc18c\uac1c MySQL\uc5d0\uc11c \ub370\uc774\ud130 \uac80\uc0c9\uc2dc \ub370\uc774\ud130\uac00 \ub9ce\uc740 \uacbd\uc6b0 \uc790\ub8cc\ub97c \uac80\uc0c9\ud558\ub294\ub370 \uc18c\ubaa8\ub418\ub294 \uc2dc\uac04\uc774 \ud06c\ub2e4. MySQL\uc758 \ub370\uc774\ud130\ub97c \ubcc4\ub3c4\uc758 \uac80\uc0c9\uc5d4\uc9c4\uc774 \uc778\ub371\uc2f1\ud558\uc5ec \uc778\ub371\uc2f1\uc744 \uac80\uc0c9\ud568\uc73c\ub85c\uc11c \uc2dc\uac04 \uc18c\ubaa8\ub97c \uc904\uc77c \uc218 \uc788\ub2e4. \uc5ec\uae30\uc11c\ub294 \uc624\ud508\uc18c\uc2a4 \ud504\ub85c\uadf8\ub7a8\uc778 Sphinx \uac80\uc0c9 \uc5d4\uc9c4\uc744 \ub3c4\uc785\ud574\ubcf4\uace0, Sphinx \uac80\uc0c9\uc5d4\uc9c4\uacfc MySQL, \uadf8\ub9ac\uace0 PHP\uc640 \ud568\uaed8 \uc0ac\uc6a9\ud574\ub3c4\ub85d \ud55c\ub2e4. \uc124\uce58 \ud658\uacbd OS : Debian 7 64Bit S\/W : MySQL : 5.6.11 \/ PHP 5.4.4-14 \uc124\uce58\ud560 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[23],"tags":[],"class_list":["post-507","post","type-post","status-publish","format-standard","hentry","category-development_web"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/507","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=507"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/507\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=507"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=507"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=507"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}