…(32 tables, 10M rows each) and a 4GiB buffer pool. The cache devices were flushed to disk immediately… we examine the impact of a couple of different dirty-page ratios on device performance, since this is… 0 ft_min_word_len = 4 thread_stack = 192K tmp_table_size = 64M serverid = 101 key_buffer_size =…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…normal circumstances. The extra data will not impact performance because it will never be accessed. …2.1G ontime9 212K performance_schema 0 test ICE size on disk: 2.5GB # du -sh …TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…table-name=md_cache_test_small –oltp-table-size=1100000 –mysql-user=msandbox –mysql-password=msandbox –mysql-socket=/tmp…many pages from the disk it pushes out most of the smaller table from the …bound hence such drop in performance. The performance of mysqldump is impacted too because we now have…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… in the join condition and then a hash table lookup is performed, on the hash table we created earlier. This step is known…=4M & mrr_buffer_size=4M Created_tmp_disk_tables 0 0 0 0 0 0 Created_tmp_tables 1 1 1 1 1 1 Handler… impact on MRR performance, and BKA uses the MRR interface, so these buffers indirectly impact BKA performance. I did not find much of a performance…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
….000027 | | creating table | 0.002255 | | After create | 0.000050 | | copy to tmp table | 61.816063 | | rename result table | 0.161528…performance as compared to the default method, because it does not have to do random disk… buffer pool had a huge impact on ALTER TABLE with the optimization disabled,…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
…between its buffer pool and the tablespace on disk. Most seriously, if something should happen and …_checks=0; load data local infile ‘/tmp/my-fifo’ into table load_test fields terminated by ‘\t’ …I/O-bound server and see what the performance impact is, especially on other transactions running at the…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…disk would be the problem. However it is not always the case. There are whole classes of systems where Disk performance…query or 5 hours ALTER TABLE command. Let me also …from performance standpoint without a good reason. Having OS and tmp …BBU on the raid volume impact on transactional log write speed…
