index rt

{

        type = rt

        rt_mem_limit = 512M

        path = /usr/local/sphinx/data/rt

        rt_field = title

        rt_field = content

        rt_attr_uint = gid

}

searchd

{

  workers           = threads

  listen            = 3312

  listen            = 3313:mysql41

  log               = /usr/local/sphinx/var/log/searchd.log

  query_log         = /usr/local/sphinx/var/log/query.log

  read_timeout      = 5

  client_timeout    = 300

  max_children      = 30

  pid_file          = /usr/local/sphinx/var/log/searchd.pid

  max_matches       = 1000

  seamless_rotate   = 1

  preopen_indexes   = 1

  unlink_old        = 1

}

/usr/local/sphinx/bin/searchd -c /usr/local/sphinx/etc/csft_rt.conf

mysql -h 10.10.3.181 -P 3313

MySQL [(none)]> desc rt;

+---------+---------+

| Field   | Type    |

+---------+---------+

| id      | integer |

| title   | field   |

| content | field   |

| gid     | uint    |

+---------+---------+

4 rows in set (0.00 sec)

insert into rt (id,title,content,gid) values (1,'','','');

MySQL [(none)]> select * from rt;

+------+------+

| id   | gid  |

+------+------+

|    1 |  111 |

+------+------+

1 row in set (0.00 sec)