>From the manual:
"The default database page size in InnoDB is 16 kB. By recompiling the
code one can set it from 8 kB to 64 kB. The maximun row length is
slightly less than a half of a database page, the row length also
includes BLOB and TEXT type columns. The restriction on the size of BLOB
and TEXT columns will be removed by June 2001 in a future version of
InnoDB. " - http://www.mysql.com/doc/I/n/InnoDB_restrictions.html
I read this to mean that the limit on a TEXT column is slightly less
than 32k at best (if you recompile the code), or slightly less than 8k
by default.
Hello PostgreSQL...
Good luck
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> m] On Behalf Of ryc
> Sent: Wednesday, June 13, 2001 8:48 PM
> To: MySQL
> Subject: innodb text fields
>
>
> I am aware that currently innobase tables can not have
> abritararly large text/varchar fields and support for this
> will be released sometime in the month of June. The
> application I am working with requires text fields (usually
> less than 64k), and I desperatly need row level locking.
> Either I continue using Mysql, and use Innodb tables.. or I
> have to switch to Postgresql.
>
> I need to do something right away about this performance
> problem, I can not wait until Innodb tables are released with
> the unlimited row length. I tried to find out what the max
> row length for a Innodb table row, but did not find it in the
> documentation. If it isnt too much smaller than 64k I could
> switch now, and not have to worry about using postgresql.
> Does anyone know what the limit is? Any pointers would be apreciated.
>
> ryan
>
>
> ---------------------------------------------------------------------
> 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