… to worry about memory usage are quite understandable. If you configure MySQL Server so it uses too small amount of memory it will likey… to do with real memory consumptions. In fact typical server with 8GB of memory will often run with maximum theoretical memory usage of 100GB or…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… “what’s the formula to compute mysqld’s worst-case maximum memory usage?” Various formulas are in wide use, but none of them… * 1024 * 100); Query OK, 0 rows affected (2.34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock(@a, 1) | +—————–+ | 1… point is there simply is no formula to compute the maximum possible memory usage, and there cannot be because there are some things…
