Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database]

System that handles large amounts of data in an organised fashion

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 include:

  • FileMaker Pro
  • IBM DB2
  • Microsoft Access
  • MySQL
  • Microsoft SQL Server
1684 questions
11
votes
4 answers

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 status; but this is unfortunately producing the following,…
simon
11
votes
3 answers

100 terabytes database on PostgreSQL without sharding

Is it realistic to setup a 100 TB database (about 90 TB actually) on PostgreSQL without data sharding between a number of nodes? Are there any success stories / examples about similar setups?
voidlizard
  • 211
  • 1
  • 2
  • 4
10
votes
1 answer

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

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 which converts .mdb to .db?
Rajendar
  • 101
  • 1
  • 1
  • 3
10
votes
6 answers

join_buffer_size >= 4 M is not advised?

I get this message from MysqlTunner.pl: join_buffer_size >= 4 M This is not advised On the other hand, I read in Debian's my.cnf guide about jont_buffer_size that: This buffer is used for the optimization of full JOINs (JOINs without indexes).…
alfish
  • 3,127
  • 15
  • 47
  • 71
10
votes
4 answers

Why are my MongoDB queries really, really slow?

I've inherited a large MongoDB server at work, and have been tasked with figuring out why queries run against it are so slow. The DB contains tons and tons of records (on the order of 10^9) and takes up about 300 GiB. At first, I thought that the…
Mark LeMoine
  • 201
  • 1
  • 3
  • 7
10
votes
7 answers

The wisdom of exposing a database server on the internet?

The leadership of the small company I work for has gotten very excited about SaaS and is pushing our product into a SaaS deployment - I have a concern about this because part of the functionality of the product is based on the users being able to…
John Clark
  • 103
  • 1
  • 6
10
votes
3 answers

mysqldump error LOCK TABLES

When I execute a mysqldump I get following error: mysqldump -u root -ppassword --databases information_schema > test.sql mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK…
tom
  • 535
  • 2
  • 6
  • 14
10
votes
3 answers

How to check PostgreSQL database integrity?

Is there a way to check PostgreSQL database(s) integrity and consistency? I know about SQL Server DBCC CHECKDB and wonder if there is something similar to PostgreSQL.
FooBar
  • 653
  • 2
  • 6
  • 8
10
votes
5 answers

Is it risky to have a database server and a web server on the same machine?

It seems like life would be simple to run the database server on the same machine as the web server, but are we taking a big secuirty risk by doing this? The environment will be Windows 2008 server, Postgresql (latest version, possibly 9.0 when it…
CLJ
  • 333
  • 2
  • 4
  • 15
9
votes
5 answers

Unknown Database when trying to connect to an AWS RDS instance

I created a MySQL RDS instance, however, when I try to connect without writing the database name, it connects but does not allow me to create any tables. When I do write the name, the connection fails and I don't know why. Error I have my…
Eduardo Andrés Castillo Perera
  • 113
  • 1
  • 1
  • 4
9
votes
4 answers

How do you maintain your database without taking your site down?

There are certain database maintenance tasks, like re-organizing indexes, moving files, changing schema, etc, that require disabling any applications that are using the database. What are some good strategies for working around this, aside from just…
Eric Z Beard
  • 503
  • 1
  • 6
  • 12
9
votes
3 answers

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 controllers. Up until now, I have configured the…
teo
  • 91
  • 1
  • 2
9
votes
1 answer

MySql server keep crashing inside docker

I am running mysql inside docker with its /var/lib/mysql mounted on HOST. Eveything was working fine . Then i upgraded the docker from 1.4 to 1.5 . I rebuild the mysql image and but /var/lib/mysql stays same. Now whenever i start conatiner then the…
user192362127
  • 215
  • 1
  • 3
  • 5
9
votes
9 answers

How to store 3 million records in key value format?

We have to store basic information about 3 million products. Currently the info is one 180 mb CSV which gets updated quarterly. There will be about 30,000 queries per day, but the queries are just a very simple key value store. We only need to…
Phil
  • 105
  • 1
  • 5
9
votes
8 answers

What is a relational database?

I'm mostly a system administrator and I don't directly work with databases other than installing them, setting up accounts, granting privileges, and so on. I realized that if The Boss walked up to me and asked, "What is a relational database?" I…
user62491
1 2 3
…
99 100