the longblob is the biggest data type of Mysql. If I want to save something bigger than 4gb (longblob) how can I do?.
I'm talking about Mysql v-5.+
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
Using LONGBLOB can be very risky in light of the fact that the biggest max_allowed_packet is only 1GB.
Back in August 2006, someone asked a similar question. in which Peter Zaitsev said:
As you can see in theory it is about 4GB.
It is however also limited by max_packet_size which is 16M by default.
I would be very careful using blobs larger than 100MB. MySQL will need some 3 times of this size of memory allocated on the server for blob processing.
I am not a PostgreSQL DBA, but I would have to venture the following suggestion:
If you really want to store in mysql, then perhaps you could store it using chunks, meaning that you make an algorithm that takes your data and store it in the database in chunks - this ofcourse makes the programming a bit more difficult when retrieving the data, since you have to do the opposite, but this type of technique could solve your problem