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
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
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.
This year, we had a chance to work with large Point of Sales (POS) and e-commerce companies who used EverSQL to speed up their applications. Here are our key takeaways: It is much more than just a Point Of Sale - These tablets we see in restaurants, supermarkets or retail chains are much more than… Continue reading Slow Point of Sale, Databases and Mark Zuckerberg
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]
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
This post's content#1 - EverSQL#2 - LiquiBase#3 - JFrog#4 - ELK stack#5 - Datadog#6 - DBmaestro#7 - Grafana #1 - EverSQL EverSQL provides SQL query optimization and database observability, powered by AI. EversSQL's optimization capabilities can be integrated into your CI workflow, to automatically and contentiously optimize your SQL queries. The integration can be implemented… Continue reading Top 7 CI/CD tools for PostgreSQL and MySQL databases in 2023
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]
This post's content1. Locate the root cause2. Fix the performance issue3. Make sure it will not happen again.4. Summary - PostgreSQL High CPU We all love PostgreSQL, but sometimes, usually around 3 AM, it can reach a 100% CPU usage, which can be annoying for us, and a disaster for our customers. So how can… Continue reading How to Fix PostgreSQL High CPU Usage?
This post's contentWhat is pg_stat_statements ?How do I know if pg_stat_statements is enabled?I don't see the pg_stat_statements table. How can I enable it?How does enabling pg_stat_statements impact performance and does it create an overhead?How to disable pg_stat_statements?Who can access and see the content of pg_stat_statements?How pg_stat_statements is different from slowlogs?What columns does pg_stat_statements include?How do… Continue reading PostgreSQL – pg_stat_statements, explained