dba - Related information

  • Data not Synchronize problem in xtrabackup backup

    there are three existing servers (all mysql5.7 installed by centos7,): br 10.19.6.6 BRV 192.168.3.101 CRAV 192.168.3.102 use xtrabackup to back up A s MYSQL data, then restore to B A s database to deactivate, and B updates the primary database d...

  • Problems with mysql indexing

    problem description take over a new database, today found table data 50G, and then various indexes 75G, of which three large indexes are each around 23g, and most of the large indexes are bound to timestamps. what result do you expect? What is the e...

  • Mysql master-slave replication exception

    for example, in the master-slave replication architecture of mysql, SQL threads often fail to execute and lead to replication being stranded. I want to know how people generally deal with this situation ...

    Jun.15,2021
  • Is there a relational database suitable for working on solid state drives?

    High performance MySQL (3rd edition, 1st edition, May 2013) on page 390, it is mentioned that the current generation of RDBMS technology has been optimized for mechanical hard drives for decades, and the same mature and in-depth research work has not re...

  • MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
    MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1bdc5e7-3130c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
    MySQL Errno : 1021
    Message : Disk full (/tmp/#sql-temptable-64f5-1bdc5e7-3130c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
    Need Help?