mysql – 페이지 55 – 지락문화예술공작단

mysql server system variables log_warnings to log_error_verbosity

2016-10-04 KENNETH 0

url : http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html under 5.7.2 : log_warnings over 5.7.2 : log_error_verbosity log_warnings Deprecated 5.7.2 Command-Line Format –log-warnings[=#] System Variable Name log_warnings Variable Scope Global Dynamic Variable Yes Permitted Values (32-bit platforms, <= 5.7.1) Type integer Default 1 Min Value 0 Max Value 4294967295 Permitted Values (32-bit platforms, >= 5.7.2) Type integer Default 2 Min Value 0 Max Value 4294967295 Permitted Values (64-bit platforms, <= 5.7.1) Type integer Default 1 Min Value 0 Max Value 18446744073709551615 Permitted Values (64-bit platforms, >= 5.7.2) Type integer Default 2 Min Value 0 Max Value 18446744073709551615 Whether to produce additional warning messages to the error log. This variable is enabled by default (the default is 1 before MySQL 5.7.2, 2 as of 5.7.2). To disable it, set it to 0. The server logs messages about statements that are unsafe for statement-based logging if the [ more… ]

MySQL 8.0: Testing Improvements

2016-09-29 KENNETH 0

MySQL 8.0: Testing Improvements The first DMR of MySQL 8 was recently released. While a DMR (or Developer Milestone Release) is not yet a GA product, it does come with our commitment that each feature has been tested and qualified for inclusion. In MySQL 8.0 we have made additional improvements to the MySQL test framework (MTR) and the test suite.… Source: MySQL 8.0: Testing Improvements

MySQL 8.0: Making User Management DDLs Atomic

2016-09-26 KENNETH 0

MySQL 8.0: Making User Management DDLs Atomic With MySQL 8.0, we are bringing in an important change in the way user management DDLs are executed. Background User management DDLs cover following user management actions: Creating user/role (CREATE USER [IF NOT EXISTS] / CREATE ROLE [IF NOT EXISTS]) Altering user account properties (ALTER USER [IF EXISTS]) Dropping user/role from database (DROP USER [IF EXISTS] / DROP ROLE [IF EXISTS]) Granting/Revoking privileges to/from a user/role (GRANT/REVOKE) Each of these administrative action can handle multiple entities as a part of single command.… Source: MySQL 8.0: Making User Management DDLs Atomic

MySQL 8.0 Labs: [Recursive] Common Table Expressions in MySQL (CTEs)

2016-09-20 KENNETH 0

MySQL 8.0 Labs: [Recursive] Common Table Expressions in MySQL (CTEs) The MySQL development team just published a Labs release of the MySQL Server. A prominent feature of this release, which I developed, is [Recursive] Common Table Expressions, also known as [recursive] CTE, [recursive] subquery factoring, WITH [RECURSIVE] clause. … Source: MySQL 8.0 Labs: [Recursive] Common Table Expressions in MySQL (CTEs)

Introducing MySQL InnoDB Cluster – A Hands-On Tutorial

2016-09-20 KENNETH 0

Introducing MySQL InnoDB Cluster – A Hands-On Tutorial Traditionally, setting up high availability (HA) in MySQL has been a challenging task, especially for people without advanced knowledge of MySQL. From understanding concepts and technologies, to the tooling, specific commands and files to execute and edit, there’s a lot of things you need to know even when planning a test deployment (the Quick Start Guide for Group Replication should give you an idea).… Source: Introducing MySQL InnoDB Cluster – A Hands-On Tutorial