MySQL single-process multi-threaded, that is, the MySQL instance on the system is a process that the schema is similar to SQL Server and the Windows version of the Oraclemysql database is composed of some column physical files. Files similar to frm, MYD, MYI, IBD the MySQL instance is the thread and memory composition instance that is really used to manipulate the database files in general case one instance corresponds to a DB cluster when multiple instances correspond to a database when the instance starts, MySQL reads the configuration file, Similar to Oracle's SPFile file, the difference is that Oracle fails to start if the parameter file cannot be found, and MySQL launches the instance according to the default parameter settings if the configuration file cannot be found. "Linux"
#mysql--help|grep my.cnf
Order of PREFERENCE,MY.CNF, $MYSQL _tcp_port,
/etc/my.cnf
/etc/mysql/my.cnf
/usr/local/mysql/etc/my.cnf
~/.my.cnf
"Windows"
C:\users\gechong>mysql--help
Default options are read fromThe following filesinchThe given order:
C:\windows\my.ini C:\windows\my.cnf
C:\my.ini
C:\my.cnf
D:\Wamp\wamp\bin\mysql\m
Ysql5.5.20\my.ini D:\WAMP\WAMP\BIN\MYSQL\MYSQL5.5.20The \my.cnfmysql instance is subject to the parameters that are read in the last configuration file
About MySQL databases and examples
