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

MySQL Installation: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

Tried to install MySQL on Ubuntu, with these 3 commands:sudo apt updatesudo apt install mysql-servermysql_secure_installationWhen running the last command, it asks for the password for the root account. After...

Asked on 01/25/2021 by rdrgtec

1 answer

Limiting join to top 1 row for each row

I'm trying to join two tables and filter join results but I couldn't manage it and I'd appreciate any help. I have these row sets:Table Aid | userid |...

Asked on 01/25/2021 by dstr

2 answer

How to move SSISDB database

I have a SQL 2016 instance installed. It has SSISDB for SQL server integration services installed. Now because it is taking up all the space on our system drive, I...

Asked on 01/24/2021 by Jac

2 answer

Ident authentication failed for user "postgres"

I am using PostgreSQL12 on Cent0S8, and I am able to connect to PostgreSQL using the command:sudo -u postgres psql However, when I attempt to connect using:psql -U...

Asked on 01/23/2021 by Lloyd Thomas

1 answer

Creacte Mysql Database copy

I need copy full database in MySql but cant to do this. I trymysqldump db_name | mysql new_db_nameIts work, but DB so big and this comand need 5Gb+ in...

Asked on 01/20/2021 by Viktor Mandrika

1 answer

What are minimum configurations for mongodb replica set though a java program

I'm new to morphia. I'm using morphia and mongo-java-driver.jar to talk with replicaset(I need for cluster also) through a java program. I'm new to morphia. Wrote a sample program code...

Asked on 01/18/2021 by Narendra

1 answer

Solving intra parallel query deadlocks

We are experiencing deadlocks in our production environment. Seems to be the victim and winner are the same spid's. We rebuild/reorganize indexes daily and we dont find any missing indexes....

Asked on 01/14/2021 by din

1 answer

Fetching Remote Encryption Key for MariaDB

I've set up encryption at rest for MariaDB but I can't seem to get my key fetching service to fetch the key. I have the following fetch script and a...

Asked on 01/14/2021 by Vince Kronlein

1 answer

A database differential backup without a full backup

At 10 pm, I scheduled a SQL Agent job to do a daily backups with the schedule:Daily Full: 22:00Differential: Every 4 hoursLog: Every 30 minutesNow when I check my backup...

Asked on 01/14/2021 by Nico M.

2 answer

Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade

In mysqld.log I have thousands of lines like:Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgradeSo, according to virtually every post on the matter...

Asked on 01/13/2021 by Roy Hinkley

3 answer

Ask a Question

Get help from others!

Database Administrators : Recent Questions and Answers (Page 32)

Ask a Question