…to check out MySQL Performance on “Memory Appliance” by … Using 16K read sizes (matches Innodb page size) I could …queries/sec with multiple threads. So Innodb took very high hit supplied with high performance IO subsystem. But not only performance…normal case is to allocate cache memory to buffer pool…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
… size, or something like that. It suddenly caused the query cache to become an enormous bottleneck. The query cache…, I was able to see queries that have mostly very fast performance, and occasionally have much worse,…– and that’s where improvements to the MySQL source code are necessary. But in many…
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
…work with MySQL Performance Optimization and Optimization for other applications the better…query to perform full table scans, with 3 runs and averaged results. MySQL 5.1.21-beta was used for tests. mysql… smaller table (which fits in OS cache): read_buffer_size impace on in memory tableread_buffer_…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
…MySQL is actually badly configured, you can hurt its performance significantly. Correcting these mistakes can correspondingly improve performance… the InnoDB buffer pool size or log file size, and not using InnoDB… include what happens when you have query cache contention, DNS problems, or very slow…
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
…investigation of the fact read_buffer_size variable affects connection speed. This is… user data is expected to be cached on startup but even if it…often together with strace) are great tools for MySQL Performance analyses. Too many people end tuning… LIMIT 10 in full table scan query you well may not…
Post: How Much memory do you use to run MySQL
November 2, 2012 By 8 Comments
… issues with MySQL Server related to amount of memory you have in the system – these range from problems with large size Query Cache to bad drop table performance with large Innodb Buffer Pool size. As such I wonder how…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
… workload was performed with a buffer pool size of 1G, while benchmark on in-memory workload was performed with a buffer pool size of…_DIRECT query_cache_size=0 query_cache_type=0 MySQL 5.6.5 Configuration innodb_file_per_table=1 innodb_file_format=barracuda innodb_log_file_size…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
…) with a Scale Factor of 2 (InnoDB dataset size ~5G). Note that query cache is disabled during these benchmark runs and that the… that, just increasing the join_buffer_size is not going to provide the best possible query performance. As I mentioned at the start… or MySQL, but you need to appropriately increase read_rnd_buffer_size/mrr_buffer_size because these have an impact on MRR performance, and…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…performance sort_buffer_size = 8M read_buffer_size = 2M query_prealloc_size = 65536 read_rnd_buffer_size = 8M table_open_cache = 1024 thread_cache_size = 8 query_cache_size = 128M join_buffer_size…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…MySQL interactive performance – serving simple standard web traffic is drastically impacted when some heavy queries…
