Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By Adam S on
I added Context.module last night after two hours of configuration moved all my blocks into contexts. Looked like it works great. This morning my host shuts me down because my website is taking up all resources CPU and database.
I can't tell that anything is wrong. How do I install some type of system that tests the database for me to see if something is wrong. I would rather have that than the host turning off my website with a banner for all the see that screams, "Your account has been SUSPENDED!" Makes me look dumb. (Not that I'm smart, but still......)
Comments
check the error log first,
check the error log first, depending if you enable dblog or not , usually you can check the watchdog tables for error.
Also check the watchdog table size, there is a chance that the table size got too big.
--------------------------------------------------------------------------------------------------------
if you can use drupal why use others?
VicTheme.com
I had to switch hosts a few
I had to switch hosts a few years ago for pretty much the same reason. It was a shared host, and their limitations on memory weren't enough to handle my needs for Drupal (Drupal can be a resource hog). It bothered me because they advertised that they could run Drupal installations, but forgot to mention 'only to a certain point'.
Anyways, I don't have any specific help on how to track down your problem, but I just wanted to mention that even if you uninstall the module that is causing you problems, it sounds like you are close to the limit of what your host will allow you to run. It may be time to start looking for a host that is a little more robust.
Contact me to contract me for D7 -> D10/11 migrations.
I just reverted my Database
I reverted my database after 12 hours of work. I don't know how to go about debugging a problem like that -- everything looked fine. I decided that I didn't want to use the core block module but context instead which should give the system a little performance boost. I would like some tools to test if turning off blocks or not is making the problem. There might have been at some point a corruption in the block table of the database and a module is looking for something that isn't there. Is there tools that go onto the server, installed into Drupal or can be run from desktop that analyze database performance that work well or are designed from Drupal?
I wanted to add that there were only 500 visits to my site, we are never busy on Sunday, and normally we can get as many as 15,000 at 50,000 pageviews without a server problem. So something must have been really draining the CPU.
My error log is 207MB. I wonder what is in there :(
"My error log is 207MB. I
"My error log is 207MB. I wonder what is in there :("
Have you try to clean it up and see if the problem solved?.
And try to use rawlog module, it will write the log into a file instead of database, might cure your problem if your database server cant handle large table.
also after you clean / install raw log, view the log to see what is the problem with your site
--------------------------------------------------------------------------------------------------------
if you can use drupal why use others?
VicTheme.com