A database is a system of handling and organising large amounts of data that can be easily created, reference or edited. SQL (Structured Query Language) is a database computer language that is designed for managing the data in a relational database management system. Some popular database systems ...
-1
votes
0answers
14 views
Searching for a Digital Asset Management Solution [closed]
I am evaluating products for my company in order to meet requirements for a digital asset management system. We plan on making this management system a central location for any and all types of ...
1
vote
1answer
28 views
Do we really need to perform MS SQL database integrity check regularly?
What's the benefit of performing regular database integrity checks?
Can't we just perform it when there's a problem?
-1
votes
0answers
25 views
Best hosted, web-accessible datastore for millions of small documents? [closed]
I have several gigabytes of documents (perhaps growing into terabytes in time) which I wish to store online somewhere in a system I can access from multiple servers using HTTP requests.
These are ...
2
votes
1answer
26 views
How to store text inputs of unknown & varying size?
I am trying to create a table (or several) to receive user inputs (UGC). This content could vary in size from a single character up to a few hundred words. The input will be coded in utf8_unicode_ci ...
-1
votes
1answer
26 views
Redundant / partially duplicated data in a DB - how to structure?
I'm building a website for which a large amount of user generated data will be stored in a back end db and will be discoverable by all users.
By its nature, a portion of the user entries will be ...
1
vote
1answer
23 views
Accessing database from local network
I would like to access database running on virtual machine which resides in server connected to local network.
Here's the whole situation:
There is Windows Server 2008 R2 Datacenter running as ...
-2
votes
0answers
29 views
Networked Database vs.Relational Database? [closed]
What would benefit from a Networked Database more than it would from a Relational Database? Any examples?
Thanks!
0
votes
2answers
55 views
database for storing network traffic
I am developing a software to monitor network traffic and I need a database server that would be very fast in storing and querying packet header fields.
I know there is a .pcap file format, but it is ...
0
votes
0answers
32 views
MySQL Load anlaysis and the ADMIN PING command
Currently investigating high load on one of our databases and trying to track down the culprit / look for any optomizations.
Using tcpdump and pt-query-digest one query which always appears at the ...
1
vote
0answers
16 views
Substantial difference between database size under MySQL and actual size on disk [migrated]
When I check the size of my databases under MySQL I get this:
MariaDB [(none)]> SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB", ...
0
votes
2answers
60 views
How to use SSH import database into mysql?
I have a bigger database(2.1GB). I want input it into mysql in server part. If I output it from mysql in local part with tar.gz format, it has 420MB, if left a sql format, it has 2.1GB.
How to use ...
0
votes
0answers
6 views
Adding multiple invoices from row b in sql for all of each company name in Row A [migrated]
To put it simply, I have a table with multiple companies on Row A, and invoice amounts in Row B.
How would I write a query that will add and then show the total invoice amount for Company A, Company ...
0
votes
1answer
19 views
Receiving an error when moving table from one server to the other
I am trying to move a Wordpress table from my old server to my new one and I am receiving this error:
SQL query:
--
-- Database: `username_film`
--
-- ...
0
votes
0answers
30 views
informix + Fatal error in shared memory creation
please advice how to solve this problem
I have linux with informix DB
its fail on - Fatal error in shared memory creation
su - informix
-sh-2.05b$ oninit -v
ONCONFIG ...
0
votes
1answer
24 views
linux + Informix cant startup + external EMC storage
I have Linux machine with Informix DB
from the Informix log I see the following
please advice what could be the problem ( my Informix cant startup )
13:40:45 Warning: ONCONFIG dump directory ...
1
vote
1answer
47 views
Can the production db server be in our intranet domain?
I've got someone setting up a "backup-relay" server on our intranet. It will transfer our local backups off-site, and transfer backups of our production db (which is off-site) back home. These are ...
4
votes
1answer
72 views
How do you do Load Testing and Capacity Planning for Databases
To go along with "How do you do Load Testing and Capacity Planning for Web Sites"
I'm looking to create a canonical question of tools and methods of capacity planning for Databases. This is intended ...
3
votes
1answer
96 views
What's the advantage of splitting a mysql table into smaller ones without physical distribution?
I've seen such design in my company.
A big mysql table is split into tens of smaller ones of identical schema on the same server in the same db, without any physical distribution, no ...
1
vote
2answers
92 views
PostgreSQL service initdb doesn't work
I installed PostgreSQL 9.1.2 on my fedora 16 in a method similar to mentioned here, and tested it, which means that my installation is working fine.
But when I do: service postgresql initdb or even ...
0
votes
0answers
37 views
SQL based database is slow and periodically crashes
This seemed to have happened after a server restart and a server restart seems to temporarily solve the problem. Everyone's database does not crash at the same time. Mine may be working while someone ...
4
votes
2answers
102 views
Best practices for backing up databases
I asked this on stackoverflow, but someone pointed out it would be better to ask here.
Let's assume Subversion and MySQL on a RAID NAS. What are the best practices for backing up data?
I was ...
1
vote
2answers
82 views
Nightly Backups and Server Performance
At a certain time we run a few backup scripts to backup:
code/files
databases
other important files on the server
During this time the websites on the server grind to a hault giving timeouts and ...
0
votes
0answers
24 views
MySQL said “InnoDB: Initializing buffer pool, size = 128.0M”, does it mean it is using 128MB RAM? [migrated]
I am just using a very few InnoDB tables (e.g. less than 1MB), but during MySQL startup, it said
InnoDB: Initializing buffer pool, size = 128.0M
Does it mean even I am using in such a small size, ...
-1
votes
2answers
62 views
Optimizing my MySQL server
I just updated to a 8gb dedicated server from a 3gb vps that can no longer handle my site. I have built a search engine using sphinx fulltext search engine and receive 100k to 200k queries a day "alot ...
1
vote
0answers
24 views
Schema-less/flexible + ACID database? [migrated]
I am looking at rewriting a VB based on-premise (locally installed) application (invoicing+inventory) as a web based Clojure application for small enterprise customers. I am intending this to be ...
0
votes
0answers
15 views
mysql missing update information [migrated]
ive got problem with update.
here is mysql query.log
25474 Query UPDATE db_mail4u.dMailerQueue
SET mailid = '1Rj6eb-0005bG-ED'
where DeliveryId = '131' and ...
-1
votes
0answers
98 views
System Administrators, If you utilize a CMDB, what are some good tips/techniques? [closed]
In our environment we have a plethora of applications spread across quite a few servers. As well as a number of Database servers and a fairly good size VMWare and Citrix virtual desktop environment. ...
0
votes
1answer
17 views
Django update database entry from view?
Have been trying to build a simple asset tracking script, I have most of it working correctly however I would like to be able to check items back in once they have been returned.
I would like to be ...
1
vote
2answers
123 views
How to convert Mysql database to Postgresql in Linux?
I have a large Mysql database containing tens of tables which I need to convert to Postgresql. I have tried a couple of ancient Perl scripts which I found here and there but none of them did the job ...
1
vote
2answers
122 views
How to dump database to be used with no credentials
I am wondering how can I generate a dumped database so that it can be restored without requiring the original database username and password?
Ideally I'd like to know the pg_dumpall as well as ...
-1
votes
1answer
64 views
Backend infrastructure for a social game to be deployed on Facebook, Web and Mobile phones [closed]
The game in question is ditto like Diamond Dash. You can play it here
It will be an HTML5 game. Mostly there'll be writes more than reads and once the player completes a play session, the high score ...
0
votes
3answers
98 views
what went wrong if I get “Index of/” when I load a webpage instead of the actual site?
I recently shifted my site to another host. I uploaded both the wordpress folder and the database. But still the home page is not loading when I enter the website name. If I directly try to access an ...
0
votes
0answers
17 views
If Data is Bigger than Allocated Memory(DataMemory) MySql Cluster Crashes
I have a Mysql Cluster, I stopped it and decreased its DataMemory, and restarted it. But it crashes due to bigger data on nodes then allocated memory.
It starts saying
Data usage is 80%
Data usage ...
0
votes
1answer
65 views
How to repair mysql database
I have a database server(Fedora 14) which mysql is running as the database server. Recently that server broke down and I was only able to get the database directory from the server.
I have tried to ...
1
vote
1answer
106 views
MySQL Cluster on SSD
We are planning to implement a four node MySQL Cluster and are considering using SSDs as the storage. We would like to get a high level of performance and very low latency on disk IO from the small ...
4
votes
1answer
68 views
Where do I start re: my physical application server moving to virtual machines?
My company develops, among other things, a Linux database and application server. The database backend is Sybase ASA. We treat it as a walled garden in order to help keep our support and test loads ...
0
votes
1answer
43 views
Database deployment tool for windows
I need help with a MySQL database. We develop a big SaaS system on .net and we have 2 db servers:
Local for developers, they make changes on this etc. This server is in other city where all team ...
0
votes
0answers
38 views
Recovering deleted PostgreSQL database from recovered binary files
A PostgreSQL database has mistakenly been deleted from a Linux server. Some binary files of that database have been recovered (maybe all of them but I'm not sure). Is it possible to recover the ...
0
votes
1answer
31 views
Repairing MySQL databases - restoring data issue
Today I reinstalled Web-Developer Server Suite and although all my old PHP pages work, the databases don't... I copied them over from my backup folder and only some of the tables re-appeared.
How ...
0
votes
1answer
20 views
setting up a local database to be updated from a master database
I'm looking for an efficient way to keep multiple databases (on different servers) sync with a master database (also on a different server). Mind you I only need a one way sync (from master to all ...
6
votes
5answers
311 views
Virtualizing Microsoft SQL Database server
My company is looking to virtualize our Microsoft SQL server. I read on another question that databases on VM's suffer from a IO bottleneck which is not very good for us. But I was wondering if ...
0
votes
2answers
52 views
Error while connecting to sql database
I am trying to access a sql database remotely. The database and the server are on two different ips. i have tried commenting out bind-address line and all the other things people have suggested in ...
1
vote
1answer
51 views
my.cnf in server directory, why
On my Ubuntu machine, I have installed MySQL .
I notice that there are /etc/my.cnf file which contain the content (only two lines):
innodb_buffer_pool_size = 1G
max_allowed_packet = 512M
While ...
-1
votes
1answer
48 views
/data/tmp on database server? [closed]
I am on a Linux ubuntu machine with MySQL installed.
My teacher gave out an assignment which mentioned "copy cars.dat to /data/tmp on the MySQL database server" without any explanations, I do not ...
0
votes
3answers
66 views
“chown mysql:mysql /data/tmp” command
I am on a Linux ubuntu machine with MySQL installed.
If there is a MySQL installation on a Ubuntu machine, I saw some people doing the following thing:
sudo chown mysql:mysql /data/tmp
I get ...
0
votes
0answers
45 views
sybase bcp import fails
We're trying to export some tables from our production database to our test database using bcp. The bcp export seems to work fine, but the import always fails with a data type error (see below).
We ...
0
votes
1answer
41 views
database scanning tools recommendation? [closed]
Lately my boss is asking me to looking into database scanners. I know very little about db scanning technology. Just wondering if it is worth to purchase tools like Sentrigo ( ...
0
votes
0answers
25 views
Cloud verses VPS vs Hosted for remote database
We have a dedicated server that hosts several of our sites along with our databases. Its a typical LAMP setup running on Ubuntu/Debian 9.04 Jaunty Jackalope. Its security patches and repositories are ...
4
votes
3answers
192 views
What hardware & software consideration does a major website require to properly manage 1000+ servers? [closed]
Sorry for such a high level question. I understand the basics of server load balancing, but the concept of managing 30,000 servers is a bit foreign to me. Is it really just the same concept of ...
0
votes
2answers
59 views
Server configurations for hosting MySQL database
I have a web application which uses a MySQL database hosted on a virtual server. I've been using this server when I started the application and when the database was really small. Now it has grown and ...
