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

SQL Server: Log file grows more and more, and do not get merged with the MDF file

My database files look very suspicious. we are using the DB in a production stage. and I'm seeing how the LDF file grows more and more. while the MDF file seems as it is not growing at all (I don't have a file size history to demonstrate it, but I…
SDReyes
  • 653
  • 2
  • 8
  • 15
0
votes
4 answers

Are there any reasons to duplicate table in the same database?

Let says we have several MySQL server, one master and some slaves. A member table which contains more than 5.000.000 peoples. Are there any reasons (performance, atomicity, etc..) to use duplicate tables like member_1, member_2, member_3 and then…
bob
0
votes
1 answer

sqlite : Fatal error: Call to undefined function sqlite_escape_string()

I use a script that requires SQLITE, On my previous host, it worked. On localhost it works. On my new dedicaced server, it doesn't. I use PHP5 of course, you can access phpinfo() of the server. Could you tell me what/how (apt-get?) to install…
Tristan
  • 498
  • 2
  • 9
  • 27
0
votes
2 answers

How to publish internal data to the internet - as simple as possible

I Asked this at Staock Overflow, but I would like your oppinion too as it has as much to do with administration as it does with coding. We have a .net 2-tier application where a desktop program is talking to a database. We support MS SQL Server…
mlarsen
  • 103
  • 3
0
votes
1 answer

Unicenter Software Delivery 4 not able to connect to MS SQL 2000 Database after W2003 SP2 upgrade

Yesterday I installed the Windows Server 2003 Service Pack 2 on a Windows Server 2003 which has Unicenter Software Delivery 4 installed. Prior to the installation I disabled every CA service on the server (Brightstor, SDO , RCO, TNG) and the MS SQL…
grub
  • 1,118
  • 1
  • 7
  • 12
0
votes
1 answer

mysql UDF : fopen = permission denied

this is question I already asked on SO but I wonder if this could be a SysAdmin problem. I'm trying to create a mysql UDF function , this function calls "fopen/fclose" to read a flat file stored in /data. But using errno (yes, I know it is bad in a…
Pierre
  • 429
  • 1
  • 5
  • 14
0
votes
3 answers

Splitting a MySQL DB in two may ease server from "Too many connetions"? I don't think so

I was requested to split a MySQL in two, it's kind of a horizontal partition, in which some rows correspond to one site, and some other correspond to another site. But they want to split it in two DBs in the same MySQL server. I'm no DB expert but I…
Petruza
  • 285
  • 3
  • 9
0
votes
2 answers

Emptying site collection recycle bin doesn’t make content DB smaller?

I deleted everything from a site collection recycle bin and remoted into the SQL server the content database is located on, went to view the WSS_Content and the sucker didn't get smaller. I had about a good 2 or 3 gigs of folders with files in the…
Mike
  • 358
  • 1
  • 5
  • 17
0
votes
2 answers

Ecommerce Database DNS Switch

I am moving an e-commerce site to a new server. All has been successful and its time to change the DNS for the domain. It's a relatively popular site and I fear that during propagation orders will be split between the old database and the new one.…
KThompson
  • 119
  • 1
  • 5
0
votes
1 answer

Column locking in innodb?

I know this sounds weird, but apparently one of my columns is locked. select * from table where type_id = 1 and updated_at < '2010-03-14' limit 1; select * from table where type_id = 3 and updated_at < '2010-03-14' limit 10; the first one would…
mingyeow
0
votes
1 answer

Do I need to recreate statistics if I had to drop them to add a foreign key

I have a database which had all it's foreign-key relationships dropped at some unknown time in the past (don't ask). I have an old copy of the database which isn't good to restore from, but the schema has the relationships. I'm working from that…
Adam J.R. Erickson
  • 147
  • 2
  • 6
0
votes
1 answer

How to rename an oracle database?

I am running Oracle 11g on windows 2003. What are the steps to rename database? I had followed the steps in http://www.ordba.net/Tutorials/OracleUtilities~DBNEWID.htm but I can't get past the error, NID-00121: Database should not be open I had tried…
arthur.aoife
0
votes
3 answers

Slow Inserts SQL Server 2005

I'm researching an issue with the following information: We had a logging table with about 90k records in it that had inserts taking several seconds(approximately 10 to 20s) in extreme cases. One of the columns of the table stores XML as the XML…
Achilles
  • 107
  • 4
0
votes
2 answers

hosting site on one web server and accessing a database on another

I'm fairly sure this is the right place for this question, but if not please move it to the the right site. I have a number of sites on a 1and1 package (yeah, I know...) and I also have a subdomian that belongs to a college tutor. I have been…
tombull89
  • 2,964
  • 8
  • 41
  • 52
0
votes
2 answers

2 partitions in a sharded mysql database

the first one is running at 73% memory utilization. The second one runs at 16% utilization. how can i balance the 2 out?
ming yeow
1 2 3
…
99 100