Lukas Vileikis

Featured in: Favicon

sitepoint.com Favicon

dzone.com

Articles

I Wrote a Book on How You Broke Your Database – Here's Why You Should Read It

Jan 10, 2025 | red-gate.com | Lukas Vileikis |Louis Davidson

If you are a frequent reader of Simple-Talk, it’s possible that you’ve come across blogs about optimizing all kinds of queries, tutorials on how to back up your database, tutorials on index internals, or even speaking at conferences. If you’re a DBA, these things should resonate with you because all of those things have their place. These blogs advance your knowledge about database internals, and query structure, or inform you about things to come.
MySQL Index Deep Dive: Clustered B-Tree Indexes

Dec 3, 2024 | red-gate.com | Lukas Vileikis

If you’re a frequent reader of the Simple-Talk blog, you’re no stranger to indexes as we’ve covered indexes in database management systems previously – in that blog, we’ve told you that indexes come in a variety of flavors including ordinary Balanced Tree (B-Tree) indexes and R-Tree, or spatial, indexes. B-Tree indexes have multiple types: they can be covering, composite, descending, FULLTEXT, UNIQUE, hash-based, or have something to do with the PRIMARY KEY.
MySQL Index Overviews: FULLTEXT B-Tree Indexes

Oct 24, 2024 | red-gate.com | Lukas Vileikis

If you’ve been following Simple Talk for a while, you know that we’re fans of databases and everything they involve. We’re also big fans of database performance, too. And if you’re a developer or a DBA, you surely know one of the primary answers to database performance – indexing! We’ve already told you about indexes when we talked about multiple approaches to improve your query performance and we’ve already told you about indexing nuances during some of our previous blog posts, too.
Thoughts Before Covering MariaDB Indexes in the MariaDB Server Fest 2024

Sep 13, 2024 | red-gate.com | Lukas Vileikis

Next week, Tuesday, 17th of September, I’m speaking at the MariaDB Server Fest. My speech involves and heavily focuses on indexes within MariaDB. One of my primary goals with this speech is for attendees to understand how to harness the power of indexing.
Devising the Perfect Index for Your Use Case – MySQL Edition - Simple Talk

Sep 10, 2024 | red-gate.com | Lukas Vileikis

If you’ve been following SimpleTalk for a while, you will be aware that I’ve recently blogged about MySQL indexes. I’ve already told you about the nuances of indexes in MySQL, vanilla B-Tree indexes, composite B-Tree indexes, and other kinds of indexes too. This blog will walk you through how to choose the perfect index for your specific use case. It will also advise you on the things you should consider to devise the perfect index design in MySQL.
MySQL Index Overviews: Composite B-Tree Indexes

Aug 29, 2024 | red-gate.com | Lukas Vileikis

Indexes in MySQL are one of the primary ways to enhance query performance and they are especially useful when the primary use case of our project refers to reading data stored in a database. We‘ve already told you about the nuanced world of indexes in MySQL – and there we‘ve mentioned that MySQL has multiple types of SQL indexes available for you to choose from. The primary index type available within MySQL is the B-Tree index which we‘ve already covered in one of our previous articles.
Thoughts Before Speaking at the Software Architecture Conference

Aug 14, 2024 | red-gate.com | Lukas Vileikis

Tomorrow, August 15, I have yet another conference where I’ll speak about MySQL’s performance. To be more exact – MySQL performance on bigger data sets. You can watch me speak via this link through YouTube – it will be fun!The Software Architecture Conference is a conference organized by an online community called C# Corner. C# Corner is a community that lets all kinds of developers share their thoughts, knowledge, and experience through various forms of content.
MySQL Index Overviews: B-Tree Indexes

Aug 5, 2024 | red-gate.com | Lukas Vileikis

In this first entry in a multipart series on indexes, I will cover the most important index type in MySQL, B-Tree Indexes. Applying indexes of any type in MySQL is nuanced task – they are used to speed up the performance of our search queries at the expense of having to be maintained when data is changed in the table.
Optimizing MySQL: Deleting Data

May 17, 2024 | red-gate.com | Lukas Vileikis |Aisha Bukar |Robert S. Sheldon

In the previous parts of these MySQL optimization series, we told you how query optimization works on a high level, then walked you through how you should optimize queries that insert, read, or update data. Remember the laws of physics? “What goes up, must come down”?
SQL Server: Optimize for Ad Hoc Workloads - use or not use

Dec 6, 2023 | red-gate.com | Dennes Torres |Lukas Vileikis |Ben Johnston

I used to believe this option was something almost absolute: it should be enabled as best practice. I was in some way happy when all my demos for SQL Server 2022 started to fail, and I discovered it was because this option was enabled by default. This weekend I attended a technical session which caught my attention to many blog posts stating the opposite.