Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [database-performance]

The tag has no usage guidance.

1
vote
0answers
38 views

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 ...
2
votes
1answer
477 views

Mysql high cpu usage (over 600%)

The server has 8core CPU and 22 GB of ram. Every day receives many requests from users, and recently a replication mechanism has been activated, with an implementation of a db master and a slave. Now ...
1
vote
1answer
911 views

MariaDB 10.3 CPU usage, Server performance suggestions

my platform: 8 cores, CPU benchmark > 10k (Intel(R) Xeon(R) CPU E5-1620 v2 @ 3.70GHz) 32GB of RAM 2x 7200 SATA enterprise HDD, 128MB cache, each of them have physical 512b block size Actual file ...
1
vote
1answer
6k views

What does “GC (Allocation Failure)” mean in my ElasticSearch 5.6 logs?

I see these constantly in my Elasticsearch 5.6.3 logs. Is this a signal that I should scale up and add more RAM? Or is this just normal operations for ElasticSearch? [GC (Allocation Failure) [...
-1
votes
1answer
51 views

Best database (SQL\NoSQL) for storing file hashes and corresponding description [closed]

I am working on a system that store file hashes and a corresponding description basically, the structure is very simple just 1 table, HASH (key) and File Description. For example: ...
-4
votes
1answer
103 views

how to initiate and maintain mongo shard replica set from mongos server? [closed]

I am trying to initiate a mongo shards replica set from mongos server, I want my mongos to maintain replica set and able to add new server to replication if needed.
0
votes
1answer
31 views

MySQL bottleneck on AMD A-10 witn 12BG of RAM?

Running the identical python script that parses XML and inserts records into MySQL using MySQLdb package for python, I'm experiencing very different load times between a Mac Mini i5 with 8GB of RAM (...
0
votes
1answer
102 views

MySQL 5.7 trying to improve performance

We have a PHP app running against MySQL 5.7 with innoDB. The app used to be really slow. MySQL takes 100% of the CPU for a really long time, for some queries. I tried running optimize table, which ...
-2
votes
1answer
52 views

Why would my Oracle read from disk?

Our Oracle server (version 12c) is running on a RedHat-6.7 server with 128GB of RAM. The current size of the only database on it is only about 60GB. Yet, we see plenty of disk reads -- on the device ...
0
votes
0answers
263 views

Maximum cpu performance mode, configure in BIOS and/or the S.O?

I`m running a database benchmark (Tpc-h), and running a same SQL query several times. To my surprise, the time spent has a significant difference, even though it is the same query, reaching up to 40% ...
0
votes
3answers
392 views

mysql high cpu on dedicated server

we have a prestashop website running at dedicated server with 10K products, I have slow perfomance and looking htop found that mysql CPU is 100%. Dedicated Server CPU:Intel(R) Xeon(R) CPU E3-1230 ...
0
votes
1answer
200 views

Database query response size - when is it too many kb?

I am a developer of e-commerce websites modules. The module displays some dynamic data (html) on website pages with ajax call. Ajax call gets html from database. 1 query for each page load. Database ...
2
votes
1answer
1k views

Are the limitations of SQL Server Express the bottleneck?

Question: What is the best way to determine whether the limitations of SQL Server Express are the bottleneck in an environment? Are there some performance counters that would be a good indication for ...
0
votes
0answers
93 views

How to spread MySQL load across several EC2 instances?

So I have a DBMS, MySQL, installed on an EC2 c4.compute instance. The problem is that it can only handle up to 8 RPS, before reaching 100% CPU, and then having problems. For a project, I need at ...
6
votes
1answer
3k views

Understanding IXSCAN and COLLSCAN in MongoDB logs

I'm attempting to grep through some Mongo logs in an attempt to find slow operations that I need to optimize. Slow query logging is at the default and is logging operations over 100ms. I think ...
0
votes
0answers
512 views

MySql High CPU Low memory utilization

I am facing an issue with MySQL server. I am not a primary DB admin, so i might need some assistance in tuning DB. The CPU Utilization shoots up way beyond expectations. It just hovers around 70-90% ...
0
votes
1answer
70 views

connections to postgresql at particular time frame

How can i find the connections made/utilized to my PostgreSQL at a particular given time frame ? In the PostgreSQL logs i am getting JSTERROR: canceling statement due to user request Sar logs : ...
1
vote
1answer
672 views

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 ...
1
vote
0answers
154 views

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 ...
-1
votes
1answer
50 views

Nagios server service_perfdata not saved at the good place

I have a server nagios on my Raspberry who monitored some Windows 7 client and i want to save the performance data of my service in particular file. So i have set the nagios.cfg for it : ...
0
votes
2answers
74 views

Mysqld.exe RAM size increasing upto 130MB and performance is poor

I have deployed my application with java 8 and mysql server. While running mysqld.exe takes upto 130 MB of RAM size and it stops increasing. But after that my application's performance is very poor. ...
0
votes
0answers
132 views

Advice about scaling out IIS and SQL Server 2014 on Windows Server 2012R2

We are running a dual processor server E5-2630 V3 / 64 GB RAM with Windows Server 2012 R2, this server has IIS and SQL Server 2014 installed, only one web service is running to serve a mobile ...
0
votes
1answer
132 views

max data transfer rate on RAID array

1) Let's say I have an array of twelve disc drives in a RAID-1 formation. That's effectively six drives presented for use. What's the maximum read rate I should be able to get out of that array? ...
0
votes
0answers
181 views

WordPress site with no traffic; MySQL reporting 300-500 queries per second, frequently crashing

My server is running Debian 7.10 (Apache 2.2.22, MySQL 5.5.47, PHP5). It's a VPS. I've tried to summarise the issue in the title. I'm running a very small, private WordPress blog which is only ...
3
votes
3answers
9k views

How to improve AWS RDS Performance - Heavy read write updates

After searching and reading as many posts, comments and discussions I could find I did not find one specific to my issue. I have multiple AWS EC2 deployments with a single RDS all in the same ...
0
votes
1answer
220 views

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 ...
1
vote
1answer
213 views

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/...
1
vote
0answers
237 views

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 ...
3
votes
1answer
309 views

Finding SQL Server Bottleneck - not CPU, IO, available memory

I'm trying to identify the bottleneck on a new SQL Server implementation (2012 Enterprise). I've been running some meaty queries/ETL jobs which are taking a considerable time - but I'm having ...
1
vote
0answers
102 views

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 ...
10
votes
3answers
1k views

Importance of location of installation of Microsoft SQL Server

I have a server with cheap slow disk and an expensive fast disk. I want to use the expensive disk for all the things where it's important that it's fast, such as my databases. To save money, I want ...
0
votes
2answers
934 views

Two Azure disks have the same LUN

I am trying to set up SQL Server on an Azure VM (that has an SSD) per the following articles: Performance Best Practices for SQL Server in Azure Virtual Machines Using SSDs in Azure VMs to store SQL ...
0
votes
1answer
575 views

MySQL slow connection

I am running a laravel application that is on a separate server than my MySQL database. If I run the query on the Mysql server it takes the expected 0.00 - 0.01 seconds to return. However when I log ...
1
vote
0answers
519 views

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 ...
-3
votes
1answer
1k views

PHP Fatal error: Call to undefined function mysql_pconnect() [closed]

I'm Having same Problem. PHP Fatal error: Call to undefined function mysql_pconnect() in I gone through PHP Fatal error: Call to undefined function mysql_pconnect() in. i have same problem. but ...
2
votes
1answer
60k views

Mysql showing 100% CPU usage [closed]

I'm experiencing some problems with my MYSQL server installed with Cpanel. My server is showing 100% usage of mysql even if I don't have too much traffic on web. I am running CentOS 6.5x64 with 80GB ...
0
votes
1answer
42 views

Where should the DB server be and its updates scripts should run from where?

I currently have a web application and database on the same server. I am moving the database to a new server that is spec'd for being a database. Now i have nightly scripts that run on the web ...
1
vote
1answer
583 views

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 ...
3
votes
1answer
5k views

Slow connection to Azure Sql Server

I'm moving from a Rackspace Cloud platform to Azure but I'm having some real performance issues. It seems like everything is a little but slower but especially database interaction. I've done some ...
0
votes
2answers
94 views

MySQLD is using 175% of the cpu

On one of the servers, I have mysqld running as slave DB. The CPU usage is 175% at the moment used by mysqld. Here are the results of SHOW PROCESSLIST; +----------+-------------+-----------+--------...
3
votes
1answer
36 views

SQL Server 2005 global slowdown

Two days ago our production server suffered a massive slowdown where the primary symptom was that an extraordinarily high number of requests were suffering SQLTimeouts. I will quickly describe our ...
0
votes
1answer
2k views

Innodb performs IO Operation when idle

I am currently doing some stress testing where I am pushing inserts to the database as fast as I can. The simulation inserts 10000 records per second. After inserting around 200 million records I ...
1
vote
1answer
521 views

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 ...
2
votes
0answers
416 views

Exchange 2010 on KVM - CPU usage reporting incorrectly

Good Morning, I have virtualized an exchange server using KVM (proxmox actually). It is Exchange 2010 SP3 running on server 2012 R2. KVM version 1.7.1. I am using the latest (0.1-74) virtio ...
2
votes
1answer
635 views

MongoDB 100% locked periodically. MMS charts attached

Trying to diagnose what could be causing intermittent lock-up on MongoDB server running behind a Rails application. Hoping that someone might recognise the pattern of peaks and troughs in the charts ...
1
vote
0answers
1k views

MongoDB Performance Troubleshooting

I have a small MongoDB replica set (2.4.6) and it seems about once a week, the primary gets bogged and the load average spikes up. This app doesn't see a huge amount of traffic. It resides in EC2 ...
0
votes
1answer
115 views

Over 100% of stage done during DROP COLUMN

I'm running a DROP COLUMN on the primary key column (I know, it's terrible but I had to do it). There's a progress indicator: Stage: 1 of 2 'copy to tmp table' 107% of stage done I haven't been ...
-1
votes
1answer
163 views

SQL Server Express 2008 R2 limitations

When considering to use an Express Edition of SQL Server 2008 for a system that officially is only tested with full editions, what do I need to know about the limitations? Memory, connections? What ...
0
votes
1answer
2k views

How to set MySQL's internal time zone support?

Today MySQL at Facebook posted the following about MySQL performance: Today we found a performance problem in a completely unexpected place - if TIMESTAMP data type is being used and MySQL is ...
0
votes
1answer
33 views

OpenBase server database connection troubleshoot?

I am troubleshooting a workstation/server instance in which an application hangs while interacting with our Windows 2003 Server OpenBase-hosted database. In short, the application will go into "Not ...