Results 1 to 5 of 5
  1. #1

    Need urgent Help, query cause cpu stress!

    Hey all i need your help urgently!

    Ive made a mysql query within my drupals block, it seems it was badly wrong, (using inner join where it should not be used ), but right before i noticed ive hit save allready and caused stress, taking other sites on the host down too
    I want to undo the change but cant access to undo save the changes cos the site aint load cos the cpu stress.

    Is there any way i can undo the change somehow? cpanel also not load and host is offline....


  2. #2
    Join Date
    May 2009
    Unless you have KVM & root access to your host, you're pretty much screwed. You should not be able to take down a whole machine with one db query. If you did, and your hosting provider hasn't responded immediately, it's time to host somewhere else. It's also possible that they've just blocked YOU. Either situation warrants a call to your hosting provider.

  3. #3
    Join Date
    Oct 2009
    Nottingham, UK
    Yeah i would agree, whilst it's possible you took down the hosts shared server i'm sure their system administrators will have noticed it go offline (you'd hope). If it keeps taking it down they will isolate the cause. If that cause is you then they will be in touch but to beat them to the punch i'd agree ringing them is a first step!
    SWORDFISH HOSTING - UK Based Web Hosting - 24*7 Support
    Shared Hosting | VPS | Dedicated Servers | Plesk 9 Control Panel
    Web Hosting For Everyone

  4. #4
    thanks for the replies
    Luckily the site went online for seconds and i could rip out totally messed query lol. After that i could replace it with a correct one.

    The query was bada** , the query caused 1000% cpu useage -_-

  5. #5
    Join Date
    Aug 2007
    Brighton, UK
    I've never seen a single query do that before, I'd be interested to see what the query was and know what version of MySQL is running on your host?

Similar Threads

  1. Paying $15 for MySQL Query - URGENT
    By bow-viper1 in forum Software & Scripts Requests
    Replies: 2
    Last Post: 07-20-2007, 08:54 AM
  2. Urgent - it is about selection of CPU!
    By chessming in forum Dedicated Server
    Replies: 3
    Last Post: 11-11-2006, 07:12 PM
  3. Stress testing dualcore CPU reliability at Tomshardware
    By wm2100 in forum Dedicated Server
    Replies: 26
    Last Post: 06-08-2005, 04:31 AM
  4. Urgent Help Needed (Hosting/CPU%)
    By 7of9 in forum Web Hosting
    Replies: 6
    Last Post: 04-14-2005, 04:28 PM
  5. Restricting CPU and RAM stress for clients?
    By keyDet79 in forum Hosting Security and Technology
    Replies: 3
    Last Post: 04-01-2003, 10:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts