Tag: performance

Feed: Planet MySQL; Author: Oracle MySQL Group; MySQL is a proven, reliable database that is quick to set up easy to maintain, and has outstanding performance. However, that performance can usually be improved with the judicious use of the following tips that are all easy to implement ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; Performance issues are often stubborn things to cure. Suddenly a query or operation seems slow, or slower-ish. Sadly, the database is often pointed at as the culprit by developers who are either positive their code cannot be at fault or those who see databases as a mysterious box that does odd things ... Read More

Feed: Database Journal. Author: Gregory Larsen. Table Variables have been known to run slowly when the table variable contains lots of rows. This is because when a batch is compiled the table variable has yet to be populated with any rows, and therefore the optimizer uses an estimated row count of 1 for table variables. This occurs because table variables don’t have statistics. Having an estimated row count of 1 works well for operators that have small row counts, like a NESTED LOOP operator for a join operation. Operators that perform well for small numbers of rows do not always ... Read More

Feed: Recent Announcements. FSx for ONTAP is a storage service that provides the familiar features, performance, capabilities, and APIs of NetApp file systems with the agility, scalability, and simplicity of a fully managed AWS service. Starting today, you can monitor your file systems and volumes without any additional configuration in the Amazon FSx and Amazon CloudWatch consoles. You can also continue to monitor your file systems and volumes with NetApp monitoring tools (such as NetApp Cloud Insights or Harvest with Grafana) ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Recently we published the first part (m5, m5a, m6g) and the second part (C5, C5a, C6g) of research regarding comparing Graviton ARM with AMD and Intel CPU on AWS. We selected general-purpose EC2 instances with the same configurations (amount of vCPU in the first part). In the second part, we compared compute-optimized EC2 instances with the same conditions. The main goal was to see the trend and make a general comparison of CPU types on the AWS platform only for MySQL. We didn’t set the goal to compare the performance of different CPU ... Read More

Feed: Recent Announcements. Amazon Relational Database Service (Amazon RDS) Performance Insights is a database performance tuning and monitoring feature of RDS and Aurora that helps you quickly assess the load on your database and determine when and where to take action. One way to view Performance Insights data is in the AWS Management Console. Performance Insights also provides a public API so that you can query your own data. We are now launching three new API endpoints: GetResourceMetadata, ListAvailableResourceDimensions, and ListAvailableResourceMetrics. These new APIs provide programmatic access to metadata about the metrics collected by Performance Insights. This makes it easier to ... Read More

Feed: Recent Announcements. You can now add nodes to SAP systems deployed with AWS Launch Wizard from within the Launch Wizard console post-deployment if your performance needs increase. This allows you to scale the infrastructure supporting SAP applications (S/4HANA, BW/4HANA, and NetWeaver) deployed with Launch Wizard using the same guided, best-practice-aligned deployment process. As you on-board new users to your SAP applications on AWS, extend them to new regions, or implement new functionality, your application performance requirements will likely grow, requiring you to add more app servers or database worker nodes. With this launch, you can add pre-configured app servers or ... Read More

Feed: R-bloggers. Author: quantixed. [This article was first published on Rstats – quantixed, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. A quick post about a puzzle called Wordle that is currently taking over the internet. It’s a mastermind-like game where the object is to guess an unknown 5-letter word. Puzzlers are encouraged to share their results after completing a puzzle. Here is an example for puzzle 192. So how do you know ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Recently we were asked to check the performance of the new family of AMD EPYC processors when using MySQL in Google Cloud Virtual Machines. This was motivated by a user running MySQL in the N1 machines family and willing to upgrade to N2D generation considering the potential cost savings using the new AMD family.  The idea behind the analysis is to do a side-by-side comparison of performance considering some factors:  EPYC processors have demonstrated better performance in purely CPU-based operations according to published benchmarks.  EPYC platform has lower costs compared to the Intel ... Read More

Feed: Planet MySQL; Author: Sveta Smirnova; First I want to thank everyone who attended my November 16, 2021 webinar “MySQL Performance for DevOps“. Recording and slides are available on the webinar page. Here are answers to the questions from participants which I was not able to provide during the webinar. Q: Hi! We have troubles with DELETE queries. We have to remove some data periodically (like, hourly, daily) and we have short-term server stalls during these DELETEs. Server is running on modern NVMe’s so we wonder why do we have this situation. Those DELETE’s are not so large, like 10 ... Read More