MySQL - All about Configuration File

-

What My.cnf File Was Used To Start The Instance

Often it is not clear that configuration file is used to boot a MySQL instance. In this case we will see a trick for Windows. First of all if we execute the following command;
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql –help
In one part of the output that gives us, we see the following;
Default options are read from the following files in the given order:
C:\Windows\my.ini C:\Windows\my.cnf C:\my.ini C:\my.cnf C:\Program Files\MySQL\MySQL Server 5.7\my.ini C:\Program Files\MySQL\MySQL Server 5.7\my.cnf
Here indicates the file name and order to search for the file of parameters. The easiest trick in Windows, as long as we have installed MySQL as a service, remember that Windows can be installed as application  although I do not recommend this option. It is to see service properties as shown in the following screen shot;


where_is_mysql_my

Comments

Post a Comment

Popular posts from this blog

SQL Server on Nutanix - Best pratices

-
The following taken from : Microsoft SQL Server 2016 Nutanix Best Practices Drive configuration: For optimal performance several virtual disks should be used.   Nutanix suggest eight disks per SQL Server virtual machine spread across   4 SCSI controllers as laid out below:   Drive Controller Type Controller # OS LSI SAS 0 SQL Sever installation LSI SAS 0 Backup LSI SAS 0 SQL Datafiles 1 PVSCSI 1 SQL Datafiles 2 PVSCSI 1 TempDB Datafiles 1 PVSCSI 2 TempDB Datafiles 2 PVSCSI 2 TempDB Log Files PVSCSI 3 Database Log Files PVSCSI 3 Cluster size formatting of all drives as below: SQL Data and log files   - 64KB NTFS OS and SQL Server installation - 4KB NTFS - Server Team ?? ...
Read more

ASM Proxy: New Instance Type in Oracle 12c

-
Image
Prior Oracle Database 12c, an ASM instance ran on every node in the cluster and ASM Cluster File System (ACFS) Service on a node connected to the local ASM instance running on the same host to fetch the required metadata. If the ASM instance on a node were to fail, then ACFS file systems could no longer be accessed on that node. With introduction of Flex ASM in Oracle 12c, hard dependency between ASM and its clients has been relaxed and only a smaller number of ASM instances need run on a subset of servers in a cluster. In such a scenario, in order to make ACFS services available on nodes without an ASM instance, a new instance type has been introduced by Flex ASM: the ASM-proxy instance which works on behalf of a real ASM instance. ASM Proxy instance fetches the metadata about ACFS volumes and file systems from an ASM instance and caches it. If ASM instance is not available locally, ASM proxy instance connects to other ASM instances over the network to fetch the me...
Read more

Export/Import Data on Amazon RDS using Oracle Datapump utility

-
How you import data into an Amazon RDS DB instance depends on the amount of data you have and the number and variety of database objects in your database. For example, you can use Oracle SQL Developer to import a simple, 20 MB database. You can use Oracle Data Pump to import complex databases, or databases that are several hundred megabytes or several terabytes in size. You can also use AWS Database Migration Service (AWS DMS) to import data into an Amazon RDS DB instance. AWS DMS can migrate databases without downtime and, for many database engines, continue ongoing replication until you are ready to switch over to the target database. You can migrate to Oracle from either the same database engine or a different database engine using AWS DMS. If you are migrating from a different database engine, you can use the AWS Schema Conversion Tool to migrate schema objects that are not migrated by AWS DMS. For more information about AWS DMS, see  What is AWS Database Migration Ser...
Read more