…played with queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting …-Range-Read feature which allows to read data not row-by-row but in batches reads. So let us see ….40 and then rkB/s was continuously dropped to Device: rrqm/s wrqm/s r/s w/s rsec/…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…in the first terabyte of the device which seems to have affected the…MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have been running these benchmarks…rows used was 20M, transactions were not used (autocommit), number of threads – 1, 4, 8, 16 and 32. Benchmark…
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
…documentation writers and do more benchmarks and performance research. I …MySQL 5.1.21-beta was used for tests. mysql> select count(*) from dt2 where slack like “a%”; +———-+ | count(*) | +———-+ | 4705992 | +———-+ 1 row…multiple ones submitting them to device which slows things down …
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 28 Comments
… scan through lots of obsolete, but not-yet-purged, row versions. Later, the purge thread will have to clean… other terminal: while [ -e /tmp/my-fifo ]; do time mysql -e “set foreign_key_checks=0; set sql_log… think to use iostat to see how much the device was actually used, so this isn’t a scientific…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… benchmark to be sure. In Innodb besides scalability changes in later 5.0 series compact row…restarts. When putting log files on such device could give great logging performance because you…buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries…
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
…scale-out solution has traditionally been popular for MySQL, it’s interesting to see what room we … instead, and use the storage device for writes. Here’s the benchmark I came up with to confirm ….1 release Sysbench OLTP workload with 80 million rows (about 18GB worth of data+indexes) XFS Filesystem …
