Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-performance]

185 questions
2
votes
0 answers

Why is my mongodb setup not reaching EBS IOPS limit?

I have an application that is constantly pumping data to MongoDB. MongoDB instance is running with 2-replicas, each with 3TB gp2 EBS volume. As you can see on the following graph…
dpc.pw
  • 173
  • 3
2
votes
1 answer

Slow database connection with KVM

On my server I have a setup with multiple KVMs managed with virsh on ubuntu. A vm for the apache, a vm for the database, mail server, etc. Everything works quite well, except bigger CMS systems run in performance issues. I narrowed it down to the…
Dominik Sander
  • 23
  • 4
1
vote
0 answers

Difference in utilisation reported by iostat for two identical disks in RAID1

I'm trying to debug some weird behaviour with Postgres performance and am trying to understand the iostat output. I'm on 2x SSD on RAID1. Why would one of the disks be reported at ~21% utilisation and the other at ~95% utilisation? Shouldn't they…
Saurabh Nanda
  • 449
  • 1
  • 7
  • 17
1
vote
5 answers

potential SAN misconfiguration?

I am a developer and know very little about Storage systems. At work, I noticed slow large query performance on one of the SQL Servers. I was told the database is on a fiber channel SAN MSA1500 (HP?) with 14 COMPAQ BF3008B26C drives. I did a quick…
coderguy123
  • 143
  • 3
1
vote
2 answers

How does a SQL database handle simultaneous requests?

This may be a bit of a noob question, but I'm curious: How can a database handle multiple simultaneous requests, most notably reads? Is every request placed in a queue, so it really occurs one at a time? Or, with a multicore processor is it…
user28431
1
vote
1 answer

Zabbix : How to acheive 1s interval with active items?

Is it even possible/recommended ? We are trying to set up few active items configured with a 1 second interval. However those items don't keep up the desired interval, instead we are gathering a value about every ~30 seconds (as seen on the…
Wexiwa
  • 11
  • 5
1
vote
0 answers

Oracle Cloud data service with Applications on AWS?

We're deploying an application that uses Oracle as the database backend, and as the application is deployed in AWS, we use AWS RDS for the Oracle database - and we have a lot of problems with that, as it looks like almost anything other than very…
Guss
  • 2,520
  • 5
  • 32
  • 55
1
vote
5 answers

How fill a database mysql with examples data?

i'm looking for a software that i can use to fill a mysql db (structure created by joomla, drupal or any CMS or script) with samples data for tot MB, so i can decide to put 400 MB of data in my tables to test my db and mysql engine. Is there…
nik
1
vote
1 answer

pgbouncer:is it OK putting on localhost or it's better on another server?

I'm about to migrate my (tiny) server farm to Google Cloud Platform and so giving the architecture a small restyling. One of the changes I'm about to commit is the introduction of pgBouncer, to manage pooling (ATM I'm having only one DB server with…
Morenz
  • 23
  • 5
1
vote
1 answer

Persist statistics data from Postgres' stats_temp_directory on demand

We are investigating I/O load in one of our VMs and possibilities to optimize it and it showed that most of the load is generated by the stats collector of PostgreSQL. It jumps between 3,5 and 6,5 MB/s. I've already found some interesting sources on…
Thorsten Schöning
  • 643
  • 5
  • 16
1
vote
0 answers

MariaDB query cache not being used with prepared statements

We are seeing a problem with our MariaDB setup where our queries executed as prepared statements are not being cached, however, queries executed locally through mysql command (i.e. text protocol) do get cached. I have read MySQL query cache is…
Márcio Martins
  • 141
  • 1
  • 7
1
vote
0 answers

Sybase heavy Disk I/O issue

I have a Sybase 15 server that is constantly reading from the hard disk. I noticed that the sqlsrvr.exe is the culprit which is the main database engine. This is a pretty utilized server that is running a 32 bit instance which means the process can…
Super1337
  • 474
  • 2
  • 4
  • 9
1
vote
0 answers

Performance Monitor Processor Time counter blank data

I setup a simple data collector with Performance Monitor to collect Processor time(CPU Usage in %) and SQL Statistics: Batch Requests/sec @ 15 second intervals to see if i can get some baselines and report back to our vendor. I started the counter…
samalkobi
  • 41
  • 2
  • 5
1
vote
1 answer

mysql server mostly stops working when binlog disabled

Performance was a little slower than I'd like on a mysql server, and we don't use replication and don't need point-in-time restores. So one recommended way to improve performance seems to be turning off bin-logging. I have the following in my…
davidpricedev
  • 113
  • 4
1
vote
1 answer

Is Amazon RDS overkill for small business site?

One of my clients wants a small business site run on Wordpress. I'm setting it up through Amazon EC2, and was curious if using Amazon's RDS service to run the wordpress installation is overkill. I could just install MySQL locally on the instance and…
tralston
  • 165
  • 1
  • 6
1 2 3
…
12 13