…. Do you think you can show a program where row-locks are used by one user to lock records for edit/update…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… and effective tool iiBench which has been developed by Tokutek. Though the “1 billion row insert challenge” for which this tool was…_adaptive_flushing_method = estimate innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_max_dirty_pages_pct… every 100 million rows inserted. I noticed that the insert rate drop was mainly caused by IO pressure caused by increase in flushing…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… keep going, making the problem be 10B rows, the cost of querying will go up by another factor of ten (it will… fit. But with all 4 indexes the data itself is 2 or 3 times bigger, and the B-tree nodes are… around 300M or 400M rows, I would expect Inno starts hitting disk. Perhaps you could verify that by watching IOstat. Tim’s…
Comment: Multi Column indexes vs Index Merge
May 10, 2012 By 30 Comments
…2) AND (FileTbl.deactive!=1) AND (LinksTbl2.converted_from_id IS NULL OR LinksTbl2.converted_from_id=0) ORDER BY… 4 rows…
Post: New distribution of random generator for sysbench - Zipf
May 9, 2012 By 3 Comments
… following: say row 1 accessed N, then row 2 is accessed 2^θ less times, row 3 is accessed 3^θ less, …, row X is accessed… times ( for row X: 1/(X^0) ). There is a research that shows that user behavior can be described by this distribution: Zipf, Power-laws, and Pareto – a ranking tutorial To see distribution on graphs, I took tables with 1mln rows…
Post: Percona Server 5.5.22-25.2 released!
April 26, 2012 By Leave a Comment
… announce the release of Percona Server 5.5.22-25.2 on April 25, 2012 (Downloads are available here and from… bug fixes in it, Percona Server 5.5.22-25.2 is now the current stable release in the 5.5….22-25.2 milestone at Launchpad. Bugs Fixed: While running the test case found that MEMORY engine may return rows in non…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 17, 2012 By 11 Comments
Aaron, No particular reasons, it doesn’t matter if you have 4 1G or 2 2GB log files, as they are all concatenated together by InnoDB and written to in a circular fashion.
Post: Testing Fusion-io ioDrive2 Duo
May 10, 2012 By 12 Comments
… I did for other Flash devices. This is ioDrive2 Duo 2.4TB card and it is visible to OS as two… run this card you need to have an external power, by the same reason I mentioned in the previous post: PCIe…
Comment: InnoDB's gap locks
May 7, 2012 By 15 Comments
…@localhost:test 14:33:38>start transaction; Query OK, 0 rows affected (0.00 sec) root@localhost:test 14:35:22…:35:29>select * from t; +——+ | i | +——+ | 21 | | 30 | | 26 | +——+ 3 rows in set (0.00 sec) root@localhost:test 14:51… in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1216, 1 row lock(s) MySQL thread id 31929…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… single process overloads system too much in this case throttling by having relatively short queries and introducing “sleeps” between them can…
