…to global memory allocation and will result in increased memory allocation until server is restarted. I would suspect memory leak when you see memory…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…mysql client), you would execute whatever steps you think are necessary to increase memory usage/trigger the memory problem. You could also just leave the server running for some time (for example, if you have experienced memory increase…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…to it number of memory Operation System and other applications need, add might be 32MB more for MySQL Server code and various small static buffers…memory consumption is often less than 1MB per thread with default buffers, and you really do not need to increase per thread buffers…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…to the query times for MySQL 5.6, when the workload fits entirely in memory, because there is no extra cost for memory…buffering step introduced by MRR, and hence, there is a slight increase in query time for MySQL 5.6, increase…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
…for people to work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL…to increase sort_buffer_size even if you have 64GB of memory to…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…to increase innodb_buffer_pool_size to 50% of my RAM, and then when I tested MyISAM FT index, I reallocated that memory to into key_buffer…for different application types. There are books that describe how to use one technology or the other, and some may compare one technology to…
Post: Impact of memory allocators on MySQL performance
July 5, 2012 By 11 Comments
…memory allocator is quite important for the proper utilization of CPU/RAM resources. Efficient memory allocator should help to improve scalability, increase throughput and keep memory…MySQL so i decided to include old one to comparison as well. I used glibc-2.13 for…_buffer_pool_size=52G For… see how …
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…buffer will not be able to be used, which can be important for…increase its length dramatically, for example adding long varchar column. In such cases it indeed might be better to…memory anymore. How does this affect performance? A: Typically you do not need all your indexes to be in memory…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
…how effective are the join optimizations when the workload fits entirely in memory. For the purpose of benchmarking in-memory workload, the InnoDB buffer…to MySQL 5.5 While with join_buffer_size set to 6M and read_rnd_buffer_size set to 6M, the query time for MySQL…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… to increase size of your Innodb log files to be able to use a lot of memory for write buffering…memories, and noticed that random writes to them are actually slower than to a mechanical disk. I do not know how it is for… a dedicated server for Mysql you will still need some memory for the OS and the…
