Website works slow any suggestions?

Hello guys few days I'm bumping in the wall as my website works slow. Website have 600k+ registered
users, it is dating website so there is heavy load on database. Now I'm not generating heavy traffic,
only 700 - 900 registrations in day. I have dedicated server in ionos. Before website who's in Ionos
shared hosting, but I hit file cap limit 200k and needed to upgrade to dedicated. Everything worked
fine, until I got to 500k users.

Problem is that ionos offer my only 5.5v mysql database with unlimited space, 5.7v is only 1gb,
this is really lame, but what I can do. My database whose 1.3gb size, so few days back I deleted
some info from database and made it to 700+mb size. So I uploaded it to 5.7v and website
worked 30 - 40% faster. After night my database raised to 1.6gb and they locked it. So again
I need to get back to 5.5v...

I wanted in past to transfer my website to other hosting provider, but there is big problem,
website have 800k files and in total 65gb+ space, it will gonna take ages to download it and
upload in other server.

So I see only few options, start everything from scratch, delete all users, all info... Another option is
to rent only mysql server and upload my database. If anybody have any suggestions I'm open to them.

Server specs: $65 in month.
Memory 8 GB RAM (DDR3 ECC)
Intel®Atom™ C2750
8 Cores x 2.4 GHz
240 GB Intel® SSD Storage

Have 2 servers. One for website content and one just for database

LilMosey said:

Have 2 servers. One for website content and one just for database

Click to expand...

Maybe you can suggest some providers for database?

Try using cloudflare
If its wordpress - try cloudflare with jetpack (the image URLs will change if u use the photon cdn here - if u r getting traffic from images - don't turn the photon cdn on - otherwise turn it on - it will reduce much of the server load.

bossofthebosses said:

Try using cloudflare
If its wordpress - try cloudflare with jetpack (the image URLs will change if u use the photon cdn here - if u r getting traffic from images - don't turn the photon cdn on - otherwise turn it on - it will reduce much of the server load.

Click to expand...

Thanks for info, it is custom script.

I think you need someone to reorganize your database, things seems to be mixed up, or just get a better hosting for better hardware performance, but I'm sure it will be much better to hire someone to do a clean job.

I'd suggest you go with Leaseweb. Also, depending on your budget, you should look for server starting from $250. You could also have a problem on your code. Look for errors in log files.

Are you already using a cdn, how large is your websites initial load. Check Google pagespeed insights. It's generally a good starting point to start optimizing. If you run PHP, try updating to a newer version if you haven't already, do make sure to test this out first since updating from older versions may break some things.

try digitalocean for hosting

Try upgrading your servers with your hosting company, large databases tends to slow down servers. I take it you are making revenue from this site, so you can do a cost benefit analysis.

For Slow Web Hosting, Database and website content Issue.

Check your web hosting, if your web hosting is low quality then your website is must slow.

r3L4x said:

I wanted in past to transfer my website to other hosting provider, but there is big problem,
website have 800k files and in total 65gb+ space, it will gonna take ages to download it and
upload in other server.

Click to expand...

Wow haha.

If it is a wordpress website, you should check your WP_Options Autoloads. That is a silent DB killer.

r3L4x said:

I wanted in past to transfer my website to other hosting provider, but there is big problem,
website have 800k files and in total 65gb+ space, it will gonna take ages to download it and
upload in other server.

Click to expand...

That is if you do it manually from your computer. There are hosting providers who do all the migration works from their end and it won't take much time as you worry.

You surely need better servers looking to the future.

Better server is not always the solution though

I don't understand why MySQL is limited to only 1GB. It's a service that the hosting provider offers? If you have SSH access to the server, you could install MySQL yourself. It would only be limited by the free space on the hard drive.

You also talk about needing to download 65GB worth of files and it taking too long. I imagine these are mostly selfies and gym videos. A possible migration strategy would be to move only your code and database over to the new service first, and in your code, prepend your media paths with the old server domain. The images should still show up on your site, then move the files over, then point the base URL for images to your new server.

Get a new provider with faster server. Run them in parallel while you transfer the data- use rsync for the transfer that way you can re-sync after the initial transfer of data for a fast switchover when you do the live migration.

moving to a new host is done fast. Just dump your database, zip everything and wget the zip file on the new server. Unpack it, import the database, edit your config file. done.
then you should really look into optimizing your database and your php scripts.
optimize the queries, cache the query results where possible, etc.

I've used IONOS in the past and found their hosting and customer service appalling.

It says they're load-balanced servers yet can't scale with your traffic, I would seriously question them on that, but then again my fridge has more tech support knowledge than them.

Some great advice and too many people to quote but migrating your DB first, then the front end is your best bet (obviously changing connection string, etc.), it could just eliminate all your issues, it did with mine.