Article about ways to optimize INSERT operations and look at alternatives when you need to load more than a few rows in the LOAD DATA INFILE statement.
https://www.red-gate.com/simple-talk/databases/mysql/optimizing-mysql-adding-data-to-tables/
#mysql #performance #insert
https://www.red-gate.com/simple-talk/databases/mysql/optimizing-mysql-adding-data-to-tables/
#mysql #performance #insert
Simple Talk
Optimizing MySQL: Adding Data to Tables - Simple Talk
Welcome back to the MySQL optimization series! In case you haven’t been following this series, in the past couple of articles we have discussed the basics
A new article has just been published!
In the "Lessons" series, I'm sharing small things I have learned as part of my job. The first article explains MySQL Replication.
#lessons
#mysql
In the "Lessons" series, I'm sharing small things I have learned as part of my job. The first article explains MySQL Replication.
#lessons
#mysql
Gym the Meme
The Evolution of MySQL Replica - Gym the Meme
MySQL’s replication mechanism has evolved significantly over the years to improve scalability and reduce lag. Early versions of MySQL used a simple asynchronous model with a single thread applying al…