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
29
votes
3 answers

How does one list warnings from the 'mysqlimport' utility?

To start off, this is not about loading data from within MySQL itself, but using the command-line tool "mysqlimport". I am using it to load a CSV directly into a table and need to see the warnings it has generated. I cannot seem to get warnings to…
brink
  • 293
  • 1
  • 3
  • 5
28
votes
2 answers

how to connect to mongodb server via ssh tunnel

It was easy for me to connect to my remote mysql server on AWS using a sequelpro, however I'm struggling with doing the same thing with mongodb. I tried setting up an ssh tunnel via command line like so: ssh -fN -l root -i path/to/id_rsa -L…
abbood
  • 1,127
  • 4
  • 13
  • 21
27
votes
3 answers

Is there a difference between RAID 10 (1+0) and RAID 01 (0+1)?

I've seen both of these listed, both being striped and mirrored across multiple drives, but is the a difference between them that I'm not picking up on?
notnot
26
votes
7 answers

Third-party SSD solutions in ProLiant Gen8 servers

I was wondering if anyone had any specific experience using Intel DC3700 SSDs (or similar) in the HP (DL380p) Gen8 servers? I'm upgrading a set of database servers that use direct-attached storage. Typically, we use HP-branded everything in our…
gwf
  • 361
  • 1
  • 3
  • 8
26
votes
3 answers

Postgres: How can I see all SQL statements being executed by the database server?

I'm in the process of reviewing every SQL statement that an application makes against the database, for performance reasons. Is there an easy way to log all statements that are executed by the PostgreSQL database server? Thanks.
Jin Kim
  • 963
  • 2
  • 9
  • 12
26
votes
6 answers

From a shell script, how can I check whether a MySQL database exists?

mysqladmin -uroot create foo returns an exit status of 1 if foo exists, and 0 otherwise, but of course it will also create the database if it doesn't already exist. Is there some easy way to simply check whether a database exists?
ithinkihaveacat
  • 1,624
  • 3
  • 14
  • 18
25
votes
6 answers

Scaling databases with cheap SSD hard drives

I hope that many of you are working with high traffic database-driven websites, and chances are that your main scalability issues are in the database. I noticed a couple of things lately: Most large databases require a team of DBAs in order to…
Dennis Kashkin
  • 391
  • 3
  • 5
22
votes
4 answers

How to duplicate MSSQL database on the same or another server?

I am trying to accomplish the following: Take a snapshot of the original database, create and exact a duplicate on another server? Take a snapshot of the original database, create a duplicate on the same server under a different DB name However, I…
Alex N
  • 782
  • 3
  • 10
  • 24
22
votes
1 answer

Is it possible that just one bit switches so my file shows me a letter "Q" instead of a "S"

In our application we use Hibernate and PostgreSQL to store data. In one of our database tables we have a discriminator column which says for example "TIPPSPIEL". It is a fixed string and can not be manipulated by any user. Suddenly we had one entry…
Janning
  • 1,421
  • 2
  • 21
  • 38
22
votes
2 answers

Best MySQL cache settings for 8gb RAM dedicated MySQL server using only InnoDB (5gb database)

I'm a pretty big noob when it comes to setting up MySQL for performance. And honestly I'm not worried about the fine tuning to squeeze every last bit of performance out of MySQL, but I do know that the most important thing to do that provides some…
billmalarky
  • 323
  • 1
  • 2
  • 4
22
votes
4 answers

Can MySQL effectively take advantage of 64 GB RAM?

We have been running into a problem where querying a table that has approximately 50 million rows, and has an index size of 4 GB (table size of about 6 GB) results in the database server swapping memory, and slowing down dramatically. I'm pretty…
Galen
  • 323
  • 2
  • 5
20
votes
5 answers

Is MySQL supposed to be installed alone

I often hear people making statements such as "our MySQL server machine failed", which gives me the impression that they dedicate a single machine as their MySQL server (I guess they just install the OS and only MySQL on it). As a developer not a…
sameold
  • 993
  • 3
  • 11
  • 20
20
votes
7 answers

What is the best filesystem for insert performance on PostgreSQL?

I'm curious if anyone out there has done any experimentation or comparisons between file systems and database performance. On Linux, I'm wondering what is the optimal file system for a postgres database. Also, what settings (inode, etc) are ideal…
Elijah
  • 537
  • 2
  • 8
  • 17
19
votes
5 answers

Modifying columns of very large mysql tables with little or no downtime

I periodically need to make changes to tables in mysql 5.1, mostly adding columns. Very simple with the alter table command. But my tables have up to 40 million rows now and they are growing fast... So those alter table commands take several…
apptree
  • 345
  • 1
  • 3
  • 10
18
votes
3 answers

What's difference between "varchar" and "text" type in PostgreSQL?

All I know about differences of them is varchar has limit, and text is not. The documentation does not mention about this. Is that really the only difference? No consideration about performance or etc?
Eonil
  • 10,459
  • 16
  • 36
  • 54
1
2
3
…
99 100