slashcode-development

[Slashcode-development] many images in the db makes blob table >2Gig

[James M. <jm...@tr...>]

Hi all,
just a note about images in the db, something I came across tonight
but hadn't thought about.  If you have a lot of images, then the image
table will get really big.  So I just ran into my filesystem/MySQL limit, I
think, of about 2 Gig.  Not that the standard slash install will have
this problem, but it might.  So perhaps a note in the docs is in order
w/r/t the blob table, that if you have a lot of blobs, make sure the
filesystem/MySQL setup can handle it.

If anyone knows an easy fix, aside from upgrading my machine to a new
version of linux (which I am going to do anyway) I'd like to hear it.
I am pretty clueless when it comes to files this big, and when it
comes to setting up MySQL to handle big tables.  

Thanks,
James

Re: [Slashcode-development] many images in the db makes blob table >2Gig

[Eric D. <eri...@ja...>]

Wouldn't putting them into Innodb files solve the problem?

James Marca wrote:

>Hi all,
>just a note about images in the db, something I came across tonight
>but hadn't thought about.  If you have a lot of images, then the image
>table will get really big.  So I just ran into my filesystem/MySQL limit, I
>think, of about 2 Gig.  Not that the standard slash install will have
>this problem, but it might.  So perhaps a note in the docs is in order
>w/r/t the blob table, that if you have a lot of blobs, make sure the
>filesystem/MySQL setup can handle it.
>
>If anyone knows an easy fix, aside from upgrading my machine to a new
>version of linux (which I am going to do anyway) I'd like to hear it.
>I am pretty clueless when it comes to files this big, and when it
>comes to setting up MySQL to handle big tables.  
>
>Thanks,
>James
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: GNOME Foundation
>Hackers Unite!  GUADEC: The world's #1 Open Source Desktop Event.
>GNOME Users and Developers European Conference, 28-30th June in Norway
>http://2004/guadec.org
>_______________________________________________
>Slashcode-development mailing list
>Sla...@li...
>https://lists.sourceforge.net/lists/listinfo/slashcode-development
>  
>

Re: [Slashcode-development] many images in the db makes blob table >2Gig

[Shane <sh...@lo...>]

On Jun 10, 2004, at 1:40 AM, Eric Dannewitz wrote:

> Wouldn't putting them into Innodb files solve the problem?

The schema for slash::blob uses TYPE = InnoDB by default...

http://cvs.sourceforge.net/viewcvs.py/slashcode/slash/plugins/Blob/ 
mysql_schema?rev=1.8&view=auto

Re: [Slashcode-development] many images in the db makes blob table >2Gig

[Eric D. <eri...@ja...>]

So wouldn't creating a couple more datafiles solve the problem then?

Shane wrote:

>
> On Jun 10, 2004, at 1:40 AM, Eric Dannewitz wrote:
>
>> Wouldn't putting them into Innodb files solve the problem?
>
>
> The schema for slash::blob uses TYPE = InnoDB by default...
>
> http://cvs.sourceforge.net/viewcvs.py/slashcode/slash/plugins/Blob/ 
> mysql_schema?rev=1.8&view=auto

Re: [Slashcode-development] many images in the db makes blob table >2Gig

[Shane <sh...@lo...>]

On Jun 10, 2004, at 1:31 AM, James Marca wrote:

> Hi all,
> just a note about images in the db, something I came across tonight
> but hadn't thought about.  If you have a lot of images, then the image
> table will get really big.  So I just ran into my filesystem/MySQL 
> limit, I
> think, of about 2 Gig.  Not that the standard slash install will have
> this problem, but it might.  So perhaps a note in the docs is in order
> w/r/t the blob table, that if you have a lot of blobs, make sure the
> filesystem/MySQL setup can handle it.
>
> If anyone knows an easy fix, aside from upgrading my machine to a new
> version of linux (which I am going to do anyway) I'd like to hear it.
> I am pretty clueless when it comes to files this big, and when it
> comes to setting up MySQL to handle big tables.
>
> Thanks,
> James

Did you ever come up with a solution for your problem?