MySQL with Sphinx storage engine
Today I’ve launched Visual Studio 9 2008 and compiled Sphinx, the full-text indexer, as storage engine into MySQL. I’ve limited my effords to the latest 64bit Windows version, because compiling under Linux is with GCC rather trivial.
MySQL 5.1 with SphinxSE for 64bit Windows can be downloaded here.
Just replace your original MySQL files by these from the zipfile.
Bookmark to:
Follow me on Twitter
Another source for customized MySQL builds I’ve found is http://ourdelta.org/. Unfortunately it seems to be down at the moment.
if you will compile mysql with 64 bit, try to install the 64bit dependency only. example openssl.x86_64 openssl-devel.x86_64
another will be some programs dont detect lib64 or it goes to lib instead so you should add a parameter –with-libdir=/lib64
Hi,
Could you please let me know if you have precompiled binary (MySQL 5.1 + SphinxSE) for 32 bit systems? I am having hard time compiling the sources.
Thanks in advance
Manoj
Renz, your tip is good, installing a GNU system with 64bit libraries only spares the admin a lot headaches due to incompatibilities. I’ve found compiling packages with
--with-picsolves some issues, too.BTW, my MySQL build instructions do look like these (I prefer Gentoo, but these are for OpenSuSE):
# replace these with settings suitable for your architecture: export CHOST="x86_64-pc-linux-gnu" export CFLAGS="-march=k8 -O3 -pipe -mno-tls-direct-seg-refs -fomit-frame-pointer -fno-exceptions" export CXXFLAGS="${CFLAGS} -felide-constructors -fno-rtti" export SRCS="/usr/src/packages/SOURCES" cd /tmp tar -xzf ${SRCS}/sphinx-*.tar.gz tar -xzf ${SRCS}/sourcecode/mysql-5.4*.tar.gz cd /tmp/mysql* cp -ra ../sphinx-*/mysqlse storage/sphinx patch -p1 < ${SRCS}/kubacki_-_mysql-5.4.1-beta_fnv_64.patch patch -p1 < ${SRCS}/kubacki_-_mysql_sphinx_additional_settings.patch BUILD/autorun.sh \ && ./configure \ --prefix=/usr --sysconfdir=/etc --build=x86_64-pc-linux-gnu --cache-file=./config.cache \ --libdir=/usr/lib64 --with-unix-socket-path=/var/run/mysql/mysql.sock \ --enable-assembler --enable-local-infile --enable-thread-safe-client --with-atomic-ops=up --with-pthread \ --with-mysqld-user=mysql --without-bench --without-docs --without-debug \ --with-pic --with-readline \ --with-charset=utf8 --with-extra-charsets=utf8,latin1,ascii \ --with-myisam --with-heap --with-csv --with-archive-storage-engine --with-blackhole-storage-engine --with-partition \ --with-sphinx --with-plugins=sphinx --with-server-suffix=-qkai \ && make \ && sudo -- make installManoj, I’ve compiled 32bit versions for you. See the downloads page.
Hi marl, you mention you have compiled a 32 bit version, where is the downloads page?
Thanks
Craig
Sorry Mark, scrap that. Found your link. Should look more carefully lol!