Lukas Vileikis in MySQL MySQL Index Overviews: Hash Indexes Welcome back to the MySQL indexing series! We’ve already covered the nuances surrounding indexes in MySQL as well as walked... 06 May 2025 14 min read
Aisha Bukar in MySQL MySQL vs PostgreSQL – String Datatypes A very common task in creating a database is to store string data. For example, words, paragraph(s) or even documents.... 20 March 2025 22 min read
Aisha Bukar in MySQL MySQL vs. PostgreSQL: Character Sets and Collations When working with strings in a database system, you need to ensure that the data is stored, sorted, and compared... 17 March 2025 18 min read
Chisom Kanu in MySQL MySQL Shell Basic Configuration Management (Part 3 – Disk I/O and Storage Optimization) So far, in our previous articles on MySQL optimization, we’ve looked at basic configuration management and memory and CPU tuning... 27 February 2025 15 min read
Lukas Vileikis in MySQL MySQL Index Overviews: Descending B-Tree Indexes Most anyone who works with indexes should be familiar with B-tree indexes. These are the most commonly used data structures... 13 February 2025 11 min read
Chisom Kanu in MySQL MySQL Shell Basic Configuration Management (Part 2 – Memory and CPU) In the first part of the series article, we introduced MySQL Shell as a tool for managing and optimizing MySQL... 17 January 2025 17 min read
Lukas Vileikis in Blogs I Wrote a Book on How You Broke Your Database – Here’s Why You Should Read It This blog introduces the book "Hacking MySQL: Breaking, Optimizing, and Securing MySQL for Your Use Case" by Lukas Vileikis.… 10 January 2025 7 min read
Chisom Kanu in MySQL MySQL Shell Basic Configuration Management (Part 1 – Introduction) The database is an important part of any application and setting it up correctly is key to ensuring smooth performance.... 27 December 2024 23 min read
Lukas Vileikis in MySQL MySQL Index Overviews: Clustered B-Tree Indexes If you’re a frequent reader of the Simple-Talk blog, you’re no stranger to indexes as we’ve covered indexes in database... 03 December 2024 10 min read
Aisha Bukar in Databases MySQL vs PostgreSQL: Numeric Datatype Comparison When you think of how to store data in a database, you think of data types. A data type represents... 15 November 2024 18 min read
Lukas Vileikis in MySQL MySQL Index Overviews: FULLTEXT B-Tree Indexes If you’ve been following Simple Talk for a while, you know that we’re fans of databases and everything they involve.... 25 October 2024 17 min read
Lukas Vileikis in Blogs Thoughts Before Covering MariaDB Indexes in the MariaDB Server Fest 2024 This blog outlines why you should be coming to see a talk on MariaDB indexes at the MariaDB Server Fest... 13 September 2024 4 min read
Lukas Vileikis in Blogs Devising the Perfect Index for Your Use Case – MySQL Edition This blog will walk you through how to choose the perfect index for your specific use case. It will also... 11 September 2024 7 min read
Lukas Vileikis in MySQL MySQL Index Overviews: Composite B-Tree Indexes Indexes in MySQL are one of the primary ways to enhance query performance and they are especially useful when the... 30 August 2024 16 min read
Lukas Vileikis in Blogs Thoughts Before Speaking at the Software Architecture Conference This blog shares the thoughts of a conference speaker Lukas Vileikis before speaking at a conference called Software Architecture Conference.… 14 August 2024 3 min read
Aisha Bukar in MySQL MySQL vs PostgreSQL: Which Open-Source Database is right for you? When I joined a growing startup company as a backend developer, we were at crossroads choosing between MySQL and PostgreSQL... 12 August 2024 12 min read
Lukas Vileikis in MySQL MySQL Index Overviews: B-Tree Indexes In this first entry in a multipart series on indexes, I will cover the most important index type in MySQL,... 05 August 2024 19 min read
MySQL Adrien Payong in MySQL Exploring MVCC and InnoDB’s Multi-Versioning Technique In the realm of relational databases, MySQL stands out as one of the most popular choices. Maximizing its performance is... 20 May 2024 33 min read
Lukas Vileikis in MySQL Optimizing MySQL: Deleting Data In the previous parts of these MySQL optimization series, we told you how query optimization works on a high level,... 17 May 2024 14 min read
MySQL Mercy Bassey in MySQL MySQL Error Log Management in DevOps Operations When it comes to the development and operations (DevOps), one thing stands out as a critical aspect and that is... 14 December 2023 14 min read
