MySQL Forums
Forum List  »  General

Re: InnoDB log group capacity error
Posted by: Arjen Lentz
Date: February 28, 2009 06:45AM

The TEXT/BLOB type columns you use in your schema, what's their actual maximum content? For text, the thing to realise is that in MySQL 5.0, the limit for a VARCHAR was raised from 255 to 65530 or so. Therefore you can convert TEXT columns to VARCHAR and get improved behaviour in various parts of the mysql server.
(there's more to it than that, but that's the basic story)

As a general rule, see if the contents are less than 20K.
You can emulate a BLOB type col by specifying VARCHAR(n) BINARY

Regards, Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Remote expertise & maintenance for MySQL/MariaDB server environments.

Follow us at http://openquery.com/blog/ & http://twitter.com/openquery

Options: ReplyQuote


Subject
Written By
Posted
October 15, 2004 01:10AM
Re: InnoDB log group capacity error
February 28, 2009 06:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.