xing18c

xing18c

这家伙有点懒,还没写个性签名!

  • 财富值1843
  • 威望值0
  • 总积分2253

个人信息

  • 2014-12-29 已签到
    连续签到1天,获得了5个金钱
  • 2014-12-27 已签到
    连续签到3天,获得了15个金钱
  • 回复了 的回答

    我用的是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)
    }
    

    windows下如何配置sphinx ,我还正想问这个呢

  • 2014-12-26 已签到
    连续签到2天,获得了10个金钱
  • 回复了 的回答

    在composer.json中的require中添加:"yiisoft/yii2-sphinx": "*"
    然后在配置文件中添加该插件:

    return [
        //....
        'components' => [
            'sphinx' => [
                'class' => 'yii\sphinx\Connection',
                'dsn' => 'mysql:host=127.0.0.1;port=9306;',
                'username' => '',
                'password' => '',
            ],
        ],
    ];
    

    使用的时候,举个例子如下:

    $sql = 'SELECT * FROM idx_item WHERE group_id = :group_id';
    $params = [
        'group_id' => 17
    ];
    $rows = Yii::$app->sphinx->createCommand($sql, $params)->queryAll();
    

    mysql41这个什么意思呀

  • 回复了 的回答

    在composer.json中的require中添加:"yiisoft/yii2-sphinx": "*"
    然后在配置文件中添加该插件:

    return [
        //....
        'components' => [
            'sphinx' => [
                'class' => 'yii\sphinx\Connection',
                'dsn' => 'mysql:host=127.0.0.1;port=9306;',
                'username' => '',
                'password' => '',
            ],
        ],
    ];
    

    使用的时候,举个例子如下:

    $sql = 'SELECT * FROM idx_item WHERE group_id = :group_id';
    $params = [
        'group_id' => 17
    ];
    $rows = Yii::$app->sphinx->createCommand($sql, $params)->queryAll();
    
    searchd
    {
        listen = localhost:9306:mysql41
        ...
    }
    

    这个怎么用啊!!

  • 回复了 的回答

    没有解决我遇到的问题。。。

    ok--哈哈哈哈哈

  • 2014-12-25 已签到
    连续签到1天,获得了5个金钱
  • 求解--------

  • 2014-12-18 已签到
    连续签到2天,获得了10个金钱
总监 等级规则
2253/5000
资料完整度
50/100
用户活跃度
0/100

Ta的关注

33

Ta的粉丝

11

Ta的访客

27