0
votes
0answers
5 views

MySQL - Pending flush list, aio write, and the innodb_use_native_aio parameter

I'm running an Amazon RDS instance with MySQL 5.5. The applications using that are very write intensive, and there's over 1TB of data. Everything was fine until a recent minor version upgrade and ...
0
votes
0answers
12 views

SQL - Cannot Add Foreign Key Constraint

Can anyone tell me why there are errors such as : Cannot Add Foreign Key Constraint And am i on the right track ? DROP DATABASE technology_university_hospital; CREATE DATABASE ...
0
votes
0answers
7 views

Confused about Primary Keys, and Foreign Keys

Im brand new to database design and, I'm slightly confused about Primary Keys, and Foreign Keys and my database design. Context: I'm working on a database of museums and Categories will be one way ...
0
votes
1answer
11 views

How Much should increase the Innodb Buffer Pool Size acording to the following?

I need some help I found out that my mysql server only have configured 128M for innodb_buffer_pool_size , that is not enough considering that i have a 8G Ram server that hosts the mysql server and an ...
0
votes
1answer
19 views

Moving a large MySql database(Over 15 GB) from server to server mysqldump

I need to move a mysql database that is about 17 GB that is on a Cpanel/Centos based server that I do not have root access, to a Centos server that I have full root access. I do have limited SSH on ...
0
votes
0answers
9 views

Most used tables in MySQL database server

Can somebody please help me with a query that lists the most used tables in a MySQL database? Or how can i find out the most used tables in the database? Thanks
0
votes
0answers
11 views

Working out validity of table relationship

Question Background: In a quest to improve my skill set with TSQL programming I'm designing a 'simple' database schema for a zoo. In all I currently have 4 tables but am having an issue working out ...
0
votes
0answers
7 views

Using mysql cursor data to do something for each row

I have a table 'incoming_sms' and another table 'subscribers_register' and another table test_subject'.Some of the subscribers in the tablesubscribers_registerhave sent in some sms and the messages ...
0
votes
1answer
14 views

Benchmarking MyISAM vs InnoDB using Sysbench on MariaDB-10.0.14

I performed a "read" benchmark on MariaDB-10.0.14 db server using sysbench to compare performance between InnoDB and MyISAM on a single. Below are the sysbench commands i used: Create test table in ...
1
vote
0answers
10 views

postgres partial db dump/restore

A part of my database (PostgreSQL 9.3) relies on extra tables (ex. County, City, Town, ... ) I don't manage these tables, they are updated regularly. Each time I get a full dump, but I have a hard ...
0
votes
1answer
53 views

What is fragmenting my index on a table with stable traffic?

I am using Ola Hallengren's solution for optimizing indexes. I run it on Sunday every week. For the last three weeks every time it runs it reports that the clustered index on the database's biggest ...
0
votes
0answers
16 views

PostgreSQL procedural languages overhead (plpython / plsql / pllua…)

I'm trying to find information about PostgreSQL user defined functions in procedural languages performance for real time tasks. How does they compare to builtin functions? Is there any difference ...
0
votes
0answers
16 views

Trying to map postal codes to their respective cities, but running into some issues

The Problem I am creating a database of Countries, Regions, Cities and Postal Codes. Here's an example to give an idea of the database structure as it is now: Now, let's take Tuskegee University ...
0
votes
0answers
28 views

MDF/TempDB Growth, SQL Server 2005 Enterprise

Here's my scenario: SQL Server 2005 Enterprise Records from Database A being added to Database B Size of Database A MDF file: 3.15 GB I have separate drives for Data, Logs, and System. I ran a T-SQL ...
0
votes
0answers
18 views

how can I track down the source of “Internal connection fatal error”?

I'm working on a 6-700 line SQL script today. I'm running it from SSMS. Pointing at a SQL 11.0 db. About half the time I run it, I get: An error occurred while executing batch. Error message is: ...
1
vote
0answers
27 views

Sql Server 2008 R2 - Failed to send an environment change notification to a log shipping partner node

Login failed for user '*****'. Reason: Failed to send an environment change notification to a log shipping partner node while revalidating the login. I'm seeing a bunch of these errors on my ...
0
votes
0answers
11 views

Effects of renaming FC and using its original name for AG network name

We have a Failover Cluster, named MainSQL consisting of MainSQL01 and MailSQL02 which are default named instances and we can connect to whichever is the active node with just simply MainSQL. If we ...
-2
votes
0answers
20 views

Hi is there any to check that database table contains MULTIVALUE Columns [on hold]

In my project i want to check that whether the database is in the 1st normal form. TO check that i need to check whether there is any multivalued column in any table.
0
votes
1answer
24 views

Database design: Which will perform better, auto incremented column or a composite key for appointments

The schema of table is : appointment(date,time,patientID,...) pateint(patientID,PName,age,...) PS: two or more patient can came at the same time . The number of appointments per day up to 500 . ...
2
votes
3answers
86 views

Re-writing a sub-select as a condition on a column generated with 'over (partition by …)'

I am wondering if it would be possible to use over (partition by...) clause in order to avoid using a sub-select in the example below: declare @t table ( id int ,code char(2) ...
0
votes
0answers
13 views

script task sssis file extension is missing?

Hi I have problem with script task C# I create I have to prefix log file with date but my problem is not adding file extension log file is log_yyyy_MM_dd without extension I want ti extension log ...
-3
votes
0answers
29 views

What softwares are found in DB systems [on hold]

I am new to database concept and application. I want to know what softwares exist in a whole database system?
-1
votes
0answers
27 views

Getting error creating database in SQL Server 2005 [on hold]

I'm an error message when trying to create a database in SQL Server 2005: An exception occurred while executing a Transact-SQL statement or batch. Service Broker message delivery is not enabled in ...
0
votes
0answers
11 views

Mysql connections not closing

I have a web application running on Tomcat7 that connects to MySQL 5.5. I have two servers running the identical code: Ubuntu Red Hat The Ubuntu one runs fine maintaining a steady 8-16 ...
1
vote
1answer
15 views

MySQL wait_timeout setting ignored

I have a MySQL 5.5 instance running on a RedHat distro. I have edited my.cnf with the following setting: wait_timeout=30 However, client connections are sleeping and never getting killed. The ...
0
votes
1answer
10 views

Array column vs another table when the relationship is quite small

The Data I am creating a table of cities and their zip codes for the United States. Some zip codes have a list of acceptable cities, as designated by the USPS. For example, the zip code 36613 is ...
0
votes
0answers
17 views

Local SQL database settings to better mimic SQL Azure

I am developing a new application and use SQL Server 2012 installed locally for development. Then it is being deployed to Azure and running against their SQL Azure Standard S2 service. When running ...
0
votes
0answers
11 views

MySQL,- changing collation causes big problems

For one of my tables I have changed the collation from latin1_swedish_ci to utf8-unicode_ci. Then one of my queries, run from a synchronization script, ran amok. It cause sessions to lockup and not be ...
0
votes
0answers
18 views

ORA-01410 Error

I am getting ORA-01410 and ORA-06512 for the following block of code in a trigger im firing for deletion of a record in my table. Are the calls correct ? getlong ('xxx', 'YYY', :OLD.ROWID), getlong ...
0
votes
3answers
21 views

Case when not return more than one value

I try this, but the SwitchCase can not return more than one value. WHERE CP.NumIntAut IN ( CASE WHEN @NumIntAut IS NOT NULL THEN (@NumIntAut) ELSE (SELECT NumIntAut FROM ...
1
vote
3answers
26 views

Get seconds of day in Postgres

In Java we use Joda-Time to get the seconds of a day as an int value (despite the date): date: 10-10-2014 00:00:30 -> second 30 of day date: 11-10-2014 00:01:30 -> second 90 of day date: ...
1
vote
0answers
47 views

What are the dangers of non-IT managers using improper database terminology [on hold]

My immediate manager above me is not an IT person. She has obviously read a wiki page or two on SQL Server and/or database theory. Many times during discussions she will use terms like "Normalized" ...
0
votes
1answer
16 views

Postgresql single base on multiple HDD partitions

Imagine a situation: I got a Postgres database working on single server on one of HDD partitions (partition size 100GB) Database grows up to 100GB taking whole free place on the partition Database ...
0
votes
1answer
8 views

Replication Snapshot folder not cleaning up

The job that I thought was supposed to clean up old snapshots isn't removing the old files. The retention is left at default yet there are snapshots months old which remain. The job runs as the ...
0
votes
0answers
4 views

phpMyadmin 's red number, How to know is it good or bad?

I have some red numbers in my phpmyadmin status : Slow_queries | 137.297 Innodb_buffer_pool_pages_dirty | 12 Innodb_buffer_pool_reads | 127025788750 Innodb_buffer_pool_wait_free | 198 ...
1
vote
1answer
45 views

Set bit in Table A if values are present in Table B

I have two tables, Containing up to ~10 million entries. TableA which has 3 columns: IDA (bigint), IDB (int) and CHK (bit). (IDA, IDB) is the primary key. TableB which has 2 columns: IDA (bigint), ...
0
votes
1answer
29 views

T-SQL Parsing XML escaped in format %3E (less than)

First question here so please be gentle :) I am a junior SQL developer. I am try to parse a string in xml format that has been escaped like below: ...
3
votes
2answers
121 views

To make sql server instance back to multi user mode

I have made a change at instance level, ‘Properties/Connections/Maximum number of concurrent users’ to 1, disconnect all other users from the server. Since some of the users were logged in and left ...
0
votes
1answer
6 views

Machine account causing a Token-based server access validation failed with an infrastructure error

As the error suggests the SQL log is filling with the error: Login failed for user 'xxx\xxx$'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous ...
0
votes
1answer
24 views

Transactions within a Transaction

What behaviour would PostgreSQL display if for example the script below were called BEGIN; SELECT * FROM foo; INSERT INTO foo(name) VALUES ('bar'); BEGIN; <- The point of interest END; Would ...
1
vote
1answer
9 views

Warnings while running AutoMysqlBackup

I am using Automysqlbackup.sh file to take MySql backups on Ubuntu.I have only 1 database. But when i run this script then it generates several Warnings (plus a error mail) like below Errors reported ...
0
votes
1answer
18 views

HTML column in a full text index?

Using sql server management studio, I want to create a full text index where a certain field is treated as html, tags should be ignored and umlaut-codes should be taken into account. How can I do ...
0
votes
2answers
19 views

Meaning of 'show variables LIKE '%_database'

Despite being a newbie in db administration, I have been assigned to move our crm from mysql to mssql. I have reached a point where I have met a query I dont understand and it cannot execute in sql ...
0
votes
2answers
22 views

Copy database from one mysql sever to another mysql server

Following are the details of the database and server: Server1: Host Name: abc Port Num: 01 database: test Server2: Host Name: xyz Port Num 02 database: spareparts userid: spts password: abcdefgh@123 ...
0
votes
1answer
24 views

Is there a standard mechanism for moving data to a remote database? [on hold]

I have my application installed in data centers across the world, performing various functions, with each data center having its own local database for the application. Certain reporting data is ...
0
votes
0answers
9 views

Calculate sum of a whole column in IBM Datastage without any grouping

I have a table in oracle with salary as one of the columns. I want to calculate the sum of this salary column. It is pretty simple in SQL sum(salary) but I have made some dimensions and facts using ...
1
vote
1answer
33 views

Why would I not specify ROWLOCK to get rid of page locks?

I have a query that goes something like this: SELECT TOP (1) * FROM MyTable WITH (UPDLOCK, READPAST) ORDER BY SomeColumn ASC; This answer says that it's hard to say for sure but it will probably ...
0
votes
1answer
22 views

How to import large sql file in postgres?

Trying to import sql file around 8GB using these commands sudo -u postgres psql yourdb -f my_file.sql sudo -u postgres psql yourdb < my_file.sql sudo -u postgres cat my_file.sql | psql yourdb ...
1
vote
3answers
71 views

500 databases or 1 database with 500 tables or just 1 table with all the records? [on hold]

I currently have an application that is used by a single end customer. For ease of discussion assume the application only needs a single database table for all records. I now need to support ...
1
vote
1answer
19 views

Slow Query with LIMIT

We have this query: SELECT "messages".* FROM "messages" WHERE "messages"."account_id" = 1 AND "messages"."status" = 'unread' AND (created_at >= '2014-04-24 01:00:00.000000') ORDER BY id DESC It ...

15 30 50 per page