…get group commit again. HT: I do not think so. Sergei Golubchik serialized the MySQL binlog write and the InnoDB log flush with a mutex in…of a foreign key constraint need not form a primary key or a unique constraint: it is sufficient if the referenced columns form a consecutive set of…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…the results that you do in iiBench test ( Graph 2), and the number of…rows/sec – about 10.6x faster. One consequence of having such fast indexes, is that you can maintain a richer set of indexes at a…in a future release. With all the given advantages and drawbacks, I see a good practical usage of…
Post: Eventual Consistency in MySQL
November 18, 2011 By 8 Comments
…A IS NULL; If the result set of this query is empty, then there are no orphaned rows. But there are probably hundreds of foreign key relationships in…a non-empty result set, it shows us which rows in Bar are orphans. mysql> INSERT INTO Foo (A,B) VALUES (111,2222), (333,444); mysql…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
…a diff tool for MySQL to see what is different in the tables. It turned out one of the float columns stored “-0″ in MySQL…positives too – thanks to TABLE CHECKSUM mk-upgrade uses by default to check result sets. –compare-results-method rows…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…in a while so be careful with my results and forgiving to my mistakes The environment Here is the summary of the…MySQL versions or settings. Moreover, I have been running these benchmarks for a customer so I just used the setting…
Post: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 93 Comments
… get result set…the country, ie Slovenia – same kind of search might need to scan 1000s times more rows to provide result set. In the…result set. For example: key(a,b,c) SELECT * FROM tbl WHERE c=5 ORDER BY a,b limit 10 – In…position (as long as it is indexed) Force index if needed In some cases MySQL…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…the reorganization run in a tolerable time? PZ: Indeed using master-master setup and switching roles is a good way to get large data manageable. MySQL…
Comment: Countless storage engines
May 4, 2007 By 6 Comments
…MySQL official marketing never position MySQL as such per say (for obvious reasons) but it is indeed set as replacement for Innodb in…the last thing you want is loosing your data – it is worse than crashes or wrong query results…
Post: Looking at Redis
August 27, 2009 By 27 Comments
…MySQL as you do not need to deal with snapshot or binary log position…the commands on the data since the start of the process. Slave can get the data (which is basically set of commands to populate database itself) and when get the…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
…rows than it needs to requires look at the queries and schema. Ok Let us new get to back to main point of the article. In…in the parallel to normal read operations issued by the thread and so can result in multiple outstanding requests to the…
