Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am running mysql 5.5.33 with innodb_file_format = Barracuda as well as innodb_file_per_table and created a database like so :

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `foobar` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

Then within that a table like so :

CREATE TABLE `barfoo` (
      `id` int(12) unsigned NOT NULL AUTO_INCREMENT,
      `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
      `somedata` varchar(128) DEFAULT NULL,
      `comment` varchar(16383) DEFAULT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=123456 ROW_FORMAT=DYNAMIC CHECKSUM=1 DEFAULT CHARSET=utf8mb4;

This seems to work fine however where I ask to see the table status I see checksum is NULL :

mysql> show table status \G
*************************** 1. row ***************************
           Name: barfoo
         Engine: InnoDB
        Version: 10
     Row_format: Dynamic
           Rows: 1821
 Avg_row_length: 1448
    Data_length: 2637824
Max_data_length: 0
   Index_length: 0
      Data_free: 4194304
 Auto_increment: 1001923
    Create_time: 2013-08-12 02:24:58
    Update_time: NULL
     Check_time: NULL
      Collation: utf8mb4_general_ci
       Checksum: NULL
 Create_options: checksum=1 row_format=DYNAMIC
        Comment: 

There I see Checksum is NULL where it should be 1 shouldn't it ?

Also when loading in some data from a mysqldump I get this error :

ERROR 1118 (42000) at line 248: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs

Not sure why I would see that given that there really isn't anything large happening here.

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.