System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

1
vote
0answers
21 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
votes
1answer
36 views

InnoDB Failure of some kind [closed]

I have MySQL 5.5 installed. I tried to install Joolma but it failed. I went into their sql and replace EGNINE=InnoDB with MyISAM and the install worked. InnoDB is listed under SHOW ENGINES; Any idea ...
-1
votes
1answer
2k views

mysqld 5.6 service error 1067

Upon running this service "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL56 I get this error windows could not start ...
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
1answer
1k 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
3answers
655 views

Can't start MYSQL after changing directories

So I started running out of space on my linux hard disk. I added another hard drive and now I want to change the MySQL directories. So instead of saving the data into the old hard drive, it saves it ...
0
votes
1answer
41 views

Database replication with old data

I am using MySQL to accomplish Database replication. The replication process is works very well. What my problem is, the old record is not copied from the master database. Is there is any way to keep ...
0
votes
2answers
199 views

OpenLDAP: How to hide config directory from tools like JXplorer, etc

I'm trying to set up an OpenLDAP server for test and demonstration purposes - my team need to be add LDAP connectivity to our product, so we want to have an LDAP server we can authenticate against. ...
0
votes
1answer
49 views

Setting up a transparent proxy for a database

Currently my setup is as follows :- Database client/library <---------------------> Database I'd like to have the following :- Database client/library <---> Proxy <-------------> Database ...
1
vote
1answer
45 views

IBM Tivoli Reclaim vs Update

What is the difference between TSM reclaim vs update? I have accidentally run the reclaim command on my offsite pool? Is it fine to run the reclaim command on offsite pool or is there a bad impact by ...
-1
votes
1answer
45 views

Improving Database Performance [closed]

I've heard that you can do something like the following in my.cnf to get better performance: tmpdir = /dev/shm I'm running MariaDB and wondering is this a good idea? All it does it create the ...
4
votes
1answer
4k views

Maintenance of tables: do I need to REINDEX a table after truncating and repopulating?

I have a table with about 2 million rows in it of transactional data that we use for analytics. Every week we reload this with new data, so we've been using TRUNCATE to clear it out and then inserting ...
0
votes
1answer
108 views

Solutions for a growing Postgresql database on Amazon EC2?

I've been doing a lot of research into scaling issues on Amazon EC2, especially growing databases. I looked into how I can make the database more solid and sound (I use PostgreSQL). Many sources say ...
0
votes
1answer
50 views

Stable version of Mysql [closed]

I am plan to do some real application, here i finalized to use mysql as a backend. And my question is Currently which MySQL version is stable. Also want the major pitfalls for MySQL 5.5 if MySQL 5.6 ...
1
vote
0answers
229 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
2answers
138 views

Serve large number of small images in ext4

I read through some similar question, but still have some confuse about my situation. My website allow user upload huge number of large images (scan pages of book). My server will auto tiling and ...
-1
votes
2answers
290 views

How can I synchronous two databases

I have two databases. First one is local and the other is at Internet, in my domain. I want to synchronous two databases. Is it possible to do so ? How can I synchronous two databases ? Some detailed ...
0
votes
1answer
35 views

Install mysql 5.5 without remove old version

I am using CentOS 5.7 (64-bit). By default mysql 5.0.88 version is installed in my machine. Now i wants to install mysql 5.5, without remove mysql 5.0.88. I didn't get any clear document to install a ...
0
votes
1answer
1k views

cpanel account transfers failing: ERROR: Failed to dump one or more databases [closed]

Getting this error when transferring multiple accounts via whm transfer utility: ERROR: Failed to dump one or more databases I was told this by a cpanel tech Here is the specific error I'm seeing ...
0
votes
1answer
2k 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 ...
1
vote
1answer
2k views

Why can't I connect to my PostgreSQL database?

I'm trying to install tentd-admin. The install fails during this step: $ DATABASE_URL=postgres://localhost/tent_server bundle exec rake db:migrate I also tried this: $ ...
0
votes
0answers
42 views

Need some information about using SQL-Express 2012 with an OLD databse software

I have a friend who has managed to go for many years running their company on an old piece of software that is no longer supported. The original software vendor is no longer in business and the one ...
0
votes
2answers
170 views

Postgresql performance enhancement

I have my setup like this: Two separate instances of the database on a clustered environment. Both instances are on dedicated servers each carries up to the standard configurations. Instance one ...
3
votes
2answers
4k 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 ...
-4
votes
1answer
36 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
1answer
2k 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
482 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
2k 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. ...
3
votes
2answers
5k 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
25 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 ...
2
votes
2answers
3k 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 ...
4
votes
1answer
5k 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
3k 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
210 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
340 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
3k 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
1k 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
533 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
272 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 ...
2
votes
1answer
397 views

PostgreSQL and Mongodb in production

We have a product that uses Postgres for RDBMSish data (accounts, billing, etc.) and MongoDB for each of the accounts data (which obviously can't be maintained on Postgres). In local development we ...
1
vote
2answers
62 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
316 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
532 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
372 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
212 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
228 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
82 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 ...
2
votes
1answer
6k 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
110 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 ...