distal-attribute
distal-attribute
distal-attribute
distal-attribute

SphinxQL support / custom startup commands on connect

kaseriisikas posted 3 years ago in Feature discussion
I've been using HeidiSQL for several months and I really like this tool. Keep up the good work!

I'd like to use HeidiSQL to make fulltext queries on a Sphinx Search Server (http://www.sphinxsearch.com), which has a MySQL-like interface (http://sphinxsearch.com/docs/2.0.2/sphinxql-reference.html).
I can make a connection and run queries, but some errors pop out in the process. Specifically, the SphinxQL does not seem to support the queries

SHOW STATUS LIKE 'Uptime';
SHOW DATABASES;
...


that are being executed after establishing the connection. Sphinx cannot be blamed, since it is not a true MySQL server and probably will never support these.

However, is it possible to define a new session (in the Session manager) in a way that no additional startup commands (even those required to fetch a list of databases) are sent to server? Or perhaps override the default startup commands from a file? I've tried the "Startup script" parameter in the Session manager, but that does not work the way I'd like.
ansgar posted 3 years ago
Well Heidi is a MySQL + MSSQL client, and does not support Sphinx. I wonder you can connect to it at all with Heidi.
jfalch posted 3 years ago
MariaDB has Sphinx access as a "storage engine" plugin (http://kb.askmonty.org/en/about-sphinxse/2941/); this way, you define "sphinx databases" within your mysql server (which do access an external sphinx server). This way, no automatic server startup code should be run for a sphinx database. I do not know wether this plugin will run with your server, but it should be worth a try.

Please login to leave a reply, or register at first.