-
Starting and Stopping MySQL 8 Events (Part 4)
Jul 17, 2018 by Robert Gravelle Since version 5.1.6, MySQL has supported events. They employ a natural language scheduling syntax, so that you can say: "I want the MySQL server to execute this SQL statement every day at 11:30am, until the end of the...
https://www.navicat.com/en/company/aboutus/blog/757-starting-and-stopping-mysql-8-events-part-4.html -
Working with MySQL Logs (Part 2): the Binary Log
Dec 4, 2018 by Robert Gravelle Logging is about recording what happened in your databases. Just as some people might keep a personal journal to write down what happens in their daily lives, a database log keeps track of things like logins and...
https://www.navicat.com/en/company/aboutus/blog/971-working-with-mysql-logs-part-2-the-binary-log.html -
Deciding between NoSQL and Traditional Relational Databases
Jan 29, 2019 by Robert Gravelle Selecting which database will manage all of your company's data can be a very daunting decision; one that will have long-term ramifications for both your employees, partners and customers. Perhaps you're already...
https://www.navicat.com/en/company/aboutus/blog/994-deciding-between-nosql-and-traditional-relational-databases.html -
Using Covered Queries in MongoDB
Mar 5, 2019 by Robert Gravelle You've probably heard that column indexing is a great way to optimize query performance by minimizing the number of disk accesses required by the query. MongoDB has a specific application of field indexing called Covered...
https://www.navicat.com/en/company/aboutus/blog/1006-using-covered-queries-in-mongodb.html
