Qiang Xue qiangxue

## cloudwatch_log_insights_mysql_slow_query_examples.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                qiangxue
                / cloudwatch_log_insights_mysql_slow_query_examples.md
            
            
              Created
              October 20, 2020 19:28
                — 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


## cloudwatch_log_insights_mysql_slow_query_examples.md

      
              1 file
            
          
              8 forks
            
          
              2 comments
            
          
              18 stars
            
          
                qiangxue
                / cloudwatch_log_insights_mysql_slow_query_examples.md
            
            
              Created
              October 20, 2020 19:28
                — 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


## test.php
<?php
/**
strncmp : 0.099173069000244
substr : 0.11933302879333
substr_compare : 0.10576391220093
*/

$str = 'namespace yii\web';
$str2 = 'namespace';
	<?php
	/**
	strncmp : 0.099173069000244
	substr : 0.11933302879333
	substr_compare : 0.10576391220093
	*/

	$str = 'namespace yii\web';
	$str2 = 'namespace';