…MEMORY tables you can create both as permanent and temporary. There is a max…MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…For example, if a database isn’t owned by MySQL, you won’t have any problems until… allocating too much memory. A runaway server process, or poorly optimized queries, can consume too much memory…your application environment makes it difficult to handle max_connections problems (the use of fixed-size …
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… parse tree inside MySQL which of course depends on query size which is controlled by max_allowed_packet. However some MySQL optimizations such as…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
… they estimate memory consumption by MySQL Server in given configuration. What is the formula they could use. The reasons to worry about memory usage… “ps aux” to see VSZ – Virtual Memory allocated by MySQL process. You can also look at “Resident Memory” but I find it less helpful as… sort_buffer_size from 1MB to 4MB and 1000 max_connections increases peak memory consumption just 30MB not 3000MB as you might…
Post: InnoDB memory allocation, ulimit, and OpenSUSE
August 23, 2010 By 7 Comments
… in the code (InnoDB code actually has very good comments), max_size is the maximum number of buffer pool pages (16K…. I tested it with allocating 70 GB concurrently in each process so as to overrun physical memory + swap. Both allocations were successful, one initialized successfully, the other was killed by the OOM kill during…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…_mem_pool_size, by the way. If it needs more it will allocate it. innodb_additional_…– they use memory too. And they can be really big (but no bigger than max_allowed_packet). … 100); Query OK, 0 rows affected (2.34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock(@a, 1) | …
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…SpecJAppServer Benchmarks several years ago while being employed by MySQL. These are great results, plus they can …indeed better to have smaller sort buffer because allocating it will likely be faster. query_cache_size = … max_heap_table_size=200M – I’m not sure why is it set. Are any explicit MEMORY …
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…some tables in MyISAM format in “mysql” database. Plus HEAP/MEMORY tables are used for temporary tables …this option is used for MyISAM and MEMORY tables. max_write_lock_count Variable which may save …_buffer_size Buffer used to sort result set (allocated by each thread once sorting needs to be done…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…allocate a lot of memory… by line, like this: +———————————–+———————-+———————-+ | Variable_name …mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max…
Post: MySQL Prepared Statements
August 2, 2006 By 19 Comments
… extra performance can you get by using prepared statements ? Results can … is no statement cache – You can allocate multiple copies of same prepared…close prepared statements – Many memory leaks reported in MySQL Server turned out to… diretly. You can also adjust max_prepared_stmt_count variable which…
