Thanks again,
It is becoming relatively clear now. Sounds like for the most part,
once InnoDB is set up, everything is handled like a 'normal' MyISAM
table with InnoDB simply adding the transactional support. Does Michael
Kofler's book discuss a lot of these types of things? The InnoDB
material is terrific, but I think I will definitely need some dead-tree
literature on this (so I don't have to keep bugging this list with
low-level topics). Thanks, Aaron
-----Original Message-----
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 12:24 PM
To: [EMAIL PROTECTED]
Subject: Re: innoDB confusion
Aaron,
"Rutledge, Aaron" wrote in message ...
>
>Woah...
>
>Heikki Tuuri wrote:
>"With some work, yes. innodb_table_monitor prints the internal schema
of
>InnoDB. There are fewer column types inside InnoDB than in MySQL. For
>example, a DATE column will appear as an integer."
>
>Now I am confused again. Do you only have access to column types
>specified by InnoDB? I thought that was the purpose of the .frm files.
you have all the column types of MySQL available. The above just means
that
at the lower level types are mapped to more basic types. Internally DATE
columns can be compared like integer columns.
>--Aaron
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and foreign key support for
MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
