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

Mysql auto_increment reset WITHOUT rebuilding index?

There just HAS to be a way to reset the auto_increment value on a table without rebuilding the entire index. I have a table with over 2 billion rows in it that accidentally got an ID inserted into it near 4.2 billion. From past experience I know…
Sean
  • 379
  • 2
  • 3
  • 8
3
votes
5 answers

Alternative to multiple WordPress installs (and not using WordPress-mu)

I run several instances of WordPress on a server for managing blogs across multiple domains (also hosted on the same server). Some domains are even utilizing multiple WordPress instances just as subdirectories. What is the best way of implementing…
warren
  • 18,369
  • 23
  • 84
  • 135
3
votes
1 answer

Not able to backup of postgres DB from DBeaver

Hope you are doing great. We have postgres install on centos server and accessing it through DBeaver from Ubuntu machine. Whenever we try to take backup of Database it is giving error as "Native client is not specified for connection". I did search…
Satish Lamak
  • 51
  • 1
  • 3
  • 7
3
votes
2 answers

How to find joins performed without indexes?

I run a WordPress website on Mariadb 10.6, and recently I saw an error Joins performed without indexes in Mysqltuner. Although the number is not very large, Mysqltuner recommends that you keep increasing the Key_buffer_size. However, my VPS doesn't…
Junuk
  • 33
  • 3
3
votes
3 answers

SQL Server problem with restoring big databases

I often need to to backup and restore database(SQL Server 2000/2005). Now if database is of size > 1 GB restoration process is real time consuming. Is there any way using which i can truncate the logs or reduce the database size? Thanks all,
Anil Namde
  • 145
  • 3
3
votes
4 answers

SQL Server "Quick" Incremental backup?

I'm working on a very large database (250+ gigs) with well over 225 million records. The database is hard to work with simply from its sheer size. This database is read-only. We're looking at getting faster hardware, but either way I'm trying to…
KTF
  • 161
  • 1
  • 2
3
votes
1 answer

MS SQL: How to make sure db files are deleted when dropping a database?

When my colleague drops a database he just created on SQL 2008 Express using Management Studio 2008 the files do not get deleted. When I drop a database I just created on SQL 2005 Express using Management Studio 2008 the files do get deleted. If my…
Ries
  • 153
  • 1
  • 2
  • 6
2
votes
3 answers

Database checksum features - redundant? useful?

Just about every mainstream DB has a feature to calculate checksums per page, per sector, or per record. Now for a DB that does full recover after any crash, like PostgreSQL, is a checksum even useful? There will be no data loss as long as the xlog…
Eloff
  • 137
  • 8
2
votes
2 answers

Significantly downgrading a server processor in light of extremely idle CPU?

I'm considering migrating my database to a new server. The new server has a much less performant CPU, but more RAM and a faster SSD. Also, it is half the monthly price. Based on available CPU benchmarks the new CPU may have 50% less processing power…
tom_nb_ny
  • 51
  • 1
  • 9
2
votes
1 answer

What are some options for a small organization's contact management system?

I would like to implement some sort of contact database management system within a small company. At this point I have roughly 200 contacts but I see a prospecting database could grow over 500 but probably not more than 1000. I would like contacts…
CT.
  • 741
  • 2
  • 8
  • 20
2
votes
1 answer

POSTGRES - psql: FATAL: Peer authentication failed for user "root"

I am trying to configure peer authentication for root on Postgres v9.5. My aim is to allow the cron jobs to run pgdump to create backups. My pg_hba.conf file looks as follows: local all postgres md5 local all …
RLBChrisBriant
  • 595
  • 1
  • 7
  • 22
2
votes
1 answer

accessing a postgress DB with in a docker container that has no shared port with server

I have a postgress database installed in a Docker container called dbDocker. This container is not using any of the server ports and the container's port for postgres 5342 is only visible from containers in the same virtual network. I want to create…
Jose Cabrera Zuniga
  • 179
  • 1
  • 3
  • 11
2
votes
2 answers

ZFS performance with databases and more than 80% space used

We have Oracle 11.2 databases on SAN storage (fibre channel on EMC) with Solaris 11.3. For the development environments, the space used on the filesystems is over 80% most of the time. How important is the '80%' rule for databases? Nearly all the…
Michael Finken
  • 21
  • 1
2
votes
0 answers

MongoDB Very slow queries since yesterday

Since yesterday I am having huge trouble with my MongoDB. I have a 100GB collection with over 50M documents. Making a find on them and a .count() was never an issue until yesterday. Somehow, since yesterday, a simple find and count query takes over…
Bastian Jakobsen
  • 41
  • 2
  • 6
2
votes
0 answers

MariaDB Cluster is having timeout issue between nodes

I'm having some hard time diagnosing MariaDB Cluster issue that I would like to have some advices. We're running a 3-nodes MariaDB Cluster, each node is on a dedicated ESXi server, and connected by local network at the same data center. Recently, we…
user472241
1 2 3
…
99 100