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 - 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

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

This post's content#1: EverSQL for PostgreSQL#2: DataDog#3: Percona Monitoring and Management (PMM) #4: VividCortex (DPM)#5: OPM - Open PostgreSQL PostgreSQL is becoming one of the most popular relational databases in 2022, as you can see its Growth on DBengine records, or in the latest StackOverflow developers survey. We have decided to review and list the top… Continue reading Best PostgreSQL Monitoring & Observability Tools in 2022