MySQL (EN)

Good evening everyone, I have a question, I installed MySQL Server version 5.6.31 and created a database named microbill in it, my question is, if there are problems with the ...

How to activate Mysql server logs, for example the Test User made a change to the table structure, or the Test user changed the X or Y Record??

Who has used rsync before?

Hello everyone, I am starting to learning SQL and trying to find a tool to code in online without installation SQL client directly on PC (cuz im studying on work and doesn't h...

When I am running my query it is taking time to create sort index, After that my result is coming. How to reduce time for sorting Index. Is there any change in configuration o...

hello, can someone help me, how can i insert many colums at once using sqlalchemy?

Hello! I'm a novice with mysql and I found myself in an unpleasant situation. current danger state: db3_leader and db4_replica original correct state: db3_replica and db4_lead...

You have not included a critical information Are all tables InnoDB or do you have MyISAM as well?

you are indian, right?)

what are you trying to achieve? start slave all; show all slave status; replication errors will be there. but basically, if slaves don't start - restore from backup. skipping...

Sharding is possible on same node with different db?

wanna buy some?

Hi All, How to check mysql db load for prior dates? in azure? or any helpful query?

Does anyone have a good link to learn SQL MySQL for DBA? please send

I picked up the replica from the backup, indicated the binlog file number and position is 0. Used the command changed master to.... then slave start And now I have YES for Sla...

Hi all! Tell me a way to transfer a large mysql database, say 600 GB, to a new server? If you use mysqldump it takes a long time, what other reliable methods are there?

There are several Docker containers with a database and PHP. Passwords for the database are passed through environment variables from Docker Compose. When I access the page, s...

Засыпаю и тут мозг сгененировал нубский вопрос. Если отключаю автокоммит, то я могу к этому моменту откатиться с помощью rollback? При отключенном автокоммите неявно обьявляет...

What can you recommend to transfer data from one table to another using INSERT INTO new_table SELECT * FROM original table WHERE .... So that a network break would not break ...