Connector/Node.js 1.0
Connector/Node.js 1.0 Connector/Node.js 1.0 (1.0.2 m1, published on Monday, 11 Apr 2016) Source: Connector/Node.js 1.0
mysql
Connector/J 6.0
Connector/J 6.0 Connector/J 6.0 (6.0.2 m1, published on Monday, 11 Apr 2016) Source: Connector/J 6.0
MySQL for Visual Studio 2.0
MySQL for Visual Studio 2.0 MySQL for Visual Studio 2.0 (2.0.2 m1, published on Monday, 11 Apr 2016) Source: MySQL for Visual Studio 2.0
Extending the SYS schema to show metadata locks
Extending the SYS schema to show metadata locks Starting with MySQL 5.7, performance_schema has been enhanced to instrument metadata locks, and can be turned on by adding the following line to your my.cnf file: performance-schema-instrument=’wait/lock/metadata/sql/%=ON’ (At runtime, it can also be enabled by modifying the setup_instruments table in performance_schema.) From here, you can now query performance_schema.metadata_locks to reveal all currently open metadata locks on your server: mysqlselect * from performance_schema.metadata_locksG *************************** 1. … Source: Extending the SYS schema to show metadata locks
mysql error : No data – zero rows fetched, selected, or processed
프로시저를 생성해놓고 호출시에.. No data – zero rows fetched, selected, or processed 에러가 발생하는 경우가 있음. DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1; 구문을 프로시저에 추가해주면 된다고함… (이것은 내가 테스트 해본것은 아님.. 귀찮기도 하고.. ) 실사용은 아래 내용을 참고할 것 PS. mysql-5.6 으로 업데이트 하는 방법도 있다고함 (역시 내가 테스트 해본것은 아님.. 귀찮기도 했고.. ) 참고 : https://jirak.net/wp/mysql-fetch-cursor-%eb%ac%b8-%ec%82%ac%ec%9a%a9%eb%b0%a9%eb%b2%95/