All Questions

Filter by
Sorted by
Tagged with
0
votes
0answers
2 views

mysql threads running high issue for Percona Mysql 8.0.16

we are experiencing a threads running high issue mysql> show global status like '%buffer_pool%' -> ; +-----------------------------------------+--------------------------------------------------+ ...
2
votes
3answers
13k views

Error during Oracle database 12c Release 1 installation

I am trying to install Oracle database 12c on Oracle Linux 7 version. But it is keep on failing with the below error. [INS-30131] Initial setup required for the execution of installer validations ...
1
vote
1answer
9 views

Schema changes on sharded database

I have performance issues with one particulary large table, 500+ Million rows, 300Gb data, Postgres 10.5. It is already partitioned. I am working on optimising it here and there, but that is not ...
0
votes
1answer
179 views

connecting to an oracle sql database from sql developer on the same computer. When the computer is a domain computer

Hi I am trying to do DBA course that requires that I use Oracle database. I am using my corporate pc to do it. I set up the loopback adapter to enable localhost communication and setup the hosts ...
1
vote
1answer
39 views

Invoke-SQLCMD with special characters

I'm currently working on a project integrating AD with SQL Server data, which I am handling mainly via powershell (Invoke-SQLCMD in particular). The issue I'm running into is if someone has a special ...
1
vote
5answers
47 views

“History-based” database design approach?

A few years ago I've stumbled upon a database design approach, but I can't find any information on this for the love of my life. Its main feature was normalizing tables in a way where every "property"...
1
vote
1answer
33 views

postgresql pg_dump out of memory

is it possible to limit somehow usage of resources for pg_dump? The problem is, whole DBase is 775GB and i have two very large tables: pg_largeobject table is – 390GB pg_largeobject statistics: ...
0
votes
1answer
9 views

How to get all the data before the current date and data for the next 3 days from current date.DATEDIFF(now(),d.tentative_date_of_return) <= now() + 3

SELECT DISTINCT d.name AS "ID:Link/Demo Request:120", d.requester_name AS "Requester Name:Data:190", d.customer_name AS "Customer Name:Data:250", d.date_of_request AS "Date Of Request:...
0
votes
1answer
16 views

Is it safe to leave/exit the stored procedure without commit or rollback on a transaction?

Like the code below is it safe to do that? create definer=`root`@`%` procedure `test`() label: begin declare exit handler for sqlexception rollback; start transaction; select condition from table ...
0
votes
0answers
2 views

Why is it necessary to run both mongod and mongo.exe in windows? What's happening behind the scene?

Why is it necessary to run both mongod and mongo.exe in windows? What's happening behind the scene? What's the difference between these two?
0
votes
1answer
187 views

How to find the most common phrases in a MySQL database

I have a table which contains articles on movies. Each article has a title and many of them have common phrases in them. I would like to do some analysis on the data and extract these common phrases ...
0
votes
1answer
182 views

SQL Server 2012 AlwaysOn Availability Group

We have an application that needs access to the database all the time to work properly and we are planning on deploying SQL Server 2012 AlwaysOn Availability Groups on Windows Server 2012. We have ...
1
vote
0answers
9 views

Script to find a range of ASCII characters in SQL Server

I am using some scripts from another topic, but the accepted answer isn't working for all my data scenarios. I would have asked my question on the original How to check for Non-Ascii Characters post, ...
1
vote
1answer
164 views

SQL - Update certain database records with a loop

I have a certain IDs in a table that I would like to change a column value from false to true. How can I do a loop that goes through the specific IDs given and changes a column value from false to ...
2
votes
0answers
12 views

How do I solve the following error on attaching ldf-less database in SQL Server?

Before you write about the dangers of not having backups, etc., please withhold judgement... perhaps I just inherited the problem? I have an .mdf which which I am trying to attach to SQL Server 8. I'...
2
votes
1answer
193 views

TokuDB table stats row count decreases to 1

I have a few Percona 5.6.30 servers with a TokuDB table that has ~120 million rows. On some of these servers, row count in SHOW TABLE STATUS mysteriously decreases until is hits 1. This is accompanied ...
0
votes
2answers
13 views

Mysql: slave read binlog from local storage

I am running master-slave replication, Can I manually move binlog files from the master server to the slave and make the slave read them locally? I am willing to do so because I am running out of ...
0
votes
2answers
32 views

Mysql: Is it possible to handle 1000 concurrent while having low cpu?

We're running Centos 7, we're in the process Mariadb 5.5, upgrading to 10.3 today. PHP 5. The queries are bad, and there are far too many of them to optimize, but I'm trying what I can, the database ...
0
votes
1answer
138 views

SSRS Configuration

I'm trying to configure SSRS to use email subscription feature. This SSRS server is hosted on AWS and I have an SMTP relay to use. This SMTP relay requires an userid and password to authenticate. I ...
0
votes
0answers
10 views

How to auto increment value in mysql

i have age column in MySQL database. So my question is how can i increase the age value by 1 every time a year passed. For example this year the age value is 20 and the next year the value will be 21. ...
0
votes
0answers
24 views

Mysql vsz keep growing until OOM

cat /etc/redhat-release CentOS release 6.5 (Final) thread variables join_buffer_size 4k read_buffer_size 2k read_rnd_buffer_size 4k sort_buffer_size 4k key_buffer_size 2k tmp_table_size 64M ...
2
votes
2answers
113 views

Using CONVERT TO CHARACTER SET for changing only collation?

I think the answer to this is an obvious yes, but I'm having trouble finding confirmation on it. All the questions related to charsets seems to be about changing the charset and not only collations. ...
0
votes
2answers
85 views

Auto scaling MongoDB as a service in Microsoft Azure

I see a MongoDB service in Microsoft Azure but that deploys a VM and installs MongoDB in that. I am guessing this will not auto scale and also charge me for the entire VM and MongoDB management (not ...
0
votes
2answers
29 views

Error messages while migrating from Oracle to MSSQL

I got these error messages when migrating from Oracle to MSSQL (Unfortunately, the error messages are in German languages) Verletzung der PRIMARY KEY-Einschränkung "DTR_PK". Ein doppelter Schlüssel ...
1
vote
2answers
437 views

postgres pg_upgrade 9.2 to 9.5 problem

I'm trying to upgrade from 9.2 to 9.5 using the pg_upgrade tool. I'm using CentOS 7.0 current postgres bin folder: /opt/rh/postgresql92/root/usr/bin new postgres bin folder: /opt/rh/rh-postgresql95/...
2
votes
2answers
488 views

Delete records if not present in subquery

I want to delete records from a table that are not found in a subquery. But it's not having the desired result. The table has multiple rows per SKU. Each price row has a valid_from and valid_to date ...
1
vote
1answer
50 views

SSMS login by external developers

This is my first question so please bear with me ! We have an external company whose developers need to login into an instance on our on-premise SQL Server 2016. They have AD logins, and these are ...
0
votes
1answer
15 views

Mongo: mongodump and the config database error

I've setup a backup script on my Ubuntu box using mongodump. However this currently doesn't work because of an error when attempting to dump the built in config database: (Apologies for the image, I ...
0
votes
1answer
107 views

error 15466 An error during decryption

I have a stored procedure that runs xp_cmdshell with a user with sysadmin right.(it was created by someone else long time ago). For security purposes I need to remove the sysadmin right from this user....
-1
votes
0answers
9 views

Find the functional dependencies and decompose this table if necessary into a lossless third normal form design

Each hotel has several room types (e.g. singles, doubles, doubles with views). For that hotel and room type, there are a certain number of rooms available and the room type has a description for that ...
0
votes
1answer
15 views

purge worker, purge coordinator, shutdown handler stuck

I can't make out if the following is a problem or not, and what the solution might be. show processlist; +--------+------------------+-----------+-------------------+---------+------+-----------------...
0
votes
1answer
36 views

Computed Columns - SQL Server Function

I'm looking to improve overall SQL performance of a customers application. On each table of the application, there is a computed column, that uses GETUTCDATE and a combination of three columns on that ...
3
votes
3answers
83 views

Query slow when using function in the WHERE clause

This is fast (49ms): v_cpf_numerico := ext.uf_converte_numerico(new.nr_cpf); select cd_cliente into v_cd_cliente from central.cliente where nr_cpf_cnpj = v_cpf_numerico; This is slow (15 seconds): ...
0
votes
2answers
20 views

To fetch Data from a table column value as Column into 3 categories [on hold]

Example Table: Result Table: Could you please help me on this, so that I can get exact result what I'm expecting to get? Please any one of you can look into this? I'm able to get the results using ...
0
votes
2answers
97 views

Running a task without waiting for the results in Postgres 11 on RDS

I've got a question about spawning stand-alone threads on Postgres. Here's what I'd ideally like: Have a postgres-side solution to automatically launch tasks on a schedule in their own threads. ...
0
votes
2answers
1k views

Disable Binary Logs in MySQL 8.0

How can I disable binary logging on MySQL 8.0? I am needing to import a large MySQLDump file, and don't want to fill the Binary logs with many GB of data. In the past I would have set log_bin=0 in ...
1
vote
2answers
414 views

Partial copy of huge database

I have started working in a project which has a big database, around 300GB. For security reasons I can not access database from my local web app. So I need to copy last 100,000 from each table. To ...
3
votes
3answers
318 views

Mysql - Average price for top 10% cheapest volume (algorithm help)

My question is very similar to this but not the same. The table is the same: rows with ID, volume, and price. In short, I need an SQL query that will give me the rows with the lowest prices whose sum ...
1
vote
0answers
23 views

Is the table designer not supported for memory optimized tables?

If I right click a table, I get the normal designer option: But if I right click a memory optimized table, the designer is missing: The server is 2016 and I've tried it in SSMS 16, 17, and 18.3. Is ...
0
votes
1answer
24 views

Problem with writing data to MySQL database

We have a problem with peak loading while writing data to database This is example of error SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction SQL: insert ...
0
votes
1answer
261 views

MYSQL Patching -Roll back

MYSQL patching. I took all database backups before starting patching. If we patch mysql 5.6.30 to 5.6.32 and if we want to rollback to 5.6.30 due to some issues. Can we do that? if so should we have ...
0
votes
1answer
197 views

enable log_bin_use_v1_row_events in mysql 5.6

I have a MYSQL master with two slaves also running MYSQL 5.6. I want to create another slave and that needs to be MYSQL 5.5. I was wondering if replication will work smoothly. I have ...
0
votes
0answers
25 views

Operator used tempdb to spill data, spill level 1

I have a query which is spilling to tempdb. I understand that the cardinality estimates are wrong and causing this spill. I've read few articles that mentions updating the statistics and rebuilding ...
-1
votes
1answer
23 views

Oracle data file size

My client’s tablespaces are autoextend off and i add monthly or bimonthly 3 or 6 gb space for tablespaces. Can you advise me if there is a recommended datafile size for Oracle 11gR2 on Windows 64 Bits?...
4
votes
2answers
107 views

Will one SQL instance work whilst the other 2 are patched?

My change request to patch 3 SQL instances on the same server was denied because of one instance - they say a server reboot is fine, but not a few hours downtime. Seeing as each instance is ...
-1
votes
0answers
19 views

Database for real-time cryptocurrency exchange webapp [on hold]

Which database we should choose for an application of cryptocurrency exchange system like Binance? This exchange system needs to be real-time on database changes and have to handle so many money ...
0
votes
0answers
29 views

update trigger insert only if value is different

i have some gps modules that send data to my database. On update of the last package sent i want to compare new values with old values and insert into a new table only those values that are diferent. ...
0
votes
0answers
60 views

exceeds the maximum allowed database size when export database oracle 18c

I have worked on Oracle Database 18c Express Edition, while I try to export database schema by using expd command, I have an issues ORA-12954: The request exceeds the maximum allowed database size ...
0
votes
1answer
156 views

DB2 importing/replacing fields from a file that contains XML

In two tables I have a column called table1.column_xml and table2.column_xml_2 defined as CLOB(1000000). The fields in the column contain XML formatted information like below column_xml ...
0
votes
2answers
29 views

SQL Server 2014 DELETE with OUTPUT

Why would I get an 'incorrect syntax' error with this (on the OUTPUT keyword): DELETE tb FROM dbo.TransactionBatch tb OUTPUT Deleted.TransactionID INTO #TransactionIDs INNER JOIN @...

15 30 50 per page