Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
MariaDB cluster Version : mysql Ver 15.1 Distrib 10.0.24-MariaDB, I have a two node + arbitrator cluster which is live and replicating data across nodes. Unfortunately we found some inconsistency...
Asked on 02/23/2021 by Rameez
1 answerHow often does Postgres or Mysql make the fsync call?Does Postgres or Mysql fsync for every write to the Write Ahead log?Does Postgres or Mysql fsync for every transaction? so...
Asked on 02/23/2021 by user1870400
4 answerI have two tables (Order and equipment) and they should be linked together by the order No. the SQL script is as the following:-- ------------------------------------------------------- Table `rr`.`order`-- -----------------------------------------------------CREATE TABLE...
Asked on 02/22/2021 by Ramy Khalifa
1 answerThe picture helps explain what I am trying to do. I know how to setup an SQL failover cluster, did it and it works perfectly. Here is my situation :...
Asked on 02/20/2021 by gfbaggio
0 answerHy, i want reduce my table and updating himself (group and sum some columns, and delete rows) Source table "table_test" :+----+-----+-------+----------------+| id | qty | user | isNeedGrouping...
Asked on 02/19/2021 by immobiluser
0 answerDatabase: MySQL I have a running app with concurrency transactions in it. I noticed that there are so many errors occur related to deadlock.The error saysSQLSTATE[40001]: Serialization failure: 1213...
Asked on 02/19/2021 by Ammar Faizi
3 answerWe currently have an issue with some queries/jobs causing non-yielding at a specific point in time. There no are mini dumps which are generated when this happens. Is there a...
Asked on 02/19/2021 by TitanL0rd
1 answerHow can I check if the structure of a foreign table was changed in the source database in order to know when to re import it. Foreign table was imported...
Asked on 02/19/2021 by Radu Dumbrăveanu
1 answerI know that the order of returned rows is not guaranteed with the IN statement in Postgres. For example if I do this:SELECT users.id FROM users WHERE users.id IN...
Asked on 02/18/2021 by Gandalf StormCrow
2 answerI have backed up several Microsoft SQL Server databases to a single media set (.bak file). I have uploaded the database to S3 and am now trying to restore the...
Asked on 02/17/2021 by Caltor
1 answerGet help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP