EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Blog Poll: How Do You Currently Host Applications and Databases?

 | October 19, 2017 |  Posted In: Aurora RDS, Cloud and MySQL, Cloud and NoSQL, Database Poll, Insight for DBAs, Insight for Developers, MongoDB, MySQL

Host applications and databases

Percona latest blog poll asks how you currently host applications and databases. Select an option below, or leave a comment to clarify your deployment! With the increased need for environments that respond more quickly to changing business demands, many enterprises are moving to the cloud and hosted deployments for applications and software in order to […]

Read More

How to Choose the MySQL innodb_log_file_size

 | October 18, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL

innodb_log_file_size

In this blog post, I’ll provide some guidance on how to choose the MySQL innodb_log_file_size. Like many database management systems, MySQL uses logs to achieve data durability (when using the default InnoDB storage engine). This ensures that when a transaction is committed, data is not lost in the event of crash or power loss. MySQL’s […]

Read More

Webinar Thursday, October 19, 2017: What You Need to Get the Most Out of Indexes – Part 2

and  | October 18, 2017 |  Posted In: Insight for DBAs, MySQL, open source databases, Technical Webinars

Indexes

Join Percona’s Senior Architect, Matthew Boehm, as he presents What You Need to Get the Most Out of Indexes – Part 2 webinar on Thursday, October 19, 2017, at 11:00 am PDT / 2:00 pm EDT (UTC-7). Register Now Proper indexing is key to database performance. Finely tune your query writing and database performance with […]

Read More

Webinar Wednesday, October 18, 2017: How to Scale with MongoDB

and  | October 17, 2017 |  Posted In: Benchmarks, Hardware and Storage, Insight for DBAs, MongoDB

Scale with MongoDB

Join Percona’s Senior Technical Services Engineer Adamo Tonete as he presents How To Scale with MongoDB on Wednesday, October 18, 2017, at 11:00 am PDT / 2:00 pm EDT (UTC-7). Register Now In this webinar, we will talk about how to scale with MongoDB, up to thousands of writes and reads per second. What are […]

Read More

A Mystery with open_files_limit

 | October 12, 2017 |  Posted In: Insight for DBAs, MySQL, Percona Server

open_files_limit

In this blog, we’ll look at a mystery around setting the open_file_limit variable in MySQL and Percona Server for MySQL. MySQL Server needs file descriptors to run. It uses them to open new connections, store tables in the cache, create temporary tables to resolve complicated queries and access persistent ones. If mysqld is not able […]

Read More

Webinar Thursday, October 12, 2017: MongoDB Readiness from an SRE and Ops Viewpoint

and  | October 11, 2017 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB, Technical Webinars

MongoDB Readiness

Join Percona’s MongoDB Practice Manager David Murphy on Thursday, October 12, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7) as he discusses MongoDB Readiness from an SRE and Ops Viewpoint. Register Now Operations teams (SRE, PE, DevOps, etc.) are being asked to take a more active role in database provisioning and scaling. Much […]

Read More

MySQL, Percona Server for MySQL and MariaDB Default Configuration Differences

 | October 9, 2017 |  Posted In: InnoDB, Insight for DBAs, MariaDB, MySQL

MySQL and MariaDB Default Configuration

In this blog post, I’ll discuss some of the MySQL and MariaDB default configuration differences, focusing on MySQL 5.7 and MariaDB 10.2. Percona Server for MySQL uses the same defaults as MySQL, so I will not list them separately. MariaDB Server is a general purpose open source database, created by the founders of MySQL. MariaDB […]

Read More

One Million Tables in MySQL 8.0

 | October 1, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL, MySQL 8.0

MySQL 8.0

In my previous blog post, I talked about new general tablespaces in MySQL 8.0. Recently MySQL 8.0.3-rc was released, which includes a new data dictionary. My goal is to create one million tables in MySQL and test the performance. Background questions Q: Why million tables in MySQL? Is it even realistic? How does this happen? Usually, millions […]

Read More

Avoid Shared Locks from Subqueries When Possible

 | September 25, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL

Shared Locks

In this blog post, we’ll look at how to avoid shared locks from subqueries. I’m pretty sure most of you have seen an UPDATE statement matching rows returned from a SELECT query:

This query, when executed with autocommit=1, is normally harmless. However, this can have bad effects when combined with other statements in the […]

Read More

Percona Live Europe: Tutorials Day

 | September 25, 2017 |  Posted In: Group Replication, High-availability, InnoDB, Insight for DBAs, Insight for Developers, MongoDB, MySQL, Percona Live

Percona Live Tutorials

Welcome to the first day of the Percona Live Open Source Database Conference Europe 2017: Tutorials day! Technically the first day of the conference, this day focused on provided hands-on tutorials for people interested in learning directly how to use open source tools and technologies. Today attendees went to training sessions taught by open source database […]

Read More