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 Introduction to MySQL Shell and Basic Configuration Management (Part 1) 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
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
Blogs Aisha Bukar in Blogs A Beginners Guide to MySQL Replication Part 3: Multi-Source Replication Welcome back to the world of MySQL Replication! If you’ve been following this series, thank you for your support! And... 18 July 2023 11 min read
Featured Aaron Bertrand in Featured Build a Better WordPress Archives Page Using MySQL I recently wrote about a way to generate visual, interactive calendars in HTML by combining a calendar table with data... 10 March 2023 15 min read
Blogs Lukas Vileikis in Blogs Backing Up MySQL Part 7: MySQL Enterprise Backup In this blog, we walk you through the primary way to take enterprise-level backups in MySQL: MySQL Enterprise Backup. Have... 03 December 2022 7 min read
Blogs Lukas Vileikis in Blogs Backing Up MySQL Part 6: Physical vs. Logical Backups In this blog, we compare two of the most popular types of backups in MySQL - backups of a physical... 01 December 2022 9 min read
Blogs Lukas Vileikis in Blogs Backing Up MySQL Part 5: Backing Up Big Data This blog will guide you through backing up big data sets in MySQL with ease. Have a read!… 26 November 2022 14 min read
Blogs Lukas Vileikis in Blogs Backing up MySQL Part 4: mydumper In this blog, we walk you through one of the most prominent MySQL logical backup solutions - a CLI-based tool... 22 November 2022 4 min read
Blogs Lukas Vileikis in Blogs Backing up MySQL Part 3: mysqlpump In this blog, we walk you through the brother of mysqldump - mysqlpump - and tell you everything about it.... 19 November 2022 6 min read
Blogs Lukas Vileikis in Blogs Backing Up MySQL Part 2: Percona XtraBackup In this blog, we walk you through one of the flagship backup offerings by Percona - XtraBackup.… 16 November 2022 7 min read
