System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

2
votes
0answers
54 views

Barracuda SSL VPN Managing Users

Not really sure if this is the right site to be posting on, but I have a question about my Barracuda SSL VPN. I know there is a built-in user database on the VPN. Is there some way (in my asp.net ...
2
votes
0answers
1k views

Firebird 2.5 Database Corrupt

We have an issue where a database hangs the server when: a backup is performed (Hangs on a specific table) selecting * or count(1) from a specific table or viewing data that is related to the table ...
1
vote
0answers
18 views

Setting up SQL server on EC2?

I would like to set up a SQL server in AWS on an EC2 server. I originally wanted to use an RDS instance however we require the bulk admin privilege for some of our operations which is not allowed in ...
1
vote
0answers
37 views

SQL Server seems to be taking 40GB of RAM but keeps reading disk… Why?

So I have allocated 40GB of RAM for SQL Server. I can see that after I first run a query on database, that 40GB memory limit will be quickly filled during first run, however when I will do exactly ...
1
vote
0answers
27 views

Huge oplog size after full sync on one secondary causing performance issues - MongoDB

I'm a MongoDB newbie. I have a replica set with 3 members (1 primary and 2 secondaries) on CentOS 6 and Mongo 2.6.8. One of the secondaries crashed because of high consumption of memory and I ...
1
vote
0answers
25 views

Managing data created with an API in multiple environments

I have a staging and production environment for my application and store Stripe::Customer ids in my database. Occasionally, I want to copy production data to my staging database, but the ...
1
vote
0answers
30 views

Commvault, how to generate a report by time scheduled?

I'm using commvault at the moment to manage backups, but i need to creata a report of some kind that can show me the days of the week , and what server is backing up at that moment. A bit like this: ...
1
vote
0answers
108 views

MSSQL Server 2008R2 Replication stall, no latency, no errors, missing data on subscriber

This morning after performing a routine database deployment of two new tables I noticed that transactional replication had stopped for more than 3 hours. When replication resumed it picked up 3+ hours ...
1
vote
0answers
84 views

Unexplained excessive database response times - very powerful hardware, tiny database

I've a strange problem that's repeatedly troubled me across 3 different servers now. The problem Please see the graph from NewRelic showing the huge amount of time spent in the database. The ...
1
vote
0answers
626 views

MongoDB Performance Troubleshooting

I have a small MongoDB replica set (2.4.6) and it seems about once a week, the primary gets bogged and the load average spikes up. This app doesn't see a huge amount of traffic. It resides in EC2 ...
1
vote
0answers
78 views

Tell proftp to allow connections only to the users that have permissions in PostgreSQL

I'm trying to set up an ftp server for the first time (under Debian Squeeze) and after searching through Google, I decided to use proftp. NOTE: I have a PostgreSQL server running in the same machine ...
1
vote
0answers
84 views

Legacy BSD PTYs instead of /dev/pts?

I'm trying to use an old database that only accepts connections from legacy BSD style pseudo-terminals /dev/ttyp's or /dev/tty's. It does not recognise /dev/pts/9 style PTYs. Connections via SSH. I ...
1
vote
0answers
23 views

My transactional overnight batch has spiked in duration

I have an overnight batch run which is transactional...picking up data doing some small calculations and putting it somewhere else and it was finishing around 3am every day for the last 2 months. Now ...
1
vote
0answers
631 views

SSD Performance under Oracle

I have serious performance issues with oracle running over ssd. I have two OCZ Vertex 3 MAX IOPS drives (firmware 2.15). It runs on a INTEL C600 SATA Chipset. Windows 2008 R2. So the issue is ...
1
vote
0answers
471 views

Corrupt mysql system tables

I am having issues with the columns_priv table in the mysql system database. I cannot add new users currently. I have tried repairing it using mysqlcheck --auto-repair --all-databases --password but ...
1
vote
0answers
137 views

Is memcache impacting my performence negatively?

I am using pressflow 6 and NewRelic seems to suggest that memcache is infact hurting performance as shown below : My settings.php file : # Varnish reverse proxy on localhost $conf['reverse_proxy'] ...
1
vote
0answers
437 views

Server quit without updating PID file on multiple mysql installation in linux

Iam trying to install one version of mysql in a LINUX machine. The system contain already another version of mysql installation. I prefer manual installation. Copy the extracted tarball into a ...
1
vote
0answers
568 views

mysql fails to start

My Django web app was working fine, writing data to a mysql database. However, sometime in the past 36 hours or so, it stopped working. I typed "mysql" into the command line (i'm using ubuntu on ...
1
vote
0answers
114 views

Really slow execution

I own a wordpress installation, and Updated to 3.4.1. After the upgrade, I got a very strange slowdown to my wordpress. After all, I used the define('SAVEQUERIES', true); in my wp-config.php with ...
1
vote
0answers
135 views

SQuirreL Client: Opening up a table in a separate tab

I've switched to SQuirrel Client to view an Oracle database with a variety of tables. At any given time, I need to look at the contents of several related tables at the same time. The problem is ...
1
vote
0answers
852 views

MySQL Replication: Slave I/O thread constantly dying and starting back up

I have MySQL running on Debian 5 (Lenny) between two MySQL databases. The data is being transferring between the two machines, but one of them is logging the fact that it's slave I/O thread is ...
1
vote
0answers
106 views

Effective backup and archive strategy for database and linked files

I am using Postgres to store a variety of application data for a webapp. Part of the application involves storing and retrieving user uploaded files. I am storing the files in the filesystem with ...
1
vote
0answers
1k views

PostgreSQL: Could not connect to server even though it's running!

I wonder if you could possibly help me. I have installed PostgreSQL and I have tried running various checks to ensure it is running and I know it is. Here are the results of searching for the ...
1
vote
0answers
952 views

listener could not find available handler for requested type of server

I have ora-12520. I run Oracle 11g on Red Hat 4 64 bit. Actually I have RAC but one node is down and I work only with up one (connection string point directly to listener of running node). I run test ...
0
votes
0answers
39 views

How to raise max no of file descriptors for daemons running on Debian Jessie?

I'm playing with pgBouncer as a connection pooling system for PostgreSQL. My system is a 12-core with 64GB RAM and 1Gbps network interface running Debian 8.1. Now I want to raise the limit for open ...
0
votes
0answers
25 views

Bridge server for connecting two databases?

I'm in a bit of a pickle. I currently have 2 database servers. One is hosted in the US and is online on the internet. The other is local, working only on LAN and external connections are not allowed. ...
0
votes
0answers
19 views

How can I access to a database on OpenShift?

I created an application on OpenShift, everything is working and there are no problems. I now need to attach the database that is on OpenShift with my desktop application developed in C #. The desktop ...
0
votes
0answers
16 views

How to Restore from sql Maintenance plan backup

I have a SQl 2005 Instance in my PROD SQL server. I have been given a task to migrate databases inside that instance to different SQL box ( SQl 2008 r2 in Win 2008 r2 box) Database. Current sql ...
0
votes
0answers
126 views

Repairing corrupt MS SQL master database - no SQL client access

Apologies for any duplication but I feel like I'm falling at the first hurdle. I have a MS SQL 2005 Server which is refusing to start and for which I don't have a password (including the 'sa' ...
0
votes
0answers
48 views

DataFileSync flushing mmaps takes a long time

We are running MongoDB 2.6.9 on a 64 bit Ubuntu Linux VM. When I look in the database folder, this is what I see with ls -lh: -rw------- 1 mongodb mongodb 64M Apr 15 14:26 admin.0 -rw------- 1 ...
0
votes
0answers
34 views

SSH tunnel is up, but cannot connect to database

I am working on a project where we are using an SSH Tunnel with port forwarding. Our server contains a website which references a database on our customers server. We have established an SSH ...
0
votes
0answers
33 views

SSH Connect to remote computer to query database on local server

I'm having real difficulty with an SSH tunnel to a customer server. This is needed as we are developing a site on their behalf, hosted on our server but referencing the database on their server. The ...
0
votes
0answers
28 views

Web and Business Azure Tiers sunset (Deprecation)

The problem I am struggling to understand which is the best option to move to from this as their is no direct replacement. What would be the best step forward? I have flagged that optimization needs ...
0
votes
0answers
83 views

Clean up AD References to now deleted mailbox Exchange 2013

We recently separated one of our mailbox databases into three databases to better manage its growing size. The migrations all went well, and the old database has been dismounted for some time. Today, ...
0
votes
0answers
44 views

tfsbuild.exe delete / destroy keeps orphans in database

We're using TFS 2012 since 2013. In the mean time the database has increased up to ~60GB. This has several drawbacks like increased backup time, wast of drive space, ... After having a look into to ...
0
votes
0answers
13 views

percona cluster schema change with RSU issues?

I have a setup with three percona cluster servers. I am doing some tests with online schema changes using the manual RSU method [1]. I have a question regarding what happens when you drop a column on ...
0
votes
0answers
8 views

msxbse35.dll intermitent error accessing shared opera foxpro database file

I have traced the failure of an Access 97 DB, where it works some of the time and not others. It can take a few page changes in the DB to get the error up, just as easily as it can come up right away. ...
0
votes
0answers
111 views

How do I migrate a database between servers from SQL 2008 Std to SQL 2014 Std using T-SQL without losing data?

What is the process using T-SQL to copy/move/relocate a database from one server to another? Do I need to take a log backup on the source as well and restore it on the new server? I am pretty sure ...
0
votes
0answers
13 views

VCenter and SSO Database

We are using external dedicated Database Server During VCenter SSO installation RSA Database got created using the script (RSA_DATA.mdf,RSA_INDEX.ndf,translog.ldf)and pointed the SSO to it Now During ...
0
votes
0answers
202 views

MySql server keep crashing inside docker

I am running mysql inside docker with its /var/lib/mysql mounted on HOST. Eveything was working fine . Then i upgraded the docker from 1.4 to 1.5 . I rebuild the mysql image and but /var/lib/mysql ...
0
votes
0answers
57 views

Database Organizational Structure, DB Groups

I'm setting up a web server where users can create their own databases. In order to prevent name clashing, I've typically seen hosting companies handle this by prefixing any DB name the user creates ...
0
votes
0answers
32 views

Duplicate DB and files

I'm creating a group of websites using the CMS Concrete5 has models to be presented to my clients. My idea is that they can choose each one they want and deploy a new subdomain with a model ready to ...
0
votes
0answers
56 views

Percona connectivity issue, user cannot connect?

I am trying to authenticate a user in percona but I am seeing the error message below each time I try... 2014-09-29 12:43:37 5028 [Warning] The plugin '0' used to authenticate user 'user@' is not ...
0
votes
0answers
59 views

jboss 7 connection to database vip fail

Jboss 7 is connecting to HA database with VIP. When master db fails, the HA kicks in and slave db takes over as master. Querying directly the new master db works fine. However, at Jboss level, the ...
0
votes
0answers
46 views

Write Failed Request Tracing logs to a database

I'm using Failed tracing logs on my IIS 7 which are a very good source of debugging information. Theses logs are written on the hard drive but I would like IIS to write them directly to a database, ...
0
votes
0answers
97 views

SQL DATABASE USING VPN

I have a very simple classic asp site on a Windows 2008 Server with an IIS 7.5 that connects to an Sql database on a Sql 2008 r2. the site works perfectly when accessing it both locally from the ...
0
votes
0answers
168 views

indexing a ~3gb database into elasticsearch: how?

I have a new database of 2 million records (around 3gb when dumped json) produced every several days. I want to quickly put it into ElasticSearch. That's what I do right now: Create a new index and ...
0
votes
0answers
313 views

AIX JFS2 I/O performance problems

I have a fresh installation of AIX 7.1. I noticed that JFS2 file system with logging enabled (log=/dev/hd8) is dramatically slower than one with log=NULL. Simple zip archive extraction takes 5 minutes ...
0
votes
0answers
51 views

Dismounted Exchange Database - It's disappeared

I dismounted a database to try and fix the backup. It's not in the list of databases anymore, and I can't figure out how to mount it again. Googling does not help. Does anyone have any suggestions? ...
0
votes
0answers
349 views

Postgresql running slow

We recently migrated our postgresql server from a heroku 400mb ram add-on to a SSD VPS with 1GB of ram and we have seen a huge performance drop. I am using ubuntu 12.06 and have increased the ...