• Blog
    • Oracle EBS ERP
      • DBA
      • Developer
      • Application
    • Db2 Database
    • MySQL
  • About Me
  • Skills
  • Education
  • Employment
  • Contact

Lookup Error – MySQL Database Error- Row size too large 8126

  • Home
  • Lookup Error – MySQL Database Error- Row size too large 8126

During the access of mysql database DBA face error like 'Row Size too large 8126' in few tables which could be resolve by taken below steps :

Add the following to the my.cnf file under [mysqld] section
/usr/my.cnf

innodb_file_format = Barracuda
innodb_file_per_table = 1

ALTER the table to use ROW_FORMAT=COMPRESSED.

ALTER TABLE <table_name>
ENGINE=InnoDB
ROW_FORMAT=COMPRESSED 
KEY_BLOCK_SIZE=8;

If above steps not workout then need execute below script :

Alter table <table_name> engine=innodb ROW_FORMAT=DYNAMIC;

Tags
Lookup Error, mysql, MySQL Database Error, Row size too large 8126
Categories
  • Application
  • Db2 Database
  • DBA
  • Developer
  • MySQL
  • Oracle EBS ERP
o
  • Extract & restore single mysql table from backup of databaseSaturday - September 04, 2021
© 2019 KS is proudly powered by Kapil Savaliya.