… /bench/mysqldata xtrabackup: Target instance is assumed as followings. xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…-engine’ ‘–with-example-storage-engine’ ‘–with-federated-storage-engine’ ‘–without-bench‘ ‘–with-zlib-dir=bundled’ ‘–with-big-tables’ ‘–enable-assembler’ ‘–enable… with InnoDB extensions msl patch for MySQL 5.0.51a with InnoDB extensions msl patch for MySQL 5.0.54a with InnoDB extensions…
Comment: Interesting MySQL and PostgreSQL Benchmarks
December 4, 2006 By 20 Comments
… on linux and we had to learn solaris for these benches, with that those sun’s were a great help. They…) commited some changes to the Studio10 compiler that should increase innodb and mysql performance on solaris even more, but that was… same for all platforms, and if you do io-bound benches you are testing your io-system, and not the CPU…
Comment: Choosing innodb_buffer_pool_size
September 19, 2010 By 39 Comments
… hiring more memory and allocating to innodb_buffer_pool_size). Of course we can do bench marking to know when something is… the buffer and cost of memory. Less importantly, when the innodb_buffer_pool_size is grossly increased (ie 100 times) is… I can find is that innodb_log_file_size should be increased to about 25% of innodb_buffer_pool_size. Thanks again…
Comment: Linux schedulers in tpcc like benchmark
January 31, 2009 By 19 Comments
… written log files to the more write-costly spreaded/random innodb data file. Whatever, I stand corrected now, thank you 
You… fill the BBU cache, the I/O queue and the innodb log file in the background may not be the expected… even less about how it’s used here): does this bench really spreads writes to emulate some randomness (wrt block device…
Comment: Percona XtraDB Cluster reference architecture with HaProxy
August 11, 2012 By 63 Comments
… use the sys bench tests… sysbench –test=oltp –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127…
Comment: What's required to tune MySQL?
July 27, 2011 By 4 Comments
I must 100% agree to Baron, few months ago I did “tuning” and bench-marked results. Configuring my.conf for InnoDB 70% read workload gave me only 5-7% improvements of query response times.
Comment: 5.0.75-build12 Percona binaries
January 26, 2009 By 18 Comments
…-server’ ‘–with-innodb‘ ‘–with-csv-storage-engine’ ‘–with-archive-storage-engine’ ‘–with-blackhole-storage-engine’ ‘–with-federated-storage-engine’ ‘–without-bench‘ ‘–with…
