log on SWiK

Eclipse error log location

Fri, 08 Aug 2008 14:10:23 -0700

Merging Multiple Apache Access Logs Into One Overall Access Log | HowtoForge - Linux Howtos and Tutorials

Fri, 08 Aug 2008 14:06:36 -0700

Log Buffer #109: A Carnival of the Vanities for DBAs

Fri, 08 Aug 2008 11:07:56 -0700

It’s time again for another edition of the weekly review of database blogs, Log Buffer. Since it was a big week for SQL Server, let’s start there, shall we?

The big news — SQL Server 2008 is released, as reported by SqlServer-qa.net, in seven different versions. Aaron Bertrand introduces a new kid on the block: SQL Server 2008 Web Edition — “. . . designed for highly available Internet facing web serving environments for the next generation Windows Server,” according to MS. (I’ve heard it rains quite a lot in Seattle. I guess it also Drizzles, too.) Says Aaron, “Basically, it has higher scalability than Express or Workgroup Editions : it supports up to 4 CPUs, no artificial limit on RAM, and unlimited database size.”

(Before you crack open your server case, Tara Kizer on Ramblings of a DBA has some advice on how to get physical CPU count on a server.)

The SQL Server Express Express blog helpfully offers a table outlining the differences in the features of the differences between SQL Server 2008 Express editions.

A couple little issues with the release have already emerged. Here’s Euan Garden on SQL Server 2008 Installation Confusion, VS 2008 Sp1 and NetFx 3.5 Sp1: “SQL Server 2008 has dependencies on (and includes) VS 2008 SP1 and its components (BIDS is just VS 2008, SSMS uses components), plus NetFx 3.5sp1. SQL includes the RTM versions of both of these, HOWEVER they are not broadly released yet. There is a check in SQL Server Setup that if you have an old version (Beta, RC, whatever) it will bounce the install and ask you to upgrade to the RTM bits…which of course are not yet available independent of SQL.” Click through for the KB and some other help. Denis Gobo and his readers have some more to say about this.

In all this change, you may lose sight of an important fact or two, and you may ask yourself, how did I get here . . . what version of SQL Server am I running? A couple resources are shared by Kevin Kline.

(more…)

Kernel oops bugcount

Fri, 08 Aug 2008 09:09:06 -0700

kerneloops.org is a website that tries to help the developers of the Linux kernel by collecting so-called oopses, which are the crash signatures of the Linux kernel: they are processed statistically to present information for the kernel developers.

" GeoIP Information for AWStats: improve country and city location information in your web analytics reports - Antezeta

Thu, 07 Aug 2008 13:09:13 -0700

Snort: Planning IDS for Your Enterprise

Thu, 07 Aug 2008 13:03:50 -0700

Log Buffer #108: A Carnival of the Vanities for DBAs

Fri, 01 Aug 2008 11:08:54 -0700

Welcome to the 108^th edition of Log Buffer, the weekly review of database blogs.

With almost no ado at all, let’s begin with the bad news–from StatisticsIO and Jason Massie: The Death of the DBA. And who is the perpetrator of this crime? The Cloud! It sounds like something from a John Carpenter movie, doesn’t it?

Let’s see what Jason is thinking. “I’d like to retire a SQL Server DBA with 40 years experience but I don’t think that will happen. The cloud is coming and it is bad news administrators, database or otherwise. . . . Let’s make some assumptions. The features get there. The availability gets there. The platform basically matures . . . Now put yourself in the IT decision maker’s shoes. No upfront capital expenses, no managing backups, and no patch management. . . . If they can remove their focus from managing and deploying IT, they sell and service more widgets.”

Scary stuff, right? Well, the commenters don’t entirely agree. I think it will be at least a factor, but I wonder how many managers will look at “The Cloud” and feel uncomfortable about privacy, data retention, and the like. (For myself, I couldn’t even endorse the idea of putting this blog’s comments into “The Cloud”.) What do you think?

Elsewhere on StatisticsIO, Jason has a note about MSDN’s SQL Heroes contest, whose aim is to, “. . . create a community project in CodePlex based on SQL Server 2008.” Jason also links to a list of CodePlex’s active SQL Server projects.

Turning to matters technical, Jeff’s SQL Server Blog offers a lesson on converting input explicitly at your client: don’t rely on the database to “figure it out”. Jeff takes the example of formatting dates, and show both the right and the wrong way, writing, “I’ve said it over and over and I’ll say it again: The concept of formatting dates should never be something that your database code should ever worry about.”

On the Less Than Dot blog, SQLDenis observes that converting columns to date from datetime does not result in a scan in SQL Server 2008. What you get instead is a seek, as he demonstrates.

Indexing Foreign Keys - should SQL Server do that automatically? So asks Greg Low on the The Bit Bucket. “By adding indexes on the foreign keys on three tables,” he writes, “we saw a reduction of 87% in total I/O load. . . . it really struck me that having SQL Server do this by default would avoid a lot of apparent performance problems. . . . Should SQL Server simply do this by default when you declare a foreign key reference?”

Kent Tegels of Enjoy Another Sandwich — riddle me this, riddle me that! “When is a bug not a bug?” I give up, Kent. When is a bug not a bug? (more…)

JIMSUN - Postfix Contribs

Sat, 26 Jul 2008 01:45:22 -0700

Log Buffer #107: A Carnival of the Vanities for DBAs

Fri, 25 Jul 2008 09:50:05 -0700

Welcome to the 107th edition of the Log Buffer. My name is Keith Murphy and I am a MySQL database administrator for the Pythian Group. In addition, I am the editor of MySQL Magazine. This is my second go for the Log Buffer, so I must be doing something right!

This week for the open source world brings OSCON in Portland Oregon. There are plenty of MySQL people present and there have been more posting this week from these realms than normal. Also, Lewis Cunningham, among others, posted news that EnterpriseDB released the results of their open source survey at OSCON. The 451 CAOS Theory published their thoughts on the survey.

Of interest to all DBAs is John Duncan’s post about what is called the “five minute rule”. This was introduced in 1987 by Jim Grey. And finally, before we dive into the specific server news, here is a post on Facebook’s project to build a distributed database similar to Google’s BigTable.

MySQL News:

Friday saw the release of the summer issue of MySQL Magazine. The highlights of the issue include the first annual MySQL Usage Survey. The magazine is available here. Peter, over at Percona, shows some initial benchmarks for the latest version (0.9.8) of Sphinx. If you aren’t familier with Sphinx, it is a full text search engine that easily integrates with MySQL.

Probably the biggest news this week was the announcement by Brian Aker of “Drizzle”. It is what amounts to a slimmed down version of MySQL server. These comments are from his initial post “Stored Procedures, Views, Triggers, Query Cache, and Prepared Statements are gone for now.” Interesting. My co-worker, Sheeri K. Cabral, posted a video of Brian Aker talking about the Drizzle project at this week’s OSCON. Monty Widenius writes a good summary how Drizzle can/might integrate with the MySQL “ecosphere” at large. It was very good to hear Monty say that Sun management is encouraging this project. There has been some other interesting posts about this as well including Arjen’s thoughts, and Paul McCullagh’s. Brian Moon gives a very thoughtful view on how Drizzle could potentially fit in at dealnews. While I could probably fill up the entire Log Buffer with links to post about Drizzle, I better leave it at that.

(more…)

Installing AWStats on CentOS

Fri, 25 Jul 2008 06:48:32 -0700

JIMSUN - Postfix Contribs

Thu, 24 Jul 2008 07:45:06 -0700

Plugging in a logging framework for Eclipse plug-ins

Thu, 24 Jul 2008 03:53:25 -0700

AWStats简介:Apache/IIS的日志分析工具 (笔记 by 车东)

Thu, 24 Jul 2008 01:48:06 -0700

Appigo - AccuFuel - Overview

Wed, 23 Jul 2008 11:59:37 -0700

AWStats - Free log file analyzer for advanced statistics (GNU GPL).

Tue, 22 Jul 2008 16:47:42 -0700

Apache module mod_log_config

Tue, 22 Jul 2008 10:48:23 -0700

Apache HTTP ServerLOGS

Tue, 22 Jul 2008 06:48:29 -0700

無聊人的無聊小站 - 完全架站手冊 - AWStats 安裝設定教學

Tue, 22 Jul 2008 02:49:08 -0700

[AWStats] Windows IIS 的 Log 分析 @ 創造心理的感動 ::PIXNET 痞客邦::

Tue, 22 Jul 2008 02:49:08 -0700

Extended Log File Format

Sun, 20 Jul 2008 09:48:31 -0700

JIMSUN - Postfix Contribs

Sun, 20 Jul 2008 09:47:47 -0700

Multitail - view multiple logfiles windowed on console

Fri, 18 Jul 2008 23:54:12 -0700

MultiTail lets you view one or multiple files like the original tail program. The difference is that it creates multiple windows on your console (with ncurses). It can also monitor wildcards: if another file matching the wildcard has a more recent modification date, it will automatically switch to that file. That way you can, for example, monitor a complete directory of files. Merging of 2 or even more logfiles is possible. It can also use colors while displaying the logfiles (through regular expressions), for faster recognition of what is important and what not. It can also filter lines (again with regular expressions). It has interactive menus for editing given regular expressions and deleting and adding windows. One can also have windows with the output of shell scripts and other software. When viewing the output of external software, MultiTail can mimic the functionality of tools like ‘watch’ and such.

(...)
Read the rest of Multitail - view multiple logfiles windowed on console (280 words)

© admin for Ubuntu Geek, 2008. | Permalink | No comment | Add to del.icio.us digg
Who's linking ? Technorati BlogPulse Google
Want more on these topics ? Browse the archive of posts filed under Server.

Postfix Debugging Howto

Fri, 18 Jul 2008 11:44:51 -0700

jboss.org: community driven

Fri, 18 Jul 2008 07:53:45 -0700

jboss.org: community driven

Fri, 18 Jul 2008 07:50:36 -0700

metro: JAX-WS Guide - Logging

Thu, 17 Jul 2008 12:59:48 -0700

HONKA is the largest log home manufacturer in the world, offering unlimited design flexibility, innovative solutions, and beautiful architecture to a discriminating international audience. Its service is available in Colorado, Arizona, Wyoming and New Mex

Thu, 17 Jul 2008 06:01:22 -0700

Interior design ideas

Thu, 17 Jul 2008 01:03:04 -0700

interior design ideas interior designs contemporary interior design interior design minimalist

AWStats - Free log file analyzer for advanced statistics (GNU GPL).

Wed, 16 Jul 2008 20:50:26 -0700

A quick AWstats guide

Wed, 16 Jul 2008 14:47:32 -0700

log on SWiK

Eclipse error log location

Merging Multiple Apache Access Logs Into One Overall Access Log | HowtoForge - Linux Howtos and Tutorials

Log Buffer #109: A Carnival of the Vanities for DBAs

Kernel oops bugcount

" GeoIP Information for AWStats: improve country and city location information in your web analytics reports - Antezeta

Snort: Planning IDS for Your Enterprise

Log Buffer #108: A Carnival of the Vanities for DBAs

JIMSUN - Postfix Contribs

Log Buffer #107: A Carnival of the Vanities for DBAs

Installing AWStats on CentOS

JIMSUN - Postfix Contribs

Plugging in a logging framework for Eclipse plug-ins

AWStats简介:Apache/IIS的日志分析工具 (笔记 by 车东)

Appigo - AccuFuel - Overview

AWStats - Free log file analyzer for advanced statistics (GNU GPL).

Apache module mod_log_config

Apache HTTP ServerLOGS

無聊人的無聊小站 - 完全架站手冊 - AWStats 安裝設定教學

[AWStats] Windows IIS 的 Log 分析 @ 創造心理的感動 ::PIXNET 痞客邦::

Extended Log File Format

JIMSUN - Postfix Contribs

Multitail - view multiple logfiles windowed on console

Related Articles

Postfix Debugging Howto

jboss.org: community driven

jboss.org: community driven

metro: JAX-WS Guide - Logging

HONKA is the largest log home manufacturer in the world, offering unlimited design flexibility, innovative solutions, and beautiful architecture to a discriminating international audience. Its service is available in Colorado, Arizona, Wyoming and New Mex

Interior design ideas

AWStats - Free log file analyzer for advanced statistics (GNU GPL).

A quick AWstats guide