Lukas Vileikis's profile'

Lukas Vileikis

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

Articles
Guide

The Basics of MySQL Query Caching

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.

By Lukas Vileikis
2 months ago
MySQL

Unused Indexes in MySQL: A Basic Guide

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.

By Lukas Vileikis
3 months ago
Guide

Partitioning MySQL: Why, When, How?

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.

By Lukas Vileikis
4 months ago