Hi!
On Jul 13, 2008, at 10:27 AM, Antony T Curtis wrote:
Sure... Perhaps only hold complete schemas in memory (useful when
foreign keys are implemented in a meaningful way). So if no
connection is using a specific schema, it can be removed from
The only issue there is with resource counting. I need to look and see
what the cost is for signaling is in pthreads. I have never given it
much thought, so I want to know how expensive it is.
Since we use a pool of threads, unlike the main server, we have a few
options for THD that it lacks. For instance our cost for dirty writes/
reads should not not require locks for certain stats.
memory. The idea I suggested where a single file holds the SQL DDL
would be split apart so that there is one such file per schema. Make
this a 'plugable' behaviour so that for storage engines which only
know if a table exists at use time can implement their own schema
cache. This would mean that such uncooperative storage engines
cannot have their tables co-exist in the same schema as
Right. This what I believe we all keep discussing as "discovery". One
of the open questions is if Innodb has enough support in it now to
handle this, or if we are going to have to use the default mechanism
(aka go back to serialized FRM for it).
other engines but that would be a minor impediment which can be
relieved with views etc. The server would ask all SCHEMA plugins if
they 'own' a schema the first time that schema is accessed. Of
course, the 'mysql' schema must only use the inbuilt schema
plugin ... and the information_schema would be its own as well...
Hmmm, this could be an elegant way to get rid of some of the I_S
hacks and abstract them nicely too.
Right now we do not have a "mysql" system schema. I think we can avoid
having one...
Cheers,
-Brian
--
_______________________________________________________
Brian "Krow" Aker, brian at tangent.org
Seattle, Washington
http://krow.net/ <-- Me
http://tangent.org/ <-- Software
_______________________________________________________
You can't grep a dead tree.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
