… Report ############################## Platform | Linux Release | Ubuntu 10…MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have been running these benchmarks…log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files_in…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
…MySQL 5.1.30 with InnoDB-plugin-1.0.2 and MySQL 5.1.30 with XtraDB (all plugins statically compiled in MySQL) For benchmarks…flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_file_size = 256M innodb_log_files_in_group… it is important to remember as Linux kernels 2.6.18+ (which are …
Post: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
…coming by default in RedHat / CentOS 5.x may be not so good for MySQL. And yesterday …is graph of disk writes (column bo in vmstat) during benchmark As you see noop / deadline can …file_per_table=1 innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file…
Post: Disaster: LVM Performance in Snapshot Mode
February 5, 2009 By 55 Comments
… performance in this case – it is not something MySQL related. I… executes quite special path in Linux kernel so I did couple… again (ie innodb circular logs) – in this case the overhead will…benchmarks – for example I’m very curios how good is read speed from snapshot (in particular sequential file…
Post: Impact of the sort buffer size in MySQL
October 25, 2010 By 8 Comments
…the file cache before the benchmark by doing “alter table sorttest engine=myisam;”. The script used for the benchmark is the following: #!/bin/bash for i in `seq 1 1000` do START=`date +%s.%N` OUT=`mysql -…39:35 UTC 2010 i686 GNU/Linux MySQL: 5.1.41-3ubuntu12.6-log P.S.: Gnumerics for graphs…
Comment: Linux schedulers in tpcc like benchmark
January 31, 2009 By 19 Comments
…MySQL using O_DIRECT to move data from sequentially written log files to the more write-costly spreaded/random innodb data file…the innodb log file in the …Linux got a lot of refining in order to expose and enforce I/O priorities and arbitration. I’m not sure whether MySQL…for such benchmarks, if…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… the most important facts about the execution in the log file. # QC_Hit: No Full_scan: No …benchmarks and real database traffic, it’s considered experimental and as such I don’t recommend using it in production or on any important system! The patch is available for MySQL Community 5.0.45 on Linux…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…. So benchmark to be sure. In Innodb besides scalability changes in later 5….file in a log file group. My questions are: What is always being written to the first file in the log file…mysql processes drops rapidly when you increase the amount of system memory. We just deployed a new Linux/Mysql…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
… 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…
