Questions tagged [database-performance]
The database-performance tag has no usage guidance.
186
questions
0
votes
0
answers
49
views
Can you exceed 1 gigabit from an EC2 instance to an AWS Aurora MySQL instance?
I'm importing a terabyte of data into an AWS Aurora MySQL table from an EC2 instance. Because our service will be down while migrating prod, I care a lot about the import speed.
Currently I can't ...
- 171
0
votes
0
answers
51
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
217
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?
- 6,101
-1
votes
1
answer
235
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
823
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
3
votes
1
answer
519
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 ...
- 123
2
votes
1
answer
1k
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
286
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
1k
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
180
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
60
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
1
vote
1
answer
5k
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 ...
- 119
0
votes
1
answer
214
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
161
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
113
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