Berkeley CSUA MOTD:Entry 39056
Berkeley CSUA MOTD
 
WIKI | FAQ | Tech FAQ
http://csua.com/feed/
2024/11/23 [General] UID:1000 Activity:popular
11/23   

2005/8/8-11 [Computer/SW/Database] UID:39056 Activity:nil
8/8     I'm looking for a good log analyzer.  My systems generate about a gig
        a week of sendmail logs.  I'd like something I can feed in the logs
        in bulk and then query them through either a gui or SQL (which I can
        put behind a cgi).  The point is to track emails in/out of the system
        so I can tell if particular emails based on from and/or to within a
        date range were successfully delivered and hopefully how long it took
        to deliver as well.  I have a budget sufficient to purchase something
        if necessary.  Any suggestions?  Thanks!
        \_ Doesn't do everything you want, but you could check out isoqlog
           --dbushong
        \_ Check out Sawmill.  If you want stats, munin is nice but also
           doesn't do all you're looking for.  -John
2024/11/23 [General] UID:1000 Activity:popular
11/23   

You may also be interested in these entries...
2009/7/28-8/6 [Computer/SW/Database] UID:53213 Activity:nil
7/27    I have an actual technical question here. My MySQL DBA tells me
        that I can't expect a MySQL port to be able to run effectively
        on more than a two CPU box, he says that the extra CPUs will
        sit there unused. Is this true? I have a bunch of new quad core
        servers that I would like to use as Database machines. -ausman
   \_ It's not that simple.  If you stress test your new fancy multi core
	...
2008/2/7-8 [Computer/SW/Database] UID:49086 Activity:nil
2/7     What the hell?  Is there configuration option to make mysql behave
        reasonably?  By "reasonably" I mean, when a user tries to put in
        the wrong data type i'd like it to fail and throw an error, not just
        say "hmmm, I'll just put a '0' there instead". -crebbs
mysql> desc hi;
+-------+------------+------+-----+---------+-------+
	...
2007/10/29-11/1 [Computer/SW/Database] UID:48479 Activity:nil
10/29   In mysql MyISAM table, if I do a very long read query (SELECT)
        and then do an INSERT, will that INSERT hang? I understand that
        MyISAM is non-transactional so I'm guessing the two calls are
        independent of each other?
        \_ From my understanding no.  Not unless you explicitly lock the table.
           What you get, however, is undefined.  (I'm assuming these are on
	...
2006/12/1-12 [Computer/SW/Languages/Misc, Computer/SW/Languages/Java] UID:45409 Activity:nil
11/30   I remember people complaining about http://dreamhost.com on the motd in
        recent months.  What were the complaints?
        \_ You can't run ANY script for over 20-30 seconds or else ALL of
           your processes will get killed, rendering cron and cgi
           useless. Mysql quota may be unlimited but is overloaded so
           takes SECONDS for each simple query. It has been hacked into
	...
2006/10/27-30 [Computer/SW/Database] UID:45007 Activity:nil
10/27   Dear MySQL experts, I have a serious problem. I backed up my
        database using mysqldump. When I try to recover using
        "mysql < recover_file.sql" I keep getting "ERROR 2013 (HY000)
        at line 116: Lost connection to MySQL server during query"
        \_ So the dump file is just standard sql data.  Why not take a look at
           the line where it's running into problems and see if that yields
	...