All geek questions in one place

MySQL Maximum row length - is it possible to increase?

I was wondering if it is possible to increase the maximum MySQL string length using the InnoDB mechanism. The current is 8 KB.

I would also like to know what this restriction imposes. I do not remember such a limitation with Oracle 10 or MSSQL 2005.

Thanks!

+4
source share
3 answers

You need to change inno_db_page_size , check http://www.mysqlperformanceblog.com/2006/06/04/innodb-page-size/ This can be 8K, 16K, 32K or 64K, default is 16K.

+4
source

MS SQL Server also has this limitation. To get around this, you can use LOB (e.g. CLOB, BLOB, TEXT, etc.), since they are not part of the record itself.

Alternatively, you can split the table into two tables connected 1: 1. Maybe you could give some kind of experience of what you are trying to achieve and why your table is so big.

0
source

This is a restriction on InnoDB tables and cannot be changed. According to the docs :

The maximum row length, except for variable-length columns (VARBINARY, VARCHAR, BLOB, and TEXT), is slightly less than half the database page. That is, the maximum string length is about 8000 bytes.

You will have to think about remodeling your table.

0
source

Source: https://habr.com/ru/post/1338244/

More articles:


All Articles