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.
Site slow because of big database
Re: Site slow because of big database
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?
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
Re: Site slow because of big database
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.
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.
Re: Site slow because of big database
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?
can you please check on ftp what files you have in that folder?
Don't forget to run script update
Re: Site slow because of big database
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.
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.