批量操作

  • 批量插入（新增）
    ```sql — 适用于MySQL INSERT INTO testimport (name, message) VALUES (‘testname’, ‘jfksdfkdsfjksadljfkdsfjsdlafjdaslkfjasfd’), (‘testname’, ‘jfksdfkdsfjksadljfkdsfjsdlafjdaslkfjasfd’), (‘testname’, ‘jfksdfkdsfjksadljfkdsfjsdlafjdaslkfjasfd’);

— 适用于Oracle INSERT ALL INTO A (name, message) VALUES (‘testname’, ‘jfksdfkdsfjksadljfkdsfjsdlafjdaslkfjasfd’) INTO A (name, message) VALUES (‘testname’, ‘jfksdfkdsfjksadljfkdsfjsdlafjdaslkfjasfd’) INTO A (name, message) VALUES (‘testname’, ‘jfksdfkdsfjksadljfkdsfjsdlafjdaslkfjasfd’) SELECT 1 FROM DUAL;

  3. <a name="RQkOH"></a>
  4. ## MySql调优
  6. -  开启慢查询日志  
  7. ```sql
  8. set global slow_query_log='ON';

  • 设置慢查询阈值 

    1. set long_query_time=5;

  • 检查是否开启慢查询日志 

    1. show variables like '%slow_query_log%' ;

  • 慢查询阈值： 

    1. show variables like '%long_query_time%' ;