…to the main point of this article – I wanted to talk in a…how MySQL Query Cache works by removing all queries derived from the table if that table is updated. This technique requires you to… cache with result set for most …put it as separate item as it is quite efficient way to organize things. In…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
…results differences which turned out to be false positives too – thanks to TABLE CHECKSUM mk-upgrade uses by default to check result sets. –compare-results-method rows helped to…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…a richer set of indexes at a…results for some kind of queries, i.e. point select queries, as in this case TokuDB has to…in a release soon. – The ways to do a backup is mysqldump/mysqlhotcopy. It is not fully transparent backup, as it applied TABLE…put into mysql, application performance logs to…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…to fix the buffer pool scalability issue. Let’s see how MySQL performance changes for the last workload if we set…pool scalability in a different way. UPDATE By request from commenter I put also results with different …_cache_size=0 skip-name-resolve table_cache=10000 [mysql] socket=/tmp/mysql.sock…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…a lot of people out where which put it as disk is everything. Remember Paul Tuckfield saying “You should ask how…to insert new data and fetch few rows to show search results which does not require too much IO capacity or high in…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…to matter a lot. Warming up a system so it’s actually responsive can take hours. As a result…in tables on my laptop, I wrote a query against these three sets of stats to find the top tables…
Comment: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 12, 2013 By 7 Comments
…to post about it. I want to test other settings and see how they work, but I can’t put that all in a… and which ones might result in significant (and possibly negative) …tables into the BP. But it doesn’t do those things. In either case, the dimension tables could be placed (or pinned) into a…
Post: Innodb undo segment size and transaction isolation
January 12, 2011 By 3 Comments
…a small record in undo space so row can be deleted on rollback, update and delete however need to put the old row version in…result if you’re dealing with long running transactions consisting of many queries setting isolation mode to…
Comment: How to find wrong indexing with glance view
August 22, 2008 By 27 Comments
…in a test environment. Another tip, turn off caching on your testing environment MySQL that way the queries are re-executed. Cached results…putting much thought into how the data will be retrieved by the database. This allows you to…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…result” typical application would have number of low hanging fruits which are easy to…table structure which may cost you much more to fix at later stage. As time goes many project find them in…how to optimize it another 10-15% may be a great idea. On higher end I’d even look to speak to…
