Export logs of MT4
Allows uploading log file of MT4 server operation to MySQL database (configuration providing compatibility with other databases is available)
* Significant reduction of storage size required for log records. Due to optimized structure of stored data records require up to 10 times less of hard disk space.
* Availability of log file analysis automation which allows early detection of malfunctions, accidents, attacks on server and etc.
* Additional copy of system logs allows to check records integrity in case of suspisions of main file modification
* Optimization of MT4 disk space. In case of usage fast but small sized disks like SSD's or high speed SAS HDD's storing log files of journal can become an issue. Utility allows to archive most of outdated log files to reduce disk space usage and request data via database server.
Structure of created tables:
CREATE TABLE `mt4logs`.`20140102` ( `code` int(1) unsigned DEFAULT NULL, `time` time DEFAULT NULL, `second` int(3) DEFAULT NULL, `ip` varchar(32) DEFAULT NULL, `line` text ) ENGINE=ARCHIVE DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
Brief description of operation:
After startup utility connects to MySQL server and requests list of existing tables then compares it with list of files stored in log folder (can be specified in settings). All files which are not found in databse excluding current one (for current day) are exported to database.
For each file table with same name is created.
[MySQL] server=127.0.0.1 // server IP address port=3306 // server port login=Login // user login pass=pass // password DB=mt4logs // Database for storing logs Tbl_Pref=logs_ // prefix set in front of records, i.e. real_ demo_ [Conf] Dir=C:\logs // path to folder with log files.