Skip to content

Instantly share code, notes, and snippets.

@redneurocom

redneurocom/gist:5a0535ea58c92401611c36f9ec2f2a15

Created August 14, 2018 23:11
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save redneurocom/5a0535ea58c92401611c36f9ec2f2a15 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save redneurocom/5a0535ea58c92401611c36f9ec2f2a15 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. redneurocom created this gist Aug 14, 2018.
    7 changes: 7 additions & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,7 @@
    SELECT (PagesData*PageSize)/POWER(1024,3) DataGB FROM
    (SELECT variable_value PagesData
    FROM information_schema.global_status
    WHERE variable_name='Innodb_buffer_pool_pages_data') A,
    (SELECT variable_value PageSize
    FROM information_schema.global_status
    WHERE variable_name='Innodb_page_size') B;