How can I reduce the cache_default table? The views_data:fr BLOB data IN THE cache_default TABLE is too large, and I get this error when I try to import the table on a shared server (OVH).


  ERROR 1118 (42000) at line 3302: The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodb_log_file_size.


INSERT INTO `cache_default` (`cid`, `data`, `expire`, `created`, `serialized`, `tags`, `checksum`) VALUES
('views_data:fr', 0x613a3135303a7b733a383a227761746368646f67223b613a31323a7b733a353a227461626c65223b613a343a7b733a353a2267726f7570223b4f3a34383a2244727570616c5c436f72655c537472696e675472616e736c6174696f6e5c5472616e736c617461626c654d61726b7570223a333a7b733a393a22002a00737472696e67223b733a383a225761746368646f67223b733a31323a22002a00617267756d656e7473223b613a303a7b7d733a31303a22002a006f7074696f6e73223b613a303a7b7d7d733a393a2277697a6172645f6964223b733a383a227761746368646f67223b733a343a2262617365223b613a333a7b733a353a226669656c64223b733a333a22776964223b733a353a227469746c65223b4f3a34383a2244727570616c5c436f72655c537472696e675472616e736c6174696f6e5c5472616e736c617461626c654d61726b7570223a333a7b733a393a22002a00737472696e67223b733a31313a224c6f6720656e7472696573223b733a31323a22002a00617267756d656e7473223b613a303a7b7d733a31303a22002a006f7074696f6e73223b613a303a7b7d7d733a343a2268656c70223b4f3a[...]


I know that increasing the value of innodb_log_file_size solves problem, but it's impossible in a shared server.

Is it possible to reduce this table?

I tried disabling the view caching in the advanced settings, disabling the cache for that single view, but it has no effect.

I feel that the more views we have, the more space the views_data:fr column takes.
You might try compressing the data before sending it. There's a module for that: compressed_cache