Which generated by restore process?

|
2019-09-12 11:14:03
MasterZiv 2019-09-12 11:12:56
For how long does it wait?

For waiting for flush time column value is 16295

2019-09-12 11:14:26
And for insert 7217
MasterZiv 2019-09-12 11:14:59
2019-09-12 11:14:03
For waiting for flush time column value is 16295

Is it 2 mins or hour ?

2019-09-12 11:15:54
MasterZiv 2019-09-12 11:14:59
Is it 2 mins or hour ?

I think it would be seconds, not sure though

MasterZiv 2019-09-12 11:16:25
2019-09-12 11:15:54
I think it would be seconds, not sure though

Then this should not be a problem at all

MasterZiv 2019-09-12 11:16:59
2019-09-12 11:15:54
I think it would be seconds, not sure though

Check for disk space and wait till it ends

2019-09-12 11:25:10
MasterZiv 2019-09-12 11:16:59
Check for disk space and wait till it ends

Thanks for reminding me

2019-09-12 11:25:36
Binlog filesystem was full
2019-09-12 11:25:57
Can I remove old binlogs ?
2019-09-12 11:26:22
Which generated by restore process ?
2019-09-12 11:26:53
I completely missed it to check
smlkw 2019-09-12 13:49:40
I need MYSQL self paced video tutorials. Can any one suggest me
kiril_d1 2019-09-12 13:57:40
You can try to watch this tutorial

But I think the reference manual is good enough
https://downloads.mysql.com/docs/mysql-tutorial-excerpt-8.0-en.pdf

SQL Tutorial – Full Database Course for BeginnersYouTube
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

MasterZiv 2019-09-12 13:59:40
kiril_d1 2019-09-12 13:57:40
You can try to watch this tutorial

But I think the reference manual is good enough
https://downloads.mysql.com/docs/mysql-tutorial-excerpt-8.0-en.pdf

Кирилл, try watching …

kiril_d1 2019-09-12 14:00:40
Actually, I haven’t watch this )
MasterZiv 2019-09-12 14:01:06
kiril_d1 2019-09-12 14:00:40
Actually, I haven’t watch this )

да я про английский…

smlkw 2019-09-12 14:01:45
MasterZiv 2019-09-12 14:01:06
да я про английский…

Please, use only English here

Suresh 2019-09-13 10:15:26
mysql_en-105.jpg
This is what table data and I want sort In alphanumeric
Suresh 2019-09-13 10:15:50
mysql_en-108.jpg

Suresh 2019-09-13 10:15:58
Suresh 2019-09-13 10:15:50

Like this

MasterZiv 2019-09-13 11:07:46
Suresh 2019-09-13 10:15:26
This is what table data and I want sort In alphanumeric

this is imposible

MasterZiv 2019-09-13 11:09:22
Suresh 2019-09-13 10:15:58
Like this

You can try finding some smartass mysql builtin function for this , if it does not exist — this is impossible.

piterden 2019-09-13 11:13:06
REGEX_REPLACE
Suresh 2019-09-13 11:13:36
Ok
MasterZiv 2019-09-13 11:16:58
Suresh 2019-09-13 10:15:26
This is what table data and I want sort In alphanumeric

Recomendation:
Re-desing your DB, extract numbers in a separate, numeric field and use

order by fld1, fld2

RitsyIsRisky 2019-09-22 12:01:30
anybody here????
RitsyIsRisky 2019-09-22 12:11:01
i work on dynamic content with mysql in php
RitsyIsRisky 2019-09-22 12:11:56
i make database and i write code in php. but there is problem arise in connection establishment
RitsyIsRisky 2019-09-22 12:12:30
dont know why there is no establish connection
RitsyIsRisky 2019-09-22 12:12:39
i write correct code
piterden 2019-09-22 12:13:00
No, your code is incorrect
RitsyIsRisky 2019-09-22 12:24:14
mysql_en-134.jpg

piterden 2019-09-22 12:24:19
So do you have a working example
piterden 2019-09-22 12:25:01
It’s a bad idea to make photos of your monitor
piterden 2019-09-22 12:25:30
Why don’t you just copy and paste it?
RitsyIsRisky 2019-09-22 12:26:10
code is in my lappy. not in my phone
piterden 2019-09-22 12:26:30
And what?
piterden 2019-09-22 12:42:26
https://www.php.net/manual/en/mysqli.quickstart.connections.php
piterden 2019-09-22 12:42:54
@Ritsy4 have you read it?
2019-09-22 15:35:42
My slave is running behind master around 350000 seconds, while SQL and io threads are running
2019-09-22 15:36:01
But it is not writing anything in binlogs
2019-09-22 15:36:21
What I need to check
2019-09-22 15:36:53
I more thing to note is seconds behind master is continuously increasing
2019-09-22 15:45:52
Hi Denis
2019-09-23 06:01:48
Have a peculiar issue.
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.
2019-09-23 06:02:56
Any idea why indexes are not being used.
MasterZiv 2019-09-23 06:03:11
2019-09-23 06:01:48
Have a peculiar issue.
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

2019-09-23 06:04:39
Right now I can’t, but will share query later.
MasterZiv 2019-09-23 06:10:10
2019-09-23 06:01:48
Have a peculiar issue.
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 =

2019-09-23 06:15:00
Query is like,
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).
|