… in 2 standard InnoDB pages (16KB in size) as long as they are aligned properly. In first…controller for that same operation. In practice stripes by default are bigger in size – I would …element. In addition to setting correct options for pvcreate it is also a good idea to use appropriate Volume Group…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…which are used by default) have to live in the first terabyte of the …, not different MySQL configurations, I didn’t try out different MySQL versions or …log_file_size = 64M innodb_log_files_in_group = 2 innodb_read_io_threads = … beginning of the stripe element. 3. 1M alignment in partition table but …
Post: Using Sphinx as MySQL data retrieval accelerator
October 30, 2006 By 25 Comments
…group etc) and get sorted result set and claiming it is way faster than getting it with MySQL… of 200.000.000 collection (200GB) completed in 0.7 second. This is system we…plus there would be an option to retrieve by filters only with no full text query…. queue could be used if only few first elements …
