At 04:18 2002-03-05, you wrote:
>Tomasz,
>
>are you running on Windows?
>
>Please use innodb_table_monitor as explained in section 9.1 of
>http://www.innodb.com/ibman.html, and also look into section 15.1.
>
>Best regards,
Re: 9.1: Well, can't find innodb* anywhere on the system
Re: 15.1: The second problem seems to be mine, the one about "orphaned'
.frm files. That would seem to account for me seeing a tables list, but
nothing about them. Obviously, the .frm files did exist. Couldn't drop the
tables or the database ("Unknown table ...,...,...). Let me repeat:
everything was just fine until I quit mysql. When I logged back in - with
the same command, I use ksh and 'set -o vi' - that's when the issues started.
I got out of this trouble by shutting down the server, manually removing
all InnoDB files (including .frm), then starting it again - which created
the IDB files. I then used my script to create database and all the tables.
And everything was fine until I logged out. I now logged back in and
everything is still OK: I can desc tables, and so on. Just one issue: when
I do SHOW CREATE ..., it still doesn't show any REFERENCES ... that I had
when I created the tables. Either I'm exceptionally thick, or the docs
really say that InnoDB has the capability to use the foreign keys... I took
special care to reference only tables that already existed, in case it's a
concern.
Any idea? Also about how long will the tables stay healthy? I don't care
about those 5 records I put in each, but to really test, I need to put a
bit more...
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> snip! <<<<<<<<<<<<<<<<<<<<<<
THX!
--------------------------------------------------
sql, query
---------------------------------------------------------------------
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
