Im getting this warning in mysql 8 after upgrade: [InnoDB] Cannot

Question

Im getting this warning in mysql 8 after upgrade: [InnoDB] Cannot

add field in table because after adding it, the row size is 8789 which is greater than maximum allowed size (8126) for a record on index leaf page.

what does it mean? the field it's referring is varchar(255), row format is compact but this column all values are NULL

#english #programming #sql

0

07.08.2024

9 ответов

34 просмотра

🙈🙉🙊 Автор вопроса

Lucido
Change row format 👩‍🦯

but why would it raise a warning if this column is empty? why in 5.7 i didnt get this?

0

4 месяца назад

Lucido

🙈🙉🙊
but why would it raise a warning if this column is...

If you are using mysql 8.0 the Innodb storage engine includes stricter enforcement of maximum row size limits

0

4 месяца назад

🙈🙉🙊 Автор вопроса

Lucido
If you are using mysql 8.0 the Innodb storage engi...

this is because mysql 8 using utf8mb4? is it ok that my tables are still utf8mb3? im on mysql 8.0.35 from my understanding UTF8 is alias for utf8mb3 and alias for utf8mb4 - correct?

0

4 месяца назад

Lucido

🙈🙉🙊
this is because mysql 8 using utf8mb4? is it ok th...

Yes

0

4 месяца назад

🙈🙉🙊 Автор вопроса

Lucido
Yes

Thanks, How can I find all those tables that might need to change their row_format?

0

4 месяца назад