…: Sep-2012 Benchmark goal: Test Intel SSD 910 under tpcc-mysql workload and compare with HDD RAID10 Hardware specification Server: Dell…: Ubuntu 12.04.1 MySQL Version: Percona Server 5.5.27-28.1 Benchmark specification Benchmark name: tpcc-mysql Scale factor: 2500W (~250GB…. I think Intel SSD 910 is suitable to use with MySQL / Percona Server, especially if you are looking for quick performance boost…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… the relevance sorting by default, adding relevance sorting to the MySQL queries would make them even slower, I’m sure. Indeed… the blog post where I announced the webinar: We evaluated MySQL vs Solr. I was able to index all the data from… when I present the popular Percona Training in Salt Lake City, September 24-27. See http://www.percona.com/training/ for details…
Comment: Percona Server 5.5.21-25.1 released!
March 30, 2012 By 8 Comments
Yep, much appreciated – thanks! Btw, is Percona looking to create a build for the 5.6.x series? We are trying to decide between Percona 5.5.x vs Mysql 5.6.x (assuming that goes GA by summer) for a new project and would like to know your thinking. (FWIW – we have a support contract w/ Percona) AD
Comment: MariaDB 5.3.4 benchmarks
February 19, 2012 By 24 Comments
2 alex. Indeed, I never published benchmarks Percona Server vs MySQL 5.5, like this http://www.mysqlperformanceblog.com/2012/01/17/benchmarks-of-new-innodb_flush_neighbor_pages/ from which you can’t get conclusion that Percona Server performs better than MySQL 5.5.
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
…hash was almost 2x faster then combining memcached and MySQL, and about 20% slower then the all memory …is one of the things we do here at Percona. If an application requires a database great, …performance differ or change? One knock on Tokyo -vs- Memcached is Tokyo is not distributed by default.Â…
Post: Virident FlashMAX MLC in tpcc-mysql workload
November 29, 2011 By 8 Comments
… run tpcc-mysql (to compare performance Virident FlashMAX vs Fusion-io ioDrive Duo) The report with results is there: http://www.percona.com/files/white-papers/virident-mlc-tpcc.pdf The graphical result for tpcc-mysql 5000W: My conclusions…, in many cases there is also a better throughput in MySQL (up to 40\%) using the Virident FlashMAX card. DISCLOSURE: This…
Post: Write contentions on the query cache
September 5, 2012 By 5 Comments
… Of course, I wanted to know more about how MySQL executes this query. So I used commands you’… change in data access pattern (reads on disk vs reads in memory, execution plan instability) or contention …the output of SHOW PROFILE? This is specific to Percona Server 5.5 and used only for debugging …
Post: Open Development vs Making a Big Splash
May 21, 2009 By 28 Comments
… is exactly how Innodb Plugin was released last year or MySQL 5.4 performance improvements this year. Community did not know… how I think Open Source development should be done. At Percona I think we’re doing relatively well – our trees are…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… percentage of time the replication thread was busy replicating events vs staying idle. Note you can speak about idle replication capacity… Percona Server and MariaDB. This is the probably the easiest and most accurate approach but it does not work in Oracle MySQL… and run following query: mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G *************************** 1. row *************************** USER: #mysql_system# TOTAL_CONNECTIONS…
Comment: Announcing Percona XtraDB Cluster 5.5.29-23.7.1
February 3, 2013 By 8 Comments
…_debug vs depsolve: mysql conflicts with Percona-XtraDB-Cluster-client-5.5.29-23.7.1.387.rhel5.x86_64 mysql-devel conflicts with Percona-XtraDB-Cluster-devel-5.5.29-23.7.1.387.rhel5.x86_64 mysql-libs conflicts with Percona-XtraDB-Cluster-shared-5.5.29-23.7.1.387.rhel5.x86_64 mysql-server conflicts with Percona…
