…key_buffer_size=32M # Only for MyISAM which isnt used. sort_buffer_size=2M query_cache_size=10M # Might be increased thread_cache_size=40 table_cache=512 # Default 64 was used before. skip-locking innodb…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…_cache = 1024 thread_cache_size = 8 query_cache_size = 128M join_buffer_size = 8M long_query_time=300 key_buffer_size = 500M concurrent_insert=2 myisam_sort_buffer_size = 64M # innodb innodb_additional_mem_pool_size=32M innodb…_cache = 1024 thread_cache_size = 8 query_cache_size = 128M join_buffer_size = 8M long_query_time=300 key_buffer_size = 500M concurrent_insert=2 myisam_sort_buffer_size = 64M # innodb innodb_additional_mem_pool_size=32M innodb…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…9697561, query id 188161264 localhost root update insert into child values(2,2) Foreign key …if your innodb_log_buffer_size is optimal – if you see more than 30% of log buffer size being…to OS cache, and being sequential writes these logs writes are pretty fast. ———————- BUFFER POOL AND …
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… OK with default key_buffer_size even with large data set but it will crawl with default innodb_buffer_pool_size. Also Innodb buffer pool caches both data and… in normal operation. query_cache_size If your application is read intensive and you do not have application level caches this can be great…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… look at global 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_size, query_cache_size. If you’re using MyISAM seriously you can also add the size of Operation System cache…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
…innodb_write_io_threads = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer pool is sized…
Comment: Choosing innodb_buffer_pool_size
November 25, 2010 By 39 Comments
…key_buffer_size = 192 M Key cache miss rate is 1 : 63 Key buffer free ratio = 74 % Your key_buffer_size seems to be fine QUERY CACHE Query cache is enabled Current query_cache_size…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…Cache with good results. I just wrote the post on this this matter the other day – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries… order of the PRIMARY KEY, then InnoDB should have placed …
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…InnoDB: libexec/mysqld –no-defaults –user=root –key-buffer-size=1500M –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread-concurrency=8 –max-connections=1500 –table-cache…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…query-time=5 log-slow-queries=/apps/log/slow-query interactive_timeout=300 wait_timeout=300 thread_cache = 40 max_connections=500 query_cache_size…
