Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Questions tagged [database-performance]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1 votes
1 answer
37 views

Regarding how Big companies set up their databases [closed]

I am trying to understand how do companies which handle a large database requests set up their infrastructure. I have recently created a few python applications which store data in PostGres and ...
user avatar
0 votes
1 answer
27 views

Why my simple searching query is too slow?

I don't know why searching in my "cities" table is so slow. My query looking for a table "cities" located about 25km from the city. I use this simple query and the database takes ...
user avatar
1 vote
1 answer
52 views

One user for all databases or different user for different databases?

I have multiple (Wordpress) websites that use different mysql databases. I would like to know if I should use different users for different databases, or just use one user (such as root) for all ...
user avatar
  • 133
2 votes
1 answer
310 views

How to debug the cause of my suddenly extremely slow running database backups maintenance plan?

(Originally posted on DBA.StackExchange.com but closed, hopefully more relevant here.) Alexander and the Terrible, Horrible, No Good, Very Bad...backups. The Setup: I have an on-premise SQL Server ...
user avatar
  • 121
0 votes
1 answer
54 views

MYSQL: Many slave servers with smaller resources or less with larger resources

I want to create High availability with Master Slave replication (for Select query). I am wondering which one is better: Having smaller resources slaves but more servers or Having larger resources ...
user avatar
  • 101
0 votes
0 answers
23 views

ORACLE Dropping CLOB Column from a very large table

We have a table with about 2 billion rows. ( Yes - billion with a B ). It also has a CLOB column which we want to DROP to reclaim space. Being a production database, we have to ensure : be able to ...
user avatar
  • 161
-1 votes
1 answer
202 views

Proof CPU maximum frequency in VM

CPU-Z on some customers VM for DB server is constantly showing 2,8 GHz CPU frequency. While with TurboBoost enabled it could be 3,6 GHz by the Intel documentation. VM administrator is telling me, that ...
user avatar
0 votes
0 answers
54 views

Efficient lookup from file in nodejs?

I am wanting to write a node application that looks up a bunch of blacklists from plain text files. Basically are all under directories representing different categories, and in each there is a file ...
user avatar
1 vote
0 answers
27 views

What's the best approach to find out in doing what a Linux OS process is stuck?

Oracle DBA here! No experience at all in troubleshooting Linux performance... I need to identify the bottleneck in an Oracle database running on Oracle Linux. The same procedure runs fine on other VMs,...
user avatar
0 votes
1 answer
1k views

Can SQL Server 2019 perform equally well under Linux and Windows (same hardware)?

We have recently installed SQL Server 2019 on a server, running Ubuntu 20.04 (server edition). Under our specific use case, executing integration testing against this SQL Server instance, it takes 2-3 ...
user avatar
  • 101
0 votes
1 answer
55 views

RAID 0 for Development

Hello fellow administrators, I am seeking high level guidance on the following situation: First the context of the environment: internal, all virtual (vmware), development use only, performance ...
user avatar
2 votes
0 answers
71 views

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 of irate(...
user avatar
  • 173
1 vote
0 answers
30 views

Would a flat or tree-like file structure allow for faster fetching of files by Path?

Would a flat file structure allow for faster locating/fetching of files by Path in an NTFS (Windows 10 File System) or would it essentially be as efficient as a highly structured tree with a bunch of ...
user avatar
  • 141
2 votes
1 answer
122 views

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 ...
user avatar
3 votes
2 answers
264 views

Performance differences between EXT4 and XFS on kernel 4.15.0-76

OS: Ubuntu 18.04.4 LTS Kernel version: 4.15.0-76-generic Storage type: RAID10 (4 x SSD) Question: is it a bug for this version of kernel? EXT4 run a lot slower when we perform same SQL insert test; ...
user avatar
0 votes
0 answers
44 views

mariadb main thread over 100% cpu and flushing logs

I have 5.5.60-MariaDB and noticed the main thread remains on sleep mode for the last 200hrs. After checking innodb status I see the below line for this thread. Main thread process no. 119014, id ...
user avatar
  • 1
3 votes
2 answers
555 views

MySQL LOAD DATA INFILE: Better Server, Worse Performance

I am testing out Microsoft Azure Database for MySQL and have run into a performance issue that I do not understand. I launched a "Basic" server with 1 vCore (2 GB RAM, "Standard Storage"), which is ...
user avatar
1 vote
0 answers
99 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 ...
user avatar
2 votes
1 answer
7k 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 ...
user avatar
  • 21
2 votes
1 answer
6k 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 ...
user avatar
  • 123
5 votes
1 answer
25k 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) [...
user avatar
-1 votes
1 answer
308 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: ...
user avatar
  • 1
-2 votes
1 answer
295 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.
user avatar
0 votes
1 answer
34 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 (...
user avatar
0 votes
1 answer
343 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 ...
user avatar
-2 votes
1 answer
97 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 ...
user avatar
  • 2,242
0 votes
3 answers
815 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 ...
user avatar
  • 25
0 votes
1 answer
432 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 ...
user avatar
  • 131
2 votes
1 answer
3k 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 ...
user avatar
  • 1,802
7 votes
1 answer
8k 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 ...
user avatar
0 votes
0 answers
737 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% ...
user avatar
0 votes
1 answer
109 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 : ...
user avatar
  • 1
1 vote
1 answer
2k 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 ...
user avatar
  • 11
1 vote
0 answers
175 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 ...
user avatar
  • 2,480
-1 votes
1 answer
119 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 : ...
user avatar
  • 1
0 votes
2 answers
156 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. ...
user avatar
0 votes
0 answers
226 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 ...
user avatar
0 votes
1 answer
305 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? ...
user avatar
  • 1
6 votes
3 answers
19k 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 ...
user avatar
1 vote
1 answer
461 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 ...
user avatar
  • 23
1 vote
1 answer
401 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/...
user avatar
1 vote
0 answers
443 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 ...
user avatar
3 votes
1 answer
345 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 ...
user avatar
1 vote
0 answers
113 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 ...
user avatar
  • 474
10 votes
3 answers
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 ...
user avatar
0 votes
2 answers
1k 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 ...
user avatar
  • 404
0 votes
1 answer
663 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 ...
user avatar
1 vote
0 answers
857 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 ...
user avatar
-3 votes
1 answer
2k 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 ...
user avatar
  • 111
9 votes
1 answer
118k 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 ...
user avatar
  • 129