Mysql Waiting for level lock fix, solved! Myisam tables, and memmory tables

  Рет қаралды 7,590

Learn Php with Matt

Learn Php with Matt

Күн бұрын

This video is a solution how you can fix your waiting for table level lock.
Simle and easy solution for every body!
Watch the previous video about how you can optimize and configure your mysql to be as fast as hell.
Here is the link to that video : • Slow mysql Query? Make...

Пікірлер: 4
@kevindelrosario2717
@kevindelrosario2717 4 жыл бұрын
you saved me from the app i created, i configured my mysql innodb settings, i though it will already work after that, i didnt know that it needs the tables to be configured to use innodb as storage engine
@shkoqader3518
@shkoqader3518 4 жыл бұрын
Thank you for your diligent work.
@kevindelrosario2717
@kevindelrosario2717 4 жыл бұрын
teach me more pls, very helpful
@raffusbr
@raffusbr 3 жыл бұрын
you need to specify the Engine=innodb when creating your tables, or you will have to edit current table and change the engine.
This is why understanding database concurrency control is important
9:05
Motorbike Smashes Into Porsche! 😱
00:15
Caters Clips
Рет қаралды 23 МЛН
Кто круче, как думаешь?
00:44
МЯТНАЯ ФАНТА
Рет қаралды 5 МЛН
СКОЛЬКО ПАЛЬЦЕВ ТУТ?
00:16
Masomka
Рет қаралды 3,2 МЛН
HOW TO LOCK TABLES IN MYSQL?
21:31
KnowledgeForAll
Рет қаралды 1,8 М.
Slow mysql Query? Make your Msqyl Fast and faster!
44:09
Learn Php with Matt
Рет қаралды 33 М.
mysql locks explained
6:35
Execute on Command
Рет қаралды 21 М.
Use MySQL EXPLAIN for Query Optimization
17:19
High-Performance Programming
Рет қаралды 60 М.
Row-Level Database Locks Explained - (Read vs Exclusive)
8:21
Hussein Nasser
Рет қаралды 33 М.
eCommerce Database Design: Diagram & Explanation
16:06
Database Star
Рет қаралды 149 М.
How to Design a Database
10:57
Database Star
Рет қаралды 70 М.
Next-gen SQL projects with Microsoft.Build.Sql
29:31
dotnet
Рет қаралды 8 М.
What is OpenTelemetry?
12:55
Highlight
Рет қаралды 12 М.