No Image

InnoDB : Tablespace Space Management

2019-11-08 KENNETH 0

InnoDB : Tablespace Space Management A user defined table and its corresponding  index data, in InnoDB, is  stored in files that have an extension .ibd. There are two types of tablespaces, general (or shared) tablespace and file-per-table.  For shared  tablespaces, data from many different  tables and their corresponding indexes may reside in a single .ibd file.… Facebook Twitter LinkedIn Source: InnoDB : Tablespace Space Management

MySQL Keyring now speaks Hashicorp Vault

2019-10-21 KENNETH 0

MySQL Keyring now speaks Hashicorp Vault As an intro to his performance act, an “old school” entertainer Victor Borge once famously asked the audience: “Do you care for piano music?“, which was greeted by a crowd, only to be immediately followed by a self-ironic punch line – “Too bad.” Security topics share a similar notion – namely, once you start caring for them, you get exposed to an almost unmanageable set of constraints, issues and hard choices.… Facebook Twitter LinkedIn Source: MySQL Keyring now speaks Hashicorp Vault

Failed compile with error “Could not find rpcgen” when configure mysql in centos8(RHEL8)

2019-10-18 KENNETH 0

Failed compile with error “Could not find rpcgen” when configure mysql in centos8(RHEL8)   Error Message : CMake Error at plugin/group_replication/libmysqlgcs/rpcgen.cmake:100 (MESSAGE): Could not find rpcgen Call Stack (most recent call first): plugin/group_replication/libmysqlgcs/CMakeLists.txt:38 (INCLUDE)   원인 : centos8 에는 rpcgen 명령어가 없음 대략적인 관련내용 : https://fedoraproject.org/wiki/Changes/SunRPCRemoval   해결 : rpcgen을 설치하면 된다… 몇가지 방법이 있겠지만…            

MySQL EXPLAIN ANALYZE

2019-10-17 KENNETH 0

MySQL EXPLAIN ANALYZE MySQL 8.0.18 was just released, and it contains a brand new feature to analyze and understand how queries are executed: EXPLAIN ANALYZE. What is it? EXPLAIN ANALYZE is a profiling tool for your queries that will show you where MySQL spends time on your query and why.… Facebook Twitter LinkedIn Source: MySQL EXPLAIN ANALYZE

No Image

MySQL Shell 8.0.18 – What’s New?

2019-10-16 KENNETH 0

MySQL Shell 8.0.18 – What’s New? The MySQL Development team is proud to announce a new version of the MySQL Shell with the following major improvements: Migration to Python 3 Built-in thread reports Ability to use an external editor Ability to execute system commands within the shell Admin API Improvements: New options to log all the SQL used on the different operations Support for IPv6 in InnoDB Clusters New function to reset the InnoDB Cluster recovery accounts General maintenance and bug fixing Python 3 Migration Due to the coming end-of-life (EOL) for Python 2.7 by end of this year, the Shell has been updated to use Python 3. … Facebook Twitter LinkedIn Source: MySQL Shell 8.0.18 – What’s New?