Archive for the ‘Software’ Category

mysqlsla – parse, filter and sort mysql logs

Tuesday, August 12th, 2008

mysqlsla parses, filters, analyzes and sorts MySQL slow, general, binary and microslow patched logs in order to create a customizable report of the queries and their meta-property values.

Since these reports are customizable, they can be used for human consumption or be fed into other scripts to further analyze the queries. For example, to profile with mk-query-profiler (a script from Baron Schwartz’s Maatkit) every unique SELECT statement using database foo from a slow log:

         mysqlsla -lt slow slow.log -R print-unique -mf "db=foo" -sf "+SELECT" | \
         mk-query-profiler -separate -database foo

 

In brief, mysqlsla is a liaison allowing other scripts easy access to queries from a MySQL log. For a quick introduction to what mysqlsla is capable of doing, take a glance at the guide.

see http://hackmysql.com/mysqlsla for more

Posted in Software | Comments Off

apachetop

Friday, July 25th, 2008

A curses-based top-like display for Apache information, including requests per second, bytes per second, most popular URLs, etc.

Originally started by Chris Elsworth.

Posted in Software | Comments Off

Foxmarks, bookmark synchronization done right

Sunday, February 3rd, 2008

I’ve been a long time user of google browser synchronization. However, recently i’ve came to the conclusion (after losing my places in several ebooks ) that it doesn’t properly handle synch’ing directories. Somehow the bookmark just plain disappeared. The main convenience of synchronization of course is multiple workstations sharing the same bookmarks. When a conflict arises, google sync doesn’t seem to have any interactive resolution available. It is simply a point of management since these products really offer the same services.

It’s been 20 minutes but various tests have shown foxmarks has better conflict resolution and provides searching bookmarks from their web. Two features that I intend to use more often now.

Check out Foxmarks if you’re fed up with google browser sync

Posted in Software, Technology | Tags , , , | No Comments »