• sphinx, sphinx_snippets() & MySQL 5.5

    March 21, 2012

    I've written a patch which completes Sphinx's integration with MySQL 5.5. Up until a couple months ago, Sphinx would not compile with MySQL 5.5 at all. This is, thankfully, resolved as of Sphinx 2.0.3. However, to my disdain, I've found out that it only partially work: the sphinx_snippets() user defined function is not included within […]

  • Auto caching INFORMATION_SCHEMA tables: seeking input

    March 8, 2012

    The short version I have it all working. It's kind of magic. But there are issues, and I'm not sure it should even exist, and am looking for input. The long version In Auto caching tables I presented with a hack which allows getting cached or fresh results via a simple SELECT queries. The drive […]

  • Auto caching tables

    March 6, 2012

    Is there a way to create a caching table, some sort of a materialized view, such that upon selecting from that table, its data is validated/invalidated? Hint: yes. But to elaborate the point: say I have some table data_table. Can I rewrite all my queries which access data_table to read from some autocache_data_table, but have […]

Powered by Wordpress and MySQL. Theme by openark.org