Vitavonni

Sat, 31 Jul 2004

MySQL rant

The second rant is about *MySQL*. The =mysqld_safe= wrapper is a *ugly* *non-standards-compliant* hack. Or what would you call a daemon process that ignores SIGTERM?

Quote from the script: trap '' 1 2 3 15 # we shouldn't let anyone kill us

Maybe i should increase the serverity of this bug to "important", the maintainer has successfully ignored it for 333 days now.

I see no reason why the *wrapper* should ignore TERM. It's not like processes are sent a "TERM" randomly. I think this wrapper is just for stupid uses who start their mysql server in their shell, background it and wonder why it's gone when the logout... Actually, the *real* mysqld process does care about the TERM signal, and apparently the "shutdown" command is issued this way, too.

Secondly, mysql is a known process that prevents swsusp2 from working. You need to shutdown mysql first before you can suspend. Unfortunately, it doesn't shut down in 20% of the cases for me, but just keeps on running after breaking it's pid file... Guess i'll have to add a "killall mysqld" somewhere.

Don't let me get started on PHP, which IMHO is a quick-hack language you really should avoid when you intend to write nice, clean code. Just thing of the "register globals" thing, this language is not designed for clean things... (and a language being easy to learn and use certainly doesn't improve code quality. IMHO a good language should enforce clean coding styles. Albeit i'm not a fan of Java, one has to admit that it forces authors to write read- and maintainable code. PHP doesn't. PHP "coders" tend to intermix layout and code; putting all your data into a SQL database and calling inefficient queries certainly isn't the best way of storing your data either...

[category: /en/linux | Permalink]
Menu
[planet.debian]
[planet.xmlhack]
[planet SELinux]
[munichblogs]
[email]
[RSS 2 feed]
[English RSS 2]
Categories
July 2004 >
SuMoTuWeThFrSa
     1 2 3
4 5 6 7 8 910
11121314151617
18192021222324
25262728293031
Archives
2010-Mar
2010-Feb
2010-Jan
2009-Dec
2009-Nov
2009-Oct
2009-Sep
2009-Aug
2009-Jul
2009-Jun
2009-May
2009-Apr
2009-Mar
2009-Feb
2009-Jan
2008-Dec
2008-Nov
2008-Oct
2008-Sep
2008-Aug
2008-Jul
2008-May
2008-Apr
2008-Mar
2008-Feb
2008-Jan
2007-Dec
2007-Nov
2007-Oct
2007-Sep
2007-Aug
2007-Jul
2007-Jun
2007-May
2007-Apr
2007-Mar
2007-Feb
2007-Jan
2006-Dec
2006-Nov
2006-Oct
2006-Sep
2006-Aug
2006-Jul
2006-Jun
2006-May
2006-Apr
2006-Mar
2006-Feb
2006-Jan
2005-Dec
2005-Nov
2005-Oct
2005-Sep
2005-Aug
2005-Jul
2005-Jun
2005-May
2005-Apr
2005-Mar
2005-Feb
2005-Jan
2004-Dec
2004-Nov
2004-Oct
2004-Sep
2004-Aug
2004-Jul
Other links:
Swing and the City - Lindy Hop in Munich