Jeremy, At 11:37 PM 11/2/01 -0800, you wrote: >On Fri, Nov 02, 2001 at 11:17:37PM +0200, Heikki Tuuri wrote: >> >> I looked now what MySQL does when it calls lock_external at startup: >> it initializes MySQL system tables like 'host' and 'user'. I assume >> you have not converted MySQL system tables to InnoDB format? That is >> not allowed. They must be MyISAM type. > >I once converted ALL the databases and tables on a machine from MyISAM >to Gemini. And I seem to remember it working.
in theory it could work. But since it has not been tested, in practice it probably will not. I do not what kind of a 'thd' handle mysqld uses when accessing its system tables, and I think it is best to leave the freedom to MySQL AB to change the access pattern as they like. Also, the system tables are managed in a non-transactional fashion, using table level locks. I do not know what happens if the tables are transactional and are managed with row level locking. >Hmm. > >Sounds like we need a big red warning in the docs about this. Maybe >even something in the code to make it impossible. Yes, I think I will ban table names 'mysql/host', 'mysql/user', 'mysql/db' internally inside InnoDB code. >Jeremy >-- >Jeremy D. Zawodny, <[EMAIL PROTECTED]> >Technical Yahoo - Yahoo Finance >Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 > >MySQL 3.23.41-max: up 58 days, processed 1,299,168,985 queries (258/sec. avg) Regards, Heikki http://www.innodb.com/ibman.html --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
