Questions tagged [database-performance]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1
votes
1answer
76 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 ...
0
votes
0answers
14 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 ...
1
vote
0answers
19 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,...
0
votes
1answer
30 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 ...
0
votes
1answer
44 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 ...
1
vote
0answers
31 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(...
0
votes
0answers
16 views

Oracle12c standard edition SNMP monitoring

I have Oracle12c "standard" edition database running. I would like to enable SNMP to monitor this database. All the documentation I found so far pointing that I need "enterprise edition&...
0
votes
0answers
15 views

Apache processes consuming to much memory

Am suspecting apache is consuming too much memory on my server,, Here is a screenshot for htop The is lots of calls to /usr/bin/apache2 -k start , why too many calls to start apache while apache is ...
1
vote
0answers
19 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 ...
2
votes
1answer
61 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 ...
0
votes
0answers
9 views

MongoDB sharded cluster and replica sets sharing servers

I'm trying to define the architecture for a production sharded mongoDB server, I see in the documentation that each shard has to contain 3 replica-sets. I would like to have the sharding advantages(...
3
votes
2answers
109 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; ...
0
votes
0answers
25 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 ...
3
votes
2answers
476 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 ...
1
vote
0answers
63 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
5k 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 ...
2
votes
1answer
5k 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 ...
4
votes
1answer
23k 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
205 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: ...
-3
votes
1answer
268 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
33 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
266 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
84 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
3answers
755 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
345 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
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 ...
7
votes
1answer
6k 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
696 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
106 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
1k 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
168 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
100 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
123 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
219 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
276 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? ...
6
votes
3answers
17k 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 ...
1
vote
1answer
394 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
332 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
362 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
335 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
111 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
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 ...
0
votes
1answer
650 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
768 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
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 ...
9
votes
1answer
105k 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
46 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
736 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 ...