php mysql limits

[whitep8]

Hi All,

Does mysql have a limit in size? If so what is it?

Im currently using MyISAM which is suggesting 4gb

Can this be increased? if so how?

Many thanks

Paul

[Dormilich]

if possible, split the query in smaller parts.

[Atli]

Are you talking about per query, row or table?

According to the manual, MyISAM and InnoDB have a theoretical limit of 256TB and 64TB, respectively [1][2]. This can (and is) limited further by your OS [3].

Each row can not be larger than 65,535 bytes. "BLOB and TEXT columns count from one to four plus eight bytes each toward the row-size limit because their contents are stored separately." [4]

Queries are limited in size to the value of the max_allowed_packet directive. It defaults to 1MiB but can be increased up to 1GiB max.

Im currently using MyISAM which is suggesting 4gb

Can this be increased? if so how?

See this article: Overcoming MySQL's 4GB Limit