
Security News
New Website “Is It Really FOSS?” Tracks Transparency in Open Source Distribution Models
A new site reviews software projects to reveal if they’re truly FOSS, making complex licensing and distribution models easy to understand.
MySQL slow query log parser
gem install myslog
myslog = MySlog.new
text = <<-EOF
# Time: 111003 14:17:38
# User@Host: root[root] @ localhost []
# Query_time: 0.000270 Lock_time: 0.000097 Rows_sent: 1 Rows_examined: 0
SET timestamp=1317619058;
SELECT * FROM life;
# User@Host: php[php] @ [192.168.10.235]
# Thread_id: 313 Schema: ename_bbs_dx15 Last_errno: 0 Killed: 0
# Query_time: 0.031467 Lock_time: 0.000197 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 Rows_read: 2
# Bytes_sent: 1243 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0
SET timestamp=1359008764;
SELECT * FROM pre_common_session WHERE sid='vWWzwC' AND CONCAT_WS('.', ip1,ip2,ip3,ip4)='192.168.200.57';
EOF
records = myslog.parse(text)
records
is Array of Hash
records[0]
#=> {:date => 2011-10-03 14:17:38 +0900,
#=> :user => "root[root]",
#=> :host => "localhost",
#=> :host_ip => "",
#=> :query_time => 0.000270,
#=> :lock_time => 9.7e-05,
#=> :rows_sent => 1,
#=> :rows_examined => 0,
#=> :sql => "SET timestamp=1317619058; SELECT * FROM life;"}
records[1]
#=> {:user => "php[php]",
#=> :host => "",
#=> :host_ip => "192.168.10.235",
#=> :query_time => 0.031467,
#=> :lock_time => 0.000197,
#=> :rows_sent => 0,
#=> :rows_examined => 0,
#=> :rows_affected => 0,
#=> :rows_read => 2,
#=> :thread_id => 313,
#=> :schema => "ename_bbs_dx15",
#=> :last_errno => 0,
#=> :killed => 0,
#=> :bytes_sent => 1243,
#=> :tmp_tables => 0,
#=> :tmp_disk_tables => 0,
#=> :tmp_table_sizes => 0,
#=> :sql => "SET timestamp=1359008764; SELECT * FROM pre_common_session WHERE sid='vWWzwC' AND CONCAT_WS('.', ip1,ip2,ip3,ip4)='192.168.200.57';"}
FAQs
Unknown package
We found that myslog demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
A new site reviews software projects to reveal if they’re truly FOSS, making complex licensing and distribution models easy to understand.
Security News
Astral unveils pyx, a Python-native package registry in beta, designed to speed installs, enhance security, and integrate deeply with uv.
Security News
The Latio podcast explores how static and runtime reachability help teams prioritize exploitable vulnerabilities and streamline AppSec workflows.