MySQL is open source available, is a fast and popular relational database. Here are points to note when using MySQL.
The type specified by Wagby is handled as follows in the database.
|String type||Varchar (255) (* 1, 2)|
|String type (text area)||Text (* 3)|
|Date Time Type||datetime|
|File type (file name)||varchar(255)|
|1 byte integer||tinyint|
|2 byte integer||smallint|
|4 byte integer||integer|
|8 byte integer||bigint|
|4 byte floating point number||float|
|8 byte floating point number||double precision|
|Fixed value (creation date / update date)||datetime|
|Other (URL type / mail address type etc.)||varchar(255)|
Wagby's import process issues a large amount of update SQL.At this time, if MySQL is configured to perform log flush processing on the physical disk for each transaction, processing takes time.
Setting write as follows improves write performance.
innodb_flush_log_at_trx_commit = 0
However, if you leave this setting, there is a high possibility that data will be lost in the event of a failure in normal operation, so it is required to return to the default value ("1") as soon as the import process is completed.
Wagby's data import tool InitLoader,Execute the SQL statement that the developer independently definedcan do.
In the sql element described in the setting file to be read by InitLoader, when describing multiple SQLs with semicolons, it is necessary to enable MultiQueries specification of MySQL.
This setting can be done by adding the following specification at the end of the connection URL to MySQL in environment setting file project_env.xls.
Reference information: "Driver / Datasource class name of Connector / J, URL syntax, and configuration properties"