DocumentationThere are many sources for the documentation of MySQL, but the primary website is https://dev.mysql.com/doc/.The developers of MySQL have provided information about the new and upcoming features in the server in the website: MySQL Server BlogCommunity ResourceCommunity resource also play an important role. The forum is https://forums.mysql.com. There are many forums, and they have been grouped into many categories. Some of them have been listed below:MigrationMySQL UsageMySQL ConnectorsProgramming LanguagesTools3rd-Party ApplicationsStorage EnginesMySQL TechnologySQL StandardsBusinessTechnical SupportOracle also offers technical support as MySQL enterprise. Organizations that use MySQL DBMS for important, and business-critical production applications get a subscription that includes the following:MySQL Enterprise ... Read More

MySQL Enterprise EditionMySQL Enterprise Edition comes with advanced features, management tools, and technical support that helps users achieve the highest levels of MySQL scalability, security, reliability, and uptime. It reduces the risk, complication, and cost associated with development, deployment, and management of business-critical MySQL applications.MySQL Database Service is a fully managed database service that helps deploy cloud-native applications using the MySQL, which is considered as the world’s most popular open source database. It is completely developed, managed and supported by the MySQL Team.MySQL Standard EditionMySQL standard edition ensures that user delivers high-performance and provides scalability on OLTP applications (Online Transaction ... Read More

Some of the options and variables that have been removed in MySQL 8.0 have been listed below:innodb_available_undo_logs: It refers to the total number of InnoDB rollback segments. It is different from innodb_rollback_segments, which displays the number of active rollback segments. It was removed in MySQL 8.0.2.Qcache_free_blocks: It refers to the number of free memory blocks in query cache. It was removed in MySQL 8.0.3.Qcache_free_memory: It refers to the amount of free memory for the query cache. It was removed in MySQL 8.0.3.bootstrap: It is used by MySQL installation scripts. It was removed in MySQL 8.0.0.date_format: It is the DATE format (unused). It ... Read More

Some of the options and variables that have been deprecated in MySQL 8.0 have been listed below:Compression: It tells whether the client connection uses compression in client/server protocol or not. It was deprecated since MySQL 8.0.18.expire_logs_days: It purges the binary logs after specific number of days. It was deprecated since MySQL 8.0.3.log_syslog: It determines whether to write error log to syslog. It was deprecated since MySQL 8.0.2.master-info-file: It helps determine the location and name of file that remembers the source and where the I/O replication thread is, in source's binary log. It was deprecated since MySQL 8.0.18.master_info_repository: It determines whether ... Read More

Some of the options and variables newly introduced in MySQL 8.0 have been listed below:Com_clone: It refers to the number of CLONE statements. It was added in MySQL 8.0.2.Com_create_role: It refers to the number of CREATE ROLE statements that are used. It was added in MySQL 8.0.0.Com_drop_role: It refers to the number of DROP ROLE statements that were used. It was added in MySQL 8.0.0.Com_restart: It refers to the number of RESTART statements that were used. It was added in MySQL 8.0.4.Firewall_access_denied: It refers to the number of statements that were rejected by MySQL Enterprise Firewall. It was added in ... Read More

Some of the features have become obsolete and have been removed from MySQL 8.0. When alternatives to these removed items are shown, they need to be used to avoid further complications.The ‘innodb_locks_unsafe_for_binlog’ system variable has been removed.The ‘READ COMMITTED’ isolation level can be used since it behaves in a similar way.After upgrading the system to MySQL version 8.0.3 or later, scripts that reference previous InnoDB INFORMATION_SCHEMA view names have to be upgraded.Some of the account management attributes have been removed. A few have been listed below:Instead of using ‘GRANT’ to create users, use ‘CREATE USER’.The query cache has been removed.The deprecated ... Read More

Some of the features that have been deprecated may be removed in the upcoming versions of MySQL. If applications use the features that have been deprecated in that specific version, that feature should be revised and alternatives should be used wherever possible.Let us understand in brief, the features that have been deprecated in MySQL 8.0:The ‘utf8mb3’ character set is deprecated, use ‘utf8mb4’ instead.The ‘sha256_password’ password authentication is deprecated, may be removed in future updates. Use ‘caching_sha2_password’ instead.Some implementation changes have been made to ‘validate_password’ plugin, may be removed in future versions. Use this plugin by ensuring that component infrastructure is ... Read More

Let us understand the features that were added to MySQL 8.0Security Levels EnhancedThe security levels have been improved, and DBA (Database administrator) has been given greater flexibility for account management.Resource GroupsResource groups can be created and managed, and the server has the ability to assign threads to resources of specific groups, that are running within the server. Group attributes can be used to control the resources, restrict or provide permission to the threads to consume the resource, and so on.Transactional Data DictionaryA transactional data dictionary is used to store information about objects, which was previously a non-transactional table.Upgrade ProcedureThe upgrade ... Read More

MySQL is a very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages. It uses a standard form of the well-known SQL data language. MySQL 8.0 released on 19 April 2018 and the current version is 8.0.23.The new features in MySQL 8.0 have been briefly listed below:Atomic DDLAn atomic data definition language (DDL) statement to combine updates made to data dictionary, storage engine operations and so on.Encryption DefaultsThe encryption defaults have been defined and implemented globally for table encryption.  The ‘default_table_encryption’ variable is used to define an ... Read More

MySQL is an open source SQL (structured query language) database management system.  It is a system that helps store and manage data efficiently. Database generally stores data in a structured fashion.Timeline of MySQLUnireg, which is the code base of MySQL, was started in 1981.MySQL was founded in 1995 in Sweden.In 2000, MySQL went open source, so it could be accessed and used by all.In the year 2001, Marten Mickos was elected as the CEO of MySQL.In the year 2002, MySQL launched its headquarters in USA, in addition to Sweden headquarters.In 2003, MySQL entered into a partnership with SAP, and many features ... Read More