Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 37.7Mb
PDF (A4) - 37.7Mb
PDF (RPM) - 37.0Mb
HTML Download (TGZ) - 10.2Mb
HTML Download (Zip) - 10.3Mb
HTML Download (RPM) - 8.9Mb
Man Pages (TGZ) - 214.8Kb
Man Pages (Zip) - 327.7Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

21.5.10.27 The ndbinfo memory_per_fragment Table

The memory_per_fragment table provides information about the usage of memory by indidivual fragments.

The following table provides information about the columns in the memory_per_fragment table. For each column, the table shows the name, data type, and a brief description. Additional information can be found in the notes following the table.

Column NameTypeDescription
fq_namestringName of this fragment
parent_fq_namestringName of this fragment's parent
typestringType of object; see text for possible values
table_idintegerTable ID for this table
node_idintegerNode ID for this node
block_instanceintegerKernel block instance ID
fragment_numintegerFragment ID (number)
fixed_elem_alloc_bytesintegerNumber of bytes allocated for fixed-sized elements
fixed_elem_free_bytesintegerFree bytes remaining in pages allocated to fixed-size elements
fixed_elem_size_bytesintegerLength of each fixed-size element in bytes
fixed_elem_countintegerNumber of fixed-size elements
fixed_elem_free_countdecimalNumber of free rows for fixed-size elements
var_elem_alloc_bytesintegerNumber of bytes allocated for variable-size elements
var_elem_free_bytesintegerFree bytes remaining in pages allocated to variable-size elements
var_elem_countintegerNumber of variable-size elements
hash_index_alloc_bytesintegerNumber of bytes allocated to hash indexes

The type column from this table shows the dictionary object type used for this fragment (Object::Type, in the NDB API), and can take any one of the values shown in the following list:

  • System table

  • User table

  • Unique hash index

  • Hash index

  • Unique ordered index

  • Ordered index

  • Hash index trigger

  • Subscription trigger

  • Read only constraint

  • Index trigger

  • Reorganize trigger

  • Tablespace

  • Log file group

  • Data file

  • Undo file

  • Hash map

  • Foreign key definition

  • Foreign key parent trigger

  • Foreign key child trigger

  • Schema transaction

You can also obtain this list by executing SELECT * FROM ndbinfo.dict_obj_types in the mysql client.


User Comments
Sign Up Login You must be logged in to post a comment.