David Harrison trogau

## cloudwatch_log_insights_mysql_slow_query_examples.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                trogau
                / cloudwatch_log_insights_mysql_slow_query_examples.md
            
            
              Created
              April 8, 2024 04:20
                — forked from qiangxue/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


## index.php
<?php
header("Content-Type: text/plain");
$data = file("data.txt");
$bytesRx = $data[0];
$bytesTx = $data[1];
?># TYPE modem_stats_bytesrx counter
modem_stats_bytesrx <?= $bytesRx ?>
# TYPE modem_stats_bytestx counter
modem_stats_bytestx <?= $bytesTx ?>

## Average.js
import Colour from './Colour';
import Resample from './Resample';

/**
 * Average hash for images
 *
 * @author John Noel <john.noel@chaostangent.com>
 * @see http://www.hackerfactor.com/blog/index.php?/archives/432-Looks-Like-It.html
 * @see https://github.com/jenssegers/imagehash/blob/master/src/Implementations/AverageHash.php
 */
	<?php
	header("Content-Type: text/plain");
	$data = file("data.txt");
	$bytesRx = $data[0];
	$bytesTx = $data[1];
	?># TYPE modem_stats_bytesrx counter
	modem_stats_bytesrx <?= $bytesRx ?>
	# TYPE modem_stats_bytestx counter
	modem_stats_bytestx <?= $bytesTx ?>
	import Colour from './Colour';
	import Resample from './Resample';

	/**
	* Average hash for images
	*
	* @author John Noel <john.noel@chaostangent.com>
	* @see http://www.hackerfactor.com/blog/index.php?/archives/432-Looks-Like-It.html
	* @see https://github.com/jenssegers/imagehash/blob/master/src/Implementations/AverageHash.php
	*/