Skip to content

Instantly share code, notes, and snippets.

View shivakumaarmgs's full-sized avatar

Shivakumaar Mgs shivakumaarmgs

11 followers · 18 following
  • Banglore
View GitHub Profile
@shivakumaarmgs
shivakumaarmgs / cloudwatch_log_insights_mysql_slow_query_examples.md
Created April 28, 2023 12:40 — forked from grocky/cloudwatch_log_insights_mysql_slow_query_examples.md
CloudWatch Log Insights query examples for MySQL slow query log.

Filtering queries

Find slowest write queries

parse @message /Query_time: (?<queryTime>.*?) Lock_time: (<?lockTime>.*?) Rows_sent: (?<rowsSent>.*?) Rows_examined: (?<rowsExamined>.*?)\s(?<query>.*?)$/
  | filter @message like /(?i)insert/
  | sort queryTime desc
  | limit 10
@shivakumaarmgs
shivakumaarmgs / multiple_ssh_setting.md
Created July 14, 2022 07:22 — forked from jexchan/multiple_ssh_setting.md
Multiple SSH keys for different github accounts

Multiple SSH Keys settings for different github account

create different public key

create different ssh key according the article Mac Set-Up Git

$ ssh-keygen -t rsa -C "your_email@youremail.com"
@shivakumaarmgs
shivakumaarmgs / _toastr_flash.html.erb
Created July 13, 2016 09:45 — forked from askehansen/_toastr_flash.html.erb
Rails flash messages in toastr.js
<% unless flash.empty? %>
<script type="text/javascript">
<% flash.each do |f| %>
<% type = f[0].gsub('alert', 'error').gsub('notice', 'info') %>
toastr['<%= type %>']('<%= f[1] %>', '<%= type %>');
<% end %>
</script>
<% end %>