Questions tagged [database-performance]
The database-performance tag has no usage guidance.
185
questions
0
votes
0
answers
25
views
SQL Server Logical Reads increased 10x in past week
I'm not an SQL DBA by any serious standard but I am trying to figure out why the logical reads have gone bonkers on a DB I have for a line of business app.
the image below shows a 10 x increase in ...
- 1
0
votes
0
answers
149
views
Are there any big performance boost when upgrade from Ubuntu 16.04 to 22.04?
If I run the server as MySQL database. (Assume using the same MySQL version).
Are there any big performance boost when upgrade from Ubuntu 16.04 to 22.04?
- 5,851
-1
votes
1
answer
122
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 ...
- 163
0
votes
1
answer
602
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 ...
- 3
1
vote
1
answer
282
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 ...
- 103
2
votes
1
answer
984
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 ...
- 121
0
votes
1
answer
207
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 ...
- 101
0
votes
1
answer
896
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 ...
- 109
0
votes
0
answers
155
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 ...
- 11
1
vote
0
answers
42
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,...
- 121
0
votes
1
answer
3k
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 ...
- 109
0
votes
1
answer
168
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 ...
2
votes
0
answers
123
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(...
- 173
1
vote
0
answers
78
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 ...
- 191
2
votes
1
answer
386
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 ...
3
votes
2
answers
884
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; ...
- 252
0
votes
0
answers
150
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 ...
- 1
3
votes
2
answers
721
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 ...
- 71
1
vote
0
answers
250
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 ...
- 489
2
votes
1
answer
8k
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 ...
- 21
2
votes
1
answer
7k
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 ...
- 123
5
votes
1
answer
27k
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) [...
- 4,700
-1
votes
1
answer
473
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:
...
- 1
-2
votes
1
answer
320
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
1
answer
41
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 (...
- 212
0
votes
1
answer
396
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 ...
- 207
-2
votes
1
answer
162
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 ...
- 2,338
0
votes
3
answers
877
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 ...
- 25
0
votes
1
answer
624
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 ...
- 131
2
votes
1
answer
4k
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 ...
- 1,852
7
votes
1
answer
10k
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 ...
- 4,700
0
votes
0
answers
803
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% ...
- 101
0
votes
1
answer
206
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
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 ...
- 11
1
vote
0
answers
178
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 ...
- 2,670
-1
votes
1
answer
160
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 :
...
- 1
0
votes
2
answers
204
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
0
answers
250
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 ...
- 119
0
votes
1
answer
342
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? ...
- 1
7
votes
3
answers
22k
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 ...
- 277
1
vote
1
answer
653
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 ...
- 23
1
vote
1
answer
491
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
0
answers
508
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 ...
- 141
3
votes
1
answer
354
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 ...
- 31
1
vote
0
answers
117
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 ...
- 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 ...
- 413
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 ...
- 404
0
votes
1
answer
820
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
0
answers
947
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 ...
- 41
-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 ...
- 111