Database Performance Blog – Percona

Time 2021-11-18 06:13:30

Web Name: Database Performance Blog – Percona

WebSite: http://www.mysqlperformanceblog.com

ID:237103

Keywords:

Performance,Database,Percona,Blog,

Description:

keywords:
description:Database performance tips from Percona data performance experts. Learn to build and maintain high-performing MySQL, NoSQL, MongoDB, big data, cloud deployments.

Percona LiveAbout UsContact Us Services Support MySQL Support MongoDB Support MariaDB Support PostgreSQL Support DBaaS Support High Availability Support Flexible Pricing Support Tiers Technical Account Managers Managed Services Percona Managed Database Services Percona Advanced Managed Database Service Consulting Percona Cloud Cover Percona Open Source Advance Percona and Microsoft Azure Partnership Policies Training Products MySQL Database Software Percona Distribution for MySQL Percona Server for MySQL Percona XtraDB Cluster Percona XtraBackup MongoDB Database Software Percona Distribution for MongoDB Percona Server for MongoDB Percona Backup for MongoDB PostgreSQL Database Software Open Source Database Tools Percona Toolkit Percona Monitoring and Management Percona Kubernetes Operators Software Downloads Solutions MongoDB Runs Better with Percona Eliminate Vendor Lock-In Embrace the Cloud Reduce Costs and Complexity Optimize Database Performance Resources Percona Live 2021 2020 Survey Results Webinars Solution Briefs Datasheets Case Studies Technical Presentations Videos White Papers Product Documentation About About Percona Contact Us Customers Percona 15th Anniversary In The News Percona Live Careers Percona Lifestyle Events Community Forums Community Blog PMM Community Contributions

17 Nov 2021 How Triggers May Significantly Affect the Amount of Memory Allocated to Your MySQL Server By Sveta Smirnova Insight for DBAs, MySQL MySQL, MySQL triggers, mysql-and-variants, table cache, triggers 0 CommentsSveta Smirnova2021-11-17T08:42:48-05:00

MySQL stores active table descriptors in a special memory buffer called the table open cache. This buffer is controlled by configuration variables table_open_cache that hold the maximum number of table descriptors that MySQL should store in the cache, and table_open_cache_instances that stores the number of the table cache instances. With default values of table_open_cache=4000 []

Read more 16 Nov 2021 Percona Sponsors Conferences and Supports Community By Aleksandra Abramova Open Source, Percona Events Community, Open Source, Percona Events 0 CommentsAleksandra Abramova2021-11-16T08:07:58-05:00

We love supporting communities and open source. One of the things we are thrilled about at Percona is hybrid and in-person conferences coming back this fall. Local events are a perfect opportunity to meet and reinforce you, community members, and open source lovers, talk about databases and remote work, and maybe even hug!
Especially for []

Read more 10 Nov 2021 Community Meetup Schedule Till the End of the Year By Aleksandra Abramova and Fredel Mamindra Insight for DBAs, Insight for Developers, Percona Announcements, Percona Events Percona Events 0 CommentsAleksandra Abramova2021-11-10T09:44:49-05:00

This fall we started to run live-streamed online meetups accompanied by a live chat with the audience. Every week we invite experts for a real-time talk and devote this meeting to a specific database.
But the holiday season is coming soon! So, we slightly changed the meetup schedule and would like to announce it. Here []

Read more 10 Nov 2021 Issues Upgrading PostGIS and PostgreSQL By Robert Bernier Insight for DBAs, PostgreSQL PostgreSQL, Robert PP 0 CommentsRobert Bernier2021-11-10T07:28:46-05:00

PostGIS is arguably the best GIS implementation in the world. There may be other database technologies with GIS but the value proposition of quality, performance, and sophistication, and, of course, cost, is nowhere near what PostgreSQL offers.
So let me set the stage for this blog of mine: youve been using PostGIS on your PostgreSQL []

Read more 09 Nov 2021 What if … MySQL’s Repeatable Reads Cause You to Lose Money? By Marco Tusa Insight for DBAs, Insight for Developers, MySQL InnoDB, isolation level, locks, MySQL, mysql-and-variants, Read comitted, REPEATABLE READ 2 CommentsMarco Tusa2021-11-09T09:23:11-05:00

Well, let me say if that happens its because there is a logic mistake in your application. But you need to know and understand what happens in MySQL to be able to avoid the problem. 
In short, the WHY of this article is to inform you about possible pitfalls and how to prevent them from []

Read more 121,036Next How Can We Help?

Percona's experts can maximize your application performance with our open source database support, managed services or consulting.

Contact usSubscribe

Want to get weekly updates listing the latest blog posts? Subscribe now and we'll send you an update every Friday at 1pm ET.

Subscribe to our blog

CategoriesMySQL(3480)Insight for DBAs(1708)Percona Software(1657)Percona Events(888)MongoDB(615)Insight for Developers(522)Benchmarks(350)Percona Live(344)Cloud(331)Webinars(308)PostgreSQL(217)Monitoring(210)Percona Services(173)MariaDB(159)Security(139)ProxySQL(134)Hardware and Storage(109)Storage Engine(64)Database Trends(63)Percona Announcements(19) Percona Blog RSS Feed ServicesSupportManaged ServicesConsultingTrainingProducts MySQL SoftwareMongoDB SoftwarePostgreSQL DistributionKubernetesMonitoring & ManagementResourcesSolution BriefsWhite PapersWebinarsCase StudiesDatasheetsDocumentationMoreBlogCommunity BlogTechnical Forum HelpAboutCustomersNewsroomAboutCareers

Contact UsSales & General Inquiries(888) 316-9775 (USA)(208) 473-2904 (USA)+44 203 608 6727 (UK)0-808-169-6490 (UK)

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners. Proudly running Percona Server for MySQL

Terms of Use | Privacy | Copyright | Legal

Copyright © 2006-2021 Percona LLC.

TAGS:Performance Database Percona Blog 

<<< Thank you for your visit >>>

Database performance tips from Percona data performance experts. Learn to build and maintain high-performing MySQL, NoSQL, MongoDB, big data, cloud deployments.

Hot Websites