0
votes
0answers
2 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 ...
0
votes
0answers
4 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 ...
0
votes
0answers
3 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 ...
2
votes
0answers
8 views

Aggregation Operations on View Ignores Index

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 ...
-2
votes
1answer
30 views

how to Write a SQL Statement to display EmployeeID from Table1 and EmployeeName from Table2 a

how to Write a SQL Statement to display EmployeeID from Table1 and EmployeeName from Table2
1
vote
0answers
7 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 ...
0
votes
2answers
10 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 ...
0
votes
0answers
13 views

transactions and 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 ...
0
votes
0answers
11 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 ...
1
vote
2answers
57 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 ...
0
votes
1answer
25 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 ...
1
vote
1answer
3 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 ...
-2
votes
1answer
17 views

MySQL 2008 create database problem [on hold]

When I create a database in MySQL 2008 an error message is shown: "Create database permission in master denied in database master." What can I do?
0
votes
0answers
19 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
12 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 ...
0
votes
1answer
19 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 ...
1
vote
1answer
33 views

MS SQL SERVER Scheduled JOB issue

I have one issue in my live server ... Issue is that .. i have made one job for log file shrink & i have schedule it for every day run With sa user But when i run this job manually from management ...
-1
votes
0answers
10 views

MYSQL PHP slow response from server

I have max 72 connections at a time, normally it is 15 to 20 connections, but my server is response is slow and it is giving 500 internal server errors to users can you please tell me how to get rid ...
0
votes
0answers
5 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
17 views

Hierarcy Query Mysql

I have a table like this... ========================================================================== UID || PARENT ID || SPONSOR ID ...
1
vote
0answers
5 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
14 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 ...
0
votes
1answer
16 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 ...
-1
votes
1answer
28 views

The sum of the distances of all employees and select the top 3 [on hold]

I have a table "raporty" in which there are reports of all employees. Each employee has their id. How to do that for each employee separately summed up his trip distance and choose the 3 largest in ...
0
votes
0answers
5 views

Set variable if variable didn't initialized

I'm creating alternate of uuid_short() function named custom_uuid_short. DELIMITER $$ CREATE DEFINER=`root`@`localhost` FUNCTION `custom_short_uuid`() RETURNS bigint(20) unsigned BEGIN declare ...
0
votes
1answer
18 views

Changing mysql root password on Windows after removing mysqld-nt.exe

I am trying to change password of MySQL root by following the steps here: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html unfortunately the mysqld-nt.exe doesn't exist in Windows ...
0
votes
1answer
11 views

Changing mysql root password on Windows after removing mysqld-nt.exe [duplicate]

I am trying to change password of MySQL root by following the steps here: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html unfortunately the mysqld-nt.exe doesn't exist in Windows ...
0
votes
1answer
45 views

what's a reliable way to determine the ideal innodb_thread_concurrency setting?

on an article from 2006 , here they suggest such formula. 2*(number of cpus + Number of Disks) has anyone tried their settings according to this formula ? or do you have any other formula ? our ...
0
votes
0answers
7 views

Make a field in a form that count values [on hold]

i have a form that`s named classes and has a sub form named assignments i would like to create a field that will count the values in the sub form how much descriptions is in the assignments sub form ...
3
votes
2answers
28 views

Selecting minimum value in top grouping only

I have a query built in Oracle 10 which produces a set of data like this: EMP_ID WORK_DT TIME_TYPE ---------- --------- --------- 12345 19-DEC-14 10 12345 18-DEC-14 10 ...
0
votes
0answers
15 views

An efficient way to do “reverse queries” in MongoDB for an expert system?

I am working on an "expert system" in which I would like to perform "reverse queries", that is I want to store queries and find queries that match a given object. For example, if I have an object ...
0
votes
0answers
19 views

PostgreSQL indexing table on multiple columns

I have a table that holds half hour metering values in a compact form on a daily basis. The table has a structure as described below: day: timestamp without time zone, // describes a day ...
0
votes
1answer
20 views

I can not copy database MongoDB

I created a mongo cluster in ubuntu and run the copy in the sharding with a small database, everything works fine. The problem is that when I try to copy a database 300gb, is not getting done. The ...
9
votes
5answers
734 views

Reasons for avoiding large ID values

We are working on a web application, not yet accessible to users. My boss noticed that newly created records get an ID of over 10 000, even though we only have under 100 records in the table. She ...
0
votes
0answers
7 views

MySQL Socket exclusively

I've disabled TCP by using skip-networking in my /etc/my.cnf file I've deleted all users (mysql.user) that have other Host than localhost Now I went through the other tables in the mysql database ...
0
votes
1answer
7 views

mysqld got signal 11 - it's my fault but how do I fix it?

I was copying the database tables from our production server to my dev machine, and in the middle of the transfer I found out users were being locked out of the system because the select had locked a ...
0
votes
0answers
7 views

MySQL Socket connections and SSL

I'm currently running over some final tweaks and security measures for my MySQL server deployments. Mainly I'm running Google's Golang and connect to the MySQL database through a Socket connection. ...
1
vote
1answer
46 views

Investigating specific SELECT queries

For a particular row in a table how can I determine the number of reads done to it such as SELECT * FROM MyTable WHERE ID = <something> and when and where the read query executed? I'm ...
0
votes
0answers
5 views

Subreport Only Works In Some Situations

I have built a report that's a sort of "Landing Page" for two other reports. This report has two parameters, both of which can accept blank ("") values (not null). One of the reports is a "search" ...
1
vote
1answer
23 views

Pivoting with NULL Dates

I'm attempting the pivot below: SELECT EmpID as ID, [1] as January, [2] as February, [3] as March, [4] as April, [5] as May, [6] as June, [7] ...
3
votes
3answers
124 views

Login lifespan for password on SQL Server

What is the "lifespan" for a login with the option Enforce Password Expiration Enabled? Where can I find configuration/option to change the time?
-1
votes
2answers
42 views

Need help finding inactive users in my database

I am trying to figure out how to get this figured out. Problem: Users of inactive customers are receiving scheduled maintenance notifications Indicators: Organizations have a custom binary field ...
0
votes
2answers
12 views

creating table syntax error

I have a problem creating the table. It says unexpected parenthesis at line 3 CREATE DATABASE scl_teachers; USE scl_teachers; CREATE TABLE clteacher ( 'id' INT (10) PRIMARY KEY auto_increment, ...
0
votes
0answers
19 views

Upgrade from 2008 RTM to 2008 R2 RTM failed due to perf-ReportServer-rsctr.dll is being used by another process

I was upgrading SQL Server 2008 RTM on windows Server 2008 R2 Sp1 to SQL Server 2008 R2 RTM.I got this error " The process cannot access the file 'C:\Windows\SysWOW64\perf-ReportServer-rsctr.dll' ...
0
votes
0answers
6 views

Mysql Workbench Server Status CPU Metric

MySql Workbench 6.1 on Windows connecting to MySql 5.6 on Linux (Amazon RDS). The Management - Server Status page shows information about the connected Mysql server (Queries per Second, etc). It ...
0
votes
2answers
26 views

Get all the users that are managed by a targeted manager

I have the following model: Table user: (id, name, direct_manager_id) Table customer: (id, name, managed_by_id) i.e. users can have another user as their direct manager, Customers can be managed ...
0
votes
0answers
20 views

searching through entire database php script

$tableArray = array('tbl_course','tbl_faculty'); if(!empty($_POST["searchField"])) { $search=$_POST["searchField"]; foreach( $tableArray as $tblArry) { $out ...
-3
votes
1answer
37 views

Finding users with database owner role in sql server 2005 or so [duplicate]

I need a script which will list out all the users with DataBase Owner persmission for a specific database. Thanks
0
votes
0answers
15 views

MySQL InnoDB Deadlock For 2 simple insert queries

I have a deadlock for this two insert queries: insert into PlayerClub (modifiedBy, timeCreated, currentClubId, endingLevelPosition, nextClubId, account_id) values (0, '2014-12-23 15:47:11.596', 180, ...
-3
votes
0answers
48 views

Server CPU usage Issue [on hold]

I have a Database on MS SQL SERVER, The MDF file size os near about 30 G We have web application where this database is used. & while monitoring Live server, I Seen when number of User increase on ...

15 30 50 per page