Does anyone have any idea of how much space does indexing needs depending the size of the table in mysql?

I mean, videos or files etc..

Download courses from Torrent. Use vpn

Thanks a lot!

Oh, thanks a lot for your support and encouragement! This is the best channel/group that I’ve ever had in my Telegram life.

Hello, do u have doc for MySQL replication?

Nope. I’d be glad to receive if you’ve any kinda so-related things to share.

https://dbaprakash.wordpress.com/2016/03/26/mysql-replication-documentca/

I got

Team, can any one advise on below error
Table is marked as crashed and should be repaired

How to get it crashed table

For example by turning the power off while it runs or by moving a big magnet back and forth along the main DB disk…

Probably corrupted
If myisam then repair it
If Innodb try to perform force recovery

Is it myisam or innodb?

Mysqlcheck can help

Server is starting or not?

Thank you so much friends, I’ve fixed using repair on corrupted table. Now it’s working

Hi guys..
Does anyone check if my er diagram has a logical problem or not?

This is actually not possible without knowing much about the subject area.

Hi i

The table:
————————–
| id | nick | top | time |
————————–
Top-20 voters by total in month time range
SELECT
`nick`,
COUNT(*) AS `total`,
MAX(`time`) AS `lastvote`
FROM
`voters`
WHERE
`time` > $thismonth
GROUP BY
`nick`
ORDER BY
`total`
DESC,
`lastvote`
LIMIT 20
Illegal duplications where nick top, time are the same
SELECT
`nick`,
`top`,
`time`,
COUNT(*)
FROM
`voters`
GROUP BY
`nick`,
`top`,
`time`
HAVING COUNT(*) > 1
How to subtract second query COUNTS from first query total by nick

hi , how structure is good for online chat database?
can everybody help me?

It depends on chat’s functionality

Guys i am beginner can anyone tell me the meaning of line number 5 up to line 8

Column id, integer value, which is the primary key

It is columns definition

Ok thanks so what is the meaning of varchar(30)

Read about mysql data types

Ok thanks

Each line is
Field name, data type and optional null/not null flag and then optionally an inline constraint definition

Is there anyone who have better notes for it so that i can study using them

The thing is you wouldn’t learn something if you would have not your notes, but I swear you will learn it right after you make your own.

Hello guys nice to meet you all

i wanna ask something. I have this query and the result table. Then I wanna make case syntax where avg_score > 90 then A, avg_score 70-90 then B, and else C. How should i write the query?

Is it recommend to increase the innodb_lock_wait_timeout variable for bulk inserts or updates from the default value? I am getting this error ‘lock wait timeout exceeded; try restarting transaction’

this is incorrect query.
Wrong GROUP BY

https://dev.mysql.com/doc/refman/5.7/en/case.html

https://www.mysqltutorial.org/mysql-case-function/

no.

Okay i will check it out. Thanks!

Why so? Can I not increase it to say 120 sec instead of default 50 sec.
What is the other solution for the mentioned error?

You can increase it, but this will not help anything

The solution for your error is written in your error message: restart your transaction.

Off business hours it’s not possible to get up and restart the transactions restarting is very straight forward. I need performance or optimization related soultion so that this doesnot happen repeatedly

If not, you should dig into details, this is actually a deadlock, you should find this situation out, analyze, and probably only then it will be possible to fix or avoid this situation.

Hello All,
Storing LOBs in DB is an issue, what options MySQL offer to store them outside of DB and does not affect db performance.

Does anyone have any idea of how much space does indexing needs depending the size of the table in mysql?

MySQL offers to store blobs outside the DB, or inside the DB.

This is unpredictable this way.
This depends on the size of the fields wich go into the index and the size of the primary key, and the number of rows in the table.
Does not depend on the size of the table in bytes.

Hello All, I am trying to provide select access on information_schema to user, it is giving error access denied for user root@localhost to database information_schema..

I hope from root user it wouldn’t throw this error as it is having super privilege..

Please help me on this