EmergencyEMERGENCY? Get 24/7 Help Now!

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 Live featured talk with Álvaro Hernández Tortosa — ToroDB: Supercharging your RDBMS with MongoDB super powers

 | April 14, 2016 |  Posted In: Percona Live

Percona Live Álvaro Hernández Tortosa

Welcome to the last Percona Live featured talk with Percona Live Data Performance Conference 2016 speakers! In this series of blogs, we’ll highlight some of the speakers that will be at this year’s conference, as well as discuss the technologies and outlooks of the speakers themselves. Make sure to read to the end to get a special Percona Live […]

Read More

Peter Zaitsev webinar January 27th: Compression In Open Source Databases

 | January 22, 2016 |  Posted In: Events and Announcements, MySQL

Database Compression

Percona invites you to attend a webinar Wednesday, January 27th, with CEO Peter Zaitsev: Compression In Open Source Databases. Register now! Data growth has been tremendous in the last decade and shows no signs of stopping. To deal with this trend database technologies have implemented a number of approaches, and data compression is by far the […]

Read More

Tired of MySQL Making You Wait? Webinar: Questions and Answers

 | January 21, 2016 |  Posted In: MySQL, Query Analytics

We’d like to thank everybody for joining us on January 7th for our “Tired of MySQL Making You Wait?” webinar with Percona’s Alexander Rubin, Principal Consultant and SolarWinds’ Janis Griffin, Database Evangelist. Too often developers and DBAs struggle to pinpoint the root cause of performance issues and then spend too much time in trying to […]

Read More

Django with time zone support and MySQL

 | January 7, 2015 |  Posted In: Insight for Developers, MySQL

This is yet another story of Django web-framework with time zone support and pain dealing with python datetimes and MySQL on the backend. In other words, offset-naive vs offset-aware datetimes. Shortly, more about the problem. After reading the official documentation about the time zones, it makes clear that in order to reflect python datetime in […]

Read More

Understanding the Performance Characteristics of Partitioned Collections

 | June 10, 2014 |  Posted In: Tokutek, TokuView

In TokuMX 1.5 that is right around the corner, the big feature will be partitioned collections. This feature is similar to partitioned tables in Oracle, MySQL, SQL Server, and Postgres. A question many have is “why should I use partitioned tables?” In short, it’s complicated. The answer depends on your workload, your schema, and your […]

Read More

WITHer Recursive Queries?

 | February 11, 2014 |  Posted In: Insight for Developers, MySQL, query tuning

Over the past few years, we’ve seen MySQL technology advance in leaps and bounds, especially when it comes to scalability. But by focusing on the internals of the storage engine for so long, MySQL has fallen behind regarding support for advanced SQL features. SQLite, another popular open-source SQL database, just released version 3.8.3, including support […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.