mysql

Calculate MySQL Memory Footprint

This is intended as a quick reference to calculate memory footprint of a mysql server.

  • chefbc

    chefbc

    It's me... It's me... It's me ChefBC!

    More posts by chefbc.

    chefbc

chefbc

•1 min read
Calculate MySQL Memory Footprint

This is intended as a quick reference to calculate memory footprint of a mysql server.

Calcuate MySQL Memory

Total/Maximum RAM

SELECT ( @@key_buffer_size
+ @@query_cache_size
+ @@innodb_buffer_pool_size
+ @@innodb_log_buffer_size
+ @@max_connections * ( @@read_buffer_size
+ @@read_rnd_buffer_size
+ @@sort_buffer_size
+ @@join_buffer_size
+ @@binlog_cache_size
+ @@thread_stack
+ @@tmp_table_size )
) / (1024 * 1024 * 1024) AS MAX_MEMORY_GB;

Parameter Sizes

select @@key_buffer_size / 1024 / 1024 AS key_buffer_size_mb;
select @@query_cache_size;
select @@innodb_buffer_pool_size / 1024 / 1024 / 1024  AS innodb_buffer_pool_size_gb;
select @@innodb_log_buffer_size / 1024 / 1024 AS innodb_log_buffer_size_mb;
select @@max_connections;

select @@read_buffer_size / 1024  AS innodb_log_buffer_size_kb;
select @@read_rnd_buffer_size / 1024  AS read_rnd_buffer_size_kb;
select @@sort_buffer_size / 1024  AS sort_buffer_size_kb;
select @@join_buffer_size / 1024  AS join_buffer_size_kb;
select @@binlog_cache_size  / 1024  AS binlog_cache_size_kb;
select @@thread_stack / 1024  AS thread_stack_kb;
select @@tmp_table_size / 1024 / 1024  AS tmp_table_size_mb;

Links

Links