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

repair suspect database

My sql server 2008 told me that you database is suspect and I can't see my tables or my data or use it what should I do ?
salamonti
  • 131
  • 3
3
votes
3 answers

Proxy for database server/connection?

I am coming from an application development perspective (my day job) and not an infrastructure, or operations, perspective, so if this is a completely inane question, please let me know! We have proxies in front of our application servers and this…
Zach Bonham
  • 210
  • 1
  • 3
  • 10
3
votes
8 answers

Should I have one MySQL instance for all our apps, or one instance for each?

We're a small startup and I need to setup several applications, almost all of which require a database. I face the choice of setting up one instance of MySQL, with one database for each of our applications, or of setting up a separate instance of…
lindelof
  • 919
  • 1
  • 8
  • 11
3
votes
2 answers

Restarting a database in a database instance without restarting entire database instance

I have a database server running several instances of database. I am having issues while accessing a particular database and want to restart the same but without restarting the entire db server as it will effect other databases in the instance or…
Viky
  • 648
  • 2
  • 7
  • 11
3
votes
3 answers

Does this machine answer our database needs?

We have an application which runs already with its database on server. Because of the large amount of I/O (read and write) from this applications database we have very slow responses to our queries. So, we've decided to build a new server machine to…
Fotis
3
votes
2 answers

Best approach to design this MySQL big database

I'm planing to design a database that contains only 2 tables (stats1 and stats2), but, this tables will contain rows going to 40 000 000 records! All the records will be "positive/unsigned" integers. MySQL client version: 5.0.91 Here's some info…
numediaweb
  • 134
  • 5
3
votes
2 answers

10 Million records = wiped MySQL DB?

So I was trying to load some test data and it appears to have killed my entire database. This is one case where it's great to have backups! They were all plain insert queries, probably about a 900 MB file. What could have gone wrong? When I woke up…
Josh K
  • 454
  • 1
  • 6
  • 18
3
votes
3 answers

Shrink Sql Server database

My SQL Server 2008 database file (.mdf) file is nearly 24 MB but the log file grown upto 15 GB. If I want to shrink database what are the important points to take into consideration? Will shrink causes any index fragmentation and does it affect my…
hani
3
votes
2 answers

Very large database, very small portion most being retrieved in real time

I have an interesting database problem. I have a DB that is 150GB in size. My memory buffer is 8GB. Most of my data is rarely being retrieved, or mainly being retrieved by backend processes. I would very much prefer to keep them around because some…
mingyeow
3
votes
2 answers

Command line scripts to restore the 4 system databases of MS SQL Server 2008

can someone give me some advice on how to restore the 4 system databases (master, msdb, model, tempdb) of a sql server 2008 please? I've already done some testing myself (on restoring the master database) with the following commad line script as a…
ciscokid
  • 53
  • 3
  • 7
3
votes
4 answers

MySQL asking a user for SUPER privilege to perform a delete

When trying to do a delete operation on a table, mysql reports the following error: Error code 1227: Access denied; you need the SUPER privilege for this operation. However, my user has this privilege granted for all tables in the schema: GRANT…
scetoaux
  • 1,289
  • 2
  • 12
  • 26
3
votes
2 answers

Multiple columns in a single index versus multiple indexes

The short version of my question is what's the difference between three indexes each indexing a single column and one index indexing three columns. Background follows. I'm primarily a programmer but have to do DBA work because we don't have a DBA. …
Tim Coker
  • 298
  • 3
  • 8
3
votes
2 answers

Linux IO scheduler on databases with RAID

I have a linux database(MySQL) server(Dell 2950) with a 6-disk RAID 10. The default IO scheduler on it is CFQ. However, from what I have read and heard, there is no need for a scheduler like CFQ when reordering/scheduling is also done by underlying…
Raghu
  • 286
  • 1
  • 3
  • 6
3
votes
4 answers

WSS_Content contains?

WSS 3.0:Windows2003 I have a content database that keeps growing for the name of simply, "WSS_Content" This database is aside from all the other content databases that are linked to an web application, but located in the same directory. I count 5…
Mike
  • 358
  • 1
  • 5
  • 17
3
votes
2 answers

PostgreSQL deleteing old records from log tables

I have a PostgreSQL database which stores my RADIUS connection information. What I want to do is only store a month worth of logs. How would I craft an SQL statement that I can run from cron that would go and delete and rows that where older than…
Max
1 2 3
…
99 100