hello all,
need some urgent advice and help please.
since the last 2 months our website has been rather slow at times. but since yesterday, its very very slow and inaccessible which is giving a 500 internal server error.
i did ask our host and they have said instances of php files running.
do you know how we can identify which files are the cause of the problem?
any advice would be much appreciated.
server load is currently 92.08 and and memory used is98% :-(
how big are you var/cache folders, do you use the product designer software from alt team, this creates large size folders if left for a long time without clearing those folders.
What spec is your server and disc space
Try to disable third-party add-ons one by one maybe it will fix the issue. Also, this issue can be connected with the speed of your webhosting that you can check by the php-benchmark-script.
Try to clear the cache at first and check the result. Just add ?cc&ctpl to the home page URL of your admin panel.
we have upgraded our server to 4 cpus and 6gb rams. this has helped.
however, how big should database size be with about 35,000 orders?
we have upgraded our server to 4 cpus and 6gb rams. this has helped.
however, how big should database size be with about 35,000 orders?
What issue you are experiencing? If you see that your database size is too large - check the size of the cscart_stored_sessions and cscart_logs tables first. You can clear them using the following queries if needed:
TRUNCATE cscart_logs;
TRUNCATE cscart_stored_sessions;
our website was very slow at times..however, since the server hardware upgrade,it's now OK.
how can i check the size of cscart_stored_sessions and cscart_logs tables through phpmyadmin?
OK, found the sizes of those 2 tables.
cscart_stored_sessions =147mb
cscart_logs=7mb
OK, found the sizes of those 2 tables.
cscart_stored_sessions =147mb
cscart_logs=7mb
Hello,
Do you find the error ?
we have same problem
hi victor,
we just upgraded our server hardware and it's been fine since.
we had 4gb ram, now 6.
2 processors, now 4.
have you managed to fix your problem yet?
hi victor,
we just upgraded our server hardware and it's been fine since.
we had 4gb ram, now 6.
2 processors, now 4.
have you managed to fix your problem yet?
Have you tried to export/backup orders over certains years and have them deleted after that? We have done that for some clients and it did help to improve the database performance.
Have you tried to export/backup orders over certains years and have them deleted after that? We have done that for some clients and it did help to improve the database performance.
hi,
out website is running absolutely fine now but will bear in mind your advise if we experience any slow down. :o)