| CARVIEW |
Select Language
HTTP/2 200
date: Wed, 23 Jul 2025 13:13:18 GMT
content-type: text/html; charset=utf-8
cf-ray: 963b6f2eca25343c-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=6bd76319-4908-4215-9cd5-33515fc74e5e; expires=Thu, 23 Jul 2026 13:13:18 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-frame-options: SAMEORIGIN
x-request-guid: 754e06b8-f123-45e7-831b-531c284c392d
x-worker-origin-response-time: 511000000
x-dns-prefetch-control: off
set-cookie: prov=6bd76319-4908-4215-9cd5-33515fc74e5e; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=xifHUlaDs3WwID_tdVc6TGgpLBSYBGFmmt8b0mmHsJ8-1753276398-1.0.1.1-J9gzfHFBlYxhru3jRY0daewcepjvfozUM7mpntQtxXVdYDZXCNxaqsDnHgkYEgwZVk.hlH0u_qWfXK8ko7E8JERy_JWHDhnTOTF_HnQRwaw; path=/; expires=Wed, 23-Jul-25 13:43:18 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=p3bsgc70JOFnF_n8Ar4inJgbj4qO.hNaK2mxATZT3So-1753276398415-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'performance' Questions - Database Administrators Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 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
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [performance]
An evaluation of whether a system works well enough to be fit for purpose. Normally performance refers to the speed with which a system completes an operation or set of operations over time.
6,476 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
1
answer
20
views
MariaDB: Engine-independent statistics are not collected for column
In the course of optimizing my MariaDB database I have tried the following query (found in this blocg post):
ANALYZE TABLE <my_table> PERSISTENT FOR ALL;
The command runs without an error, ...
1
vote
1
answer
44
views
Postgres query planner join selectivity greater than 1?
I am using PostgreSQL 14.17.
I am trying to debug a query planner failure in a bigger query, but I think I've narrowed down the
problem to a self-join on a join table:
SELECT t2.item_id
FROM ...
1
vote
0
answers
89
views
SLEEP_TASK waits on single-threaded UPDATE that does not generate an in-flight plan, how are these waits possible?
Yesterday, I witnesses a running query in sp_WhoIsActive that I could not explain. It had the following properties:
It ran in a nested transaction. The first transaction bulk inserts into a temp ...
2
votes
0
answers
52
views
What Vector Database is purposed for large data?
I have few hundred millions embeddings with dimensions 512 and 768.
I looking for vector DB that could run similarity search enough fast and with high precision.
I don't want to use server with GPU, ...
3
votes
1
answer
287
views
What are better approaches than loops for frequent operations?
I have to make multiple UPDATE statements, but I'm looking for the best approach to do so, in terms of readability and performance. I looked for another answers but the only thing I found is that &...
0
votes
1
answer
46
views
Indexed Views added to database have increased Parse and Compile time dramatically
Recently, one of our development teams have added some indexed views based on some very commonly used tables. The problem we are getting now is that queries that used to execute quickly are taking a ...
-1
votes
1
answer
135
views
MySQL 8.0.41 - 83 % Waiting for row lock on AO_319474_QUEUE
Environment
We run three Jira Service Management DC clusters that all share the same topology:
MySQL 8.0.36 on Ubuntu 22.04 – 32 vCPU, 100 GB RAM, buffer-pool now 80 GB (only ~33 GB in use), NVMe ...
1
vote
0
answers
55
views
ALTER TABLE ... REORGANIZE PARTITION on huge table takes longer after upgrading to MySQL 8.0
After upgrading from MySQL 5.7 to MySQL 8.0.33, I’ve observed a dramatic slowdown in partition management operations, particularly:
ALTER TABLE ... REORGANIZE PARTITION
ALTER TABLE ... DROP PARTITION
...
1
vote
0
answers
69
views
MariaDB 4-5 times slower than Oracle
since Oracle will increase the costs for running databases my employer is currently evaluating alternatives for oracle databases.
In one application we currently use oracle db with no specific ...
2
votes
1
answer
51
views
Stategies for scaling out MySQL/MariaDB when database gets too large for a single host?
What are your strategies when a MySQL/MariaDB database server grows to have too much traffic for a single host to handle, i.e. scaling CPU/RAM is not an option anymore? Do you deploy ProxySQL to start ...
3
votes
1
answer
65
views
MYSQL and random performance of store procedure
I run this SP at night, when there’s almost no activity. The SP performs an accumulative calculation of machine usage from a laundromat—an artisanal BI query. It writes the result to a table.
On most ...
2
votes
1
answer
46
views
partition table by created - how to avoid pagination problem caused by partition by Created column
I'm dealing with a performance issue on a partitioned table in SQL Server.
⚙️ Table setup:
The table is partitioned by Created (weekly), using a PARTITION SCHEME and PARTITION FUNCTION based on the ...
0
votes
2
answers
121
views
Unexplained read latency in SQL Server despite healthy RAID 10 disk and good synthetic benchmarks
I've set up a SQL Server instance on a dedicated Windows server. The .mdf data file is placed on a dedicated disk configured as RAID 10, with the RAID controller cache ratio set to 90% write / 10% ...
0
votes
3
answers
253
views
How to Insert 150,000 Rows in SQL Server Efficiently? (Error: Max 1000 Row Limit)
I am working with a large dataset of 150,000 rows that needs to be inserted into a SQL Server table. However, I am encountering the following error when trying to insert all values at once using a ...
0
votes
1
answer
34
views
Resource allocation strategy for Cassandra on a single server
I have a single physical server running Cassandra. Given that Cassandra performs poorly with fat nodes, which strategy is better:
Running a single large node on the server (allocating all resources ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
query-performance × 2440
sql-server × 2104
mysql × 1729
postgresql × 1338
index × 620
optimization × 614
postgresql-performance × 547
performance-tuning × 522
database-design × 348
execution-plan × 315
oracle × 303
sql-server-2012 × 274
innodb × 248
sql-server-2008-r2 × 217
sql-server-2008 × 207
join × 205
index-tuning × 200
sql-server-2014 × 169
sql-server-2016 × 166
t-sql × 154
mariadb × 143
sql-server-2005 × 110
partitioning × 108
mysql-5.5 × 103
memory × 101
more related tags
Hot Network Questions
- At Helsinki airport, connecting from Schengen to non-Schengen flight, is there exit immigration?
- Why Schrodinger wave equation is totally different from classical wave equation?
- Is there a way to move the cursor specifically to the beginning of the visually selected region (not just toggle like `o`)?
- Differential amplifier layout: closer to MCU or Load?
- Which domain (time or frequency) does filtering actually occur in real-life?
- Fit text on TWO pages by varying font size automatically
- Sum of ranks of blocks
- Why is the number of Marie Curie postdoctoral fellowships in mathematics significantly lower than in other subjects?
- Can I mount my PC with a desktop mount underneath a particle board Ikea Karlby Walnut top?
- SOSL/SOQL isn't returning User records
- Calculating the wall thickness in a hollow rotating cylinder space habitat
- Is classical logic the consensus among contemporary logicians?
- Is there a formal threshold for when a variable is considered 'random' in statistics? What is it?
- How to run CorePipeline.Run("contentSearch.PopulateSolrSchema", args); outside of regular sitecore environment
- Is it legal for businesses to give financial incentives for leaving positive reviews on review sites (e.g., Google Maps, Yelp, Facebook, Amazon)?
- Define command valid only for a specific environment in expl3
- Will a restless MCU survive long enough?
- Why is my gooseberry jam so stiff?
- Is a diet of one third Tuna ok for an eldery cat?
- Is a Rakshasa Immune to True Strike?
- Manga/manhwa where protagonist is the only one summoned to a different other world
- How to model This Twisted Torus?
- Not sure which test statistic to look at with regression with interaction term
- Make a Mulenère encryption program