… configured MySQL to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount of connections but yet MySQL takes… might look at how it uses MySQL to identify potential causes. Is it working with large blobs ? Using user variables ? Prepared Statements…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…buffers which are allocated at start and always where – these are key_buffer_size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer…run MySQL server out of memory MyISAM buffers. MyISAM may allocate buffer …result sets from remove queries. Blobs may require 3x time of…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
…Interview for people to work as MySQL DBAs or be involved with MySQL Performance in some way …key_buffer_size even with large data set but it will crawl with default innodb_buffer_pool_size. Also Innodb buffer… have update activity spikes however or work with blobs a lot you might want to increase it…
Comment: How to calculate a good InnoDB log file size
June 1, 2010 By 33 Comments
…mysql/ innodb_buffer_pool_size = 2048M innodb_additional_mem_pool_size = 20M innodb_log_file_size = 512M innodb_log_files_in_group = 2 innodb_log_buffer_size = 8M innodb… InnoDB: which exceeds the log group capacity 9433498. InnoDB: If you are using big BLOB or TEXT rows, you must set the InnoDB: …
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… so it would not swap out MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb_buffer_pool_size 70-80% of… looking for more details, check out detailed guide on tuning innodb buffer pool innodb_log_file_size – This depends on your recovery speed… and good performance innodb_log_buffer_size=4M 4M is good for most cases unless you’re piping large blobs to Innodb in this…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… than 8100 bytes InnoDB will not allocate additional space for blobs, even if each blob is larger than 768. 2. InnoDB will allocate additional… swap out not buffer pool but some other important parts of MySQL process. Q20: We’ve migrated to using INNODB so that it… tablespace when an InnoDB instance is created. PZ: Sequential “dump” of buffer pool would need more optimizations to work – Innodb would also need…
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
… – which are offsets for MyISAM and primary key values for Innodb or storing full data which is being retrieved (good for… be converted to fixed size (basically everything but BLOB/TEXT) MySQL can use read_rnd_buffer to optimize data retrieval – As data is… physical) order. MySQL takes bunch of pointers from sort_buffer (just enough so all rows fit in read_rnd_buffer as they are…
Post: Percona Server 5.1.50-rel12.1
October 14, 2010 By 2 Comments
… on MySQL 5.1.50. New Features Added: innodb_lru_dump_restore – Implemented automatic dumping of the buffer pool at specified intervals. innodb_buffer_pool… end-of-line in BLOB fields in the MySQL client. (Sasha Pachev) Bug #640924 – Fixed a crash caused by innodb_doublewrite_file. (Yasufumi…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… keep max_prepared_stmt_count very low. Prepared Statements and Blob Data If you’re want to get memory consumed by… them using mysql_stmt_send_long_data call – Server buffers such data until you have executed prepared statement. Innodb Table Cache Leak – Innodb never shrinks its internal table cache (data dictionary) so by creating and accessing large amount of Innodb tables…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…been implemented outside of MySQL Storage Engine level for MySQL – reading rows in …recoverable stage. This is why Innodb has “innodb double write buffer“. Jim does not …Blob handling optimizations Jim loves BLOBs as his own child, so Falcon is optimized in Blob handling for example having direct blob…
