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

MySQL : max_allowed_packet Greater than 1 GB is it possible?

In the field of Digital forensic , a packet size of 1GB is very common and I am getting trouble. Using in-house python script , we extract text out from archives , some files are as big as 4 GB and text inside it can easily reach 1GB . and then we…
Phyo Arkar Lwin
  • 345
  • 1
  • 4
  • 10
5
votes
2 answers

datetime format changed between mysql 5.0 and 5.1?

I've upgraded a mysql slave from mysql 5.0 to mysql 5.1. during the catch up, the replication failed on a query with incorrect datetime value: 110919 13:56:18 [ERROR] Slave SQL: Error 'Incorrect datetime value: '2010-03-14 02:35:34.0' for column…
smintz
  • 282
  • 3
  • 9
5
votes
1 answer

"service mysqld stop" times out (then found out that "mysqld dead but subsys locked")

I installed mysql and server via yum on my 64bit CentOS 5 server. It starts up fine but when I try to stop it it stalls out and then I have to "Ctrl-C" it. Then I run a "service mysqld status" and it shows: mysqld dead but subsys locked I run ps…
lamp_scaler
  • 577
  • 1
  • 6
  • 18
5
votes
1 answer

Postgresql table drop taking very long time

I am kind of new to Postgresql and server administration so I am not quite sure if this is normal behavior or not. Right now I am trying to drop a table with the cascade option. The command I used was DROP TABLE library_genre CASCADE; It's been…
thebeagle
  • 151
  • 1
  • 1
  • 5
5
votes
1 answer

Store a table in a memory

Is there a way to make SQL Server to store a table with 10 attributes and 10 rows like this on memory? a1 a2 a3 a4 a5 a6 a7 a8 a9 a10 ---------------------------------------- 138 498 365 345 500 473 498 125 134 800 448 498 362 348 500…
edgarmtze
  • 219
  • 1
  • 6
5
votes
1 answer

Should the database connection limit equal the number of processes connecting?

I noticed that PostgreSQL and MySQL have a 100 client connection limit by default. I'm wondering if I should turn this down since the webserver is on the same box and I only have about 20 PHP processes that would need to connect. Should this setting…
Xeoncross
  • 4,449
  • 12
  • 43
  • 56
5
votes
2 answers

How to convert a postgres database to sqlite

We're working on a website, and when we develop locally (one of us from Windows), we use sqlite3, but on the server (linux) we use postgres. We'd like to be able to import the production database into our development process, so I'm wondering if…
luqui
  • 153
  • 1
  • 1
  • 6
5
votes
2 answers

What are the best strategies for scaling up my web application to be able to cope with a large volume of users?

I want to get some advice / best practices for how to go about developing a strategy for scaling up my a web application. I waffle on a bit here and show my limited knowledge but want to fill in my knowledge gaps. It is tempting to learn as much of…
undefined
  • 654
  • 2
  • 8
  • 18
5
votes
2 answers

What is Data Scrubbing in the context of database?

Even after reading on Data Scrubbing on Wikipedia, I am still not clear on what Data Scrubbing really is when the term is used for database. Is it a formal engineering principal that there is a pre-defined way to perform data scrubbing? If so, what…
dance2die
  • 2,011
  • 7
  • 32
  • 41
5
votes
2 answers

What is the difference between Replication and Synchronization?

In phpMyAdmin there is a tab for configuring Replication and one for Synchronization. What is the difference between Replication and Synchronization? When do you should use the one or the other? Thanks, Udo
udo
  • 287
  • 1
  • 6
  • 18
5
votes
2 answers

PostgreSQL database server virtualization, yay or nay?

Our former CTO (now "consultant") at some point warned his replacement about not virtualizing database servers, specifically our PgSQL database servers, but rather run them as actual, physical servers. The problem with this is that we are rapidly…
Williham Totland
  • 187
  • 7
5
votes
4 answers

Should I turn off swap on AWS EC2?

I'm running a webserver and database server on the same AWS EC2 instance. I know it's a bad idea to have swap for web server, so should I just turn it off? Will it affect the database service (I guess not but I'm not sure on this). If yes, how do I…
Jason Dinh
  • 161
  • 1
  • 3
5
votes
2 answers

how to change the maximum number of connection to Oracle database?

How do I change the maximum number of connection to Oracle database at start? I use : ALter system set sessions=500 scope=spfile; However, after restart the database, use show parameter sessions still give value 772 for sessions Khue.
Khue Vu
  • 151
  • 1
  • 1
  • 3
5
votes
1 answer

MS Exchange -- running code against outbound email

I would like to know if using MS Exchange there is a way to run code against outbound emails. The code would need to trigger on emails sent to a specific domain, connect to a database, check for an email related to the email sent, and Carbon-copy…
Incognito
  • 302
  • 4
  • 17
5
votes
2 answers

What is the typical maximum number of database connections for Oracle running on Windows server?

We are maintaining a database server that serve a large number of clients. Each client typically running several client-applications. The total number of connections to the database server (Oracle 9i) is reaching 800 connections on peak load. The…
Sake
  • 417
  • 3
  • 5
  • 12
1 2 3
…
99 100