… gradually recover by populating cache – if because of cache misses performance is so bad the speed of populating cache with new items is lower than speed with which items expire due to timeout you may never get a system warmed… and suffering from bad response time can be done by script… which does not care.
Post: XtraDB feature: save / restore buffer pool
January 20, 2010 By 20 Comments
… because the slave need to catchup with master and to warm cache. In case with the server crash, it is even worse… see InnoDB recovery took 1h to accomplish) and after that warm caches. Second, it is useful for some HA schemas, like DRBD… will be performed in most sequential way. The small python script lrusort.py to sort ib_lru_dump is available in…
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: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…to test wide range tables and queries. The script and instruction are available here: http://www…._record_memory=2GB –falcon_page_cache_size=1500M –max-connections=1500 –table-cache=512 –net_read_timeout=30… concurrent threads. 3. For each thread perform a warm-up run (duration 180 sec), and then …
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… I used new sysbench with Lua scripting language, so all queries were scripted for sysbench. New sysbench you… Processor 2210 stepping : 2 cpu MHz : 1800.163 cache size : 1024 KB 4GB of RAM MySQL version… 512 concurrent threads. 3. For each thread perform a warm-up run (duration 180 sec), and then run…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
…). If this becomes the problem I use tiny script which moves out all MyISAM tables out of … server its caches (key_buffer, innodb_buffer_pool, query_cache,table_cache) are cleaned, so may be OS caches. This… others) and gradually increase the load as server warms up. This may sound strange but makes a…
Post: Impact of the sort buffer size in MySQL
October 25, 2010 By 8 Comments
… CHARSET=latin1 and I inserted 100k rows with this simple script: #!/bin/bash NUMROW=100000 COUNT=0 while [ “$NUMROW” -gt “$COUNT… query cache disabled. I also verified that during the whole process, the computer never swapped and I pre-warmed the file cache before the benchmark by doing “alter table sorttest engine=myisam;”. The script used for the…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… fact removing slave read traffic from non warmed up slave will often cause warmup to … on different boxes might be different and hence cache content. Replication Traffic Changes Changing in the … replication traffic. An interesting thing to note – scripts can hurt replication traffic well after they …
