0
votes
0answers
2 views

I am new in JOOMLA and php and I just started to make a synchronizer for three databases using joomla and php. Can you help me with this?

This is the interface I made for my synchronizer. It will first query source databases and their tables and the attributes of the table and then select the target database.
0
votes
0answers
5 views

performance of handling many inserts into an Amazon RDS instance; are there other options?

I am looking at using Amazon RDS for MySQL. However, the performance has not been acceptable. Using SQLite, I get about 1000 inserts per second whereas on Amazon RDS, I'm getting about 5 inserts per ...
1
vote
0answers
3 views

Storage snapshots for consistent backup of postgresql - different data and log volumes

We are running many Linux VM's in a vmware/shared storage environment, each running its own instance of postgreSQL (a mix of 9.0 and 9.3). Currently, the entire VM sits on a single root ...
0
votes
1answer
8 views

Why does Oracle indicate my table is using so little space?

I'm running Oracle 11g. I have a table with two BLOB columns. I inserted 10,000 rows into the table, and each column contained a byte array of size 10289. As you can see, there are 10,000 rows in ...
0
votes
1answer
12 views

TempDB Best Practices For Shared Storage

Microsoft recommends separating the SQL Data Files from the Temp Files to limit device contention but what about cases involving shared storage. I have a shared environment where the data and temp ...
0
votes
0answers
8 views

MySQL AES Encryption

I'm trying to follow the example given so many times on here at http://thinkdiff.net/mysql/encrypt-mysql-data-using-aes-techniques/ I set up the table, run the query and get this error: INSERT into ...
0
votes
0answers
13 views

Bitfield in Database

What is the best way to store a Bitfield of 960 values in a Sqlite3-Database? I need to do queries of testing if the x-bit is set.
0
votes
2answers
22 views

Postgres ON DELETE Rule Not Working With WHERE Clause

I'm trying to implement "Soft Deletes" given the following schema: CREATE TABLE categories( id serial not null primary key, num integer, "name" text, deleted_at timestamp default null ); ...
0
votes
0answers
8 views

Is the use of my lookup table efficient?

I'm trying to find the best way to architect the relationship in the scenario that: A team can have multiple players, a player may also have multiple teams My first thought was to use a lookup ...
0
votes
0answers
18 views

Why Can't You Have Immediate Access To Source Table When Killing ONLINE Clustered Index CREATE/REBUILD/DROP?

When you CREATE/REBUILD/DROP a clustered index with ONLINE=ON, why can't you have immediate access to the underlying table after issuing a KILL? While performed said operations ONLINE, the source ...
0
votes
0answers
11 views

dBASE III Update query slow for 1000 entries

how to run chain update command on dbase i'm using code below but performance is very slow. is there any way to update using sp's. private static void UpdateRdTable(string rdTableName, ...
0
votes
1answer
13 views

MySQL, RAM disk for tmpdir - how to figure out what size it should be?

We regularly run a few large SQL queries to generate reports. It seems that the bottleneck is the amount of time that is spent writing to the tmpdir, which is currently on disk. We are upgrading to a ...
0
votes
1answer
13 views

MySQL Cluster High Read/Write Volume

We are currently investigating the possibility of using MySQL Cluster or another high performance solution to handle a large amount of write load. Seeing as all of these systems have specialized ...
0
votes
1answer
30 views

How to change the database mode to STANDBY?

I have a "log shipping" from server A(Database Name = main) to server B(Database Name = LS_main) . I want to take a Snapshot Database From the secondary Database (Database Name = LS_main), but he id ...
0
votes
1answer
11 views

What postgres sync solution should I use to duplicate production, but read it from another application?

I'm a little out of my league with my current problem, but I'm looking for a solution where the following conditions are met: My production database reads and writes as it currently does My ...
0
votes
2answers
24 views

Transaction has set autocommit = 0, but still the update happens before I commit

I have multiple MySQL InnoDb tables, I am trying to alter/insert/modify many of them in a SQL transaction, I set autocommit to false, so that if some SQL statements fail, I do commit the rest of ...
2
votes
1answer
25 views

How to perform server-side transaction timeout if COMMIT TRANSACTION will never arrive?

How can SQL Server terminate one of its transactions if it exceeds preset timeout? Imagine the following transaction performed by traveling salesman's SQL client application, which is submitted ...
0
votes
0answers
17 views

Best way for storing multiple account record every day

I need to store data from multiple accounts. About 300 record that are generated every day. Sample data: 100000 Account one 9$ 3/2/2015 100001 Account two 70$ 3/2/2015 100000 Account one 10$ ...
-1
votes
0answers
14 views

TRIM function in used for a loop [on hold]

SUBSTR(TRIM(location),1,INSTR(TRIM(location),' ',1,1)-1) != 'ABC'; can you please explain what exactly the above statement is doing ??
0
votes
1answer
19 views

Oracle: duplicate schema to another database

I want to copy an Oracle schema from a production database to a validation database. Both databases are Oracle 11g R1 standard edition and need less interrupting time as I can (but I can do if it ...
0
votes
1answer
9 views

what will happen to the binary log if it reaches its maximum value ? Does it reset to mysql-bin.00001 again?

what will happen to the binary log if it reaches its maximum value ? Does it reset to mysql-bin.00001 again ? I know the below points exist means, there won't be any reset happen in binlogs. I ...
1
vote
0answers
12 views

Clarification on usage of Serially Reusable Pragma for Oracle 10g

I need to make packages for Oracle 10g that can be changed while users are still logged in an using an application that makes database calls through PL/SQL. Unfortunately, anytime a package is updated ...
0
votes
1answer
22 views

What is contained in the controlfile of oracle database?

As we all know that controlfile contains datafile locations and redo log locations along with their names.It also contains dbname,timestamp,checkpoint info,log sequence number,rman backup info.In ...
2
votes
0answers
16 views

How can I speed SQLPS connection when I don't have WMI permissions at the server

When connecting SQLPS to a SQL Server, it will try to run some WMI service status queries. In an environment where one does not have permissions for those, PowerShell issues a bunch of warnings, and ...
0
votes
1answer
16 views

Possibly a silly question: Can I install MySQL on an External HDD connected to my Router?

I have a 1TB Western Digital External HDD and I was wondering if I can turn it into a MySQL Database? The HDD itself is connected to my router via USB (BT Home Hub 3) and I would like to experiment ...
0
votes
1answer
34 views

Query for orders that contain a product without using sub-query

Order ----- OrderId OrderDetail ----------- OrderDetailId OrderId ProductId How do I write a query that returns all orders that contain a specific product without using a sub-query? I don't want ...
1
vote
1answer
10 views

Using psql with string variable that has two periods

psql -d mydb -U me -h localhost -f db_log.sql -v db_user_string='Me' -v version="1.7.3" into the script begin; create table db_log ( db_owner varchar(255) not null, db_user varchar(255) ...
1
vote
1answer
25 views

DB2 - question regarding RESTORE OFFLINE backup and Archive Logs

I configured last night DB2 to be in Archive Mode. I created required offline backup at 23:00 last night. First online backup will be created at Friday night. Archive logs now keep coming to the ...
1
vote
1answer
13 views

MySQL 5.5 Replication to Galera/Percona XtraDB Cluster

We are currently investigating moving our current MySQL 5.5 Master > 5 x Slaves (with Statement Based Replication, apx 250GB data and growing) to a HA clustering option. Mainly to provide greater ...
0
votes
2answers
28 views

How to list LOGIN + ROLE in SQL Server 2008?

I'm looking for an answer but i can't found. Just a lot of long scripts. I need to list Login | Role ( sysadmin, dbcreator, etc ) but i can't find a table to join. I have this for now: SELECT name ...
0
votes
2answers
14 views

Number of connection running within certain period of time?

Is there any way to capture number of connections or processes which is running on the prod server each 10 mins of interval? And MySQL version is 5.1.47.
0
votes
0answers
3 views

How to transform Streaming Replication Master-Slave to Cascaded Master-Slave1-Slave2 setup?

I've setup streaming replication as part of HA solution on my production enviroment. I've two ubuntu servers PROD1 and PROD2. PROD1 is master and PROD2 is slave. In case of failover the slave database ...
0
votes
0answers
28 views

Database design for a railway system

This is how I intend to design my database: (It is for an academic project) Table Trains: TrainUID # primary key TrainNumber # Official train number do not need to be unqiue Traveldays # ...
0
votes
0answers
6 views

Is there any way to perform atomic updates of stored procedures in MySQL?

I know that MySQL does not support atomic updates of stored procedures yet and it is bug which was reported on 2005 but not yet resolved.(http://bugs.mysql.com/bug.php?id=9588). In our project ...
0
votes
0answers
7 views

Data base design for handling website subscriptions

I have a website where at least 20 posts are posted in a day and each post contains more than 5 categories and each category has further tags. I wanted to build a subscription module that users can ...
-3
votes
0answers
28 views

How to read default value [on hold]

I am giving startdate and enddate. There are multiple items present in table. If data is not present for item to any date. How to return default value as 0 (zero)?
0
votes
1answer
47 views

Order of Columns in Index

I have following query which has ON clause on different column, Where clause on different column and Selection on different columns so my question is what should be Order of Columns in Index as ...
1
vote
1answer
46 views

What is causing an INTERSECT to run forever when the individual SELECTs run quickly?

I have a script that applies the INTERSECT operator to 2 separate queries. Query1 executes instantly and returns ~1k rows. Query2 executes almost instantly and returns 200k rows However, when ...
0
votes
0answers
5 views

Sybase IQ: How to do ON DELETE CASCADE

Is there any way to implement ON DELETE CASCADE on IQ? There are ways to prevent delete actions (on delete restrict) but I wasn't able to find some cascading deleting.
0
votes
1answer
19 views

How do you dump specific table(s)?

Hi i have a shell script for doing a selected databases backup. Now my requirement is i wanted to take a particular tables in a database to be backed up. Each database backup need to be created in ...
-1
votes
0answers
17 views

can't restore a SQL Server database from a backup file that is in a sql filetable? [on hold]

Why can't you restore a SQL Server database from a backup file that is in a sql filetable?
5
votes
4answers
105 views

How to check if Alter view/stored proc script has run successfully

For the database deployments, I call all the db schema changes in a batch file and run them on the target database. Sometimes we have scripts for altering the views or stored procs. I'm wondering ...
0
votes
1answer
22 views

From PostgreSQL to SQLServer (No User/Pass)

Some of you MAY be able to crack a really tough nut... I have to move all the data from a PostgreSQL (9.1 - Windows) database to SQL Server because the company I am contracting with is upgrading the ...
0
votes
0answers
14 views

FATAL: terminating walreceiver due to timeout

1/ DESCRIPTION: Machine 1 (slave): Centos 6.6 , x64 , installed PostgreSQL 9.3 (on Local) Machine 2 (master): Centos 6.6 , x64 , installed PostgreSQL 9.3 (on Cloud) Machine 1 (slave) and machine ...
0
votes
0answers
19 views

sqlplus on linux not connecting when provided with IP port

I am running Oracle Database 11g R2 on Oracle Linux 5. I am able to connect to my SID from sqlplus if I use the command sqlplus system/password@orcl but when I provide the IP address and port: ...
0
votes
0answers
14 views

Prevent Reconnections During Application Cluster Restart

I have a large cluster of application processes (>5000) spread out over multiple EC2 servers. When I attempt to restart them or deploy new code (with a restart), they all attempt to reconnect to the ...
1
vote
2answers
29 views

InnoDB row metadata size (minimum row size)

I'm trying to decide whether to normalize a thing further, and need to know what the smallest a row in InnoDB can be (I've got MySQL 5.6). This is not exactly my case, but for simplicity, let's ...
-1
votes
0answers
10 views

DB2 - Sql to get only the multiple records starting from 1 in row number function

Please help me in writing a sql script to get only the multiple records in row number function inclusive of rownumber 1 record. Example: ***Column 1 Column2 Row_number*** Apple orange 1 ...
1
vote
1answer
16 views

Trigger to apply user mapping to logins on database creation [on hold]

Does anyone have any example triggers that apply user mapping on database creation?
0
votes
1answer
33 views

GROUP BY on two large joined tables

I have two tables: Person ------ PersonID (PK) GroupID DeletedDate PersonData ---------- PersonID (PK) FieldID (PK) Value The fields are custom-created; hence the schema. I am trying to run a ...

15 30 50 per page