search

matthiasmullie / scrapbook

PHP cache library, with adapters for e.g. Memcached, Redis, Couchbase, APC(u), SQL and additional capabilities (e.g. transactions, stampede protection) built on top.
https://www.scrapbook.cash
MIT License
315 stars 27 forks source link

MySql max size of data #10

Closed radoslavius closed 8 years ago

radoslavius commented 8 years ago

Hi, I'm trying to store data in mysql, but unfortunately I can not store everything (about 250kB) - to db saves only 64kB. What may be the problem? In sqlite it works fine. Thanks

matthiasmullie commented 8 years ago

MySQL's BLOB size is 64kB. I changed it to LONGBLOB in a685f488fb39627987bd0cf49ff096784bd0024e.

To change your existing setup, you can run this query (where $table is your table name):

ALTER TABLE $table MODIFY v LONGBLOB;