Data saving into the one table of the MySQL database (Database MySQL cyclic) - configuration window

Description:

The window serves for setting the parameters for the data storage into the MySQL database. By this technology the data are stored into the one table (in the MySQL database) with the name specified in the "Table" configurator. The minimum and maximum size of the table is defined. If the current size of the table exceeds the maximum size, then so many oldest records are removed to decrease the size to the minimum size of the table. This walkthrough repeats all over again.
By the RunTime method it is possible to do backward writing for this type of setting the storage (it is possible to write the records with the older time than the time of the last written record).
By this technology the writing is performed by means of the ODBC driver for the MySQL database, which has to be installed to the computer were the PROMOTIC application is running.

Configurators:

Data source (ConnectionString)	The ADO ConnectionString (http://www.connectionstrings.com) contains all necessary parameters needed by the ADO Connection object for database connection via the selected ADO Provider. Macro expression can be used for input (it is evaluated after the application is launched). This configurator must not contain an empty string. For example Provider=MSDASQL;Driver={MySQL ODBC 8.0 Unicode Driver};Server=localhost;Database=pm_data;Uid=pm_writer;Pwd=pmwriter; or Provider=MySQLProv;Data Source=pm_data;User Id=pm_writer;Password=pmwriter;
Additional parameters	Additional parameters for storing. Allows to define names and data types of system columns, database types based on the trended variable data type. Available parameters are shown in the following example together with their preset values for selectaed saving type (plugin). These values may not be entered. Enter the values only if non-default are needed. Entries are in the KeyVal format, for example "coltimename:pm_time;colattrname:pm_attr;dbdt.pmtime:DATETIME;dbdt.pmattr:FLOAT(10,0);dbdt.f64:FLOAT(10,3);dbdt.f32:FLOAT(10,3);dbdt.i32:FLOAT(10,0);dbdt.i16:FLOAT(5,0);dbdt.u8:INT;dbdt.b:BIT;". Macro expression can be used for input (it is evaluated after the application is launched). coltimename (optional) - Column name containing the record timestamp. Default "coltimename:pm_time;". colattrname (optional) - Column name containing the record attribute. Default "colattrname:pm_attr;". dbdt.pmtime (optional) - Database data type of the column containing record timestamp. Default "dbdt.pmtime:DATETIME;". dbdt.pmattr (optional) - Database data type of the column containing record attribute. Default "dbdt.pmattr:FLOAT(10,0);". dbdt.f64 (optional) - Database data type of the column for trended variable of the data type: Float64 (Double). This is used if the trended variable does not have its database data type defined. Default "dbdt.f64:FLOAT(10,3);". dbdt.f32 (optional) - Database data type of the column for trended variable of the data type: Float32 (Single). This is used if the trended variable does not have its database data type defined. Default "dbdt.f32:FLOAT(10,3);". dbdt.i32 (optional) - Database data type of the column for trended variable of the data type: Int32 (Long). This is used if the trended variable does not have its database data type defined. Default "dbdt.i32:FLOAT(10,0);". dbdt.i16 (optional) - Database data type of the column for trended variable of the data type: Int16 (Integer). This is used if the trended variable does not have its database data type defined. Default "dbdt.i16:FLOAT(5,0);". dbdt.u8 (optional) - Database data type of the column for trended variable of the data type: Uint8 (Byte). This is used if the trended variable does not have its database data type defined. Default "dbdt.u8:FLOAT(3,0);". dbdt.b (optional) - Database data type of the column for trended variable of the data type: Bool (Boolean). This is used if the trended variable does not have its database data type defined. Default "dbdt.b:BIT;".
Table	Name of the table in the database into which the data are stored. Macro expression can be used for input (it is evaluated after the application is launched). This configurator must not contain an empty string.
Minimum table size	Minimum size of the table specified by the records count. The number of records in the table never drops below this minimum limit.
Maximum table size	Maximum size of the table specified by the records count. The number of records in the table never exceeds this maximum limit. When exceeding this limit, such count of the oldest records is removed to decrease the number of records in the table to the minimum size of the table. The -1 value means that the maximum size of the table is not limited by the records count.
Minimum table size by time span	Minimum size of the table specified by time span. The time span of records in the table never drops below this minimum limit.
Maximum table size by time span	Maximum size of the table specified by time span. The maximum time span of all records in the table. When exceeding this limit, such count of the oldest records is removed to decrease the number of records in the table to the minimum size of the table. The -1 value means that the maximum size of the table is not limited by the time size.

Note:

If the writing operation of record to the database fails, then the PROMOTIC system will try to write the record two more times. If the writing operation of record fails because of network error (timeout), then the PROMOTIC system closes the connection and will try to connect and write the record during following writings (of the same or another record). If the connection is regained, then the writing of trend records continues automatically. If the network failure continues during a longer period of time, some records may be lost. The information regading writing errors on network failure will be written into the global errors of the INFO system.