Logging on a separate device
You can improve the performance of update-intensive,
large databases by putting a database's log on a separate device, which
reduces I/O contention.
By default, the transaction log is in the log subdirectory
of the database directory. Use either of the following methods to store this log subdirectory in another location:
- Specify the non-default location by using the logDevice=logDirectoryPath attribute on the database connection URL when you create the database.
- If the database is already created, move the log manually and update the service.properties file.