Adobe Commerce Cloud Performance Optimization

This post's contentAdobe Commerce Cloud Performance overviewTools for optimizing Adobe CommerceEverSQLAdobe Performance Monitoring ToolsAdobe Commerce Cloud Performance Alerts Guest author: Anshuman Ravi (Twitter / Github) Adobe Commerce Cloud Performance overview Adobe commerce cloud formerly Magento is a powerful feature packed E-commerce platform. Its core “commerce” package contains almost all standard features for B2c and B2B… Continue reading Adobe Commerce Cloud Performance Optimization

Common pitfalls when migrating MySQL to Aurora using AWS DMS

This post's contentPotential solutions for migrating RDS MySQL to Aurora MySQLMy expectations from the migration using AWS DMSPitfalls when using AWS DMS to migrate MySQL to AuroraHow to correctly migrate the schema from MySQL to Aurora? We recently migrated some of EverSQL's workload from AWS RDS MySQL to Aurora MySQL. In this post I'll share… Continue reading Common pitfalls when migrating MySQL to Aurora using AWS DMS

Choosing the best indexes for PostgreSQL query optimization

This post's contentHow to find existing indexes in PostgreSQL?Does the order of the WHERE clause matter?What is a composite index?Composite indexes vs Separate indexesANALYZE? How do I make sure that PostgreSQL has the updated stats on my table size?Does PostgreSQL allow two identical indexes on the same table?Does PostgreSQL know to use more than one… Continue reading Choosing the best indexes for PostgreSQL query optimization

[Solved] Aurora MySQL, Innodb and Indexes: Creating index required more than ‘innodb_online_alter_log_max_size’ bytes of modification log. Please try again.

This post's contentThe challengeThe solutionIncrease innodb_online_alter_log_max_sizePostpone DML operationsDo not use AFTER when adding a new columnPartitioning?External tools? The challenge If you have a large MySQL table and you're trying to add a new column and index it, you may have ran into this error: Creating index 'Name' required more than 'innodb_online_alter_log_max_size' bytes of modification log.… Continue reading [Solved] Aurora MySQL, Innodb and Indexes: Creating index required more than ‘innodb_online_alter_log_max_size’ bytes of modification log. Please try again.

The complete PostgreSQL Index Advisor guide [Online]

This post's contentWhat is an Index?How to create a PostgreSQL IndexHow does the Online PostgreSQL Index Advisor work?FAQDo I need to provide my database credentials to work with the Index Advisor?Does the Index Advisor provide the commands to create the missing indexes?How to maintain indexes?How to list all PostgreSQL Indexes?How to list all on Indexes… Continue reading The complete PostgreSQL Index Advisor guide [Online]

Using Datadog? Now you can auto-optimize PostgreSQL and MySQL queries

EverSQL's optimization capabilities can be integrated with your Datadog's Database Monitoring, to automatically and continuously optimize your SQL queries. You can find EverSQL on Datadog's integrations section. The integration can be implemented manually or automatically by adding the EverSQL Sensor, which utilizes EverSQL's Optimization capabilities, to automatically optimize queries that you found on Datadog's Database… Continue reading Using Datadog? Now you can auto-optimize PostgreSQL and MySQL queries

Top 7 CI/CD tools for PostgreSQL and MySQL databases in 2022

This post's content#1 - LiquiBase#2 - EverSQL#3 - JFrog#4 - ELK stack#5 - Datadog#6 - DBmaestro#7 - Grafana #1 - LiquiBase Liquibase Community is an open-source project that helps millions of developers rapidly manage database schema changes. With Liquibsae you can track, version, and deploy database changes. Liquibase also has a paid version that includes… Continue reading Top 7 CI/CD tools for PostgreSQL and MySQL databases in 2022

Database performance anomaly detection in 3 minutes [PostgreSQL, MySQL]

This post's content1. Enable Slowlog2. Deploy EverSQL AI-powered Sensor3. Be amazed at how accurate the ML algorithm is4. Receive anomaly alerts via Slack or email5. Summary - Finding database performance anomalies How to detect PostregSQL/MySQL performance anomalies in 3 minutes? Remember when your website checkout didn't work for 4 hours just because PostgreSQL was overloaded… Continue reading Database performance anomaly detection in 3 minutes [PostgreSQL, MySQL]