…allocated (and how much memory they use). Memory Tables MEMORY tables can take memory. There are implicit MEMORY tables which are allocated…much memory is being used by current MEMORY tables: mysql> select sum(data_length+index_length) from information_schema.tables where engine=’memory…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… down for a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in… its master. The server is allocating too much memory. A runaway server process, or poorly optimized queries, can consume too much memory and cause the server to…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… is to get enough memory allocated to get to address space limit and MySQL will crash when one of internal memory allocations would unexpectedly fail… unable to run their queries. Stored Procedures – How much memory can stored procedure allocate ? say can you create 1000 variables in stored procedure… there is some global quotas so it can’t consume too much memory and also you can’t get all of it consumed…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
… MySQL Server so it uses too small amount of memory it will likey perform suboptimally. If you however configure it so it consumes too much memory… “ps aux” to see VSZ – Virtual Memory allocated by MySQL process. You can also look at “Resident Memory” but I find it less helpful… global memory allocations which are not tuned as buffers. Watch for these especially now with many storage engines being released for MySQL by…
Post: Wanted: Better memory profiling for MySQL
May 18, 2008 By 4 Comments
…MySQL using too much memory. I would look at memory consumed by Innodb (it is often higher than innodb_buffer_pool_size) substract memory…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done…are considerably larger than amount of memory in box so full table scan…allocation for rather large tables. For 10000 tables we had just 1000 of 4K rows in the table which caused too much space allocated…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… question during Interview for people to work as MySQL DBAs or be involved with MySQL Performance in some way is to ask… for memory available. innodb_additional_mem_pool_size This one does not really affect performance too much, at least on OS with decent memory allocators. Still you might want to have it 20MB (sometimes larger) so you can see how much memory Innodb allocates for misc…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… stack, etc)? Those take memory too. The query cache can… sort buffers to be allocated. You can’t control…OK, 0 rows affected (2.34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock(@a…much, in my opinion. I think it’s far better to use a monitoring tool to watch the actual memory…
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
…up in the PROCESSLIST or will not take too much combined time in the logs to attract your…(“a”,1000000); select sleep(1); … Causes MySQL to “leak” 1MB of memory per second with no apparent good …LIST and you can’t really track how much memory was allocated for given session (or restrict this number)…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… Valgrind does not need much introduction, especially to the MySQL server developers. The Valgrind… a block of size 800000 alloc‘d ==9090== at 0x4C28FDF: malloc (… the benign and minor cases too–if only to declare an … and using MySQL 5.5 atomic operation primitives with proper memory barriers, so …
