Out of memory

7yves7 · 2012-10-12 09:11:18

When mass embeding more than one page at a time (in background) I'm getting this error when trying to watch any video on the site:

----------------------------
Query: SELECT v.video_id, v.user_id, v.title, v.slug, v.description, v.total_views, v.total_comments, v.premium, v.allow_rating, v.allow_comment,

v.allow_embed, v.rating, v.rated_by, v.embed_code, v.allow_download, v.duration, v.add_time, v.thumb, v.ext, v.type, v.adv, v.sponsor, v.size,

vm.meta_title, vm.meta_desc, vm.meta_keys, u.username, GROUP_CONCAT(DISTINCT c.cat_id) AS categories, GROUP_CONCAT(DISTINCT c.slug) AS slugs,

GROUP_CONCAT(DISTINCT c.name) AS name, GROUP_CONCAT(DISTINCT t.name) AS tags FROM video AS v LEFT JOIN video_category AS vc ON (vc.video_id =

v.video_id) LEFT JOIN video_categories AS c ON (vc.cat_id = c.cat_id) LEFT JOIN video_tags AS t ON (t.video_id = v.video_id) LEFT JOIN video_meta AS vm

ON (vm.video_id = v.video_id) LEFT JOIN user AS u ON (u.user_id = v.user_id) WHERE v.video_id = 19173 GROUP BY v.video_id LIMIT 1
Error Message: Out of memory (Needed 67108698 bytes)
Error Number: 5
----------------------------

I could do several page embeds simultaneously but only without any visitors, now with 15-20 visitors I can only do one page at a time.
It's not a very big deal but would save a lot of time.
Any suggestions? I know it's a server/sql thing but couldn't find a solution so I'm asking here

symtab · 2012-10-12 10:02:18

How much memory do you have on your server?

7yves7 · 2012-10-12 11:09:55

1GB RAM

Not that much but since you can still browse the site fast as hell (during multi page embeding) and only get the error when trying to watch a video
I didn't think that would be the problem, but I don't really know much about it so,...

symtab · 2012-10-12 14:03:34

You need more RAM. Seems like the query cannot get the database because it does not have enough memory to save it.

7yves7 · 2012-10-14 10:30:28

Found out it has 2GB RAM
also found out it constantly uses 1,75GB and maxes when embeding multiple pages
So yeah I'll need more but is 1,75GB normal?

Another question: is it possible to include the video sorting links (recent, popular, top rated,...) in the 'search results' pages?

Thanks

symtab · 2012-10-14 17:54:30

Hmm...so what you are doing is run the mass embedder more than once at the same time? Its possible, because the mass embedder downloads the html pages for processing. Currently there are no recent/popular/top rated for the search results.

7yves7 · 2012-10-15 14:53:58

yeah, with 'background grabbing' turned on I actually did ten pages at a time, +-350 embdes/3mins
And everything seems to be fine once the embeding is done. Can't really do that anymore with visitors on the site now as they'll get the error.
Since it's the only problem I'm not upgrading yet but thanks for your help.

symtab · 2012-10-15 17:08:34

There is no actual way to free up that memory. Its the remote site html, which is processed.

Adult Script Pro Community Forums

#1 2012-10-12 09:11:18

Out of memory

#2 2012-10-12 10:02:18

Re: Out of memory

#3 2012-10-12 11:09:55

Re: Out of memory

#4 2012-10-12 14:03:34

Re: Out of memory

#5 2012-10-14 10:30:28

Re: Out of memory

#6 2012-10-14 17:54:30

Re: Out of memory

#7 2012-10-15 14:53:58

Re: Out of memory

#8 2012-10-15 17:08:34

Re: Out of memory

Board footer