Remove Hardware Remove Performance Remove Speed Remove Storage
article thumbnail

MySQL General Tablespaces: A Powerful Storage Option for Your Data

Percona

Managing storage and performance efficiently in your MySQL database is crucial, and general tablespaces offer flexibility in achieving this. In contrast to the single system tablespace that holds system tables by default, general tablespaces are user-defined storage containers for multiple InnoDB tables.

Storage 93
article thumbnail

InnoDB Performance Optimization Basics

Percona

This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Although there have been many blogs about adjusting MySQL variables for better performance since then, I think this topic deserves a blog update since the last update was a decade ago, and MySQL 5.7

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

USENIX LISA2021 Computing Performance: On the Horizon

Brendan Gregg

It's an exciting time for developments in computer performance, not just for the BPF technology (which I often [write about]) but also for processors with 3D stacking and cloud vendor CPUs (e.g., This was a chance to talk about other things I've been working on, such as the present and future of hardware performance.

article thumbnail

What is function as a service? App development gets FaaS and furious

Dynatrace

Effective application development requires speed and specificity. Before an organization moves to function as a service, it’s important to understand how it works, its benefits and challenges, its effect on scalability, and why cloud-native observability is essential for attaining peak performance. Dynatrace news. What is FaaS?

article thumbnail

What is Greenplum Database? Intro to the Big Data Database

Scalegrid

Greenplum Database is an open-source , hardware-agnostic MPP database for analytics, based on PostgreSQL and developed by Pivotal who was later acquired by VMware. Greenplum uses an MPP database design that can help you develop a scalable, high performance deployment. What Exactly is Greenplum? The Greenplum Architecture.

Big Data 321
article thumbnail

MySQL Performance Tuning 101: Key Tips to Improve MySQL Database Performance

Percona

While there is no magic bullet for MySQL performance tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. What are the Benefits of MySQL Performance Tuning? Experiencing database performance issues?

Tuning 52
article thumbnail

MySQL Backups: Methods & Best Practices

Scalegrid

However, data loss is always possible due to hardware malfunction, software defects, or other unforeseen circumstances, just like with any computer system. Having MySQL backups for your database can speed up and simplify the recovery process. Therefore, it’s not the ideal choice if there are time or storage limitations.