Let us understand how to set environment variables on Linux for MySQL −Environment variables can be set at the command prompt. This is done to affect the current invocation of the command processor, or to permanently set to affect the future invocations.To set a variable permanently, it can be set ... Read More

Before a compressed table is created, ensure that the innodb_file_per_table configuration option is enabled, and innodb_file_format is set to Barracuda. These parameters can be found in the MySQL configuration file my.cnf or my.ini, or with the SET statement without having to shut down the MySQL server.To enable compression for a ... Read More

The new features in MySQL 8.0 have been briefly listed below −Transactional Data DictionaryA transactional data dictionary to store information about object.Atomic Data Definition LanguageAn atomic data definition language (DDL) statement to combine updates made to data dictionary, storage engine operations and so on.Security EnhancedThe security levels have been improved, ... Read More

The compression operation is used only if both client and server support ‘zlib’ compression, and the client requests compression.Usage of mysqldumpThe advantage of using compression is that it reduces the size of the payloadOn the other hand, the disadvantage of using compression is that it increases the computation time.Performance benefits ... Read More

TLS is also known as SSL (Secure Sockets Layer). It refers to Transport Layer Security.When there is an unencrypted connection between the MySQL client and the server, a person who has access to the network can watch all the traffic and inspect the data that is being sent or received ... Read More

Let us understand when MySQL compressed protocol should be used −The compression operation is used only if both client and server support ‘zlib’ compression, and the client requests compression.The advantage of using compression is that it reduces the size of the payload.On the other hand, the disadvantage of using compression ... Read More

MySQL will make secure connections easier when it has streamlined key generation for both MySQL Community and MySQL Enterprise. This way, the security is improved by expanding support for TLSv1.1 and TLSv1.2. This also helps administrators determine if clients are connecting securely or not with enhanced visibility into connection types.Extending ... Read More

Programs such as ‘mysql’ and ‘mysqldump’, that use MySQL client library have the support of MySQL connection to server with the help of many transport protocols, such as TCP/IP, Unix socket file, named pipe, shared memory, and so on.With respect to a given connection, if the transport protocol is not ... Read More

Programs such as ‘mysql’ and ‘mysqldump’, that use MySQL client library have the support of MySQL connection to server with the help of many transport protocols, such as TCP/IP, Unix socket file, named pipe, shared memory, and so on. Let us understand the connection transport protocols used with MySQL −The ... Read More

Let us see how command line options can be used to establish connection with the MySQL server for clients like mysql or mysqldump.For a client program to be able to connect to the MySQL server, it must use proper connection parameters, like the name of the host where the server ... Read More