Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
I'm setting up a ManageIQ appliance for development. When I updated the 'v2_key' encryption key to be same as production, my db connection croaked. Initially I got these...
Asked on 12/13/2020 by mike_butak
1 answerI have brand new mysql 8 setup and installed on a centos 7. Unfortunately I forget to set innodb_file_per_table. I would like to dump the database and recreate with the...
Asked on 12/12/2020
0 answerI'm attempting to connect to my MySQL Database using the Connection Method "Standard TCP/IP over SSH". I filled out all the SSH and MySQL connection details correctly, however I get...
Asked on 12/12/2020 by michelle
1 answerI have two sql server(SQL2016) Production-1 and Production-2 under one cluster with same database.I need real-time sync between both databases simultaneously like what ever changes in either A or B...
Asked on 12/11/2020 by Rai Micheal
3 answerThe documentation https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-dump-instance-schema.html mentions that the min chunk size is 128kB. What is the maximum possible chunk size?...
Asked on 12/10/2020 by Mihir Rane
1 answerI have a postgresql database snapshot with the following structureid (integer / autoincrement)address (varchar)balance (integer)datetime (date) CREATE TABLE public.snapshots( id integer NOT...
Asked on 12/08/2020 by mouchin777
0 answerI have some sql agent jobs that are using Windows NT Integrated Security to run (as specified in the Maintenance Plan's Manage Connections window)...eg. Translog backups. While logged in as...
Asked on 12/07/2020 by Chad Richardson
1 answerYesterday I achieved a 500x performance boost after rewriting an EXISTS with IN. I did some investigation to find out why and finally came to the following example. Basically, we...
Asked on 12/07/2020 by nalzok
0 answerI have table where one of the fields is JSON array. I need to append received JSON array into that field without overriding existing values. Something like that:CREATE OR...
Asked on 12/07/2020 by genichm
3 answerIs storing them in a CUBE type field and then getting euclidean distance, (using <->) the only way? I can not save them as a list of...
Asked on 12/07/2020 by misterghost
1 answerGet help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP