Database Administrators Questions, Problems & Solutions : TransWikia.com ~ Page 27

MongoDB: Mongoimport server selection error , connection refused, too many files open

Trying to insert several JSON files to MongoDB collections using shell script as following,#!/bin/bashNUM=50000for ((i=o;i<NUM;i++))do mongoimport --host localhost --port 27018 -u 'admin' -p 'password' --authenticationDatabase 'admin'...

Asked on 10/27/2021 by Erwin Zangwill

1 answer

15 seconds to insert a single row in MYSQL 5.7 (happens occasionally)

I'm seeing very sporadic slow queries in MYSQL, at least, that's where Datadog is suggesting the issues are. I have, for example, 5 queries out of 726K traces (both selects...

Asked on 10/27/2021 by patrickdavey

3 answer

Migration from Postgres to MySQL using MySQL Workbench (Error in Reverse Engineering catalog. A task has failed while execution)

When I am trying to migrate database from Postgres to Mysql, I am facing an error in the Reverse engineering source step in which the log showsStarting...Connect to source...

Asked on 10/27/2021 by akhilesh kedarisetty

0 answer

is it possible to populate a primary key of a table based on a column of another table?

I have a table that contains a text-type column(for example graph path : 12 5 7 19 30 ..) and I want to split this text by space and put...

Asked on 10/27/2021 by d4bbi

1 answer

Changes access method for non-correlated subquery

Oracle 11g R2 Unfortunately our application has per row security "features".We have a query that looks about like this: Bad, slow:SELECT someRow, someOtherRowFROM bigTableA aWHERE EXISTS ( ...

Asked on 03/02/2021 by rfusca

2 answer

MySQL Error Code 3019 (Undo Error Log, no space left)

I'm trying to remove some data to get some extra free space, but running the "DELETE FROM table ..." query gives me this error:Error Code: 3019 Undo Log error: No...

Asked on 03/02/2021

1 answer

Restart ORACLE OHAS without restarting databases

looks like ohasd is getting to much memory (memory leak or something) that cause heavy swapping, is it possible to restart OHAS (till patch is applied) without bouncing databases? "crsctl...

Asked on 03/01/2021 by Mikhail Aksenov

1 answer

Postgres - Find index order ASC or DESC

Im trying to list all the indexes in my Postgres along with their order like ASC or DESC. I found some great answers from this StackOverflow question. But unfortunately,...

Asked on 02/28/2021 by Bhuvanesh

1 answer

How can I check my config files my.cnf for example

I have 2 config files, master.cnf and slave.cnf, each containing a group [mysdql0] or [mysqld1] respectively. I have an almost identical setup across different servers and all but one work...

Asked on 02/27/2021 by plisken

0 answer

Make two different updates with two different where conditions

Although this question is very similar, I don't think that it is also the best approach for my case, though it seemed to work. Consider the following example:CREATE...

Asked on 02/25/2021 by DevelJoe

2 answer

Ask a Question

Get help from others!

Database Administrators : Recent Questions and Answers (Page 27)

Ask a Question