No Image

MySQL Operator 8.0

2022-06-15 KENNETH 0

MySQL Operator 8.0 MySQL Operator 8.0 (8.0.29 GA, published on Wednesday, 15 Jun 2022) Source: MySQL Operator 8.0

[MYSQL] NO_PUBKEY error in apt update

2022-05-12 KENNETH 0

환경 OS : Ubuntu 20.04 MYSQL : 8.0.26     발생에러 Err:1 http://repo.mysql.com/apt/ubuntu focal InRelease The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29 .. .. W: An error occurred during the signature verification. The repository is not updated and the previous index files will be used. GPG error: http://repo.mysql.com/apt/ubuntu focal InRelease: The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29 W: Failed to fetch http://repo.mysql.com/apt/ubuntu/dists/focal/InRelease The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29 W: Some index files failed to download. They have been ignored, or old ones used instead.     원인 URL : https://docs.oracle.com/cd/E17952_01/mysql-8.0-relnotes-en/news-8-0-28.html#mysqld-8-0-28-packaging https://dev.mysql.com/doc/refman/8.0/en/checking-gpg-signature.html The GnuPG build key used to sign MySQL downloadable packages has been updated. The previous GnuPG build key is set to expire on 2022-02-16. [ more… ]

[MYSQL] ‘user’ entry ‘[email protected]’ 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