4images Forum & Community

4images Issues / Ausgaben => Discussion & Troubleshooting => Topic started by: daika on May 02, 2006, 03:19:55 PM

Title: database problem
Post by: daika on May 02, 2006, 03:19:55 PM

I have just install 4images and no images in my gallery
but i don't know why my database is 1,6MB (session table is 1,6MB  8O)
I do a backup and my backup file is 17,1 KB
I don't know why ?

Title: Re: database problem
Post by: JensF on May 02, 2006, 05:01:56 PM

Have you another tables into the database, not from images??

Title: Re: database problem
Post by: V@no on May 03, 2006, 12:37:59 AM

and what is inside the backup file?

P.S. the session table is always huge, even if its empty, because it uses "MEMORY" (aka "HEAP") engine which is optimized for perfomance and not size.
Since sessions is not very important, you should not include it into backup, plus after NN period of time these sessions will expired anyway.

Title: Re: database problem
Post by: daika on May 04, 2006, 07:40:02 AM

but session only have my own session ( no registed member )
I try to backup session table and it is about 1KB.
but it show in database ( phpmydamin and Cpanel, 4images backup ) about 1,6MB
I don't know why.
My 4images has no member, no image. I have just installed it.

(Sorry for my bad English)

Title: Re: database problem
Post by: V@no on May 05, 2006, 06:19:20 AM

You must understand that the size of the backup and the size of the table is not the same things.

P.S. sessions have nothing to do with how many members you have, because every visitor on your site will get an unique session.