<br /> Intermittent Debian Planet problems – Debian Planet

Welcome to Debian Planet

News for Debian. Stuff that *really* matters

Sponsorship

Debian Planet is hosted by Bluelinux Internet Services Ltd. Offering a special discounted rate for Free and Open Source software community members.

Buy your Debian merchandise at DebianShop.com.

Debian
These are important Debian sites one should not be without!

  • Official Debian site
  • Package search
  • Mailing list archives
  • Bug reports
  • Debian on CD
  • Debian Weekly News — excellent news source!
  • Unofficial APT sources
    (apt-get.org)

  • Developers’ Corner
  • Community
    Need help? You’re not alone on this planet.

  • Planet Debian
  • debianHELP
    (User support site)

  • Debian Administration
    (SysAdmin resources)

  • Debian International
  • DebianForum.de
    (Deutsch)

  • DebianForum.dk
    (Dansk)

  • EsDebian
    (Español)

  • DebianWorld
    (Français)

  • Debian-Fr
    (Français)

  • MaximumDebian
    (Italiano)

  • DebianItalia
    (Italiano)
  • DebianUsers
    (한국어)

  • Debian-BR
    (Português)

  • DebianHOWTO
    (Deutsch)

  • Russian Debian (Русский)
  • Debian-JP
    (日本語)
  • Debian Suisse
    (Suisse)
  • Contribute
    Got that latest or greatest scoop? Perhaps you have some important news for the Debian community? Submit a news item!

    Or perhaps you’ve written a rather ground breaking insight into some aspect of Debian and you feel compelled to share it with others? Knock up a longer editorial article and send it to the editors.

    General feedback should be sent to staff@debianplanet.org

    IRC
    The place to get help on a Debian problem (after reading docs) or to just chat and chill is #debian on irc.oftc.net.

    Many of the Debian Planet staff live there so pop by and say hello.

    Debian Planet also has its own channel on the same network called #debianplanet.

    Syndicate
    XML

    Intermittent Debian Planet problems
    Submitted by DanielS on Thursday, December 19, 2002 – 04:04
    Some of you may have noticed that DP is sometimes down; this is not due to hardware failure, or co-location sucking, or anything like that – instead, apache uses all the CPU power, to the point where the load average spirals high enough to kill all the web sessions. If anyone has experienced this problem with Apache 1.3, Drupal and PHP4, please send us an email. In the meantime, we’ll try to resolve this issue.
    Category: Site News

    Control panel

    Comment viewing options:



    Select your prefered way to display the comments and click ‘Update settings’ to activate your changes.

    Subject: mysql?
    Author: dopey
    Date: Friday, 2002/12/27 – 16:01
    last time i noticed something like this.. it was a mysql-related problem.

    next time the load gets up, run a ‘mysqladmin processlist’.

    i found a lot of the processes were hanging over update statements on the watchdog table – eventually, i pinned it down to the auto_increment for the “id” field, and a broken cleanup of the watchdog table. i’d suggest looking at re-writing bits of it, so to avoid using auto_increment. (maybe change the ‘timestamp’ field to a more appropate type, and have that as the primary?)

    [ Please login, or register ]

     

    Subject: Yow.
    Author: DanielS
    Date: Saturday, 2002/12/28 – 00:08
    Thanks, we’ll check it out next time this happens. 🙂
    [ Please login, or register ]

    Subject: Apache 2 Fixes
    Author: agazeus
    Date: Tuesday, 2002/12/24 – 00:43
    I haven’t used Apache 2 myself, but I’ve heard it’s alot more stable than previous releases…Comments?
    [ Please login, or register ]

     

    Subject: not much difference
    Author: Fruit
    Date: Tuesday, 2002/12/24 – 02:27
    I’m using apache2 now (I wanted it so I could run a Subversion server) but in terms of stability I don’t notice much of a difference. Apache never crashed on me.

    Running PHP is a pain though, you’ll have to compile it yourself and (at least the version I’m running) won’t survive a reload, you have to stop and start each time you change the configuration.

    Too bad mod_python is so slow, it seems like a much better choice otherwise.


    Fruit

    [ Please login, or register ]

    Subject: Maybe it’s time to drop D
    Author: grolschie
    Date: Monday, 2002/12/23 – 09:34
    Maybe it’s time to drop Drupal. 😉
    [ Please login, or register ]

    Subject: Apache 2
    Author: MBCook
    Date: Sunday, 2002/12/22 – 21:08
    Sounds like a good chance to start to move over to apache 2 to me 🙂
    [ Please login, or register ]

     

    Subject: Apache 2
    Author: agazeus
    Date: Tuesday, 2002/12/24 – 00:41
    Yeah, Apache 2 sounds good
    [ Please login, or register ]

    Subject: too many number about Maxclients directive?
    Author: henrich
    Date: Sunday, 2002/12/22 – 14:49
    too big maxclients cause spiral down.
    see your httpd.conf and try to find your setting.
    [ Please login, or register ]

    Subject: post your /etc/apache/httpd.c
    Author: cd34
    Date: Thursday, 2002/12/19 – 19:58
    post your /etc/apache/httpd.conf

    try turning off Keepalives
    Increase the MaxRequestsPerChild to 5000 or more

    Disable Extendedstatus, Expires, unique_id

    show processlist; in mysql to see if anything is taking an unusually long time to process — any select or update statements that seem to hang around.

    I’m guessing persistent mysql connections (I haven’t used drupal)

    timeout on mysql high enough to avoid constant reconnects to the mysql server?

    Try APC

    http://apc.communityconnect.com/about.html

    debian package php4-apc

    However, my guess is that you have some apache processes that have tons of cpu time used. This would probably point to a mysql lock that is being held — which holds up the other processes, which prevents things from being served until the machine spirals to its death.

    Look at the select & update commands in drupal and run them with explain and see which ones use filesort rather than an index.

    If you worked with mysql and made a copy of a table, i.e. rename table oldtable; create table newtable select * from oldtable; your indexes will not have moved across. This would cause some problems if the data set was large enough.

    [ Please login, or register ]

    Subject: Maybe the problem with the php ?
    Author: gal_ga
    Date: Thursday, 2002/12/19 – 18:05
    What PHP modules do you use ?
    I know about problem with the domxml module – memory leaks.
    [ Please login, or register ]

    Subject: Maybe this will help?
    Author: forming134
    Date: Thursday, 2002/12/19 – 15:33
    It sounds too me like it may be related to this thread on lkml:

    Very High Load, kernel 2.4.18, apache/mysql

    At a glance it mentions Apache going out of control, Debian, and PHP, so might be a good place to start looking and compare.

    [ Please login, or register ]

    Subject: www.debian.hu powered by drupal with no problem
    Author: trey
    Date: Thursday, 2002/12/19 – 07:47
    I have 3 site, 1 powered by drupal, mysql, php4, apache 1.3.27, mod_ssl and I have’t any problem like this.

    the machine:
    – dual PIII 1260Mhz
    – 1GB RAM
    – SCSI UW-3 HDD
    – GE and 10/100 eth. controller

    OS: FreeBSD 4.7

    the bandwidth:

    – 100Mbit/sec

    hosted sites:
    www.hup.hu (phpnuke)
    www.hup.hu/english (phpnuke)
    www.debian.hu (drupal)

    Cheers


    trey

    [ Please login, or register ]

    Search articles



    Category
    ·News (408)
    ·Features (5)
    ·Site News (16)
    ·HOWTOs (80)
    ·Tips (21)
    ·Opinion (29)
    ·Q & A (35)
    ·Sponsorship (1)
    ·Press Releases (5)

    Log in
    Username:

    Password:

    Remember me

    » Register
    » New password

    Debian Security Announcements
    DSA-943 perl
    DSA-942 albatross
    DSA-903 unzip
    DSA-941 tuxpaint
    DSA-940 gpdf
    DSA-939 fetchmail
    DSA-938 koffice
    DSA-937 tetex-bin
    DSA-936 libextractor
    DSA-935 libapache2-mod-auth-pgsql

    Planet Debian
    Wouter Verhelst: On flames.
    Joachim Breitner: Fixing my planet.debian.org subscription
    Steve Kemp: She has the blood of reptile just underneath her skin
    Pierre Habouzit: Married …
    Pierre Habouzit: whitelister 0.4 (SPF) and aaege ….
    Pierre Habouzit: kde 3.4.1 upload
    Holger Levsen: In case you are running OpenWRT
    Michael Janssen: Shiny roofs are good for the environment!
    Matthew Palmer: Work it out yourself, dammit!
    Axel Beckert: Tell me which music you like and I tell who you are

    Debian Administration
    How do I prevent rebuilt packages from being upgraded?
    Disabling the print-screen key inside X?
    Monitoring your bandwidth usage with vnstat
    Ruby on Rails on Debian
    Choice for Virtual Private Servers?
    Monitoring your hardware’s temperature
    Sending mail with Exim from ‘dialup’ IP
    How to recover GRUB Debian Sarge after reinstalling Windows
    Getting a GUI
    Spam filtering with Pyzor and SpamBayes

    Latest poll: Which release scheme should Debian follow?
    Continue this way (release when ready)
    48%
     
    Give up on releasing
    8%
       
    Split the release up
    8%
       
    Speed the release up
    32%
       
    Crank the workload up (see DebianWiki ReleaseProposals for details on these)
    4%
       

    Total votes: 372
    0 comments · older polls

    home · archives · news feeds · about · polls · search · sections · user account

    Powered by the amazing Drupal

    Debian Planet is not officially related to the Debian Project.
    Debian and the Debian logo are trademarks of Software in the Public Interest, Inc.