…, KEY `i` (`i`,`val`) ) CREATE TABLE `dim` ( `id` int(10) unsigned NOT NULL auto_increment, `pad` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) mysql> select count(*) from dim; +———-+ | count(*) | +———-+ | 30720 | +———-+ 1 row in set (0.00 sec) mysql> select count…
Post: Innodb row size limitation
April 7, 2011 By 12 Comments
… TEXT, PRIMARY KEY (id) ) Engine=InnoDB; Now you insert some test data into it: mysql>… multi-byte characters into a VARCHAR(500) column, that value will…probably the simplest approach, and as Barracuda only uses a 20…also impact both read and modification speed, precisely for the added join complexity…
