…install Percona-XtraDB-Cluster-server Percona-XtraDB-Cluster-client percona-xtrabackup Install haproxy and sysbench on the client node. # yum -y install haproxy sysbench After installing…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… vs MySQL 5.5 & the Star Schema Benchmark[/caption] So far most of the benchmarks posted about MySQL 5.6 use the sysbench OLTP workload. I wanted to test a set of queries which, unlike sysbench, utilize joins…. I compiled both servers from source (cmake -gui .; make; make install) Only changes from defaults was that both servers are compiled…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… a stock install of MySQL, here are some example queries and the corresponding number of concurrency tickets used for each: mysql> CREATE TABLE… larger to accommodate the larger (important) select statements. A quick sysbench run gives us the following results (X-axis is innodb… really expect to see much of a difference here: Details: sysbench –test=oltp –oltp-table-size=80000000 –oltp-read-only=off…
Post: Group commit and real fsync
May 3, 2006 By 9 Comments
…problem is – new feature – XA was implemented in MySQL 5.0 which did not work with former…. This can be done for example by using SysBench: sysbench –test=fileio –file-fsync-freq=1 –file-num=… which does some extra tests for fsync() correctness. Install RAID with battery backed up cache. This gives…
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
…-out solution has traditionally been popular for MySQL, it’s interesting to see what room we… slots already filled?) Does your budget allow to install SSD cards? (You may still need more than …This graph and these results are valid only for sysbench uniform. In your particular workload the points B…
Post: HandlerSocket on SSD
November 2, 2010 By 9 Comments
… Yoshinori announcement of HandlerSocket, the plugin to MySQL which open NOSQL way to access data …respect to HandlerSocket developers – I was able to install and get it working with Percona Server …(single thread) with HandlerSocket client. Table is standard sysbench table with 300 mil rows and I …
