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

Webinar April 7, 10am PDT – Introduction to Troubleshooting Performance: What Affects Query Execution?

 | April 5, 2016 |  Posted In: MySQL

Query Execution

Join us for our latest webinar on Thursday, April 7, at 10 am PDT (UTC-7) on Introduction to Troubleshooting Performance: What Affects Query Execution? MySQL installations experience a multitude of issues: server hangs, wrong data stored in the database, slow running queries, stopped replications, poor user connections and many others. It’s often difficult not only […]

Read More

Find unused indexes on MongoDB and TokuMX

 | August 21, 2015 |  Posted In: MongoDB

Finding and removing unused indexes is a pretty common technique to improve overall performance of relational databases. Less indexes means faster insert and updates but also less disk space used. The usual way to do it is to log all queries’ execution plans and then get a list of those indexes that are not used. […]

Read More

MySQL Backup tools used by Percona Remote DBA for MySQL

 | March 13, 2013 |  Posted In: Cloud and NoSQL, Insight for DBAs, Insight for Developers, MySQL

As part of Percona Remote DBA for MySQL service we recognize that reliable backups are one of the most important things we can bring to the table. In my experience handling emergencies, the single worst thing that can happen is finding out you don’t have backups available when some sort of data loss or catastrophic […]

Read More

Percona’s widely read Percona Database 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.