Jump to content

Need a new file system, plain help


rosend511

Recommended Posts

Currently, I have a Download/Filesystem used with SimpleMachines Forum (SMF).

Due to my giant 300mb, 300,000 member MySQL database, my website at time uses a Crazy amount of CPU processes (was told from 20-27 virtual cores), therefor, all the hosts I have used will shut me down. (I don't blame them)

 

Either, how to fix, as my SMF forum is not needed anymore, but my filesystem is.

The problem is I have a directory on another server that host all my 36gb of files and can handle the bandwidth.

My problem with giving people direct access to the directory to eliminate the MySQL problem, is that there will be not download restrictions that my SMF 3rd party Download system has in place to limit the number of user downloads at one time, per day, etc.

 

What is a solution?

Link to comment
Share on other sites

300mb memory and you use 20-27 virtual cores. Clearly someone has got it wrong. Either the amount of virtual cores is lower or the memory consumption is higher.

 

Also using that many cores would cost an insane amount of money and they would never allow anyone to scale up like that unless you paid for it. So, my guess is that your website has outgrown what shared hosting can offer, which is not that hard knowing there could be like minimum 64 websites on one machine (some ignore the limits of the server altogether and simply keep adding websites until it fails to boot due to insufficient ram figuratively speaking).

 

So, you either need to buy a virtual dedicated, or a dedicated server. Or use cloud hosting, so you pay less on quiet periods, and more (with a max.) on heavy traffic.

Edited by ignace
Link to comment
Share on other sites

I now use a VPS with low specs, but while watching the stats, it uses at most 25% all day.

But at random points, it goes to a CPU load of 40, which is outrageous. It's just a giant spike that makes the server overload.

 

Each and every time, the host says to me it has to do with the MySQL.

How to fix or find out?

Link to comment
Share on other sites

I would be inclined to believe that for some reason your database probably doesn't have any indexes and as such is doing a table scan each request resulting in a lot of disk i/o and processing.

 

If not that, maybe your scripts are poorly written and doing something like select * from blah; and filtering the results themselves rather than with a proper WHERE clause.

 

Ultimately we do not have enough information to be able to say one way or the other what your issue might be.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.