3
votes
2answers
190 views

Scalability: Desiging a message table

This question might be deadly simple but I wanted to make sure I am going through the correct path and not making any simple and irrevertible mistakes. My project will be based on messaging and it ...
-3
votes
1answer
129 views

SQL Server: Month Range Join [closed]

Given that there are two dates like 2012-07-08 and 2013-02-06. I need to count record of each user for every month. If there is no data for a user in particular month then it should return zero. The ...
0
votes
2answers
698 views

How restore from ASM to a new server?

We have a machine that crashed completely. The ASM disks are fine. Is it possible to mount the old ASM disks to a new machine and then restore the datafiles/redo files/ control files/everything to ...
1
vote
2answers
272 views

Security: writing to a file from MySQL CLI

I was testing writes to a file from MySQL CLI (locally & remotely) and I wonder what settings are preventing writes for remote users, basically I would like to make sure that it's set on all ...
3
votes
3answers
5k views

Difference between Full backup and Copy-only full backup

I saw in this link that full backup does not truncate the log. So what is the difference between full backup and copy-only full backup? For the log backup there is copy-only backup which prevent the ...
-4
votes
2answers
161 views

Inserting images in database [closed]

How can the images be inserted in a table? Var binary is not working in structured query language command prompt,what can be the syntax?
3
votes
5answers
433 views

Extract data to another computer

I have SQL Server 2008 R2 Express edition, and I want to export the data in that database to another computer so I can import it again in that computer. How please? What I have tried Right-click ...
7
votes
2answers
3k views

How to do incremental/differential backup every hour in Postgres 9.1?

Trying to do an hourly hot incremental backup of a single postgres server. I have the following setup in postgresql.conf: max_wal_senders=2 wal_level=archive archive_mode=on archive_command='copy ...
2
votes
1answer
156 views

sql query - table@string meaning

I am trying to understand a query . When I run the below query , no rows are fetched. select * from Table But when I run the query , a result is returned having multiple rows. select * from ...
2
votes
2answers
140 views

MySQL #1064 error on line 2 [closed]

I'm quite new on learning SQL and I seem to be running into an issue with the following code: CREATE TABLE `read` (`order` NOT NULL UNIQUE AUTO_INCREMENT, `title` VARCHAR(50) NOT NULL, `url` ...
0
votes
0answers
217 views

setup mysql row-based-replication without downtime?

Is it possible to use setup rbr on a mysql server (current version happens to be 5.5.31) to a slave without incurring downtime? (and if "yes", how?) My thought is first to configure the master and ...
-1
votes
1answer
164 views

Query mysql database through memcache

I have been trying to use memcache with MySQL 5.6 but I can not figure out how to do this. I have add an entry into innodb_memcache.containers so I can query the database through memcache. What I ...
-1
votes
1answer
138 views

MySQL Migration from Slave to Master

I recently had a problem with our server. It required us to install a new hard drive, cpanel, and setup the old hard drive as a slave. How can I migrate the mysql database from the slave drive to the ...
-2
votes
1answer
97 views

mongos and monod have the same default port?

Is it true that by default mongos and monod uses the same port 27017? I had to pick a different port for one of these two. For example --port 37017 for mongos. Did anyone have the same confusion? ...
1
vote
0answers
275 views

How to switch Quiescing to Normal Mode in Oracle?

I have two instance database Oracle, they are ORCL11 and ORCL10,.... I've configured them, it looks like correct. Then, I connect to replication user admin ORCL10 conn repadmin/repadmin@orcl10 And ...
4
votes
1answer
329 views

Should I deploy Mongodb sharding for 50 collections?

I have a 10 node clusters that runs about 50 concurrent jobs. Each job needs to read/write a separate collection. So I have about 50 collections roughly. Each collection has about 20 M records. Most ...
2
votes
1answer
121 views

Changed root password from '<blank>' to '<password>'. Now cannot connect to databases in Cloud SQL prompt

I changed the root password using Google APIs SQL Prompt from blank to using: UPDATE mysql.user SET password = PASSWORD('<password>') WHERE user = 'root'; It has been documented here that ...
2
votes
1answer
152 views

Import issue with Replication

When I import some data from excel file to a table that is part of a merge replication, the data is imported successfully to the table, but those new records are not synced to subscribers that belong ...
3
votes
3answers
2k views

How do I monitor bandwidth used by SQL Server on port 1433?

I have a single server running a .NET web application and a SQL Server database (2008 Standard). I'm planning to move the database onto a separate server but in order to provision the network hardware ...
1
vote
1answer
188 views

Storing different countries' administrative divisions

I'm designing a data base which should relate users to their administrative division for statistical purposes, considering that every country has its own type of divisions. Chile, for example, is ...
2
votes
3answers
516 views

index mysql concatenated columns

I have a table for author names with two fields, first_name & last_name, both varchar(55), both nullable (for crazy business logic reasons) although in reality last_name is unlikely to ever be ...
1
vote
1answer
514 views

10g to 11gr2 upgrade causes SYS.UTL_HTTP malfunction

After a 10g to 11gr2 upgrade, we are getting ORA-29273 errors when we try to use the SYS.UTL_HTTP package. Our upgrade list requires ACL to be disabled. How can we resolve this problem without ...
2
votes
1answer
6k views

MySQL: Row size too large (> 8126)

Here's the issue. I have a table which has 300 columns in it, each up to 255 bytes (there IS a business justification for this). When I try it create it using VARCHAR(255), I go past the limit for ...
4
votes
1answer
230 views

What is the name of this type of query, and what is an efficient example?

The purpose is to find a parent, given it's children. For example, say you have a marketing package (aka a "combo"), and want to match it based on the products in it. Example table/data: create table ...
2
votes
2answers
1k views

Two primary keys to one foreign key

racing_couple ID (PRIMARY) breeding_couple ID (PRIMARY) egg IDpar(FOREIGN KEY) I have 2 IDs from 2 different tables (racing_couple and breeding_couple) and they are primary keys. In 3. table (egg) ...
3
votes
1answer
135 views

What if I want to keep using MyISAM

In my current use of MyISAM the databases are extremely small and kept for a few weeks after which time they are deleted and completely rebuilt with a clean slate. The script uses MYISAM tables and ...
2
votes
1answer
184 views

user permission cache in session or check from database?

On each page of my websites 2 or 3 permissions have to be checked and I use role-permission model. Which one is better? to check permissions of each user always through database directly or once ...
4
votes
1answer
1k views

How to properly index hstore tags column to faster search for keys

I imported a large area of OpenStreetMap's planet.osm file into a postgresql database. The database contains a table called nodes. Each node has a geometry column called geom and a hstore column ...
-2
votes
1answer
364 views

If there exist multiple similar Values than show Sum of a another column else Show simple Value [closed]

I am having a probelm. I have a table of Invoice with different Invoices. Each Invoice has a unique Invoice Number and some amount. Invoices are of two type. One is of Invoice Type, and the other is ...
1
vote
1answer
965 views

Upgrade path - Oracle Standard to Oracle Enterprise

Could I start on Oracle Standard edition and easily upgrade to Oracle Enterprise? Or do I need to rebuild the entire server? how does the upgrade path work?
-1
votes
1answer
693 views

mysql tried to restart itself 3 or more times, but it failed finally

it happended the second time, could be the same reason cause it. mysql tried to restart itself 3 or more times, but it failed finally. here is mysql log 130706 09:43:27 mysqld_safe Number of ...
1
vote
1answer
260 views

Cannot change root access in MySQL to %

This is a new MySQL Server install. I created my root password as part of the setup (on Centos 6.4). When I connect to the server through a terminal, I can connect to MySQL and issue commands, using ...
1
vote
1answer
430 views

Alter table move taking long time

I'm currently trying to compress a table in Oracle with the following statements: ALTER TABLE MYTABLE COMPRESS FOR OLTP; ALTER TABLE MOVE; My question is: the MOVE operation is taking forever and ...
0
votes
2answers
204 views

MySQL database datafiles in windows SystemData directory

When I create a database and some tables in MySQL Server, it makes some data files in Windows SystemData directory in C:\ProgramData\MySQL\MySQL Server 5.5\data\mydb\. Each table has three files with ...
2
votes
1answer
369 views

List of variable defaults for InnoDB engine

I would like to list the defaults for the global variables that are innodb specific. The problem is that the following commands doesn't list any innodb variables: /usr/sbin/mysqld --no-defaults ...
-1
votes
2answers
256 views

Find records in same table with different company id but some other same values [closed]

I have subscriptions table that looks roughly: table subscriptions id (auto generated id) company_id city state subscription_date I would like to find records that: A) are of different company ...
0
votes
2answers
98 views

Return table based on 1, 2, 3, 4, 5 or 0 selected search options

Scenario: Lets say I have several tables for a software ticketing system: Developer, Supervisor, TicketType, TicketStatus and a Ticket table to join them on. Assume I have done my inner joins and now ...
1
vote
1answer
965 views

pt-table-checksum - Diffs cannot be detected because no slaves were found (1)

I'm new to Percona tools. I am trying to use pt-table-checksum as follows: pt-table-checksum h=localhost -u root -p xyz--replicate=percona.checksums --create-replicate-table --databases=mysql But ...
1
vote
1answer
197 views

MYSQL COLLATE Performance

I have a table called users with a column firstname and with collation utf8_bin I want to know what happens under the hood when I execute an query like SELECT * FROM `users` `a` WHERE ...
-2
votes
1answer
391 views

MySQL Incremental Backup (cron job): “sh: mysqlbackup: command not found” [closed]

I want to run cron job Mysql Incremental backup, Can any one pls help me. I tried: $command = "mysqldump-h $dbhost -u $dbuser -p$dbpass ". $dbname." > $backup_file 2>&1"; ...
2
votes
1answer
232 views

InnoDB forum DB design and Composite Primary Key (Cluster Primary Key)

I am designing forum database using InnoDB and got few questions , Could any one please help me to clarify them? Posts and Comments table design below CREATE TABLE `my_posts` ( `forum_id` ...
2
votes
1answer
40 views

Removing superfluous tables with a synchronization?

I'm using SQL Server 2008 r2's replication functionality to update my subscriber database through a transactional pull subscription. When I mark it for reinitialization, it does fix the schema and ...
4
votes
2answers
306 views

Strategy to deal with multi billion row simulation results and partitioning

I am trying to come up with a good way to deal withthe results of statistical simulations from a dba point of view. We generate about 500 million rows per day, most of which are "garbage" (i.e. the ...
1
vote
2answers
623 views

Obvious inefficiencies in this Netezza query?

Why might this query be taking nearly 2 hours to run when similar queries complete within a minute? CREATE TABLE T3 AS SELECT A.*, COALESCE(C.FIELD1,0) AS FIELD1A, ...
1
vote
1answer
323 views

How to identify who made changes in SQL server management? [duplicate]

I'm working on the server using SQL Server Management Studio 2005. Is it possible to identify the person who made changes in the SQL server Management Studio 2005 tables data?
1
vote
2answers
95 views

Most efficient way to perform table operations (spec. drop) on tables having table names that match a certain criteria

I am performing a schema dump of certain tables. This accompanied by dropping the tables that will be dumped. For example I need to drop all tables that start with, let's say, "SRC_". You guys think ...
-2
votes
1answer
431 views

Restore to last transaction log restore

We have a log shipping setup where we replicate from our primary database to a secondary. Now that database is, by the way of log shipping, in standby and thus read-only. We set it up so we could ...
4
votes
1answer
32 views

How to provide a access to the data base if the user is not having the privilleges

In MS SQL Server 2008 R2 is installed by a user "A" and he has a data base named "DB1" . He left the company. Now the user "B" is trying to access the data base. He is able to see the data abse and ...
1
vote
3answers
383 views

SELECT lock only for inserts [closed]

I need to get the MAX aggregate of certain field in a transaction. I use this value further inside the transaction. I want to avoid inserts in the entire table from which I'm getting the MAX while the ...
-5
votes
0answers
61 views

Website is working very slowly [closed]

We have replication from Oracle to MySQL via Oracle Golden Gate. Yesterday because of some issues we have rebuilt the replication from Oracle to MySQL (this is called opal replication). Now our ...

15 30 50 per page