LOAD DATA INFILE vs. INSERT in MySQL: Why, How, When?
This article will demonstrate the differences between LOAD DATA INFILE and INSERT and explain when you should use both for data entry in MySQL.
Lukas is an ethical hacker and a speaker running one of the biggest & fastest data breach search engines in the world - BreachDirectory.com. He also runs his own blog over at lukasvileikis.com
This article will demonstrate the differences between LOAD DATA INFILE and INSERT and explain when you should use both for data entry in MySQL.
MySQL's Query Cache is incredibly versatile. It’s usually able to store a wide variety of values and return them from the memory (rather than the disk) to improve query execution times. This guide will explore the usages and limitations of query caching.
Slow query performance is a huge thing—so much so that modern database performance optimization techniques are in large part targeted at mitigating slow queries. Surprising? We think not.
Indexes are frequent friends for SELECT queries; however, if we want to use indexes, we must ensure that our database instances use them first. Indexes that are not utilized by our database instances are useless – they waste space and make INSERT, UPDATE, and DELETE queries slower.
Before InnoDB replaced it, MyISAM was one of the flagship storage engines available in MySQL. However, as time moved on, InnoDB replaced it as MySQL engineers found it to be a better choice.
If you are familiar with MySQL, you have probably heard of partitions. Partitions are one of your best friends in regards to query optimization. This article will provide you with a basic overview of partitions to help you understand why they are so important.
If you have found yourself in the MySQL world (at least for a little while), chances are that you have probably heard about the usage of EXPLAIN. In the MySQL world, this keyword is everywhere.
SQL injection attacks traditionally represent one of the largest threats to database security. This article explains what they are and how you can prevent them.
Some MySQL engineers might call them the cornerstone of improving performance in MySQL: indexes are data structures that are frequently used to quickly find rows matching a given query.