Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 38.1Mb
PDF (A4) - 38.1Mb
PDF (RPM) - 37.3Mb
HTML Download (TGZ) - 10.2Mb
HTML Download (Zip) - 10.3Mb
HTML Download (RPM) - 8.9Mb
Man Pages (TGZ) - 217.0Kb
Man Pages (Zip) - 329.8Kb
Info (Gzip) - 3.5Mb
Info (Zip) - 3.5Mb
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.

The block_instance column provides the NDB kernel block instance number. You can use this to obtain information about specific threads from the threadblocks table.


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