Re: Heap table limitations

Daniel Cummings wrote: We want to convert a 200+ meg table to a heap table. We've gotten pretty good performance converting from InnoDb to MyIsam table but converting to a heap table would give an even bigger performance boost. You think it would, or it already has in your testing? Heap vs. MyISAM

RE: Heap table limitations

your table from accidentally eating all of you're available memory. Ed -Original Message- From: Daniel Cummings [mailto:[EMAIL PROTECTED] Subject: Heap table limitations We want to convert a 200+ meg table to a heap table. We've gotten pretty good performance converting from I

Heap table limitations

We want to convert a 200+ meg table to a heap table. We've gotten pretty good performance converting from InnoDb to MyIsam table but converting to a heap table would give an even bigger performance boost. Does making a heap file this large make any sense? Are there size limitations to heap

RE: MERGE table limitations

TECTED] [mailto:[EMAIL PROTECTED] -->Sent: Friday, October 24, 2003 12:26 PM -->To: [EMAIL PROTECTED] -->Subject: Q: MERGE table limitations --> -->Does anyone know of any limitations on the number of underlying tables in -->a MERGE table? Seems to be a topic of scant coverage in the

Q: MERGE table limitations

Does anyone know of any limitations on the number of underlying tables in a MERGE table? Seems to be a topic of scant coverage in the books and online docs. ANY help or ideas would be appreciated. /Tony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

re: table limitations

Kip, Sunday, October 06, 2002, 11:20:25 PM, you wrote: KK> Mysql - how many tables will it handle? KK> I currently have no access to docs, so forgive me as I'm sure it is KK> documented. The only limitation is how many files can be stored in the directory. -- For technical support contract

table limitations

Mysql - how many tables will it handle? I currently have no access to docs, so forgive me as I'm sure it is documented. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.c

MERGE TABLE limitations

Other than a horrendous number of file descriptors, what other performance issues should one be worried about when using merge tables? Is there an upper limit on the number of tables one can use in generating a merge table? Please send a copy to [EMAIL PROTECTED] as I am not a subscriber. -- [