24 April 2014

The Ruby Reflector

Topic

Percona Server

  Source Favicon
Email

…Fast and reliable has been at the heart of Percona Server even before it was Percona Server (i.e. when it was still a collection of patches). Other projects and companies were created during this time, but in my biased opinion Percona held the fort. When MySQL became an Oracle product, the collective MySQL conscience waited to see if they would kill or revive it. They have revived it. MySQL 5.6 is great, and 5.7 is looking good so far too. The work Percona did and still …

mysqlperformanceblog.com Read
  Source Favicon
By Paar of MySQL Performance Blog 7 days ago.
Email

…bugs.mysql.com (for MySQL Server bugs) or on bugs.launchpad.net/percona-server (for Percona Server bugs) already.

In this example, we will be testing Percona Server, as the combination.pl (.cc) grammar we use is optimized for Percona Server. If you would like to test the MySQL server, you can build your own grammars, or use one of the many grammars available in RQG (though they are not many combinations.pl grammars in RQG yet. There are plenty of ( less-powerful) runall.pl …

mysqlperformanceblog.com Read
  Source Favicon
Email

…Percona Toolkit and Percona XtraBackup are up to the latest versions, but Percona Server and Percona XtraDB Cluster comes with 5.5 versions, and it is in line with default MySQL version, which again is 5.5.

I expect this release will make it much easier for users to get familiar with our software, so you can go and try this today!

The post Percona Software in Ubuntu 14.04 LTS ( Trusty Tahr) release appeared first on MySQL Performance Blog .

mysqlperformanceblog.com Read
  Source Favicon
By Klampaeckel of till's blog 2 years ago.
Email

Among all the different technologies in our stack, we also use MySQL. While we still run MySQL (or Percona-Server) ourselves, we selected a managed solution to power parts of our production infrastructure: a Multi-AZ setup with Amazon's RDS.

AZ is Amazon-speak for "availability zone", essentially a datacenter. RDS stands for: Relational Database Service.

Judging from my experience with our own setups where EBS is in the mix, I have to say that Amazon does an …

till.klampaeckel.de Read
  Source Favicon
By Todd Hoff of High Scalability 3 months ago.
Email

Hey, it's HighScalability time:

Google "Corkboard" Server, 1999

5 billion requests per day : Heroku serves 60,000 requests per second; 500 Petabytes : Backblaze's New Data Center; 25000 simultaneous connections : on a Percona Server

How algorithms help determine that shape of our world. First we encode normative rules of an idealized world in algorithms. Second those algorithms help enforce those expectations by nudging …

highscalability.com Read
  Source Favicon
By patrick.crews of MySQL Performance Blog over 2 years ago.
Email

./ dbqp.py -default-server-type=mysql -basedir=/path/to/ Percona-Server -suite=randgen_basic innodbDictSizeLimit_test

This enabled us to reproduce the crash within 5 seconds.

The reason I think this is interesting is that we were unable to duplicate this bug otherwise. The combination of the randgen's power and dbqp's organization helped us knock this out with about 15 minutes of tinkering.

Once we had a bead on this bug, we went on to try a couple of other bugs:

Crash when …

mysqlperformanceblog.com Read
  Source Favicon
By Ryan Lowe of MySQL Performance Blog 3 years ago.
Email

HandlerSocket matures. More people will publish benchmarks and use cases. As companies upgrade their Percona-Server installations, HandlerSocket will become available and easily accessible to them. Finally, as the code matures and the community grows, we'll see lots more third-party involvement with bug reports, feature requests, and patches. I see lots of interest in HandlerSocket and am tremendously optimistic about it's future.

mysqlperformanceblog.com Read
  Source Favicon
By Paar of MySQL Performance Blog 7 days ago.
Email

…bugs.mysql.com (for MySQL Server bugs) or on bugs.launchpad.net/percona-server (for Percona Server bugs) already.

In this example, we will be testing Percona Server, as the combination.pl (.cc) grammar we use is optimized for Percona Server. If you would like to test the MySQL server, you can build your own grammars, or use one of the many grammars available in RQG (though they are not many combinations.pl grammars in RQG yet. There are plenty of ( less-powerful) runall.pl …

mysqlperformanceblog.com Read
  Source Favicon
Email

…can be a lot). Given the sensitivity to replication delay and the high end infrastructure in place ( Percona Server 5.6, 384G RAM, Virident and FusionIO PCI-Flash cards), we decided it was important to absorb the extra traffic in an effort gain further insight into the precise points of any slave lag.

There had been discussion about tweaking the use of pt-heartbeat (-interval = .01 with reduced skew) to look at the sub-second delay, but there were some other considerations:

The tool …

mysqlperformanceblog.com Read
  Source Favicon
By Yves Trudeau of MySQL Performance Blog over 3 years ago.
Email

Last Friday I published results of DBT2 performance while varying the number of idle connections here , but I had compiled MySQL with the debugging code enabled. That completely screw up my results, be aware... debug options have a huge performance impact. So, I recompiled Percona-Server 11.2 without the debug options and did another benchmark run. The result is shown below:

As you can see, the impact is more moderate and far less shocking. The performance loss is approximately …

mysqlperformanceblog.com Read