2
votes
2answers
286 views

Localhost vs LAN Database Performance [closed]

Normally, what some of us do is to just host the database and web-server inside 1 machine. Meanwhile we also may focus a machine with high RAM just for the remote database on LAN and another machine ...
0
votes
1answer
173 views

Converting dbo file from windows to linux

I have a .dbo file which is created from windows. This file is succesfully reloaded into the mysql database in windows. I need to reload the dbo file into the mysql/mariadb database in linux. How I ...
0
votes
0answers
4k views

Oracle XE TNS Listener fails to start

I freshly installed Oracle XE 11.2.0.2.0 and found out that the TNS Listener service fails to start. At first I tried to start the Windows service by hand. After the failure this is the entry in the ...
2
votes
0answers
228 views

Dynamic MySQL partitioning based on UnixTime

My DB design includes multiple MYISAM tables with measurements collected online, Each row record contains auto-incremented id, some data and an integer representing unixtime. I am designing an aging ...
1
vote
0answers
125 views

MySQL Partitioning, Reorganize Max Value partition (Known Bug / Feature)

I have written a crone job which reorganizes last max value partition every week into 2 new partitions , one for the previous week , and one for the future data (new max value partition which ...
2
votes
3answers
1k views

Cannot shutdown old postmaster when upgrading to Postgres 9.2

I'm upgrading to Postgres 9.2.2 (from 9.1.4). When I try to upgrade the DBs using: pg_upgrade -b /usr/local/Cellar/postgresql/9.1.4/bin -B /usr/local/Cellar/postgresql/9.2.2/bin -d ...
8
votes
2answers
107 views

Read ancient Oracle database into current Oracle version

An old computer with Oracle 8i is dead. We have the daily backup of the database (C:\oradata). We are unable to install this old Oracle version anywhere because we don't have the install CDs for it. ...
13
votes
1answer
5k views

MERGE a subset of the target table

I am trying to use a MERGE statement to insert or delete rows from a table, but I only want to act on a subset of those rows. The documentation for MERGE has a pretty strongly worded warning: It ...
2
votes
1answer
6k views

Expanding system tablespace

I need to add new data file into the system tablespace because its running out of space. Are there any precautionary measures I should consider since this is a production environment?
3
votes
1answer
670 views

Mysql Server optimization tips needed! (InnoDB)

I've recently been trying to optimize our mysql server but I've encountered some pretty serious problems on the way. We're running a game server which is coded in C#. We have two dedicated servers. ...
3
votes
2answers
1k views

Running pg_dump on a hot standby server?

Disclaimer: I admittedly haven't tried this yet, but I'm not sure I would know if it wasn't working correctly, so I wanted to ask. I would like to run a nightly backup job (via pg_dumpall) from a hot ...
4
votes
1answer
310 views

Why does WAITFOR (RECEIVE FROM QUEUE) show up in the monitor incorrectly?

I kick off the following command in my app: WAITFOR (RECEIVE CONVERT(int, message_body) AS Message FROM MyQueue) When I run `sp_who2 active', I get Status=SUSPENDED and Command=DELETE Note: ...
1
vote
0answers
123 views

Requesting advice on creating a table controlled SQL job scheduler

I have been tasked with cleaning up a series of SQL jobs that send email updates about various data and system conditions in my company. Currently, there are a ton of jobs, each with its own SQL code ...
13
votes
2answers
299 views

Does firing off an indefinite WAITFOR increase the log file size?

In the last release of my app, I added a command that tells it to wait when something arrives in the Service Broker queue: WAITFOR (RECEIVE CONVERT(int, message_body) AS Message FROM MyQueue) The ...
-1
votes
2answers
337 views

Oracle SQL Query/SubQuery Single column with mutilple data [closed]

Id File-Name Descrption 1 yyyy Started 2 yyyy incompleted 3 rrrr Started 4 tttt started 5 uuuu started 6 rrrr completed 7 tttt completed 8 uuuu ...
1
vote
1answer
235 views

Fill ibdata1 With Zeros/Nulls/etc Or Change A Table's Tablespace

I have a MySQL 5.5 server running on CentOS 6. The MySQL package is a MySQL-released version (MySQL-server-5.5.28-1.el6.x86_64), not the stock CentOS one. I have moved an existing database over from a ...
6
votes
2answers
1k views

PostgreSQL: Can I do pg_start_backup() on a live, running db under load?

Our established replication has broken ("requested WAL segment has already been removed" during downtime) We cannot easily stop the master again. Can we do pg_start_backup(), rsync ${PGDATA}/ ...
3
votes
1answer
307 views

How to categorize rows by SUM of a column in mysql?

I have a table as id num_items folder 1 4 2 33 3 74 4 41 5 24 6 34 7 46 8 55 9 11 I want to assign folder number to rows but limiting the number of items in each folder (e.g. ...
1
vote
1answer
448 views

MySql proxy to replication configuration

Is there any solution (say a proxy) that makes MySQL replication cluster behave like one database towards developers? And developers then don't need to worry about using master to write and slaves to ...
1
vote
1answer
150 views

MapReduce performance on a single PC [closed]

I have heard that Hadoop has better performance than MySQL. Until now, I have used relational databases so this is really new technology for me. I have a 6 core PC. Suppose I have a table with 20 ...
4
votes
1answer
789 views

What is actually happening when postgresql discovers the trigger file and promotes it self from slave to master?

I have a streaming replication setup between two postgres servers (master: server A, slave: server B). I'm wondering what's actually happening under the hood when I touch the trigger file and the ...
4
votes
1answer
1k views

need suggestions to improve view performance

I am looking to improve the performance of a view in SQL Server 2008. This view exists in a reporting database that is widely used by not-very-technical-folk to basically denormalize all of these ...
4
votes
1answer
109 views

Is there a compact way to use a NOT IN (1,2,3) syntax when setting a variable?

Expressions like NOT IN (1,2,3) are valid in a where clause: SELECT foo FROM bar WHERE ((record_type NOT IN (2, 3, 7, 18, 19, 20, 21,12,13,22)) However if I want to move an elaborate expression ...
2
votes
2answers
109 views

How to prevent SQL Log from being too full

I have a database that generate a huge amount of transaction per seconds, something like 50-100 transactions/second. Because of this, the log files grows very quickly. The thing is though, that even ...
1
vote
0answers
199 views

big mysql database optimization

My Joomla mysql database has about 3.4 million rows in content table. It is just static article. Very slow and often use out of resources. To speed up it, I segmented it into 6 sub-tables and added ...
9
votes
1answer
364 views

Calculate MATCH() AGAINST() scores from UNIFIED QUERY not FOR EACH TABLE

I am trying to have a score for entire section of SELECT statements SELECT *,MATCH(`result`) AGAINST('keyword') as `score` FROM `table1` WHERE MATCH(`result`) AGAINST('keyword') UNION SELECT ...
2
votes
1answer
585 views

Can't create/write to file MySQL

Server Configuration: MySQL 5.051a-community-nt-log Community Edition installed on Windows Server 2003 Standard Edition SP1. This MySQL Server is part of a client's WAMP installation Problem: ...
2
votes
1answer
134 views

Databases design decision - Mobile & Web

This may be a question a little broad but... I'm currently having the following dilemma: Having a web application (already deployed) and a new mobile app, I'm currently working on the mobile app ...
1
vote
1answer
109 views

Track access to database

How can I see who has accessed the database, viewed the tables or executed SELECT, for SQL Server 2008 R2?
0
votes
1answer
186 views

mysql index on derived table [duplicate]

Possible Duplicate: Calculate MATCH() AGAINST() scores from UNIFIED QUERY not FOR EACH TABLE I want to have a FULLTEXT INDEX on data name in the base SELECT that selects data from another ...
2
votes
2answers
771 views

Enable slow_query_log tries to write to slow_log.CSV

I'm running MySQL 5.5 I wanted to truncate the slow log file, so I did: SET GLOBAL slow_query_log = 0; then truncated the file in filesystem. But, when I enable it back it fails: SET GLOBAL ...
2
votes
3answers
3k views

How to avoid using the IN clause in sql query used in a stored procedure

Is there a better way to write the SQL other than using the IN clause in the below given SP. When i am using this IN clause, i suffer a performance dip due to large number or records involved in the ...
0
votes
1answer
4k views

check listener status other than 1521

I have two listner: one is running on port 1521 another on 1531. lsnrctl stat show's status of services running on port 1521 only. How should i check whether the services running on port 1531 is ...
0
votes
2answers
387 views

MySQL concurrent INSERTs

I have a MySQL database with InnoDB tables. There are different client processes making SELECT (to check the existence of a value) and INSERT or UPDATE (depending on the result of the select) ...
3
votes
2answers
2k views

Two way replication

I have a little problem... I have this case: 2 server instances 2 Databases 1 Table (5 columns) From server 1 I created publication to replicate all columns of tables I have in DB1. From server ...
2
votes
2answers
3k views

How to solve MySQL “The table is full” error 1114 with Amazon RDS?

I am trying to add a new column in a table and the query giving me this error 1114. My RDS instance size is small. 1.7 GB memory, 1 ECU (1 virtual core with 1 ECU) Table i am trying to modify is ...
1
vote
2answers
168 views

Automatic create SQL database and table relationship

For SQL Server 2008, what is the best way to automatically "draw up" the Database relation ship and table relationship too? Is there any way to visualize database with this.
0
votes
1answer
1k views

Importing CSV file to MySQL via PHPMyAdmin

I am currently stuck and unable to upload a complete CSV file into a MySQL database. Unfortunately, the nice folks at Stackoverflow haven't been able to help me solve this issue, so I'm hoping someone ...
1
vote
2answers
533 views

how to insert the remote table data into another table in my local computer in mysql?

can any body tell me. I have a remote table from which I need to import part of the data and I need to place into my table which is in my computer(local). I know select-into command and its use but ...
2
votes
1answer
7k views

Difference between database dump (export) and database backup?

What is the drawback using only EXP or EXPDP command for a database dump (and considering it as a backup) instead of taking backups using BACKUP DATABASE command (via RMAN)? What is a difference ...
0
votes
1answer
42 views

viewing Original Object under synonyms

I have certain synonyms in my schema which represent views from another schema. Now in oracle sqldeveloper, I am unable to see the actual SQL for those views but I see only an SQL like: CREATE OR ...
4
votes
1answer
1k views

How to restore replication after server crash

We had two databases on one SQL Server 2005 instance with transactional replication between them (3 tables as articles). This server acted both as publisher and distributor. Then the RAID on the ...
1
vote
1answer
578 views

How can I ensure that in a insert trigger a column gets filled before other column?

The bigger picture: tableX represents pipelines and tableY streets. A pipeline crosses/goes along many streets, and I want to know which street is crossed the most. First, I am segmentizing each ...
1
vote
1answer
989 views

Copy data between two databases periodically [duplicate]

Possible Duplicate: How to update one database from another? I need to know how to copy data across to another SQL Server database periodically. Both databases are in the same SQL server; I ...
3
votes
2answers
2k views

Procedure cache (plan cache) size

I'm developing an application with many, dinamycally-assembled, complicated SQL queries. I'd like to keep the query plans in the procedure cache for as long as it is possible. To prevent discarding ...
-3
votes
1answer
253 views

Simple online collaborative database for many users to add and query… does it exist? [closed]

:) I'm looking to create a VERY simple database that people can subscribe to for a nominal monthly fee... no relational/pivot tables, no complicated expressions, etc... just an easy form of a couple ...
1
vote
1answer
215 views

How to setup a PostgreSQL cluster

Could you point me to a good book about setting up a PostgreSQL cluster? The goal is to set up an active-passive cluster spread across two different data centers to achieve high availability.
2
votes
2answers
108 views

Optimizing index creation

One thing that has bothered me for awhile is creating many many indexes for the one table where the query only differs slightly or contains many of the same columns. An example case would be: table1 ...
1
vote
1answer
188 views

Covering Index - Include columns

I have a table : [sch].[Parent] ( ID Identity [INT] (PK), Name VARCHAR(100), Email VARCHAR(250), Active TINYINT, InsertedBy VARCHAR(100), InsertedDTM DATETIME, ...
0
votes
2answers
877 views

Saving every mysql user login attempts

Is there a way to save the username and the IP from which the user tries to login to a MySQL server?? Enabling general-log seems to log everything but that seems to write too much details taking more ...

15 30 50 per page