Changes between Version 2 and Version 3 of TimeBasedDB


Ignore:
Timestamp:
10/29/14 10:24:12 (11 years ago)
Author:
dneise
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • TimeBasedDB

    v2 v3  
    111111I think, this is still no problem for an InnoDB table index, so in principle, I don't see a problem in creating one table per file, for the entire lifetime of the experiment.
    112112
     113=== Table width ===
     114Since MySQL tables cannot be wider that 64kb , out widest fits tables might create problems, if we don't take care about column sizes:
     115These are our widest tables:
     116
     117|| name                                    || delta t [s]  ||  stddev [s] || rows   ||  width [bytes]    ||    size = rows*width [bytes]||
     118||FAD_CONTROL_EVENT_DATA                   ||     5.386 ||    15.066 ||      7050 ||     23052 || 162516600 ||
     119||FEEDBACK_CALIBRATION                     || 39889.953 ||     0.000 ||         2 ||      6668 ||     13336 ||
     120||FEEDBACK_CALIBRATION_STEPS               ||  7977.991 || 15955.981 ||         6 ||      5008 ||     30048 ||
     121||FEEDBACK_CALIBRATED_CURRENTS             ||     1.230 ||     9.689 ||     63269 ||      3372 || 213343068 ||
     122||FEEDBACK_CALIBRATION_R8                  || 39889.953 ||     0.000 ||         2 ||      3340 ||      6680 ||
     123||BIAS_CONTROL_DAC                         ||     0.568 ||     6.419 ||    137359 ||      1676 || 230213684 ||
     124||BIAS_CONTROL_VOLTAGE                     ||     0.568 ||     6.419 ||    137359 ||      1676 || 230213684 ||
     125||FSC_CONTROL_BIAS_TEMP                    ||    16.722 ||     4.993 ||      5168 ||      1304 ||   6739072 ||
     126||FTM_CONTROL_DYNAMIC_DATA                 ||     1.415 ||     1.239 ||     61082 ||      1086 ||  66335052 ||
     127||BIAS_CONTROL_CURRENT                     ||     0.686 ||     7.046 ||    113823 ||       844 ||  96066612 ||
     128||FTM_CONTROL_TRIGGER_RATES                ||     1.415 ||     1.239 ||     61082 ||       844 ||  51553208 ||
     129
     130=== arrays --> columns, Number of columns ===
     131I found on SO that there is a limit on the total number of columns in a table at 3398 columns.
     132Since storage of arrays is not suported natively by MySQL we decided to create a large number of columns fo each array.
     133
     134This limit is crossed by FAD_CONTROL_EVENT_DATA, which ends up having 5762 columns. So we omit this aux file for the time being.
     135