210
201
/* Fields of the dynamic table INFORMATION_SCHEMA.innodb_trx */
211
static ST_FIELD_INFO innodb_trx_fields_info[] =
202
static FieldInfo innodb_trx_fields_info[] =
213
204
#define IDX_TRX_ID 0
214
{STRUCT_FLD(field_name, "trx_id"),
215
STRUCT_FLD(field_length, TRX_ID_MAX_LEN + 1),
216
STRUCT_FLD(field_type, DRIZZLE_TYPE_VARCHAR),
217
STRUCT_FLD(value, 0),
218
STRUCT_FLD(field_flags, 0),
219
STRUCT_FLD(old_name, ""),
220
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
207
DRIZZLE_TYPE_VARCHAR,
222
213
#define IDX_TRX_STATE 1
223
{STRUCT_FLD(field_name, "trx_state"),
224
STRUCT_FLD(field_length, TRX_QUE_STATE_STR_MAX_LEN + 1),
225
STRUCT_FLD(field_type, DRIZZLE_TYPE_VARCHAR),
226
STRUCT_FLD(value, 0),
227
STRUCT_FLD(field_flags, 0),
228
STRUCT_FLD(old_name, ""),
229
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
214
FieldInfo("trx_state",
215
TRX_QUE_STATE_STR_MAX_LEN + 1,
216
DRIZZLE_TYPE_VARCHAR,
231
222
#define IDX_TRX_STARTED 2
232
{STRUCT_FLD(field_name, "trx_started"),
233
STRUCT_FLD(field_length, 0),
234
STRUCT_FLD(field_type, DRIZZLE_TYPE_DATETIME),
235
STRUCT_FLD(value, 0),
236
STRUCT_FLD(field_flags, 0),
237
STRUCT_FLD(old_name, ""),
238
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
223
FieldInfo("trx_started",
225
DRIZZLE_TYPE_DATETIME,
240
231
#define IDX_TRX_REQUESTED_LOCK_ID 3
241
{STRUCT_FLD(field_name, "trx_requested_lock_id"),
242
STRUCT_FLD(field_length, TRX_I_S_LOCK_ID_MAX_LEN + 1),
243
STRUCT_FLD(field_type, DRIZZLE_TYPE_VARCHAR),
244
STRUCT_FLD(value, 0),
245
STRUCT_FLD(field_flags, MY_I_S_MAYBE_NULL),
246
STRUCT_FLD(old_name, ""),
247
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
232
FieldInfo("trx_requested_lock_id",
233
TRX_I_S_LOCK_ID_MAX_LEN + 1,
234
DRIZZLE_TYPE_VARCHAR,
249
240
#define IDX_TRX_WAIT_STARTED 4
250
{STRUCT_FLD(field_name, "trx_wait_started"),
251
STRUCT_FLD(field_length, 0),
252
STRUCT_FLD(field_type, DRIZZLE_TYPE_DATETIME),
253
STRUCT_FLD(value, 0),
254
STRUCT_FLD(field_flags, MY_I_S_MAYBE_NULL),
255
STRUCT_FLD(old_name, ""),
256
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
241
FieldInfo("trx_wait_started",
243
DRIZZLE_TYPE_DATETIME,
258
249
#define IDX_TRX_WEIGHT 5
259
{STRUCT_FLD(field_name, "trx_weight"),
260
STRUCT_FLD(field_length, MY_INT64_NUM_DECIMAL_DIGITS),
261
STRUCT_FLD(field_type, DRIZZLE_TYPE_LONGLONG),
262
STRUCT_FLD(value, 0),
263
STRUCT_FLD(field_flags, MY_I_S_UNSIGNED),
264
STRUCT_FLD(old_name, ""),
265
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
250
FieldInfo("trx_weight",
251
MY_INT64_NUM_DECIMAL_DIGITS,
252
DRIZZLE_TYPE_LONGLONG,
267
258
#define IDX_TRX_DRIZZLE_THREAD_ID 6
268
{STRUCT_FLD(field_name, "trx_mysql_thread_id"),
269
STRUCT_FLD(field_length, MY_INT64_NUM_DECIMAL_DIGITS),
270
STRUCT_FLD(field_type, DRIZZLE_TYPE_LONGLONG),
271
STRUCT_FLD(value, 0),
272
STRUCT_FLD(field_flags, MY_I_S_UNSIGNED),
273
STRUCT_FLD(old_name, ""),
274
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
259
FieldInfo("trx_mysql_thread_id",
260
MY_INT64_NUM_DECIMAL_DIGITS,
261
DRIZZLE_TYPE_LONGLONG,
276
267
#define IDX_TRX_QUERY 7
277
{STRUCT_FLD(field_name, "trx_query"),
278
STRUCT_FLD(field_length, TRX_I_S_TRX_QUERY_MAX_LEN),
279
STRUCT_FLD(field_type, DRIZZLE_TYPE_VARCHAR),
280
STRUCT_FLD(value, 0),
281
STRUCT_FLD(field_flags, MY_I_S_MAYBE_NULL),
282
STRUCT_FLD(old_name, ""),
283
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
268
FieldInfo("trx_query",
269
TRX_I_S_TRX_QUERY_MAX_LEN,
270
DRIZZLE_TYPE_VARCHAR,
288
279
/***********************************************************************
391
382
/* Fields of the dynamic table INFORMATION_SCHEMA.innodb_locks */
392
static ST_FIELD_INFO innodb_locks_fields_info[] =
383
static FieldInfo innodb_locks_fields_info[] =
394
385
#define IDX_LOCK_ID 0
395
{STRUCT_FLD(field_name, "lock_id"),
396
STRUCT_FLD(field_length, TRX_I_S_LOCK_ID_MAX_LEN + 1),
397
STRUCT_FLD(field_type, DRIZZLE_TYPE_VARCHAR),
398
STRUCT_FLD(value, 0),
399
STRUCT_FLD(field_flags, 0),
400
STRUCT_FLD(old_name, ""),
401
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
387
TRX_I_S_LOCK_ID_MAX_LEN + 1,
388
DRIZZLE_TYPE_VARCHAR,
403
394
#define IDX_LOCK_TRX_ID 1
404
{STRUCT_FLD(field_name, "lock_trx_id"),
405
STRUCT_FLD(field_length, TRX_ID_MAX_LEN + 1),
406
STRUCT_FLD(field_type, DRIZZLE_TYPE_VARCHAR),
407
STRUCT_FLD(value, 0),
408
STRUCT_FLD(field_flags, 0),
409
STRUCT_FLD(old_name, ""),
410
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
395
FieldInfo("lock_trx_id",
397
DRIZZLE_TYPE_VARCHAR,
412
403
#define IDX_LOCK_MODE 2
413
{STRUCT_FLD(field_name, "lock_mode"),
404
FieldInfo("lock_mode",
414
405
/* S[,GAP] X[,GAP] IS[,GAP] IX[,GAP] AUTO_INC UNKNOWN */
415
STRUCT_FLD(field_length, 32),
416
STRUCT_FLD(field_type, DRIZZLE_TYPE_VARCHAR),
417
STRUCT_FLD(value, 0),
418
STRUCT_FLD(field_flags, 0),
419
STRUCT_FLD(old_name, ""),
420
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
407
DRIZZLE_TYPE_VARCHAR,
422
413
#define IDX_LOCK_TYPE 3
423
{STRUCT_FLD(field_name, "lock_type"),
424
STRUCT_FLD(field_length, 32 /* RECORD|TABLE|UNKNOWN */),
425
STRUCT_FLD(field_type, DRIZZLE_TYPE_VARCHAR),
426
STRUCT_FLD(value, 0),
427
STRUCT_FLD(field_flags, 0),
428
STRUCT_FLD(old_name, ""),
429
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
414
FieldInfo("lock_type",
415
32, /* RECORD|TABLE|UNKNOWN */
416
DRIZZLE_TYPE_VARCHAR,
431
422
#define IDX_LOCK_TABLE 4
432
{STRUCT_FLD(field_name, "lock_table"),
433
STRUCT_FLD(field_length, 1024),
434
STRUCT_FLD(field_type, DRIZZLE_TYPE_VARCHAR),
435
STRUCT_FLD(value, 0),
436
STRUCT_FLD(field_flags, 0),
437
STRUCT_FLD(old_name, ""),
438
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
423
FieldInfo("lock_table",
425
DRIZZLE_TYPE_VARCHAR,
440
431
#define IDX_LOCK_INDEX 5
441
{STRUCT_FLD(field_name, "lock_index"),
442
STRUCT_FLD(field_length, 1024),
443
STRUCT_FLD(field_type, DRIZZLE_TYPE_VARCHAR),
444
STRUCT_FLD(value, 0),
445
STRUCT_FLD(field_flags, MY_I_S_MAYBE_NULL),
446
STRUCT_FLD(old_name, ""),
447
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
432
FieldInfo("lock_index",
434
DRIZZLE_TYPE_VARCHAR,
449
440
#define IDX_LOCK_SPACE 6
450
{STRUCT_FLD(field_name, "lock_space"),
451
STRUCT_FLD(field_length, MY_INT64_NUM_DECIMAL_DIGITS),
452
STRUCT_FLD(field_type, DRIZZLE_TYPE_LONGLONG),
453
STRUCT_FLD(value, 0),
454
STRUCT_FLD(field_flags, MY_I_S_UNSIGNED | MY_I_S_MAYBE_NULL),
455
STRUCT_FLD(old_name, ""),
456
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
441
FieldInfo("lock_space",
442
MY_INT64_NUM_DECIMAL_DIGITS,
443
DRIZZLE_TYPE_LONGLONG,
445
MY_I_S_UNSIGNED | MY_I_S_MAYBE_NULL,
458
449
#define IDX_LOCK_PAGE 7
459
{STRUCT_FLD(field_name, "lock_page"),
460
STRUCT_FLD(field_length, MY_INT64_NUM_DECIMAL_DIGITS),
461
STRUCT_FLD(field_type, DRIZZLE_TYPE_LONGLONG),
462
STRUCT_FLD(value, 0),
463
STRUCT_FLD(field_flags, MY_I_S_UNSIGNED | MY_I_S_MAYBE_NULL),
464
STRUCT_FLD(old_name, ""),
465
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
450
FieldInfo("lock_page",
451
MY_INT64_NUM_DECIMAL_DIGITS,
452
DRIZZLE_TYPE_LONGLONG,
454
MY_I_S_UNSIGNED | MY_I_S_MAYBE_NULL,
467
458
#define IDX_LOCK_REC 8
468
{STRUCT_FLD(field_name, "lock_rec"),
469
STRUCT_FLD(field_length, MY_INT64_NUM_DECIMAL_DIGITS),
470
STRUCT_FLD(field_type, DRIZZLE_TYPE_LONGLONG),
471
STRUCT_FLD(value, 0),
472
STRUCT_FLD(field_flags, MY_I_S_UNSIGNED | MY_I_S_MAYBE_NULL),
473
STRUCT_FLD(old_name, ""),
474
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
459
FieldInfo("lock_rec",
460
MY_INT64_NUM_DECIMAL_DIGITS,
461
DRIZZLE_TYPE_LONGLONG,
463
MY_I_S_UNSIGNED | MY_I_S_MAYBE_NULL,
476
467
#define IDX_LOCK_DATA 9
477
{STRUCT_FLD(field_name, "lock_data"),
478
STRUCT_FLD(field_length, TRX_I_S_LOCK_DATA_MAX_LEN),
479
STRUCT_FLD(field_type, DRIZZLE_TYPE_VARCHAR),
480
STRUCT_FLD(value, 0),
481
STRUCT_FLD(field_flags, MY_I_S_MAYBE_NULL),
482
STRUCT_FLD(old_name, ""),
483
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
468
FieldInfo("lock_data",
469
TRX_I_S_LOCK_DATA_MAX_LEN,
470
DRIZZLE_TYPE_VARCHAR,
488
479
/***********************************************************************
614
605
/* Fields of the dynamic table INFORMATION_SCHEMA.innodb_lock_waits */
615
static ST_FIELD_INFO innodb_lock_waits_fields_info[] =
606
static FieldInfo innodb_lock_waits_fields_info[] =
617
608
#define IDX_REQUESTING_TRX_ID 0
618
{STRUCT_FLD(field_name, "requesting_trx_id"),
619
STRUCT_FLD(field_length, TRX_ID_MAX_LEN + 1),
620
STRUCT_FLD(field_type, DRIZZLE_TYPE_VARCHAR),
621
STRUCT_FLD(value, 0),
622
STRUCT_FLD(field_flags, 0),
623
STRUCT_FLD(old_name, ""),
624
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
609
FieldInfo("requesting_trx_id",
611
DRIZZLE_TYPE_VARCHAR,
626
617
#define IDX_REQUESTED_LOCK_ID 1
627
{STRUCT_FLD(field_name, "requested_lock_id"),
628
STRUCT_FLD(field_length, TRX_I_S_LOCK_ID_MAX_LEN + 1),
629
STRUCT_FLD(field_type, DRIZZLE_TYPE_VARCHAR),
630
STRUCT_FLD(value, 0),
631
STRUCT_FLD(field_flags, 0),
632
STRUCT_FLD(old_name, ""),
633
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
618
FieldInfo("requested_lock_id",
619
TRX_I_S_LOCK_ID_MAX_LEN + 1,
620
DRIZZLE_TYPE_VARCHAR,
635
626
#define IDX_BLOCKING_TRX_ID 2
636
{STRUCT_FLD(field_name, "blocking_trx_id"),
637
STRUCT_FLD(field_length, TRX_ID_MAX_LEN + 1),
638
STRUCT_FLD(field_type, DRIZZLE_TYPE_VARCHAR),
639
STRUCT_FLD(value, 0),
640
STRUCT_FLD(field_flags, 0),
641
STRUCT_FLD(old_name, ""),
642
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
627
FieldInfo("blocking_trx_id",
629
DRIZZLE_TYPE_VARCHAR,
644
635
#define IDX_BLOCKING_LOCK_ID 3
645
{STRUCT_FLD(field_name, "blocking_lock_id"),
646
STRUCT_FLD(field_length, TRX_I_S_LOCK_ID_MAX_LEN + 1),
647
STRUCT_FLD(field_type, DRIZZLE_TYPE_VARCHAR),
648
STRUCT_FLD(value, 0),
649
STRUCT_FLD(field_flags, 0),
650
STRUCT_FLD(old_name, ""),
651
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
636
FieldInfo("blocking_lock_id",
637
TRX_I_S_LOCK_ID_MAX_LEN + 1,
638
DRIZZLE_TYPE_VARCHAR,
656
647
/***********************************************************************
841
832
/* Fields of the dynamic table information_schema.innodb_cmp. */
842
static ST_FIELD_INFO i_s_cmp_fields_info[] =
833
static FieldInfo i_s_cmp_fields_info[] =
844
{STRUCT_FLD(field_name, "page_size"),
845
STRUCT_FLD(field_length, 5),
846
STRUCT_FLD(field_type, DRIZZLE_TYPE_LONG),
847
STRUCT_FLD(value, 0),
848
STRUCT_FLD(field_flags, 0),
849
STRUCT_FLD(old_name, "Compressed Page Size"),
850
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
852
{STRUCT_FLD(field_name, "compress_ops"),
853
STRUCT_FLD(field_length, MY_INT32_NUM_DECIMAL_DIGITS),
854
STRUCT_FLD(field_type, DRIZZLE_TYPE_LONG),
855
STRUCT_FLD(value, 0),
856
STRUCT_FLD(field_flags, 0),
857
STRUCT_FLD(old_name, "Total Number of Compressions"),
858
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
860
{STRUCT_FLD(field_name, "compress_ops_ok"),
861
STRUCT_FLD(field_length, MY_INT32_NUM_DECIMAL_DIGITS),
862
STRUCT_FLD(field_type, DRIZZLE_TYPE_LONG),
863
STRUCT_FLD(value, 0),
864
STRUCT_FLD(field_flags, 0),
865
STRUCT_FLD(old_name, "Total Number of"
866
" Successful Compressions"),
867
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
869
{STRUCT_FLD(field_name, "compress_time"),
870
STRUCT_FLD(field_length, MY_INT32_NUM_DECIMAL_DIGITS),
871
STRUCT_FLD(field_type, DRIZZLE_TYPE_LONG),
872
STRUCT_FLD(value, 0),
873
STRUCT_FLD(field_flags, 0),
874
STRUCT_FLD(old_name, "Total Duration of Compressions,"
876
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
878
{STRUCT_FLD(field_name, "uncompress_ops"),
879
STRUCT_FLD(field_length, MY_INT32_NUM_DECIMAL_DIGITS),
880
STRUCT_FLD(field_type, DRIZZLE_TYPE_LONG),
881
STRUCT_FLD(value, 0),
882
STRUCT_FLD(field_flags, 0),
883
STRUCT_FLD(old_name, "Total Number of Decompressions"),
884
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
886
{STRUCT_FLD(field_name, "uncompress_time"),
887
STRUCT_FLD(field_length, MY_INT32_NUM_DECIMAL_DIGITS),
888
STRUCT_FLD(field_type, DRIZZLE_TYPE_LONG),
889
STRUCT_FLD(value, 0),
890
STRUCT_FLD(field_flags, 0),
891
STRUCT_FLD(old_name, "Total Duration of Decompressions,"
893
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
835
FieldInfo("page_size",
840
"Compressed Page Size",
843
FieldInfo("compress_ops",
844
MY_INT32_NUM_DECIMAL_DIGITS,
848
"Total Number of Compressions",
851
FieldInfo("compress_ops_ok",
852
MY_INT32_NUM_DECIMAL_DIGITS,
856
"Total Number of Successful Compressions",
859
FieldInfo("compress_time",
860
MY_INT32_NUM_DECIMAL_DIGITS,
864
"Total Duration of Compressions in Seconds",
867
FieldInfo("uncompress_ops",
868
MY_INT32_NUM_DECIMAL_DIGITS,
872
"Total Number of Decompressions",
875
FieldInfo("uncompress_time",
876
MY_INT32_NUM_DECIMAL_DIGITS,
880
"Total Duration of Decompressions in Seconds",
1020
1008
/* Fields of the dynamic table information_schema.innodb_cmpmem. */
1021
static ST_FIELD_INFO i_s_cmpmem_fields_info[] =
1009
static FieldInfo i_s_cmpmem_fields_info[] =
1023
{STRUCT_FLD(field_name, "page_size"),
1024
STRUCT_FLD(field_length, 5),
1025
STRUCT_FLD(field_type, DRIZZLE_TYPE_LONG),
1026
STRUCT_FLD(value, 0),
1027
STRUCT_FLD(field_flags, 0),
1028
STRUCT_FLD(old_name, "Buddy Block Size"),
1029
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
1031
{STRUCT_FLD(field_name, "pages_used"),
1032
STRUCT_FLD(field_length, MY_INT32_NUM_DECIMAL_DIGITS),
1033
STRUCT_FLD(field_type, DRIZZLE_TYPE_LONG),
1034
STRUCT_FLD(value, 0),
1035
STRUCT_FLD(field_flags, 0),
1036
STRUCT_FLD(old_name, "Currently in Use"),
1037
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
1039
{STRUCT_FLD(field_name, "pages_free"),
1040
STRUCT_FLD(field_length, MY_INT32_NUM_DECIMAL_DIGITS),
1041
STRUCT_FLD(field_type, DRIZZLE_TYPE_LONG),
1042
STRUCT_FLD(value, 0),
1043
STRUCT_FLD(field_flags, 0),
1044
STRUCT_FLD(old_name, "Currently Available"),
1045
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
1047
{STRUCT_FLD(field_name, "relocation_ops"),
1048
STRUCT_FLD(field_length, MY_INT64_NUM_DECIMAL_DIGITS),
1049
STRUCT_FLD(field_type, DRIZZLE_TYPE_LONGLONG),
1050
STRUCT_FLD(value, 0),
1051
STRUCT_FLD(field_flags, 0),
1052
STRUCT_FLD(old_name, "Total Number of Relocations"),
1053
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
1055
{STRUCT_FLD(field_name, "relocation_time"),
1056
STRUCT_FLD(field_length, MY_INT32_NUM_DECIMAL_DIGITS),
1057
STRUCT_FLD(field_type, DRIZZLE_TYPE_LONG),
1058
STRUCT_FLD(value, 0),
1059
STRUCT_FLD(field_flags, 0),
1060
STRUCT_FLD(old_name, "Total Duration of Relocations,"
1062
STRUCT_FLD(open_method, SKIP_OPEN_TABLE)},
1064
END_OF_ST_FIELD_INFO
1011
FieldInfo("page_size",
1019
FieldInfo("pages_used",
1020
MY_INT32_NUM_DECIMAL_DIGITS,
1027
FieldInfo("pages_free",
1028
MY_INT32_NUM_DECIMAL_DIGITS,
1032
"Currently Available",
1035
FieldInfo("relocation_ops",
1036
MY_INT64_NUM_DECIMAL_DIGITS,
1037
DRIZZLE_TYPE_LONGLONG,
1040
"Total Number of Relocations",
1043
FieldInfo("relocation_time",
1044
MY_INT32_NUM_DECIMAL_DIGITS,
1048
"Total Duration of Relocations, in Seconds",
1067
1054
/***********************************************************************