No Image

MySQL 8.0: Excluding the Buffer Pool from a Core File

2019-01-29 KENNETH 0

MySQL 8.0: Excluding the Buffer Pool from a Core File The latest release of MySQL 8.0 introduces a new dynamic system variable @@innodb_buffer_pool_in_core_file which lets you omit the Buffer Pool’s memory content when generating a core file. This change is an adaptation of a patch contributed by the Facebook team. We would like to thank and acknowledge this important and timely contribution by Facebook.… Source: MySQL 8.0: Excluding the Buffer Pool from a Core File

mysql 프로세스 리스트 확인 (mysql show processlist VS show full processlist)

2019-01-28 KENNETH 0

mysql 에서 기본적으로 지원하는 processlist 를 사용하다가너무나도 뒤늦게 깨닳은 바가 있기에… 세상에 이걸 이렇게 모르고 살 수 있었던가 싶기도 하네… 출처https://dev.mysql.com/doc/refman/8.0/en/show-processlist.html 보통 프로세스 목록을 확인하는 경우mysql> show processlist;로 확인 하며 결과는 ———+—————–+———–+——————–+———+———+————————+——————+| Id | User | Host | db | Command | Time | State | Info |+———+—————–+———–+——————–+———+———+————————+——————+| 4 | event_scheduler | localhost | | Daemon | 3937394 | Waiting on empty queue | || 1566520 | root | localhost | test_db | Sleep | 702 | | || 1568887 | root | localhost | | Query | 0 | starting | show processlist |+———+—————–+———–+——————–+———+———+————————+——————+ 이러한 형태로 출력되며실제 수행되는 SQL은 “Info” 필드에 표시된다. 허나 SQL문이 장문일 경우 뒤가 잘리게 되는데보다 정확하게 확인하기 위해서는 다른 tool 을 사용했었던것…. 그런데 mysql 레퍼런스를 확인해보니 13.7.6.29 SHOW PROCESSLIST Syntax SHOW [FULL] PROCESSLIST SHOW PROCESSLIST shows which threads are running. If you have the PROCESS [ more… ]

No Image

MySQL InnoDB Cluster – Extended cluster information and rescan

2019-01-25 KENNETH 0

MySQL InnoDB Cluster – Extended cluster information and rescan This blog post completes the series that we have been composing to detail every single new feature added in the latest MySQL InnoDB Cluster release, as mentioned in the release announcement of 8.0.14. We’ll close the series now with the details about the new features that improve the management capabilities of MySQL Shell: “Extended status information available from <Cluster.>status()” and “Redesigned and extended <Cluster.>rescan()”.… Source: MySQL InnoDB Cluster – Extended cluster information and rescan

No Image

MySQL InnoDB Cluster – Controlling data consistency and expel timeouts

2019-01-24 KENNETH 0

MySQL InnoDB Cluster – Controlling data consistency and expel timeouts This blog post follows the series that we have been composing to detail every single new feature added in the latest MySQL InnoDB Cluster release. As listed in the release announcement of 8.0.14, we’re very happy with new features that greatly enhance the whole experience and capabilities of InnoDB cluster!… Source: MySQL InnoDB Cluster – Controlling data consistency and expel timeouts

No Image

MySQL InnoDB Cluster – Changing cluster options “live”

2019-01-23 KENNETH 0

MySQL InnoDB Cluster – Changing cluster options “live” As listed in the release announcement of the latest MySQL InnoDB Cluster release, 8.0.14 brings exciting new features! This blog post integrates a series detailing every single new feature added. We’ll follow up now with two very desired and useful features: “Checking current cluster configuration options” and “Changing cluster members or global cluster options ‘live’”.… Source: MySQL InnoDB Cluster – Changing cluster options “live”