…_64 ICE 3.5.2pl1. Requires m1.large or larger ami-8eb648e7 shard-query-innodb-demo-64bit x86_64 Percona Server 5.5.11 with XtraDB. Requires m1.large or larger. ami-f65ea19f shard-query-infobright-demo i686 ICE 3.5.2pl1…-threads=1 innodb-read-ahead=linear innodb-read-ahead-threshold=8 innodb-read-io-threads=16 innodb-recovery-stats innodb-recovery…
Post: Debian / Ubuntu Percona builds
March 9, 2009 By 8 Comments
… builds of Percona releases so I could not ignore that and added scripts to build binaries on our Ubuntu 8.10 box… announcements), and you can get it there http://www.percona.com/downloads/Percona-Server-5.0/LATEST/deb/, and your feedback is welcome! As… to interpret, so I removed any mentioning of embedded server as 5.0 actually is not supposed to work in embedded mode…
Post: Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark
September 11, 2012 By 6 Comments
… Memory: 192GB Storage: Hardware RAID10 over 8 disks, card: Perc H710, disks: Seagate ST9750420AS 750GB, 2.5“, 7200RPM, 16MB, SATA. Intel SSD…) Filesystem: ext4 Software OS: Ubuntu 12.04.1 MySQL Version: Percona Server 5.5.27-28.1 Benchmark specification Benchmark name: tpcc-mysql Scale…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…Percona Server and MariaDB. This is the probably the easiest and most accurate approach but it does not work in Oracle MySQL Server…2 0.01 0 0.14 0 # Tmp table 8.30G 0 2.01M 7.12k 0 117….it too). First I would measure replication capacity on 5 minute intervals (or something similar) because it tends …
Post: Review of Virident FlashMAX MLC cards
November 10, 2011 By 14 Comments
…: Server: Cisco UCS C250, running Oracle Linux 6.1 and Percona Server 5.5.15 Client: HP ProLiant DL380 G6, sysbench v5 Of course, our Percona Server… seconds in each run: Card / Threads / tps 1 2 4 8 16 32 64 128 256 512 1024 1 Fusion-io…
Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
January 9, 2013 By Leave a Comment
…attachment_12275″ align=”alignright” width=”300″] Percona Toolkit 2.1.8[/caption] Percona Toolkit 2.1.8 was released today and the new …summary doesn’t handle renamed variables in Percona Server 5.5. Some renamed variables had caused the Percona Server section to work unreliably. Fixed bug 1074179…
Comment: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 22, 2010 By 11 Comments
….com/2010/12/20/mysql-5-5-8-and-percona-server-being-adaptive/) in the 3rd graph there, buffer_pool_instances=8 didn’t give any…_pool_instances, 1 or 8? 2) Is the buffer_pool_instances=8 option only available for MySQL 5.5 whereas Percona Server 5.5 only allows 1 buffer… previous post (http://www.mysqlperformanceblog.com/2010/12/20/mysql-5-5-8-and-percona-server-being-adaptive/) in the 3rd graph innodb_io_capacity…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
… on DPE3 server, from which I’m not touching from the test at all ? Summary: 833 out of 10000 rounds (8.33… the cluster as if it were single server from generic application. Right. Default configuration for Percona XtraDB Cluster at this point is…: Percona XtraDB Cluster related configuration # PXC Settings for Version: ‘5.5.29-55-log’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 Percona XtraDB…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…. # yum -y install Percona-XtraDB-Cluster-server Percona-XtraDB-Cluster-client percona-xtrabackup Install haproxy and … connections. Version: ‘5.5.24-log’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Percona XtraDB Cluster …sbpass –oltp-table-size=10000 –num-threads=8 run This is the status of …
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… in the foreground sysbench was run for 15 minutes with 8 threads which would execute read/write queries against a 20M… 5.5.15, the version of MySQL used for benchmarking the new DROP TABLE implementation is MySQL 5.5.24, and the version of Percona Server used for benchmarking Lazy Drop Table is Percona Server 5.5.24 (innodb_lazy_drop…
