System that handles large amounts of data in an organised fashion
0
votes
0answers
27 views
Strange CPU cycles and slow queries
My database (XAMPP) runs at almost 350 questions a second is 99% in the SELECT category. The website I'm running is heave on timed ajax calls that refresh data every 10 seconds. During this, there are ...
-1
votes
1answer
28 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
25 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
0answers
96 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
24 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
2answers
36 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
21 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
26 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
40 views
How do I get my ubuntu server to listen for database connections?
I am having a problems connecting to my database outside of phpmyadmin.
Im pretty sure this is because my server isn't listening on port 3306.
When I type:
sudo netstat -ntlp
on my OTHER working ...
-2
votes
0answers
34 views
Searching for the best Database solution [closed]
I am new to this field and trying to learn the best possible way to maintain a database for my company. I am looking for the best option (cheap and reliable) to manage all the documents and contacts.
...
0
votes
1answer
23 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
...
-3
votes
0answers
54 views
What is dangerous about opening your Oracle g11 database for external connection [closed]
How safe is it to create an Oracle database on Oracle Linux and open it for public?
The only danger where I can think of is that someone will steal data. Are there any other risks? Is it for example ...
1
vote
0answers
12 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
28 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 ...
0
votes
0answers
41 views
Mysql database on ubuntu server not accepting connections
I am having problems with my database. The only way I can connect to it is via phpmyadmin. I try to use the same username and password to connect to the database in 'SQL PRO' and I get the following ...
3
votes
1answer
78 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
38 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
32 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
28 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
68 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 ...
0
votes
0answers
30 views
PLSQL-Developer debug session crashed > database slowed down > restart VM> ORA-01034 & ORA-27101 (Oracle 11G- WIN7)
I recently started a debug session to debug a package function,
this session crashed the PLSQL-Developer at one of the first lines (that havent changed & always worked fine (its ony variable ...
-1
votes
1answer
43 views
ssh script to read from database [closed]
Does anybody know if its possible to create an ssh script to perform the below:
1 - read IP addresses from a table in a database
2 - use the IP addresses from above in the ssh script (dynamically) ...
-1
votes
2answers
49 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
27 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
80 views
cpanel account transfers failing: ERROR: Failed to dump one or more databases
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
81 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
0answers
15 views
MS SQL server 2008 R2 for databas slowing down
We are hosting a ERP/CRM system that uses MS SQL server 2008 R2 for database.
After a while some of this systems starts to feel "slow", high CPU utilz on database server and some maintance on the ...
0
votes
1answer
34 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
1answer
15 views
Express App Cannot Connect to valid MongoDB, Can Connect Using `mongo <ip_address>`
x-posted
I have an app in production that has been running for about a year. It's had it's fair share of ups and downs, but I haven't had a problem with it for a while. The Linode server decided to ...
0
votes
0answers
24 views
What distributed, horizontally scalable key-value document store is easiest to manage? [closed]
I need a distributed, horizontally-scalable key-value store. It's primarily for documents. No real indexing of the data required - just store a document given a key, and return the document when ...
0
votes
1answer
33 views
missing data after attach mdb
Recently, one of my customers had a server crash. Unfortunately, the 3th party who was responsible for the backup had 'forgotten' to schedule a backup of the DB (I know, I should have noticed that).
...
0
votes
0answers
27 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
50 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 ...
1
vote
1answer
110 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
31 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
168 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
69 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
212 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
69 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
21 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
128 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 ...
0
votes
1answer
230 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
214 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
112 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
43 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
73 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
418 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
2answers
183 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
0answers
86 views
linking pervasive sql to sql server as a linked server using odbc
I have been trying to establish a linked server on my sql server 2012 to pervasive sql v11 this way:
EXEC sp_addlinkedserver
@server = 'kslap208',
@provider = 'MSDASQL',
@datasrc = ...
0
votes
1answer
114 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 ...
