SMF Support > Server Performance and Configuration

Forum using up all system resources?

(1/9) > >>

Goosemoose:
hi guys,
 my host just shut down my site because the forum started to hog all their system resources "This was shut down due to the fact that your site has a heavy enough mysql load to shut down the physical server."
  They made a backup of the database but won't turn it back on until I fix the problem. But since its not running I don't know how to go about this. If you have any ideas let me know.

[Unknown]:
Do you have the facility to check the database?

If you do, can you see if any of the topics have a "numViews" higher than logically possible?  Meaning, more than say 10000 but with few replies?

Was your host using MySQL 3 or MySQL 4?

-[Unknown]

Goosemoose:
I'm downloading the database right now. I'll look at it and let you know what I find.

Goosemoose:
The backup I downloaded that they created for me is full of MYD and MYI files of each table. When I try to view them in notepad I see only junk. What should I use to view this and what table should I be looking for. Usually I would just look around but since there are hundred of files now it's harder to find.

[Unknown]:
You might be able to view those if you install MySQL on your own server, create a database, and copy these files into mysql\data\databasename.  Those are the raw MySQL database files....

-[Unknown]

Navigation

[0] Message Index

[#] Next page

Go to full version