|
----------+
| 16049 |
+----------+
1 row in set (0.07 sec)
mysql> Ctrl-C -- exit!
Aborted
abc@ubuntu:/usr/local/mysql/data$ sudo tail ./mysql-slow.log
[sudo] password for abc:
# Time: 151106 23:40:39
# User@Host: root[root] @ localhost []
# Query_time: 0.047216 Lock_time: 0.000099 Rows_sent: 1 Rows_examined: 16650
SET timestamp=1446882039;
select count(*) from payment p left join customer c on p.payment_id = c.customer_id;
# Time: 151106 23:41:02
# User@Host: root[root] @ localhost []
# Query_time: 0.075027 Lock_time: 0.000083 Rows_sent: 1 Rows_examined: 32699
SET timestamp=1446882062;
select count(*) from payment p left join customer c on p.payment_id = c.customer_id order by c.customer_id;
|