MySQL Indexing Best Practices
During my work tenure, I got a chance to work with MySQL databases with as many as 700 million rows. This post will emphasize how to index and optimize your MySQL queries for indexes.
During my work tenure, I got a chance to work with MySQL databases with as many as 700 million rows. This post will emphasize how to index and optimize your MySQL queries for indexes.
MySQL introduced Window functions in their release of MySQL version 8.0. to target groups of rows without collapsing them. In this article, we will explore example implementations of the most versatile window functions MySQL has to offer.
Once developers find themselves in the MySQL world, they will almost certainly hear some advice on how they should go about designing database schemas in MySQL. This blog post will provide insight into what you should consider when dealing with database schemas in MySQL.
Sometimes MySQL (or MariaDB) can be great for big data too! In this article, we will explore the things you should consider when answering the question: “Is MySQL a good option for my big data project?”
Being able to view products and pages liked by other users is not only an interesting exercise, but also a nearly-ubiquitous marketing tool—and, it can be easily implemented with MySQL using Arctype.
How to use full text search and the match keyword to find a string in every table in a MySQL database.
What workload analysis and running queries can teach us about the performance differences in JSON, indexing, and concurrency.
Replicating a database can make our applications faster and increase our tolerance to failures.
While MySQL and PostgreSQL have many things in common, you should make sure you understand the differences between them in order to make sure you select the right one for your specific application.