Site slow because of big database

Post Reply
happydg
Posts: 412
Joined: Mon Jul 08, 2013 2:22 pm

Site slow because of big database

Post by happydg »

Hello,

I updated to latest version.

When not cached, my site and access to the admin is loading slow because it has a lot of galleries to the database.

When connecting to scj/admin/ it sometimes go to 504 Gateway Time-out after loading for a while.

1) I see you can optimize database in scj admin. I would prefer to do it through ssh. What command should I type?

2) Is there anything else I can do to make the site load faster? It's on a good dedicated server.

ps: You have access to the admin in the pm.

Thank you.
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Site slow because of big database

Post by admin »

Hello,

optimize in admin area won't help in this case

did you check server LA?
what process consumes the most resources and so on?
Don't forget to run script update
happydg
Posts: 412
Joined: Mon Jul 08, 2013 2:22 pm

Re: Site slow because of big database

Post by happydg »

Server LA is about 4. Mysql is taking most of the usage.

Also after update. When I go to https://www.domain.com/scj/admin/?operation=main&sub=& I get this error:

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 67108872 bytes) in /data/domain.com/html/scj/includes/libs/check_scj.lib.php on line 134

You have access to the admin in the pm.

Thank you.
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Site slow because of big database

Post by admin »

looks like you have a lot of extra files in scj folder
can you please check on ftp what files you have in that folder?
Don't forget to run script update
happydg
Posts: 412
Joined: Mon Jul 08, 2013 2:22 pm

Re: Site slow because of big database

Post by happydg »

I just have in scj folder:

ioncube_fallback.php
scj2.free.lic
sitemap.php
scj2.sql
scjwebmaster.php
rotation.log
rss.php
scj2.lic

and subfolders

I really think the problem is mysql. The database has 3 millions galleries and the db size is 27 gb which is huge.
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Site slow because of big database

Post by admin »

ok, send ssh plz
Don't forget to run script update
Post Reply