[Building Sakai] problem with BLOB table in Sakai DB

[Jim Eng]

Hi Pat,

I can't answer your specific questions about how MySQL handles that, but I can caution that generally storing the content bodies in the database is not expected to scale very well.  Storage of content bodies in the db simplifies setup for pilots and demos, but the general recommendation is to convert to storing content bodies in the filesystem before usage is expected to put much load on that table. That said, the last time we discussed this on the list, a number of people spoke up to say they are running small instances in production and storing file bodies in the database without problems.  Maybe somebody who is doing that can give more focused advice.  My advice would be convert to filesystem storage for content bodies.

Jim


On May 11, 2010, at 8:19 AM, Patrick Coleman wrote:

> 
> In my Sakai DB there is a blob table (type longblob) called
> content_resource_body_binary
> This table is about 2.8GB in size and I'm having problems backing it up or
> even looking at it's content.
> 
> If I do a "select * from content_resource_body_binary" I get an error
> saying..
> 
> ERROR 2020 (HY000): Got packet bigger than 'max_allowed_packet' bytes
> 
> I have the  'max_allowed_packet' set to 1GB which I think is the max it can
> be set to?
> 
> When I try and do a backup of the table (or the whole DB) using mysqldump I
> get this error..
> 
> mysqldump: Error 2013: Lost connection to MySQL server during query when
> dumping table `content_resource_body_binary` at row: 1582
> 
> I done check table etc and it always says ok?
> 
> Is there any limit to the size of a table like this? It just started to
> happen a few weeks ago.
> I'm running mysql 5.0.84 and Sakai 2.6
> 
> Thanks.
> 
> Pat.
> -- 
> View this message in context: http://old.nabble.com/problem-with-BLOB-table-in-Sakai-DB-tp28523391p28523391.html
> Sent from the Sakai - Development mailing list archive at Nabble.com.
> 
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
> 
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
> 
>