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
4
votes
1 answer

SQL Server 2008 R2 - What is the best plan to back up 2005 dbs and move to new 2008 machine?

I have four super small databases that I need to migrate from SQL Server 2005 on one box and move to a brand new SQL Server 2008 R2 box. I have backed up the databases and copied them to the new machine. Should I create the new databases and then…
Evik James
  • 257
  • 3
  • 9
4
votes
3 answers

Database scalability with write-heavy application

I have a write-heavy application. The application is best compared to surveys - the customer creates custom questionares and this is saved to the database. Most of the requests are from their users submitting these forms. Later on our customers do…
Luke
  • 1,932
  • 6
  • 22
  • 27
4
votes
1 answer

Are there any performance differences between Oracle Entreprise and Oracle Standard editions?

Someone has asserted to me that the reason why one database is performing better than another (50-100%) is because one has Enterprise Edition and the other has Standard Edition. Given the same hardware, OS, versions and data - and only using the…
BIBD
  • 1,866
  • 10
  • 30
  • 44
4
votes
7 answers

MySQL database backup over network

Server #1 is a MySQL database server running on Debian which contains numerous tables and one particular table that is over 100GB. Server #2 is used as a MySQL slave for replication, but now it needs to be reset and the replication reinitialized due…
calvinf
  • 204
  • 1
  • 3
  • 7
4
votes
1 answer

Deleting MySQL rows causes lock table error

I had a couple million rows to delete but they can't be deleted at once without this error ERROR 1206 (HY000): The total number of locks exceeds the lock table size So I wrote a script to delete 100,000 rows 10,000 at a time. It ran once but when I…
Dave L
  • 211
  • 3
  • 6
4
votes
3 answers

Importing a large SQL script into SQL Server?

I'm trying to move a database from our production server to our test server. I've used Microsoft's Database Publishing Wizard to create a script containing the schema and data for the production database. However **I can't figure out how to load…
James McMahon
  • 773
  • 2
  • 8
  • 16
4
votes
2 answers

Differential backups with LVM

Is it possible to create differential backups based on LVM snapshots (or maybe a similar technique)? I'd like to perform backups of my intranet server, which hosts multiple services, and their databases (currently using Postgres 8, Postgres 9 and…
Chris Lercher
  • 4,152
  • 9
  • 35
  • 41
4
votes
2 answers

Flushing disk cache for performance benchmarks?

I'm doing some performance benchmark on some heavy SQL script running on postgres 8.4 on a ubuntu box (natty). I'm experiencing some pretty un-stable performance, even though I'm supposed to be the only one running on the machine (the same script…
ihadanny
  • 167
  • 6
4
votes
4 answers

Fastest way to move MySQL database to a new system while minimizing downtime?

I'd like to minimize downtime (during the "cutover" period). We're running on EC2 with the data on an EBS volume. Is it safe to take a snapshot of the database volume while it's running and use that to restore on the new one or do I need to shut…
Mark Renouf
  • 1,373
  • 2
  • 16
  • 22
4
votes
2 answers

PG_Dump Fails Due to Mistaken Low Disk Space

I'm trying to use pg_dump on my localhost to dump a 4GB PostgreSQL database on a remote machine. My localhost reports 15GB of space available. I'm piping the output to gzip. However, after about 15 minutes of processing, pg_dump aborts, stating…
Cerin
  • 3,600
  • 19
  • 61
  • 79
4
votes
4 answers

MySQL, disk I/O and SSD drives

We have a LAMP box with 2x mirrored 1 TB WD Black Caviar disks running the whole OS and MySQL. 8 GB / RAM, 2x quad core CPUs. We're really taxed on disk I/O, and I've been thinking of suggesting getting a couple SSD drives in there for…
Stephen J. Fuhry
  • 154
  • 1
  • 8
4
votes
1 answer

Delete Database Information

We had our production database located on a production server. The database got deleted some how but I don't know how is was deleted. How can I determine who deleted the database, what was the IP address of the PC, at what time it got deleted and so…
xorpower
  • 141
  • 6
4
votes
5 answers

How to Best Manage High PostgreSQL CPU Use?

I am trying to fix a high PostgreSQL CPU use problem. We are using PostgreSQL 8.0.9 and when our JEE web application (in JBoss) is used in certain load increase conditions, top shows a slow increase in processes for PostgreSQL. When the problem…
user75452
  • 111
  • 1
  • 2
  • 3
4
votes
2 answers

extreme slowness with a remote database in Drupal

We're attempting to scale our Drupal installations up and have decided on some dedicated MySQL boxes. Unfortunately, we're running into extreme slowness when we attempt to use the remote DB - page load times go from ~200 milliseconds to 5-10…
ceejayoz
  • 32,910
  • 7
  • 82
  • 106
4
votes
6 answers

How to achieve zero down time

For an application we want to achieve zero database and application down time using Active Active configuration. Our dB is Oracle Following are my questions: How can we achieve active active configuration in Oracle? Will introducing…
Hiral Lakdavala
1 2 3
…
99 100