[Building Sakai] problem with BLOB table in Sakai DB

[Patrick Coleman]

Hi Jim,

That make sense so my next question is how do I "convert to filesystem
storage for content bodies."

Thanks.

Pat.


Jim Eng wrote:
> 
> 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"
>> 
>> 
> 
> _______________________________________________
> 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"
> 
> 

-- 
View this message in context: http://old.nabble.com/problem-with-BLOB-table-in-Sakai-DB-tp28523391p28523675.html
Sent from the Sakai - Development mailing list archive at Nabble.com.