…memory and there is very little load. I see that mysqld is using 10g of memory with 17g virtual size…so it’s hard to read. If the InnoDB buffer pool is set … The error log shows all sorts of interesting things. Basically, anything… users in the mysql.* tables, running mk-duplicate-key-checker to find …
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… size you need to check if there are any restrictions on Innodb Buffer Size…MySQL buffers – query cache, key_buffer, mysql threads, temporary tables, per thread sort buffer which can be allocated. There are also things like innodb additional memory… OS will need to do reads to serve writes to these …
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
…Buffers, Indexes and Joins. Buffers First thing you need to take into account is the fact – situation when data fits in memory…memory data size and expect gradual performance decrease as database size…are also clustered keys in Innodb … – MySQL can’t do hash join or sort…of random row reads, which gives…
Comment: Returning to InnoDB scalability
August 7, 2006 By 42 Comments
…innodb_thread_concurrency=20 innodb_buffer_pool_size=3G =================================================== =================MySQL error log=================== 060804 20:56:56… use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 2591766 K bytes of memory Hope that’s ok…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
… /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size = … that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 329809 K bytes of memory Hope that’s ok; if not, …
Comment: How well does your table fits in innodb buffer pool ?
December 9, 2010 By 12 Comments
… possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 9249947 K bytes of memory Hope that’s ok; if not, decrease… Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you…
Post: Impact of memory allocators on MySQL performance
July 5, 2012 By 11 Comments
… several memory allocators on the performance/scalability of MySQL server in the read-… data / CPU bound case innodb_buffer_pool_size=52G For every malloc allocator … size of mysqld warmup with ‘select avg(id) from sbtest$i FORCE KEY…|never) and gathered mysqld size with ‘ps –sort=-rss -eopid,rss,vsz,…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…memory workload was performed with a buffer pool size of 6G. The benchmarks compare Block Nested Loop (BNL) Join of MySQL…based=off’ read_rnd_buffer_size=32M optimizer_switch=’batched_key_access=on’ join_buffer_size=32M…=’mrr_sort_keys=on’ optimizer_switch=’mrr_cost_based=off’ mrr_buffer_size=32M…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…sorted indexes with Innodb (with index built by sort…read, typically 1MB in size. I should also mention a post on this topic once. Q12: If read…memory the kernel can decide (incorrectly) to swap out MySQL…memory. There is also third alternative – “huge pages” which can be used for buffer…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…size, but size range This is minor one. Unlike you would typically see Falcon uses minimum and maximum sizes…reading index first (possibly many indexes) and only then reading row data in sorted…MySQL Storage Engine level for MySQL – reading… Key or any other key… Write Buffer was … enough memory to hold…
