日期:2014-05-16  浏览次数:20910 次

MySQL 5.5.x Coreseek 4.x / Sphinx 1.x 实现中文分词搜索

MySQL/MariaDB(支持SphinxSE、Windows版本、源码补丁)


基于MySQL 5.0.92、MySQL 5.1.55、MySQL 5.5.9、MySQL 5.5.15/16、MariaDB 5.2.4,提供支持SphinxSE的Windows版本;最新版本支持string属性,可直接返回索引中存储的信息。2011-10-18更新!


首先:关于什么是SphinxSE,请前往学习了解;关于如何从源代码安装SphinxSE,请前往学习了解。


?

Win32 MySQL/SphinxSE Download (下载)


    使用前,请先下载Microsoft Visual C++ 2008 运行时环境 (x86,1.7M大小)并安装

    注意 : 1. 请先备份原有程序和数据,避免误操作导致数据丢失;默认用户root,密码为空

       2. 注意字符集为,连接时,应使用SET NAMES utf8,使用utf8字符集

       3. 可在my.ini的[mysql]和[mysqld]配置段加上default-character-set=utf8,则默认为utf8

  • Coreseek 4.x / Sphinx 1.x : (Please install Microsoft Visual C++ 2008 Runtime (x86, 1.7M))
  • MySQL 5.5.15/16 :
    • Win32 MySQL 5.5.16 / SphinxSE Plugin : coreseek-4.1-win32.zip/plugin/mysql-5.5.16-win32/lib/plugin/ha_sphinx.dll ( Recommended/Support string attr 推荐,支持string属性 )
    • Win32 MySQL 5.5.15 / SphinxSE Plugin : coreseek-4.1-win32.zip/plugin/mysql-5.5.15-win32/lib/plugin/ha_sphinx.dll ( Recommended/Support string attr 推荐,支持string属性 )
    • SphinxSE Plugin Install (插件模式安装) :
      • Chinese : 解压ha_sphinx.dll放到MySQL 5.5.15/16的lib/plugin/目录中,使用root登陆MySQL;
      • English : extract ha_sphinx.dll from zip file, put it into lib/plugin, login to mysql with root.
      • Install (启用): INSTALL PLUGIN sphinx SONAME "ha_sphinx.dll"
      • Uninstall (关闭): UNINSTALL PLUGIN sphinx
  • MySQL 5.5.x :
    • Win32 MySQL 5.5.9 / SphinxSE SVN r2616 Plugin : mysql-5.5.9-SphinxSE-svn-r2616-1.11-dev-coreseek-win32-ha_sphinx.dll.zip ( Recommended/Support string attr 推荐,支持string属性 )
    • Win32 MySQL 5.5.8 + SphinxSE SVN r2616 : mysql-5.5.8-SphinxSE-svn-r2616-1.11-dev-coreseek-win32.zip ( Support string attr 支持string属性 )
    • Win32 MySQL 5.5.8 / SphinxSE SVN r2616 Plugin : mysql-5.5.8-SphinxSE-svn-r2616-1.11-dev-coreseek-win32-ha_sphinx.dll.zip ( Support string attr 支持string属性 )
    • SphinxSE Plugin Install (插件模式安装) :
      • Chinese : 解压ha_sphinx.dll放到MySQL 5.5.x的lib/plugin/目录中,使用root登陆MySQL;
      • English : extract ha_sphinx.dll from zip file, put it into lib/plugin, login to mysql with root.
      • Install (启用): INSTALL PLUGIN sphinx SONAME "ha_sphinx.dll"
      • Uninstall (关闭): UNINSTALL PLUGIN sphinx
  • MariaDB 5.2.4 :
    • Win32 MariaDB 5.2.4 + SphinxSE SVN r2616 + Plugin: MariaDB-5.2.4-SphinxSE-svn-r2616-1.11-dev-coreseek-win32.zip ( Support string attr 支持string属性 )
    • Win32 MariaDB 5.2.4 / SphinxSE SVN r2616 Plugin : MariaDB-5.2.4-SphinxSE-svn-r2616-1.11-dev-coreseek-win32-ha_sphinx.dll.zip ( Recommended/Support string attr 推荐,支持string属性 )
    • SphinxSE Plugin Install (插件模式安装) :
      • Chinese : 解压ha_sphinx.dll放到MariaDB 5.2.x的lib/plugin/目录中,使用root登陆MariaDB;
      • English : extract ha_sphinx.dll from zip file, put it into lib/plugin, login to MariaDB with root.
      • Install (启用): INSTALL PLUGIN sphinx SONAME "ha_sphinx.dll"
      • Uninstall (关闭): UNINSTALL PLUGIN sphinx
  • MySQL 5.1.x :
    • Win32 MySQL 5.1.55 / SphinxSE SVN r2616 Plugin : mysql-5.1.55-SphinxSE-svn-r2616-1.11-dev-coreseek-win32-ha_sphinx.dll.zip ( Recommended/Support string attr 推荐,支持string属性 )
    • Win32 MySQL 5.1.54 + SphinxSE SVN r2616 : mysql-5.1.54-SphinxSE-svn-r2616-1.11-dev-coreseekwin32.zip ( Support string attr 支持string属性 )
    • Win32 MySQL 5.1.54 / SphinxSE SVN r2616 Plugin : mysql-5.1.54-SphinxSE-svn-r2616-1.11-dev-coreseek-win32-ha_sphinx.dll.zip ( Support string attr 支持string属性 )
    • SphinxSE Plugin Install (插件模式安装) :
      • Chinese : 解压ha_sphinx.dll放到MySQL 5.1.x的lib/plugin/目录中,使用root登陆MySQL;
      • English : extract ha_sphinx.dll from zip file, put it into lib/plugin, login to mysql with root.
      • Install (