Php – How to match queries made by root from mysql slow queries log using regex
Let's say I have a slow queries log like this: # Time: 230706 17:12:48 # User@Host: sample[sample] @ localhost [] # Thread_id: 626784 Schema: sample QC_hit: No # Query_time: 2.976557 Lock_time: 0.000178 Rows_sent: 0 Rows_examined: 3344231 # Rows_affected: 0 Bytes_sent:…