… bigger than stripe element; second – logs are actually written in 512 byte units (in Percona Server 5.1 and … than 4k (page size) on Linux unless you are using HugePages). Some file systems let you set stripe …see what are real life effects of misalignment, my benchmark results are in the second part…
Post: Percona testing: Quick test clusters with kewpie!
January 13, 2012 By Leave a Comment
…kewpie in-tree soon) cd basedir; bzr branch lp:kewpie edit the file kewpie.py like so: === modified file….5.17 20120113-125552 INFO server_compile_os: Linux 20120113-125552 INFO server_platform: x86_64 …MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 5.5.17-log…
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
…, no keying time), it uses MySQL C API and the server… patches contribute to the improvements in this case. split_buf_…Linux and makes the threads to be used equally for parallel using. By default InnoDB uses 1 insert buffer thread, 1 log… sense. * This test uses “innodb_file_io_threads = 34″ (But, it…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… of the pages in the extent have been accessed, and in an ascending order of the file address, then… works – it is global MySQL Server option, though it may have problems on Linux if you lock very… binary logging to get Group Commit back. Though this is often not the option. Here are some benchmarks…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…defaults_changes_in_mysql , in documentation now at http://dev.mysql….size to allocate on Linux. People with OLTP workloads …be optimal until full benchmarking to determine perfect size …in the server defaults but in the default my.cnf file… information in the binary log when using row-based logging. …
