SELECT /*!40001 SQL_NO_CACHE */ * INTO OUTFILE '/tmp/ClientActionTrack2015112511.txt' 不堵塞事务

SELECT /!40001 SQL_NO_CACHE / * INTO OUTFILE '/tmp/ClientActionTrack2015112511.txt' 不堵塞事务

mysql> insert into ClientActionTrack20151125(clientSn,ip,url,httpMethod,requestParams,requestHeader,pageUrl,sessionId,startTime,completeTime) values(11,'1.1.1.1',NULL,' 用户注册-register-成功',NULL,NULL,NULL,NULL,now(),now());
Query OK, 1 row affected (0.03 sec)

mysql> select * from ClientActionTrack20151125 where ipd='1.1.1.1';
ERROR 1054 (42S22): Unknown column 'ipd' in 'where clause'
mysql> select * from ClientActionTrack20151125 where ip='1.1.1.1';


insert into ClientActionTrack20151125(clientSn,ip,url,httpMethod,requestParams,requestHeader,pageUrl,sessionId,startTime,completeTime) 

select clientSn,ip,url,httpMethod,requestParams,requestHeader,pageUrl,sessionId,startTime,completeTime from ClientActionTrack20151125;

SELECT /*!40001 SQL_NO_CACHE */ * INTO OUTFILE '/tmp/ClientActionTrack20151125.txt' /*!50138 CHARACTER SET binary */ FROM `ClientActionTrack20151125`; 


Session 1:
mysql> SELECT /*!40001 SQL_NO_CACHE */ * INTO OUTFILE '/tmp/ClientActionTrack2015112511.txt' /*!50138 CHARACTER SET binary */ FROM `ClientActionTrack20151125`;  



Session 2:

mysql> insert into ClientActionTrack20151125(clientSn,ip,url,httpMethod,requestParams,requestHeader,pageUrl,sessionId,startTime,completeTime) values(11,'1.1.1.1',NULL,' 用户注册-register-成功',NULL,NULL,NULL,NULL,now(),now());
Query OK, 1 row affected (0.00 sec)

mysql> commit;
Query OK, 0 rows affected (0.00 sec)


不堵塞事务