0
votes
0answers
6 views

MySQL Table with 568 columns: 1118, 'Row size too large…'

I'm currently migrating database from Oracle to MySQL5.6. One table consist of 568 columns. When I try to create the table I received this Error 1118, 'Row size too large..' I already followed an ...
0
votes
0answers
2 views

PgPoolAdmin cannot execute pcp commands

Reffering to Pgpooladmin pcp commands does not work I tried to start pgpool-II from console and it works fine, but when I try to reload/start/trop it from PgPoolAdmin it shows error "pcp_node_count ...
0
votes
0answers
6 views

What is the meaning of different roles available(DB Admin etc.)

I have recently installed MySQL and also created the basic user as scott but my doubt is regarding the roles. I don't understand different roles available for the user which I have created. I want ...
0
votes
0answers
4 views

Plz clarify me about oracle apps dba functionality

I am new to oracle field. My organization wants me to work on oracle apps DBA. Can you please explain me what is oracle apps DBA and what will be its role and career opportunity on this.
0
votes
0answers
10 views

Two SQL Server databases setup with same .mdf and .ldf files

In a SQL Server 2008 R2 instance two databases (the second one being a restore/copy of the first one) have been setup against the same .mdf and .ldf files. How would I go about either deleting the ...
0
votes
1answer
13 views

Slow DELETE in MySQL with a subquery

I am running the following DELETE SQL on a MySQL database on a MyISAM/utf8 table. The SQL is called in a loop, once time per Users (in this case):- DELETE FROM regulatory WHERE documentid IN ( ...
0
votes
0answers
3 views

Data modeling with many attributes where few apply to each record

I'm pretty new to data modeling, so please excuse me if I've missed something obvious. I'm trying to decide on a schema (or possibly a DBMS) to work with some data where there are quite a few possible ...
0
votes
1answer
8 views

How can I maintain old information after an update?

I am having an issue figuring out a solution to not lose old information. For example, customers can place many orders. Let's a customer, Mary, makes her 1st order in 2013. Fast-forward to 2014, ...
0
votes
0answers
13 views

How do I build a mysql LAN out of scratch? What do I need?

I have mysql workbench, is that all the software I need? I am trying to connect 6-7 different computers together using a LAN onto a mysql server and I dont know where to begin. Any helpful links ...
1
vote
0answers
18 views

Different Execution Plans Picked for Similar Queries

Thank you in advance for reading it. This question is kind of long and need a little patience to read. I will provide as much details as I can to void interference factors to solve this problem. ...
1
vote
2answers
30 views

Are there benefits to using more than 4 CPUs for MySQL?

We are running MySQL 5.5 on linux under VMWare, running on 2 CPUs. We are planning on increasing this to 4, but we have un-used CPUs available, and I'm wondering if there is any benefit to increasing ...
1
vote
2answers
22 views

How to do the complex nested select SQL?

I have two tables, table1 is as following, id is primary key, table2_id is foreign key id date aid table2_id message 1 2014-03-19 16:21:02 121 1 login from xxxx 2 ...
1
vote
1answer
32 views

Wildcard subnet mask for IPv6

To allow any host to connect to PostgreSQL we can use the IPv4 wildcard subnet mask: 0.0.0.0/0 I need this to setup my PostgreSQL's pg_hba.conf file correctly. What is the IPv6 equivalent?
0
votes
0answers
20 views

Need some ideas for class/certification for Data Warehousing/Big Data

I am an ETL developer at a large company and have the opportunity to attend some training. I get to pick a few class's/certifications. What would this community recommend as best for someone that ...
1
vote
3answers
38 views

Best table name instead of “user”, if the DB doesn't like that

Yes, I know, it is possible to quote the name of the table, but it is sometimes improper. If there is no alternative, I name this table as "users", although this semantically unneeded plural makes ...
0
votes
0answers
8 views

Setup mySQL in a chroot in Debian Wheezy

Sounds like a simple question, but the documentation is rare about what mySQL needs to run inside a chroot. I think I'm almost there, but I'm running into a permission problem that I can't solve, and ...
0
votes
0answers
25 views

slow writes on percona server only when replication is running

Hi I am trying to migrate to percona server from mysql 5.6 on windows. In my development machine for percona is running of centos 6.5 which is installed on vmware 5.5 sphere. Our business ...
0
votes
0answers
13 views

question on oracle query performance/tuning

we have a query with large union all with a lot of tables. If that query gets hung up, it will hold up alter statements on those tables we should break the query up into individual ones to minimize ...
1
vote
1answer
24 views

Does SQL Server 2014 Express, with Advanced Services, actually support full text search?

I've installed SQL Server 2014 Express edition, with advanced services. I was hoping to try out the full-text search features. I read here that full text search is supported by the 2014 express ...
0
votes
3answers
8 views

Export data from a CCURE 800/8000 System using a pair of ODBC data sources?

I'm working on a security system called CCURE 800/8000 and trying to export some entrance / exit data from the Activity Monitor that logs when people use their badges to enter and exit the building. ...
0
votes
2answers
13 views

Seg faults in Percona Server 5.6.19

Trying to figure out what went wrong here. Any advice would be appreciated. This server is running a new installation of Percona Server 5.6.19 on CentOS 6.5 16:05:46 UTC - mysqld got signal 11 ; This ...
0
votes
1answer
31 views

Are these linked server queries susceptible to SQL injection?

I'm using a stored procedure to generate a create table script on the fly based on parameters passed into it. I am validating that the server exists, and then validating if the table exists in the ...
0
votes
1answer
13 views

How to log DML statements executed by a pl/pgsql function?

I have a pl/pgsql function (see below) that lists some fields and clears their contents using dynamically constructed UPDATE commands. When I set log_statement = 'mod', I can see nothing on the log ...
0
votes
0answers
14 views

MySQL 5.5, Xubuntu 14.04 - INSERT and UPDATE bottleneck

DBAs: I have been developing and maintaining plugins for Moodle for the last ~2 years, and have recently decided to try using my local desktop again, rather than my institutions ESX VMs, as a ...
1
vote
1answer
47 views

Use NOLOCK hint when calling table valued function

Suppose the following function: CREATE FUNCTION [dbo].[ufnTest]() RETURNS TABLE AS RETURN SELECT 1 AS Nr My actual function will select actual data from many different tables. I (mostly) understand ...
0
votes
0answers
15 views

SQL Server 2005 templog.ldf hits max size [duplicate]

I have a SQL Server 2005 database, Win2008 R2 server. The max file size limit on the temp db has been 6GB for years, without issues. We heavily customize our database with custom code monthly. ...
0
votes
0answers
3 views

MongoDB SSL Certs

I have built MongoDB with support for SSL and am wondering how it works with certs signed by a certificate authority? I have a wild card cert for the domain, so if I have mdb(1|2|3|4).domain.com and ...
0
votes
0answers
6 views

Sysadmin tools for SQLAnywhere

I'm seeing a performance issue in a 3rd party application based on SQLAnywhere 7. The DB engine seems to be dramatically underperforming on the hardware provided. It seems to have a upper limit on the ...
0
votes
2answers
23 views

Is there a way I can use currval() without selecting it more than once?

I want to be able to use the current value of an auto ID by giving it some kind of name and just referring to it (instead of calling SELECT for each record): Requests table has a serial column named ...
1
vote
1answer
17 views

Calculate value differences of rows before and after bounded by multiple referenced rows

Supposed I have a user travelling table like this: id | start_time | end_time | location | ----+--------------+------------+------------+ 1 | 1 | 2 | Loc_A | 1 | ...
2
votes
2answers
31 views

How to monitor InnoDB Disk I/O using Server Status Variables?

This question is extension of my previous question "How to monitor InnoDB Disk I/O Required for MySQL? " As mention in my previous question i want to count total number of disk i/o per query, but ...
1
vote
1answer
63 views

SQL Datetime / datetimeoffset(2) comparison & implicit cast wierdness

I discovered a problem when inserting data in our database. My insert statement was checking for the existence of data in the WHERE clause to prevent duplicate data being inserted. None was detected, ...
1
vote
0answers
15 views

Meaning of query in pgbouncer.log

I could not find any documentation about pgbouncer log, I'm assuming it has the same meaning as the SHOW STATS ? req/s - number of requests since last stat period in b/s - Bytes per sec received ? ...
3
votes
2answers
56 views

Log File Management - Space on Disk

At our organisation we have several non-Production environments where Developers run free and wild with TSQL code and databases. The DBA team do not normally monitor or maintain them. Recently several ...
0
votes
1answer
20 views

Does PostgreSQL write first to WAL and then to data files?

This is regarding the synchronous_commit in Postgres. The synchronous_commit documentation says: Specifies whether transaction commit will wait for WAL records to be written to disk before the ...
2
votes
1answer
24 views

Cannot start SQL Server replication as already running

I'm trying to configure a sql replication on the sql server 2012 . I am logged in as "sa", when I attempt to start replication i get the following error : How can I stop this job and restart the ...
0
votes
1answer
15 views

Creating unique constraint to be validated from input

I have this table name tbl with this table definition: create table tbl ( id serial primary key not null, counter integer not null default 1, ref_id integer not null, date_booked date ...
0
votes
1answer
11 views

Can we have more than one arbiter in monogodb replica set

I am setting up cluster of my webserver which uses mongodb. I am doing replica set of mongodb.I have only two machines. So can I have two arbiters in replica set ?
2
votes
1answer
35 views

Need scalable database solution for very big automated data entry database

I've been working on MySQL database in simple web applications for a long time and i now have a project which should maintain about 1,000 up to 10,000 query per minute (it is some logging database ...
0
votes
0answers
16 views

MS SQL SERVER Database mail stopped working automatically due to Timeout error

I am using SQL Server 2008 R2 SP1 , sometime database mail stopped automatically with the following error. How to fix the same. It have service broker enabled and i cleared the unsent mail. ...
0
votes
2answers
35 views

What is the best choice for MySQL high availability (zero downtime)? [on hold]

As I know there are many solutions for MySQL HA, but most of them are congenitally not zero downtime solution, like MHA, AWS RDS... That said, if zero downtime is "must have", the only choice is ...
1
vote
2answers
32 views

SQL - query multiplying records returned - Cartesian Product

I am using the following query which is returning a huge number of multiplied records - i.e. a cartesian product: SELECT * FROM specimen, topography_index, morphology, functions WHERE ...
1
vote
1answer
20 views

CRM Address table and it relation

Hi I want to ask about I have this DBD for my CRM I am trying to have the addresss in one table(customer and Employee Address) and both customerID and Employee ID are guid I have in address table FK ...
5
votes
2answers
80 views

Clustered Table Scan Because of “SELECT *”

I have a Records table with over 100 columns and very many rows, and a nonclustered index on 5 fields based on my access paths: CREATE NONCLUSTERED INDEX [IX_Records_CustomerID] ON [dbo].[Records] ( ...
0
votes
1answer
18 views

Omitting [INTO] in the INSERT … SELECT statement

Does the INTO keyword only makes the query more readable, or does it bring another benefits as well? The queries beneath both seem to run equivalently . insert ignore tbl (type, details) values ('1', ...
0
votes
0answers
55 views

SQL database recovery from corrupt database file. Anybody know the solution?

Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which contained copies of my SQL Server databases. A few days ago I lost some part of my data due to accidental ...
0
votes
0answers
8 views

Oracle 11g not allowing to connect to. Error ORA-01122: database file 1 failed verification check

I am running Oracle 11g on Windows 7 Enterprise SP2 16 GB RAM, 1 TB HD. I can connect to Oracle using SQL Plus (see below), C:>sqlplus sys/xxxxxxxxx@XE as sysdba SQL*Plus: Release 11.2.0.1.0 ...
0
votes
1answer
20 views

What is a construct in Oracle?

I'm currently studying Oracle Architecture and Database Memory Structures. I'm a newbie in the subject and I just read that a "Shared Pool" is "a data structure that caches various constructs that can ...
0
votes
1answer
21 views

MySQL EXECUTE formula from table field

I am attempting to run an UPDATE function where the formula for the updated field is provided by a related table as a string. Example, I want to update a field named HOURS in TableA based on a formula ...
1
vote
0answers
18 views

How to draw series line in SSRS chart

Does anyone know how to add the series line between these columns in SSRS chart? Thanks!

15 30 50 per page