What are the different log files available in MySQL
Log Files MySQL has different log files to record server activity. Log files can consume a large amount of disk space.
Latest Articles
Configure Operational Characteristics of the MySQL Server by Using the SQL Modes
SQL Modes The SQL mode consists of optional values that control some aspect of query processing. When you set the SQL …
What Are MySQL Server Status Variables
Server System Variables The MySQL server maintains many server system variables that indicate how it is configured. Each …
How to Avoid Passing MySQL User Password to Shell Script
In this post, we will learn how to avoid passing the password for the shell script manually. You can either:
How to Encrypt MySQL Password Using Mysql_config_editor
Obscuring Authentication Options Specifying a password on the command line in the form ‘mysql -u root -p …
How to Set Up MySQL Server Configuration Files
MySQL Configuration Options You can specify startup options on the command line when you invoke the server (or client), …
How to Start/Stop MySQL Server on Linux and Windows
Starting the MySQL Server on Linux The server can be started from a command line: # service mysql start Starting the …
What Are Linux/Windows MySQL Server Installation Directories
Linux MySQL Server Installation Directories When the RPM files are unpacked, many files are automatically extracted and …
Beginners Guide to MySQL Architecture
MySQL’s architecture is very different from that of other database servers and makes it useful for a wide range of …
What Are the Types of MySQL Server Software Distribution
MySQL Server Distributions MySQL is available for several operating systems, including Linux, Windows, Mac OS X, and …
"ORA-28365: Wallet Is Not Open" - While Running "RMAN DUPLICATE"
The Problem RMAN DUPLICATE fails with: ORA-00283: recovery session canceled due to errors ORA-28365: wallet is not open …