…constantly referring to the amazing MySQL manual, especially the option and variable reference table. … Questionsblogpercona.commanual rand_seed1blogpercona.commanual rand_seed2blogpercona.commanual range_alloc_block_sizeblogpercona.commanual read_buffer_sizeblogpercona.commanual read_onlyblogpercona…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…you have to specify compressed block size, this is the size to which you expect each …IO Bound Index scans and large range scans. We surely should benchmark this…all of them need autoincrement value allocated, some may already have values specified…which may come in MySQL 5.2 or even MySQL 5.1. I …
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…other. Calls require memory allocation and especially stack memory allocations. There are some …size which is controlled by max_allowed_packet. However some MySQL optimizations such as equity propagation and range…resource usage. Host Block You can have given client host blocked from accessing …
Post: FusionIO 320GB MLC benchmarks
January 11, 2010 By 19 Comments
… runs on 100% space allocated card and on 75% space allocated (240GB of available … tried 100GB filesize in this configuration. Block size is 16KB in all cases. The… it is < 1ms (in hundreds microseconds range) Sequential writes still behave strange, …numbers, I am going to benchmark MySQL with …
Post: Beware: ext3 and sync-binlog do not play well together
January 21, 2009 By 19 Comments
…ranges=0 –oltp-order-ranges=0 –oltp-sum-ranges=0 –oltp-simple-ranges=0 –oltp-point-selects=0 –oltp-range-size=0 –mysql-table-engine=innodb –mysql…repeated the run on the in memory block device and got very similar results – … this is because Innodb log is pre-allocated so there is not need to …
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…size of 6G. The benchmarks compare Block Nested Loop (BNL) Join of MySQL 5.5.24, Batched Key Access (BKA) Join of MySQL…size‘ controls the size of the join buffer allocated for each join in a query, MariaDB introduces another variable to control the size…
