Billions of Records in MySQL: Lessons Learned | Lukas Vileikis | Conf42 Platform Eng. 2024

preview_player
Показать описание

Chapters
0:00 intro
0:14 understanding full text search queries
1:28 identifying and fixing query bugs
2:08 speaker introduction and background
3:35 agenda and performance basics
4:32 optimizing mysql configuration
6:31 choosing and optimizing storage engines
8:11 schema optimization principles
9:59 handling large datasets efficiently
15:07 advanced features and techniques
15:57 backup strategies for big data
21:25 tools and best practices
24:10 conclusion and feedback
  1. Conf42
  2. pharma
  3. discovery platform
  4. genai
  5. scale management
  6. integration
Рекомендации по теме
Querying 100 Billion 0:09:07

Querying 100 Billion Rows using SQL, 7 TB in a single table

Best Practices Working 0:13:41

Best Practices Working with Billion-row Tables in Databases

I Tried to 0:22:44

I Tried to Query 10 MILLION Rows in MySQL in 3 Seconds

Billions of Records 0:25:24

Billions of Records in MySQL: Lessons Learned | Lukas Vileikis | Conf42 Platform Eng. 2024

Billions of Records 0:00:39

Billions of Records in MySQL: Lessons Learned

I loaded 100,000,000 0:18:27

I loaded 100,000,000 rows into MySQL (fast)

How I add 0:11:03

How I add millions of rows to MySQL (for performance testing)

Your database will 0:00:51

Your database will break in 2038 (or much sooner) #database #coding #mysql

Secret To Optimizing 0:05:57

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

How Instagram Stores 0:11:39

How Instagram Stores BILLIONS of Videos

MySQL insert millions 0:12:02

MySQL insert millions of records faster

Databases: How to 0:02:20

Databases: How to handle billions of rows in MySQL for biometric project?

SQL : Mysql: 0:01:26

SQL : Mysql: 7 billions records in a table

Optimizing MySQL Very 0:02:26

Optimizing MySQL Very Fast Loading Billion rows from Client to Server

Databases: Deleting Billion 0:02:14

Databases: Deleting Billion records in a range vs exact ID lookup MYSQL (2 Solutions!!)

MySQL : How 0:01:09

MySQL : How to do a one-time load for 4 billion records from MySQL to SQL Server

Databases: How to 0:03:19

Databases: How to optimize mysql table of 2 billions rows?

MySQL : Most 0:01:47

MySQL : Most efficient way to search a database with more than a billion records?

Databases: Optimize mysql 0:01:46

Databases: Optimize mysql query, on table with 32 million records

5 Secrets for 0:08:12

5 Secrets for making PostgreSQL run BLAZING FAST. How to improve database performance.

How to scale 0:00:57

How to scale a web application to a million users in 10 steps

what will happen 0:04:43

what will happen while getting 1 lakh rows from database || mysql database || php api

Speed up MySQL 0:07:06

Speed up MySQL 25-100x with Indexing

improve performance of 0:01:55

improve performance of insertions using MySQL for 10 million records in 5 tables

Комментарии
Автор

Amazing Video! The Settings itself, no endless talk, everything on point and in the same time explained well!
Thank you Lukas! 😊😊😊

vasiovasio