mysql

[MYSQL] ‘user’ entry ‘USER@HOSTNAME’ ignored in –skip-name-resolve mode

2022-04-05 KENNETH 0

  에러메세지 [Warning] ‘user’ entry ‘[email protected]’ ignored in –skip-name-resolve mode.     원인 mysql의 skip-name-resolve 옵션에 의해 ‘DNS Lookup’ 과정을 처리하지 않도록 되어있는 상황에서 mysql.user 테이블의 ‘Host’컬럼에 도메인(호스트이름)이 들어갔기 때문에 이는 무시된다는 메세지로서 성능에 영향이 없으며 그냥 두어도 되며 결국 문제는 없는 메세지 즉, 말 그대로 warning 형태의 메세지 이므로 걱정할 필요는 없다     해결 하지만… error-log 에 남는것은 앞으로도 불편한 내용일 수 있으니 처리해서 나쁠것은 없다 단, skip-name-resolve 는 어쩔 수 없이 off 하는 경우가 아님을 전제로 하고 (즉, 사용함) 및 이와 상응하는 방법으로 해결하시면 되겠다      

No Image

MySQL Shell 8.0.24 – What’s New?

2021-04-22 KENNETH 0

MySQL Shell 8.0.24 – What’s New? The MySQL team is proud to announce the general availability of version 8.0.24 of the MySQL Shell. In addition to a considerable number of bugs fixed, the following changes were introduced. Improved Command Line Integration Integrating the shell functionality in DevOps operations is a key feature and this release has introduced a big improvement on this area being the most remarkable improvements the following: No longer need to execute APIs using the –execute (-e) command line argument: all of the data required for any API available in CLI can be defined through command line arguments (including lists). … Facebook Twitter LinkedIn Source: MySQL Shell 8.0.24 – What’s New?

No Image

InnoDB: Converting old atomic code to C++11

2021-04-22 KENNETH 0

InnoDB: Converting old atomic code to C++11 Atomics (or GCC intrinsics) were first introduced in InnoDB (5.0) by a patch  from Mark Callaghan’s team at Google for mutexes and rw-locks. InnoDB code then was written in C.  When the code was ported to C++ ,  part of the 5.6 release, there was no C++ standard for atomics.… Facebook Twitter LinkedIn Source: InnoDB: Converting old atomic code to C++11

No Image

The MySQL 8.0.24 Maintenance Release is Generally Available

2021-04-20 KENNETH 0

The MySQL 8.0.24 Maintenance Release is Generally Available The MySQL Development team is very happy to announce that MySQL 8.0.24 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release.  Please download 8.0.24 from dev.mysql.com or from the MySQL  Yum,  APT, or SUSE repositories.… Facebook Twitter LinkedIn Source: The MySQL 8.0.24 Maintenance Release is Generally Available

No Image

InnoDB Data Locking – Part 5 “Concurrent queues”

2021-04-19 KENNETH 0

InnoDB Data Locking – Part 5 “Concurrent queues” In this blog series, I’m describing how InnoDB locks data (tables and rows) in order to provide illusion to clients that their queries are executed one after another, and how this was improved in recent releases. So far we saw that access right currently granted and waiting to be granted are represented as record locks and table locks objects in memory, which we can inspect via performance_schema.data_locks.… Facebook Twitter LinkedIn Source: InnoDB Data Locking – Part 5 “Concurrent queues”