… of free-Percona-Live tickets we’ll give away. But first — have you ever wondered what servers are in your MySQL replication….116.5 Version 5.1.57-rel12.8-log Server ID 1165 Uptime 20+09:44:46 (started 2011-09-28T10:55:30) Replication… information. Now how do you win a free ticket to Percona Live London? Watch our @percona Twitter stream to find out!
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
Post: Percona Server 5.5.21-25.1 released!
March 29, 2012 By 8 Comments
… release of Percona Server 5.5.21-25.1 on March 30, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.21, including all the bug fixes in it, Percona Server 5.5.21-25.1 is now the current stable release in the 5.5…
Comment: XtraDB storage engine release 1.0.2-2 (New Year edition)
January 2, 2009 By 20 Comments
Regarding “as binaries, percona xtradb is compiled in into MySQL-5.1.30 RPM” – does this mean that XtraDB is the default InnoDB storage engine in the server RPM file or does it still need to be enabled via the loadable modules method?
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… percona-server resolving dependencies… looking for inter-conflicts… Targets (4): libaio-0.3.109-6 libmysqlclient-5.5.30-1 mysql-clients-5.5.30-1 percona-server-5.5.29_rel29.4-1… | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES | YES | YES | [...] mysql> SELECT “Hello World!” AS “Success!” \G *************************** 1. row…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…_transfer_required():34 120723 23:45:30 [Note] WSREP: applier thread exiting (code:7…1 row affected (0.02 sec) percona1 mysql> select * from percona; +—-+—————+——–+ | id | inserted_from | name | +—-+—————+——–+ | 2 | percona1 | lefred | | 3 | percona2 | kenny | | 5…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… about the benchmark. First of all before running the benchmark, 30 tables were created and populated with 1000 rows, the tables… is MySQL 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_table=1…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…Percona Server. Another great thing about Percona Server is the ability to enable logging atomically, not just for new connections as in MySQL…wp_options # 8 0x4C16888631FD8EDB 0.1160 1.4% 5 0.0232 1.00 0.00 SELECT film …# Tmp tables 10 149 1 1 1 1 0 1 # Tmp disk tbl 30 149 1 1 1 1 0 1 # Tmp tbl size …
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… results of my testing of the new Group Commit in Percona Server 5.1. As background information, the problem appears when you have… cache online. There are two versions tested: Percona Server 5.1.57 – released and Percona Server 5.1.57 with the Group Commit Fix applied. The… 3409.97 3522.43 32 4422.41 3662.40 3842.30 64 4389.14 3860.01 3888.56 128 4345.84…
Post: Percona Server on the Nexus 7: Your own MySQL Database Server on an Android Tablet
February 28, 2013 By 11 Comments
…30…Percona Server MySQL source code wget http://www.percona.com/redir/downloads/Percona-Server-5.5/Percona-Server-5.5.29-29.4/source/Percona-Server-5.5…
Post: Intel SSD 910 in tpcc-mysql benchmark
September 7, 2012 By 9 Comments
… ext4 Software OS: Ubuntu 12.04.1 MySQL Version: Percona Server 5.5.27-28.1 Benchmark specification Benchmark name: tpcc-mysql Scale factor: 2500W (~250GB ….45 50 GB146655911242231.30 75 GB246413519394151.27 Conclusion In conclusion I see that Intel SSD 910 handles MySQL workload quite …
