0
votes
0answers
27 views

SPExecuteSQL;1 keeps executing internally

Having a major issues with this procedure called SP_ExecuteSQL;1. It keeps executing internally in SQL Server 2000 with high utilization of CPU. When I pass its SPID in DBCC inputbuffer it shows as ...
1
vote
0answers
74 views

Nosql multiple database design to handle sharing scenarios

This question is regarding design of a database in mongodb. The scenario: A user has a drive which he can share with others. Drive has two categories: docs and others. The user has three choices in ...
2
votes
1answer
309 views

MySQL WHERE if NULL select another column

This is my mysql table id date_created date_active 1 2014-06-07 18:24:38 NULL 2 2014-06-07 18:24:38 2014-06-07 18:24:38 3 2014-06-07 18:24:38 ...
1
vote
0answers
56 views

Can I revert to local logging in IIS 7.5 if ODBC fails? [closed]

Environment I have 3 Servers running instances of IIS 7.5 hosting different websites. 1 Server is on Domain A, 2 Servers are on Domain B. I have a one way trust setup from Domain A to Domain B. SQL ...
1
vote
1answer
66 views

postgresql: accept subdomain wildcards?

I want to accept all db connections from servers with domain mydomain.com so that all subdomains like tiger.mydomain.com, venus.mydomain.com will have access to the postgresql server. I've read that ...
1
vote
1answer
905 views

How to take backups of MySQL databases, explicitly based on PyMySQL

I am looking for a purely Python solution to take backups of every MySQL database on localhost. I already use PyMySQL to run queries on these databases. Any help is highly appreciated. EDIT After ...
3
votes
1answer
64 views

Best Design for this “Sweepstakes” Project?

Hello there fellow developers, Merry Christmas first aff all, and i hope you will have a happy new year soon. :) I was having more or less a problem with an idea that came to my mind. I am currently ...
4
votes
1answer
218 views

Rollback on \include error in psql

I'm trying to execute an sql script file in a single transation. The file contains includes for some other scripts which in my example create some tables. It looks like this: \include ...
1
vote
1answer
111 views

Finding out the exact size of the database after inserting records?

I have this query: SELECT table_schema "db.name" , Round(Sum(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB" FROM information_schema.tables GROUP BY table_schema; Does this ...
1
vote
1answer
10k views

MYSQL query to find records between two date range

I am working in a web application using PHP and MySQL. I have two tables Employee employee_id email_id 3 tl1@jasmine.com 4 agent1@jasmine.com 5 ...
1
vote
1answer
1k views

Upgrading mysql percona server from 5.5.40 to 5.6.71

2014-12-26 05:18:20 13215 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure 2014-12-26 05:18:20 13215 [ERROR] Native table ...
2
votes
1answer
228 views

What is the difference between select and fetch time?

In this article MySql vs MongoDB performance benchmark, they defined two measurements: select time run time (select + fetch) I do not understand what the difference is between these two. Can ...
2
votes
2answers
109 views

How to tune the below query

I am currently working on below table structure to pull the data/ generate any one time report. Let us consider the table name to be ABC. ID Field Value 1 Name Nagarjuna 1 Gender Male 1 ...
1
vote
2answers
221 views

Help - Error : Could not connect to master of shard replica set

I have a shard, using mongo v2.4.11. It has to mongos, 3 config, and 8 replica set (2 replica for each set, means 16 node for shard) It is keep having exception as per below. Caused by: ...
2
votes
2answers
417 views

Will a non-clustered index on a column with covering index on all the columns of table affect the Delete statement Records)?

I am trying to delete thousands of records say 35K from a table which consists like 10 million records. Delete * from Table where ScenarioID=859 I have also tried bulk deletion DECLARE ...
2
votes
0answers
113 views

Storing URLs in a database

I am thinking about storing URL's in my database, but I am not sure whether the way I use is an efficient way to do things or not. Table name : url url_id (Primary Key & Auto Increment) url_value ...
2
votes
0answers
44 views

Cassandra Deployement Architecture

I'm new to Cassandra. I have the responsibility to design a basic deployment architecture for a use case. I'd like to know if my solution is correct, and get advice and recommendations from you. Here ...
1
vote
1answer
82 views

SP how can I sum the amount of all leftchild in parentid

I have this data and table structure,I am creating MySQL stored procedure to sum all the amount in the leftchild of the parentid, I don't have enough knowledge in stored procedure.and I need some help ...
1
vote
2answers
525 views

Unexpectively slow data loading into Oracle

Big amount (4.000.000+) of files (1-4Mb each) are loading into Oracle 10g for about several days. Table is allocated in big tablespace, which was created on special volume (labeled BIG_VOL) over ...
1
vote
1answer
45 views

MySQL replicated tables for Cognos BI

the Business Intelligence guy is asking for faster machines, latest software etc. and some of his customers are complaining of query times in excess of an hour. The tool is Cognos/Insight and the DB ...
1
vote
1answer
91 views

Graphical user interface to change data capture on Oracle [closed]

I'm learning how to implement change data capture in Oracle. However, not being a DB specialist but rather a developer, I find the process tedious with respect to other things that I have to do. I end ...
2
votes
1answer
111 views

Only InnoDB databases locking up

I'm trying to troubleshoot my MYSQL in a LAMP and have an interesting situation. At first I thought MYSQL itself was locking up, but it turns out to be ONLY innodb databases that are locking up. ...
1
vote
1answer
107 views

mysql query from 1st domain and insert in 2nd domain

i have data in one of my website and i want to print these data in other site.these two are in same server.at present i have to export mysql data and import into other then do this code to insert in ...
2
votes
1answer
812 views

Sorting Table and get Position of row

I have a Table with 3 rows. Player, Time, Server. Now, I want 2 things and I don't know how. For Server there are 3 worths available. 1, 2 and 3. Server and Player are a Primary Key together. User ...
2
votes
1answer
1k views

Mysql binlogs exists, show binary logs is empty

I am working on a replication setup and have turned on bin-logs. I have moved my mysql datadir to a new location as well as the binlog path From my.cnf datadir = /vol/data/mysql ...
5
votes
2answers
164 views

Keeping iterator in consistent state

I was reading this post to understand how things are done in Sql Server: http://rusanu.com/2013/08/01/understanding-how-sql-server-executes-a-query/ If I understand it correctly, data is being sent ...
1
vote
0answers
34 views

TOAD query result is cut in the middle

I execute a query eith a long textual column name: select column as "a_very_very_long_field_name" from table; The result looks like : a_very_very_long_fi -------------------- 1. 2. ... ...
1
vote
1answer
38 views

SQL Server 2008 R2 - Change distributor schedule

We have configured SQL 2008 R2 replication. Distributor is configured in continuous mode, publisher is scheduler is set to execute after every six hours. Now we want to change distributor schedule ...
3
votes
2answers
305 views

How to get the sum of a particular item id in a column [closed]

Item ItemName PackageID Specifics brandname GRNQty UnitPric GRNValue 102814742801 ALL BRAN FLAKES 1PKT Bran. KELLOGS 7 15.9 111.3 102814742801 ALL BRAN ...
2
votes
1answer
527 views

mysqldump: Got error: 1044: Access denied for user 'username'@'localhost' to database 'databasename' when using LOCK TABLES

mysqldump: Got error: 1044: Access denied for user 'username'@'localhost' to database 'databasename' when using LOCK TABLES I am able to loging properly and able to take full backup from SQLyog Tool ...
1
vote
1answer
181 views

How to use fsyncLock() safely in backing up a single mongod

I read from mongodb document: important: db.fsyncLock() may block reads, including those necessary to verify authentication warning: When calling db.fsyncLock(), ensure that the connection is kept ...
3
votes
1answer
748 views

What's the advantage of thread pool in MySQL/MariaDB?

MariaDB thread pool MySQL thread pool I've read official document of MySQL/MariaDB thread pool,but I'm still confused about it; As I understand, thread pool has two advantages: 1. limit too many ...
1
vote
1answer
85 views

pgAdmin-III - Option to load a favorite automatically when opening query window

pgAdmin-III - Query window option Does pgAdmin-III has any option to load a default favorite file automatically when opening new query window? This would be much useful to have commit/rollback ...
8
votes
1answer
86 views

Aggregation Operations on View Ignores Index [closed]

The Scenario Once upon a time there was a Staging database at a small company that was participating in an ETL process, acting as a receiving catalog for the various formats of files from a number of ...
4
votes
1answer
422 views

mongoexport not exporting all possible data

I have a collection with documents similar to the following: { _id: 'p_123456', id: 123456, kind: 'person' data: [...] } id field can contain either positive or negative integers. This ...
2
votes
3answers
238 views

getting MySQL error 1064 but very (absurdly) simple query in MySQLWorkbench

I'm getting a MySQL 1064 error for the simplest query when run with \G at the end. This works: select * from locations; and this doesn't: select * from locations\G hmmm... is there any way to ...
2
votes
1answer
505 views

transactions and Oracle dblink

I have 2 dbs, let's call them writedb and readdb. Readdb has a dblink to writedb and a view to a table over that dblink. I do an update on writedb to that table which view points to and then read ...
1
vote
0answers
572 views

What are the different types of binary relationship types?

I'm new to databases and while studying questions on it, I've come across one that I can't find the answer to. Define the three different binary relationship types that are common in relational ...
3
votes
2answers
306 views

Rebuilding indexes on a list of tables

I have a large number of tables that may change, may have infrequent changes in index, etc. I may well hand this off to somebody else and I don't want indexes to become overly fragmented, slowing the ...
3
votes
1answer
2k views

How to Identify Who or What is Restarting SQL services via Service Control?

I investigated an instance that experienced an unexpected restart and came across the usual service control event but no user login associated with it. Is it still possible that an authorized user ...
7
votes
1answer
6k views

MySQL open_files_limit - cannot change this variable

I'm running into issues because my open_files_limit for mysql is only 1024. Centos 7, MySQL Community Server 5.6.22-log It's actually a vps dedicated to mysql for a WHM server (remote mysql), but ...
1
vote
0answers
41 views

Please explain log-shipping delta

I am trying to understand how Delta is monitored in log-shipping. We have log-shipping monitoring in place and I am seeing delta increases sometimes for random instances and it drops once database is ...
0
votes
0answers
82 views

Which is the best way for selecting dimension attributes while creating a dimension?

I'm a newbie to SSAS OLAP so please apologize me if it was a silly question but surely I need suggestions. I would like to make clear some concepts which was confusing for me. Let us consider five ...
1
vote
1answer
49 views

Index that mimics full-text-index

I have a database that is retrieving information quite slowly, I asked a question and was told to use full-text-indexing, this worked, but now we switched over to a .sdf file and Sql Server Compact ...
4
votes
1answer
130 views

SQL Server : scheduled JOB issue

I have one issue in my live server, I created a job to shrink the log file and I have scheduled it to run every day with sa user When I run this job manually from Management Studio, it is run ...
1
vote
1answer
789 views

MySQL cluster error: “Got error 4009 'Cluster Failure' from NDB. Could not acquire global schema lock”

I am trying to configure MySQL cluster under three Windows 7 machines with disabled firewall, cluster information is like the following: 2 hosts with each running 1 data node 3rd host running ...
0
votes
1answer
91 views

Hierarcy Query Mysql

I have a table like this... ========================================================================== UID || PARENT ID || SPONSOR ID ...
1
vote
0answers
255 views

Using Netscaler datastream and MySQL

I configured MySQL service on a netscaler 10.5. When I perform some MySQL benchmarks using mysqlslap, the first time it runs correctly, the 2nd time I have an error message: When I run it the first ...
1
vote
0answers
130 views

How to modify an existing AlwaysOn Availability Group IP

I have an unusual question regarding AlwaysOn Availability Group configuration. I have built out an AOAG cluster on a VM. The build out did not use a Heartbeat network as I had originally requested ...
1
vote
2answers
1k views

Best practice - use of derived table or use the original table in join?

Imagine I have the following tables in Teradata : TableA : Field1|Field2|Field3 TableB : Field1|Field4|Field5 I am trying to join these two tables Method 1 : SEL TableA.Field3, TableB.Field4 ...

15 30 50 per page