System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

0
votes
1answer
50 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 ...
1
vote
0answers
13 views

Securing communication over LAN in VPS provider

I'm curious about best practice when connecting from app to DB in a cloud provider. A quick rundown of our setup. We have 4 servers all on the same provider, in the same region running as VPS. ...
-3
votes
0answers
9 views

I have complicated SQL syntax, and it's error, how to solve it? [duplicate]

This is my error SQL syntax: WITH dept_total(dept_name,value) AS (SELECT dept_name, SUM(salary) FROM instructor GROUP BY dept_name), dept_total_avg(value)AS (SELECTAVG(value) FROM ...
-3
votes
0answers
18 views

My SQL syntax is error, how to solve it?

This is the SQL syntax: WITH max_budget(value) AS (SELECTMAX(budget) FROM department) SELECT budget FROM department, max_budget WHERE department.budget = max_budget.value; I get this error: ...
0
votes
1answer
21 views

PostgreSQL : Strange Sudden Data type AND select schema issue

Here is my problem : Actually I am using postgresql 9.4 and postGIS extension. I am creating a database, and adding new tables with no problems... with geometry data types... until now... Now, I ...
1
vote
1answer
725 views

Zabbix no free space on disk

I have zabbix 2.2.1 and 252 monitors the hosts. Currently, the database is in local and size database is 65GB is running housekeeper who clears history entries older than 30 days. Entries are deleted, ...
4
votes
2answers
5k views

datetime format changed between mysql 5.0 and 5.1?

I've upgraded a mysql slave from mysql 5.0 to mysql 5.1. during the catch up, the replication failed on a query with incorrect datetime value: 110919 13:56:18 [ERROR] Slave SQL: Error 'Incorrect ...
1
vote
2answers
343 views

Tip for a good Database Converter Tool [on hold]

I need often to convert a database from a database server to another, for example convert a database in MSSQL to a PostgreSQL or convert a MySQL to PostgreSQL, but also convertion between MySQL and ...
3
votes
3answers
4k views

MySQL Table not repairing

Table info: Database name: user_motiva Table name: wp_options.frm wp_options.MYD wp_options.MYI wp_options.TMD when I do a mysqlcheck -r --all-databases it gets hung on that table even if you ...
1
vote
3answers
7k views

Recover password for datasource in Weblogic

Is there a way to recover the password for a jdbc datasource, which I used in a Weblogic Application server? I could change it, but since I'm not entirely sure, where we use the database, that would ...
2
votes
2answers
7k views

Server crashed, some MySQL databases are broken. Trying to recover with InnoDB recovery, but ibdata1 seems corrupt

I've a problem. Some days ago my root server crashes after a power outage. I realised that the MySQL server won't start. In the logs I find out that an error occured with InnoDB's ibdata1. I've ...
0
votes
1answer
2k views

Command to list event monitors in DB2

I see the following commands: drop event monitor set event monitor create event monitor But nothing like list event monitor or get event monitor. Is there a DB2 command to list all current event ...
0
votes
1answer
3k views

Can't connect to remote mssql server

I'm trying to connect to my remote mssql server for my GunZ private server, but for some reason i get the following error Cannot connect to 94.xx.xx.xx. ADDITIONAL INFORMATION: A connection was ...
0
votes
1answer
40 views

MySQL Optimization for write-heavy DB, single connection [closed]

I have a cloud machine with 1 core CPU, 1GB RAM and 24GB SSD. It is running CentOS 6.5, mysql 5.1.73 with default my.cnf. I have a PHP job that runs and fetches data from some other websites, ...
8
votes
7answers
651 views

How to avoid being scraped?

We have a searchable DB, and we limit the results to 15 per page. And only 100 results and yet still get people trying to scrape the site. We ban sites that hit it fast enough. I was wondering if ...
0
votes
1answer
24 views

Removing a mySQL database without password? [duplicate]

So about 6 months ago I set up a wheezy server and at the same time I installed MySQL even though I didn't need it. I've now updated to Jessie and need the database but can not remember the password ...
5
votes
2answers
905 views

What is Data Scrubbing in the context of database?

Even after reading on Data Scrubbing on Wikipedia, I am still not clear on what Data Scrubbing really is when the term is used for database. Is it a formal engineering principal that there is a ...
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
2answers
58 views

Postgresql: restoring database from dump fails

I am using psql (9.3.9) on Ubuntu 14.04. I created dump of a database using command: pg_dump db1 > db1.backup I deleted the db and recreated it. Trying to restore it with psql -d db1 -f ...
31
votes
4answers
37k views

How do I load a sql.gz file to my database? (importing)

I'm trying to import a gzipped SQL file into mysql directly. Is this the right way? mysql -uroot -ppassword mydb > myfile.sql.gz
0
votes
1answer
19 views

Slony PostgreSQL replication - Can I create an index on a table on a slave that isn't on the master?

I have just set up a slony replication set up between 2 postgres servers. One master, and one slave host. Data is being copied. We don't want to use this for data backup or anything, but want to do ...
3
votes
2answers
5k views

pgAdmin cannot connect to PostgreSQL 9.1

I am trying to use pgAdmin on Windows to connect to postgresql 9.1.8 running on localhost's Ubuntu 12.04 VM. The host's port 5432 forwards to VM's port 5432. pgAdmin Error: Error connecting to the ...
0
votes
0answers
7 views

How are databases able to process queries in parallel while still retaining correct order? [migrated]

How do databases process queries in parallel (more than one query at a time) while still keeping the correct order (queries are performed in the same order that they are submitted)? Is there a kind of ...
1
vote
1answer
2k views

ASP.NET Website Administration Tool: Unable to connect to SQL Server database

I am trying to get authentication and authorization working with my ASP MVC project. I've run the aspnet_regsql.exe tool without any problem and see the aspnetdb database on my server (using the ...
3
votes
3answers
2k views

How can I check if my DB needs more RAM?

How would you check if your postgresql DB instance needs more RAM memory to handle their current working data?
0
votes
1answer
2k views

Cannot start Oracle XE 11gR2 Net Listener and Database on Ubuntu 13.04

I have been following the setup step on this article for installing Oracle XE 11g R2 on Ubuntu 13.04. The environment variables PATH, ORACLE_HOME, ORACLE_SID, NLS_LANG ORACLE_BASE have all been set up ...
0
votes
0answers
14 views

Conservative Azure Windows VM to Run SQL Server 2008 R2 [duplicate]

For testing purposes I need to set up three Azure Windows VMs to each run an instance of SQL Server 2008 R2 each holding one DB of approx 100GB. There will be quite a few complex stored ...
9
votes
3answers
625 views

Best practice for 24 Disk Array

we have just migrated for our old fibre SAN storage to an IBM v3700 storwize with 24 SAS 600GB disks. This storage is connected directly to two IBM ESXi 5.5 servers each with two 6Gbps multipath SAS ...
0
votes
0answers
44 views

How do I quickly tell the structural differences between two databases? [migrated]

I am upgrading a web application to a newer version and need to migrate the data manually. The newer version uses slightly different database structure. It has added a few tables, but all of the old ...
1
vote
4answers
46 views

reliably write database dump directly to remote filesystem (Linux)

I need to move a very large database (~320 GB) from server1 to server2 (Linux). Because of different extension versions, the database can only be restored on server2 from a dump file as described ...
40
votes
7answers
34k views

What is the best Linux filesystem for MySQL (InnoDB)?

I tried to look for benchmark on the performances of various filesystems with MySQL InnoDB but couldn't find any. My database workload is the typical web-based OLTP, about 90% read, 10% write. Random ...
0
votes
2answers
40 views

Pros and cons of database choice for OwnCloud [closed]

OwnCloud provides 3 choices for its database: SQLite MariaDB PostgreSQL Obviously SQLite is not a practical choice, since it can rarely handle the load. What about the other two? Is MariaDB or ...
1
vote
6answers
719 views

Should I have one MySQL instance for all our apps, or one instance for each?

We're a small startup and I need to setup several applications, almost all of which require a database. I face the choice of setting up one instance of MySQL, with one database for each of our ...
0
votes
1answer
1k views

Need DB2 OLEDB Driver / ODBC Driver

I am trying to establish a connection between excel and db2. I am able to successfully query and retrieve data from my DB. I am using the below connection string ...
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 ...
1
vote
1answer
1k views

DB2 Integrity Checks and Exception Tables

I am working on planning a migration of a DB2 8.1 database from a horrible IBM encoding to UTF-8 to support further languages etc. I am encountering an issue that I am stuck on. A few notes on this ...
1
vote
1answer
302 views

Neo4j Web Server Hangs: Logging Issue?

I have a small database that was working fine just a day ago, but now, when I try to start it, the console claims that it succeeds in opening, but the web server hangs. lsof -i | grep 7474 states ...
-2
votes
0answers
15 views

Which db choose to concurrent work of 2000 connections and more? [duplicate]

Let's assume. I have some credentials data which plan to store in mariadb. And I have two php scripts: worker.php - must work 2,000 workers(it is condition!). This workers must use same db for select ...
13
votes
8answers
8k views

What hardware makes a good MongoDB Server ? Where to get it?

Suppose you're on dell.com right now and you're buying a server to run your MongoDB database for your small startup. You will have to handle literally tens of thousands of writes and reads per minute ...
0
votes
1answer
41 views

Connecting to Oracle DB hosted on Windows 8.1 Azure VM

I have a windows 8.1 vm created on azure, it has 14 GB of memory and 200 some GB storage. I have installed Oracle with a templated database onto it. Everything is fine with the installation and I can ...
1
vote
4answers
761 views

Random IP's constantly trying to connect to SQL Server

We are building a cloud-based application that relies on a login database as well as many individual client databases. Using rackspace we have setup a server (windows server 2012) with SQL Management ...
3
votes
3answers
6k views

1286 - Unknown storage engine 'InnoDB'

I am trying to use roundcube and it recently just broke. I don't know if this is due to a MySQL update that happened recently or not but in phpMyAdmin I get the following error if I try and view a ...
0
votes
0answers
22 views

SSD vs RAM - Optimal ratio for different data sets / databases [duplicate]

I am looking for an advice or even better some studies / benchmarks to read for different scenarios (data sets) when it comes to the best ratio between actual RAM and SSDs. I know that fitting the ...
1
vote
1answer
254 views

Recover mysql database innodb 'table doesn't exist'

Our server crashed last week and we lost a lot of information. We were able to recover .frm files for the tables, ib_logfile0, ib_logfile1 and ibdata1 but no .ibd. I've tried the ...
0
votes
0answers
17 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 ...
2
votes
2answers
162 views

Database backup encryption

I've been trying to work out an effective database backup encryption scheme lately. I have a Postgres 9.4 server, I have most of the backup scheme fleshed out I think. Backups will be stored in a ...
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 ...
4
votes
3answers
9k views

MySQL simple replication problem: 'show master status' produces 'Empty set'?

I've been setting up MySQL master replication (on Debian 6.0.1) following these instructions faithfully: http://www.neocodesoftware.com/replication/ I've got as far as: mysql > show master ...
-2
votes
4answers
80 views

When should I consider a 2 socket motherboard for Server? [duplicate]

We are buying a new server and the idea of dual socket motherboard comes up. Is 2 socket motherboard worth the price and hassle for an application that hosts a couple of websites and databases for a ...
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 ...