System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

-4
votes
1answer
32 views

how to connect my server to internet [closed]

We have a project which very resource consuming in databse part and we found that database hosting which is satisfied our needs is lot money consuming. We want to built own server and connect our ...
0
votes
0answers
1k views

Reducing memory usage of MySQL

Conclusion: if you really want to use little memory out-of-the-box drop MySQL and use PostgreSQL: it has a ~30Mo memory footprint, i.e. more than 10x less than MySQL; the migration was quite easy be ...
0
votes
2answers
369 views

MariaDB set maximum database size to 1 GB

I'm using MariaDB on my hosting. I would like to limit database size to 1 GB. How to do this properly in /etc/my.cnf ?
1
vote
2answers
1k views

How to install Sphinx on CentOS 6 where the DB and App server are separate servers

First what is the best way to install Sphinx on a centOs server rpm -ivh http://sphinxsearch.com/downloads/accept.php?file=sphinx-2.0.6-1.rhel6.x86_64.rpm yum install sphinx didn't seem to work. ...
2
votes
2answers
3k 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
24 views

Storing and accessing common non-sql database live from the cloud?

Let's say the database is non-sql, something completely archaic like paradox or whatever. I have no power over it as I'm not the developer. However, I would really like to have the database live on a ...
1
vote
2answers
1k 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 ...
2
votes
1answer
3k views

How to calculate max_connections for PostgreSQL and default_pool_size for pgbouncer?

Is there a rule or something I can use to calculate a good number for max_connections, default_pool_size and max_client_conn? The defaults are odd. PostgreSQL defaults to max_connections=100 while ...
0
votes
3answers
2k views

Cannot connect to mysql database remotely using jdbc

I am trying to connect to my database which is hosted on 000webhost. I am connecting from SmartFoxServer, and they allow database connections. All you have to do is change some of the settings in the ...
0
votes
2answers
116 views

Is looking up a filename in a directory of 20,000 items as efficient as looking up a row in a database? [closed]

I'm trying to decide between storing some XML data either under uniquely identified file paths on a Linux filesystem, or in text columns in a database table. All other things being equal, is access ...
0
votes
1answer
104 views

Do database triggers have performance impact on overall database functioning?

I have a trigger defined on a table, which for every insert, update or delete, will populate another table. Will this have any performance impact on the overall database functioning? Are there any ...
0
votes
1answer
242 views

Is the Ejabberd default DB suited for large cluster deployments? [closed]

Im setting up a cluster of Ejabberd nodes to to host 1M+ active connections. Is the internal Mnesia database on every cluster the best solution in terms of reliability and load balancing, or would ...
1
vote
2answers
2k views

Mailboxes moved and whitespace isn't increasing… aka logical mailbox space not being freed

I understand the difference between "logical" and "physical" free space and have a problem with whitespace not increasing (logical space, formerly event 1221 in Exchange 2003). Given that I have ...
3
votes
3answers
656 views

if I select more than 15 fields, I get catastrophic failure

Using sql server 2012 I am connecting to a linked server with Pervasive SQL on it. When I do select * or select field1,field2,field3....field15 I am getting this error: Msg 7399, Level 16, State 1, ...
0
votes
1answer
401 views

Setup HA postgres database, failover concept

I want to setup a HA postgres database. I setup master and slave database with synchronous streaming replication on different physical servers. When there is an error in the replication, the slave db ...
-1
votes
1answer
219 views

MySQL Configuration on my.cnf [closed]

[mysqld] core-file default-storage-engine=MyISAM max_connections = 5000 max_user_connections = 5000 key_buffer = 1024MB myisam_sort_buffer_size = 512M join_buffer_size = 256M read_buffer_size = 256M ...
1
vote
2answers
61 views

How to control databases replicated by Mongo DB replica set

I have 2 databases in my mongo DB namespace, lets name them db1, db2 and db3 which are on the same dbpath. Is it possible to configure mongo db replica set in that way that db3 wont be replicated ...
0
votes
2answers
205 views

MySQL Database Problems - Growing too quick, Performance

I have some problems with my database setup: The MySQL Database is written to every few seconds and it grows in size very quickly. My disk space is limited though, so I have to work around that. ...
1
vote
0answers
376 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 ...
0
votes
1answer
201 views

Is it possible to dump a postgresql db and restore it in mysql?

I'm trying to get migrate data from a postgre db into mysql (mariaDB) and was wondering if it is possible to restore a db in mysql from a pgsql dump?
0
votes
2answers
148 views

Coverting MySQL SQL statements to SQL Server

I am installing a product which needs a database - it can use any database as long as there is a jdbc connector available for it. However, the installation guide has instructions only on how to make ...
-2
votes
1answer
174 views

Database synchronization [closed]

What is the most efficient way to sync/mirror certain data from a large remote database with a local version? The scenario is, there is a central remote database on a hosted server, which will share ...
0
votes
1answer
78 views

Amazon SImpleDB Architecture for an user with a friends list

I am relatively new to database designing. I am currently using amazon SimpleDB to provide my application with information, so far its been relatively good and efficient until just now. Basically, I ...
1
vote
1answer
4k views

How can I convert an MS Access database (.mdb) file to a Sqlite database (.db) file? [closed]

Can anybody help me convert an MS Access (.mdb) file to an Sqlite database (.db) file? I need to convert all the tables and dump the data inside. Are there any tools available, or is there any API ...
0
votes
2answers
107 views

Get dedicated server for the websites and keep shared hosting for the database, good idea? [closed]

We're thinking about moving from a shared hosting to a dedicated server (a managed one, we don't want to manage/maintain it for now). I keep reading that it's best to have a server for the websites ...
0
votes
1answer
118 views

Recovering InnoDB

Bit of tough situation. Running MySQL 5.5 on Ubuntu 12.04. Looking to add some functionality to our internal site, I installed Kaltura. In doing so, my existing MySQL databases seemed to lose all ...
0
votes
1answer
60 views

Getting exposure to big data without having to set up the environment [closed]

Is anyone aware of any sandbox where an environment is already set up for big data processing? It can be hadoop, cassandra, pig etc... I'm a sql server programmer, and trying to get into big ...
1
vote
2answers
2k views

Connecting to oracle database instance running on VM(Guest Computer) from remote computer

I have oracle database instance up and running on vmware player on Redhat linux(Guest OS). This virtual machine is running on on windows 7 computer(Host OS). I am able to connect to the database ...
0
votes
2answers
140 views

Redundant Database [closed]

This has been killing me for weeks - I'm finally breaking down and asking for advice. I'm currently in the process of setting up database servers for a startup web application. The application ...
1
vote
2answers
273 views

Nothing Can Access MySQL

I have been trying to install WordPress, but I get the error, "Error establishing a database connection". I realize this is a common error, but after a few hours, I haven't found any solutions that ...
-1
votes
3answers
660 views

Redirect MySQL queries to another server [closed]

In order to lower system usage I'm planning to use another server to store my databases. so how can I redirect MySQL queries to another server or make MySQL to store databases on another server?
2
votes
1answer
507 views

Should a connection pooler be run on my database server or my app server?

I'm getting ready to start using PGBouncer, but I'm unsure of whether it should be used on my database server or on the app servers. If it's on the app servers, there will necessarily be multiple ...
-1
votes
1answer
176 views

ZFS System on Production [closed]

Do you know/have any system which works on ZFS such as RDMS? If yes, what is your setup? FreeBSD, ZFS on Linux etc.
0
votes
1answer
39 views

Database server [duplicate]

Possible Duplicate: Can you help me with my capacity planning? I am going to make an Internet project. The sizes of it I don't know now. But I want to ask some questions. : 1. What database ...
5
votes
1answer
561 views

Removed Old Domain Trust. Now Progress (9.1D) can't open DB File

My company has an old server, running Progress 9.1D on a Windows 2000 VM, which was used by our company OS (Vantage 6 by Epicor.) Vantage was our primary OS for a very long time. About 2 years ago, we ...
6
votes
4answers
2k views

PostgreSQL scaling up to 64 cores?

In this Computer World article, it specifies that PostgreSQL can scale up to a core limit of 64. Does this mean for one multi-core processor of 64 cores? Or multiple processors with fewer cores? The ...
0
votes
0answers
106 views

Sleep processes in MySQL workbench

When I view server status in MySQL workbench I found out that there are a large number of proceeses with command "sleep". No active query is going on and I fear would it be the case that I ...
0
votes
2answers
53 views

Problems locating Redmine database

I have an active redmine but I can not find the database where it is running right now. It should be on PostgreSQL but the database where it should be running is empty. Does anybody have any idea how ...
0
votes
0answers
326 views

ORA-00942: table or view does not exist & ORA-01031: insufficient privileges

I can't access any tables on my oracle database. When selecting the table product I get ORA-00942: table or view does not exist I have tried this solution but I don't have sufficiënt rights to add a ...
-1
votes
1answer
85 views

Choosing a database management system to maximize availability and scalability [closed]

If I was planning on choosing a database management system and know that the data needs to be available as close to 100% as possible and that it needs to scale as well as possible, is there a "best" ...
0
votes
2answers
553 views

How to use read replica instance for websites? Amazon RDS MySQL

Amazon RDS FAQs stated that it is up my application to distribute traffic to the read replica. My websites have mostly visitors - non-logged in users. So, I suppose most database activities are ...
1
vote
0answers
277 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
3answers
78 views

Is it possible to detect that a database connection is to a copy rather than to the original database? [closed]

I have an application that needs to know if it is connected to the original database that it was installed with or if the connection is to a copy of that database. Is there any known method to know if ...
0
votes
1answer
1k views

innodb corrupt tables

Running shared hosting cpanel box with Mysql 5.5. Restoring or packaging (using pkgacct) is giving off some serious database errors, on multiple various users sum_joom954.jos_wf_profiles OK warn ...
3
votes
2answers
1k views

Puppet: how to use data from a MySQL table in Puppet 3.0 templates?

I have some data whose source-of-truth is in a MySQL database, size is expected to max out at the some-thousands-rows range (in a worst-case scenario) and I'd like to use puppet to configure files on ...
2
votes
1answer
55 views

Website search function working from one location but not another

The company I work for does a lot of business with a government program, U.S. General Services Administration. Their website is located here. For the last two weeks, we have been unable to perform ...
0
votes
2answers
268 views

Creating a local database instance from the RDS snapshot

I am running a AWS RDS large instance for the production. I am taking mysqldumps everyday at mid-night. But it take too long to take the mysql dump and the website does not respond during the mysql ...
0
votes
1answer
42 views

DB Migration switching from MySQL [closed]

I currently have a massive MySQL Data but would like to move over to Cassandra nosql. How hard of a move over would this be? I've not found any examples yet on this being done. It is possible right.
1
vote
1answer
86 views

Is it safe to use password in script to backup database of remote server?

Currently, Im using a small script to automatically backup my database (of a webserver). To backup the database, I have created a user account with only read and lock privilages. The script will use ...
1
vote
1answer
438 views

postgreSQL replication and failover with repmgr on Ubuntu

I'm new to Linux and have been tasked with setting up a redundant Linux DB server with PostgreSQL. preferably the fail-over needs to be automatic, but a manual process will be fine for now. What I ...