…100); Query OK, 0 rows affected (2.34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock(@a, 1) |…no formula to compute the maximum possible memory usage, and there cannot be because there are… usually calculate the Big Ones like the buffer pool, query cache etc; leave some memory for …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… MONITOR OUTPUT ===================================== Per second averages calculated from the last …442 mysql tables in use 1, locked 0 MySQL thread…memory usage. You can see total memory allocated by Innodb (sometimes it is higher than you anticipated), amount of memory allocated in additional memory…
Post: MySQL caching methods and tips
April 4, 2011 By 5 Comments
…MySQL. Popular cache methods The MySQL query cache When the query cache is enabled, MySQL… them into the cache. Additionally, memory pressure may cause unexpected invalidation … example, suppose we need to calculate the total count of items …bottlenecks: disk IO and CPU usage. Disk IO is expensive, and…
Comment: Neat tricks for the MySQL command-line pager
June 23, 2008 By 13 Comments
Cool tricks. My most frequent usage of “pager” is “vim -” and then manipulate the output at … to calculate how much memory to allocate for a buffer). $ cat index_size.sh perl -lane ‘$i+= $F[17];END{print $i}’ mysql> pager ./index_size.sh PAGER set to ‘./index_size.sh’ mysql> show table status; 71680 mysql> nopager Giuseppe
