EmergencyEMERGENCY? Get 24/7 Help Now!

Millions of Queries per Second: PostgreSQL and MySQL’s Peaceful Battle at Today’s Demanding Workloads

and  | January 6, 2017 |  Posted In: Benchmarks, InnoDB, MySQL, open source databases, OpenSource Databases on big machines, Percona Live

PostgreSQL and MySQL

This blog compares how PostgreSQL and MySQL handle millions of queries per second. Anastasia: Can open source databases cope with millions of queries per second? Many open source advocates would answer “yes.” However, assertions aren’t enough for well-grounded proof. That’s why in this blog post, we share the benchmark testing results from Alexander Korotkov (CEO of […]

Read More

Percona Live Europe 2016: “PostgreSQL Worst Practices” with Ilya Kosmodemiansky

 | October 4, 2016 |  Posted In: Percona Live

Percona Live Europe

Day one of Percona Live Europe 2016 is coming to a close, but the sessions keep coming. The afternoon contained just as many packed presentations as the morning, with the same enthusiastic transfer of knowledge. In getting Percona Live Europe 2016 ready this year, something unexpected happened. We noticed the PostgreSQL community come together and […]

Read More

PostgreSQL Day at Percona Live Amsterdam 2016

 | August 25, 2016 |  Posted In: MySQL

PostgreSQL Day

Introducing PostgreSQL Day at Percona Live Europe, Amsterdam 2016. As modern open source database deployments change, often including more than just a single open source database, Percona Live has also changed. We changed our model from being a purely MySQL-focused conference (with variants) to include a significant amount of MongoDB content. We’ve also expanded our […]

Read More

MySQL and PostgreSQL SpecJAppServer benchmark results

 | July 25, 2007 |  Posted In: Benchmarks

Listening to Josh Berkus presentation on OSCON today I decided to take a closer look at SpecJAppServer benchmarks results which were published by PostgreSQL recently and which as Josh Puts it “This publication shows that a properly tuned PostgreSQL is not only as fast or faster than MySQL, but almost as fast as Oracle (since […]

Read More

Interesting MySQL and PostgreSQL Benchmarks

 | November 30, 2006 |  Posted In: Benchmarks

I had found pile of MySQL and PostgreSQL benchmarks on various platforms which I have not seen before. Very interesting reading. It does not share too much information about how MySQL or PostgreSQL was configured or about queries. Furthermore MySQL and PostgreSQL has a bit different implementations (ie SubQueries avoided for MySQL) so do not […]

Read More

Percona Software News and Roadmap Update with CEO Peter Zaitsev: Q1 2017

 | January 27, 2017 |  Posted In: Docker, Events and Announcements, MongoDB, MySQL, Percona MySQL Consulting, Percona MySQL Support, Percona Software, Percona Support, Percona XtraBackup, Percona XtraDB Cluster, PMM, Technical Webinars, XtraDB Cluster

Percona Software News and Roadmap Update

This blog post is a summary of the webinar Percona Software News and Roadmap Update – Q1 2017 given by Peter Zaitsev on January 12, 2017. Over the last few months, I’ve had the opportunity to meet and talk with many of Percona’s customers. I love these meetings, and I always get a bunch of questions […]

Read More

Performance Schema Benchmarks: OLTP RW

 | January 26, 2017 |  Posted In: MySQL, open source databases, OpenSource Databases on big machines

Performance Schema Benchmarks

In this blog post, we’ll look at Performance Schema benchmarks for OLTP Read/Write workloads. I am in love with Performance Schema and talk a lot about it. Performance Schema is a revolutionary MySQL troubleshooting instrument, but earlier versions had performance issues. Many of these issues are fixed now, and the default options work quickly and […]

Read More

Open Source Databases on Big Machines: Does READ COMMITTED Scale on 144 Cores?

 | January 19, 2017 |  Posted In: open source databases, OpenSource Databases on big machines

READ COMMITTED

In the second post in my series on open source databases on big machines, we’ll look at whether READ COMMITTED scales with multiple cores. The default transaction level for InnoDB is REPEATABLE READ. A more permissive level is  READ COMMITTED, and is known to work well. While the  REPEATABLE READ level maintains the transaction history up to the start of the transaction, […]

Read More

Percona Poll Results: What Database Technologies Are You Using?

 | December 21, 2016 |  Posted In: Database Poll, MongoDB, MySQL

This blog shows the results from Percona’s poll on what database technologies our readers use in their environment. We design different databases for different scenarios. Using one database technology for every situation doesn’t make sense, and can lead to non-optimal solutions for common issues. Big data and IoT applications, high availability, secure backups, security, cloud vs. on-premises deployment: each […]

Read More

Amazon AWS Service Tiers

 | November 11, 2016 |  Posted In: Cloud and MySQL, MySQL, Solutions Engineering

This blog post discusses the differences between the Amazon AWS service tiers. Many people want to move to an Amazon environment but are unsure what AWS service makes the most sense (EC2, RDS, Aurora). For database services, the tiering at Amazon starts with EC2, then moves up to RDS, and on to Aurora. Amazon takes on […]

Read More