Re: Thinking of switching from MyISAM to InnoDB
If you want a MyISAM table to grow larger than 4GB you have to do alter table tablename max_rows=1 or maybe its 'maxrows'... Once you do that, you will be able to stuff the table as full as the OS will let you. Innobase will allow you to get around this by making a bunch of smaller files to create a larger table space... but keep in mind the max size for a blob is 4GB.. (yah that is pretty damn huge tho heh). Im not sure what the max size for a MyISAM blob is. Hope this helps. ryan - Original Message - From: "Nick Seidenman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, August 04, 2001 9:54 AM Subject: Re: Thinking of switching from MyISAM to InnoDB > On Saturday 04 August 2001 09:25, Sinisa Milivojevic wrote: > > > Nick Seidenman writes: > > > Apparentlly there's a 4 GB limit to a MyISAM file when the table it > > > contains has VARCHAR, TEXT, or BLOB columns. In order to get around this > > > > There is no 4 Gb limit in MyISAM with later 3.23 versions. > > I an running version 3.23.32. > > > This limit is imposed by a filesystem only. > > Don't think so. When I do a SHOW TABLE STATUS I have several tables that are > well in excess of 4 GB (2^32-1), as well as those that show exactly 4GB. The > difference is that the larger tables are of fixed type while the smaller ones > are of dynamic type. It is one of the dynamic tables that repeatedly runs > into space problems. This one happens to have a TEXT column in it the values > for which can be (and often are) in excess of 2 KB. > > > Nick Seidenman, CISSP > Director of Software Development > Hyperon, Inc. > www.hyperon.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
RE: Thinking of switching from MyISAM to InnoDB
Is there a place that outlines the advantages/disadvantages of both MyISAM and InnoDB? Thanks, Chris -Original Message- From: Tonu Samuel [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 04, 2001 2:34 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Thinking of switching from MyISAM to InnoDB On 04 Aug 2001 16:25:14 +0300, Sinisa Milivojevic wrote: > There is no 4 Gb limit in MyISAM with later 3.23 versions. > > This limit is imposed by a filesystem only. and RAIDed table can help to build aby size tables if only index file doesn't get too big. Actually InnoDB is nice thing. Just bith MyISAM and InnoDB have good advantages and you should decide, which ones you need more. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China <___/ 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
Re: Thinking of switching from MyISAM to InnoDB
On 04 Aug 2001 16:25:14 +0300, Sinisa Milivojevic wrote: > There is no 4 Gb limit in MyISAM with later 3.23 versions. > > This limit is imposed by a filesystem only. and RAIDed table can help to build aby size tables if only index file doesn't get too big. Actually InnoDB is nice thing. Just bith MyISAM and InnoDB have good advantages and you should decide, which ones you need more. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China <___/ 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
Re: Thinking of switching from MyISAM to InnoDB
On Sat, Aug 04, 2001 at 09:15:52AM -0500, Gerald R. Jensen wrote: > > To the best of my knowledge, MySQL doesn't impose file size limits > ... that is dictated by the O/S's file system. Switching to InnoDB > wouldn't change that. But InnoDB would let you use multiple tablespaces to get around any such limitation. In this case, however, that's probably not the problem anyway. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 <-- NEW MySQL 3.23.29: up 49 days, processed 393,812,934 queries (92/sec. avg) - 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
Re: Thinking of switching from MyISAM to InnoDB
On Saturday 04 August 2001 09:25, Sinisa Milivojevic wrote: > Nick Seidenman writes: > > Apparentlly there's a 4 GB limit to a MyISAM file when the table it > > contains has VARCHAR, TEXT, or BLOB columns. In order to get around this > > There is no 4 Gb limit in MyISAM with later 3.23 versions. I an running version 3.23.32. > This limit is imposed by a filesystem only. Don't think so. When I do a SHOW TABLE STATUS I have several tables that are well in excess of 4 GB (2^32-1), as well as those that show exactly 4GB. The difference is that the larger tables are of fixed type while the smaller ones are of dynamic type. It is one of the dynamic tables that repeatedly runs into space problems. This one happens to have a TEXT column in it the values for which can be (and often are) in excess of 2 KB. Nick Seidenman, CISSP Director of Software Development Hyperon, Inc. www.hyperon.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
Re: Thinking of switching from MyISAM to InnoDB
Nick: What O/S are you running ... Windows? To the best of my knowledge, MySQL doesn't impose file size limits ... that is dictated by the O/S's file system. Switching to InnoDB wouldn't change that. Gerald Jensen - Original Message - From: "Nick Seidenman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 03, 2001 6:44 PM Subject: Thinking of switching from MyISAM to InnoDB Apparentlly there's a 4 GB limit to a MyISAM file when the table it contains has VARCHAR, TEXT, or BLOB columns. In order to get around this limitation I was looking to switching to InnoDB table types. As this looks like a relatively new subsystem I'm wondering if it is stable enough for production systems, or is it still too new (and too "feature-prone".) I'd appreciate hearing feedback on this. If I do wind up switching, it won't be for at least a month. TiA, nick Nick Seidenman, CISSP Director of Software Development Hyperon, Inc. www.hyperon.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
Re: Thinking of switching from MyISAM to InnoDB
Nick Seidenman writes: > > Apparentlly there's a 4 GB limit to a MyISAM file when the table it contains > has VARCHAR, TEXT, or BLOB columns. In order to get around this limitation I > was looking to switching to InnoDB table types. As this looks like a > relatively new subsystem I'm wondering if it is stable enough for production > systems, or is it still too new (and too "feature-prone".) I'd appreciate > hearing feedback on this. If I do wind up switching, it won't be for at > least a month. > > TiA, > > nick > > > Nick Seidenman, CISSP > Director of Software Development > Hyperon, Inc. > www.hyperon.com There is no 4 Gb limit in MyISAM with later 3.23 versions. This limit is imposed by a filesystem only. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ 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
Thinking of switching from MyISAM to InnoDB
Apparentlly there's a 4 GB limit to a MyISAM file when the table it contains has VARCHAR, TEXT, or BLOB columns. In order to get around this limitation I was looking to switching to InnoDB table types. As this looks like a relatively new subsystem I'm wondering if it is stable enough for production systems, or is it still too new (and too "feature-prone".) I'd appreciate hearing feedback on this. If I do wind up switching, it won't be for at least a month. TiA, nick Nick Seidenman, CISSP Director of Software Development Hyperon, Inc. www.hyperon.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
