* Eric Prud'hommeaux <eric+mysql@stripped> [05/05/26 05:55]:
> In the same vein as adding a wet bar to a schoolbus, I'm working on
> adding SPARQL support to MySQL. I've written up some notes:
> <http://www.w3.org/2005/05/22-SPARQL-MySQL/>
> Alarmed yet? If not, here are some questions:
>
> I have a need for knowing foreign keys even when folks haven't taken
> the discipline step of specifying them as constraints.
> <http://www.w3.org/2005/05/22-SPARQL-MySQL/#structure>
> Any advice on how I should learn and where I should keep that
> meta-data?
Take a look at how information_schema.table_constraints and
information_schema.key_column_usage tables are filled.
You can also find out what keys a table has after you opened it.
> I haven't stepped into the memory management yet. Does mysqld have a
> per-request pool like Apache, or are request processors responsible
> for intimate clean-up?
MySQL has a per-query memory area, thd->mem_root.
--
Konstantin Osipov, Software Developer
MySQL AB, www.mysql.com
