Your website isn't working for me (location: Germany).
And as far as I remember, your site was full of spam content, numerous bot registrations, fake accounts, etc.
In this case, your database simply can't handle the volume of requests.
Some tips:
- Install spam protection
- Manually delete all spam content and fake accounts (this is best)
I can give you recommendations on database optimization, but I'm not sure you've the best hosting for this.
As far as I remember, you're still on shared hosting.
But in any case, I'm ready to help you solve your problem.
No , I am on Cloud Hosting .
My webhost is telling me to upgrade to Managed VPS Server then VM4 Server along with control panel will be suggested. Will it solve my problem . Please tell me ASAP . It is very urgent . URL : https://safalaya.com/
1- Use PhpMyAdmin tool
2- Some old tips. Note: be careful with this if you don't understand what you're doing.
Since Elgg is using InnoDB tables you can search how to optimize MySQL for that purpose. But a lot depends on your current setup.
If your on shared hosting with the webserver and database server on the same machine, moving the database to it's own dedicated machine will help. If you're already running the database in a cluster with 10 servers than there are different thing you should look at (but than you probably don't need our help ;)
Are you experiencing any performance issues?
If you have an active community moving the search feature out of the database to a search engine will free up a lot of resources for the 'normal' use of the database. You could look into using OpenSearch as a search engine and use this plugin https://elgg.org/plugins/3333727 to connect your Elgg installation to OpenSearch.
info@elgg.org
Security issues should be reported to security@elgg.org!
©2014 the Elgg Foundation
Elgg is a registered trademark of Thematic Networks.
Cover image by Raül Utrera is used under Creative Commons license.
Icons by Flaticon and FontAwesome.