我用的是ubuntu13.10，在安装完毕sphinxsearch后，在/etc/sphinxsearch/下有个sphinx.conf配置文件(注：不要问我关于windows下如何配置sphinx)

searchd
{
        # [hostname:]port[:protocol], or /unix/socket/path to listen on
        # known protocols are 'sphinx' (SphinxAPI) and 'mysql41' (SphinxQL)
        #
        # multi-value, multiple listen points are allowed
        # optional, defaults are 9312:sphinx and 9306:mysql41, as below
        #
        # listen                        = 127.0.0.1
        # listen                        = 192.168.0.1:9312
        # listen                        = 9312
        # listen                        = /var/run/searchd.sock
        listen                  = 9312
        listen                  = 9306:mysql41
        # log file, searchd run info is logged here
        # optional, default is 'searchd.log'
        log                     = /var/log/sphinxsearch/searchd.log
        # query log file, all search queries are logged here
        # optional, default is empty (do not log queries)
}

可以使用这种方式：

Yii::$app->db->createCommand()->batchInsert('user', ['name', 'age'], [
    ['Tom', 30],
    ['Jane', 20],
    ['Linda', 25],
])->execute();

详情查看官方文档：http://www.yiiframework.com/doc-2.0/guide-db-dao.html#non-select-queries