For how long does it wait?
Is it 2 mins or hour ?
Can I remove old binlogs ?
Which generated by restore process ?
Want more from Mike?
For waiting for flush time column value is 16295
Is it 2 mins or hour ?
I think it would be seconds, not sure though
Then this should not be a problem at all
Check for disk space and wait till it ends
Thanks for reminding me
But I think the reference manual is good enough
https://downloads.mysql.com/docs/mysql-tutorial-excerpt-8.0-en.pdf
In this course, we’ll be looking at database management basics and SQL using the MySQL RDBMS.
Want more from Mike? He’s starting a coding RPG/Bootcamp – https://simulator.dev/
The course is designed for beginners to SQL and database management systems, and will introduce common database management topics.
Throughout the course we’ll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more.
You can get PopSQL to follow along here: http://popsql.com/freecodecamp
🔗Company Database Code: https://www.giraffeacademy.com/databases/sql/creating-company-database/
⭐️ Contents ⭐
⌨️ (0:00) Introduction
⌨️ (2:36) What is a Database?
⌨️ (23:10) Tables & Keys
⌨️ (43:31) SQL Basics
⌨️ (52:26) MySQL Windows Installation
⌨️ (1:01:59) MySQL Mac Installation
⌨️ (1:15:49) Creating Tables
⌨️ (1:31:05) Inserting Data
⌨️ (1:38:17) Constraints
⌨️ (1:48:11) Update & Delete
⌨️ (1:56:11) Basic Queries
⌨️ (2:08:37) Company Database Intro
⌨️ (2:14:05) Creating Company Database
⌨️ (2:30:27 ) More Basic Queries
⌨️ (2:26:24) Functions
⌨️ (2:45:13) Wildcards
⌨️ (2:53:53) Union
⌨️ (3:01:36) Joins
⌨️ (3:11:49) Nested Queries
⌨️ (3:21:52) On Delete
⌨️ (3:30:05) Triggers
⌨️ (3:42:12) ER Diagrams Intro
⌨️ (3:55:53) Designing an ER Diagram
⌨️ (4:08:34) Converting ER Diagrams to Schemas
Course developed by Mike Dane. Check out his YouTube channel for more great programming courses: https://www.youtube.com/channel/UCvmINlrza7JHB1zkIOuXEbw
🐦Follow Mike on Twitter: http://twitter.com/mike_dane
🔗The Giraffe Academy website: http://www.giraffeacademy.com/
—
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://medium.freecodecamp.org
But I think the reference manual is good enough
https://downloads.mysql.com/docs/mysql-tutorial-excerpt-8.0-en.pdf
Кирилл, try watching …
да я про английский…
Please, use only English here
This is what table data and I want sort In alphanumeric
Like this
this is imposible
You can try finding some smartass mysql builtin function for this , if it does not exist — this is impossible.
Recomendation:
Re-desing your DB, extract numbers in a separate, numeric field and use
order by fld1, fld2
2 tables A & B are having more than 1 million records.
While making Select by joining both on Key column to Foreign key, its executing but not using Indexes built on key columns,as Explain Plan shows. Its making Table scan taking long hours to complete. Around 1000 are added daily & 1000 updated daily.
2 tables A & B are having more than 1 million records.
While making Select by joining both on Key column to Foreign key, its executing but not using Indexes built on key columns,as Explain Plan shows. Its making Table scan taking long hours to complete. Around 1000 are added daily & 1000 updated daily.
You must show DDL and the query, to be answered
2 tables A & B are having more than 1 million records.
While making Select by joining both on Key column to Foreign key, its executing but not using Indexes built on key columns,as Explain Plan shows. Its making Table scan taking long hours to complete. Around 1000 are added daily & 1000 updated daily.
Probably it’s because you have different dates type for join columns in two tables or some unusual join condition, other then =
Select A.col1, A.col2, B.col3 form A join B on
A.col1=B.col1 and A.col5=B.col5
Index is built on col1+col5 on both tables. Both columns are alphanumeric, so data type is vadchar(128).