Stack Overflow
Stack Overflow

Questions tagged [database-tuning]

deals with optimizing the performance of a database. It can be about file design, and selection of the DBMS, OS and platform.

Database tuning is about maximizing the performance of a database. It can include hardware, software, file system, OS and DBMS selection. See the wikipedia article for more.

158 questions
0
votes
0 answers

SELECT query waiting on DataFileWrite in Postgres

I have a partitioned table on which I run both queries and INSERTs simultaneously from multiple sessions. Database is Postgres 14.1. Running select wait_event_type, wait_event, state, query from pg_stat_activity often reports my queries (plain…
milan
  • 2,355
  • 2
  • 23
  • 38
0
votes
0 answers

Tuning Azure Postgres PAAS (100% memory usage)

Postgres is running on Azure as PAAS. It is running with 1 core 5 GB memory. We have a lot of row updates happening in the database. Its memory usage increases gradually as if there is a memory leak and then it reaches 100%. What I tried so…
Cpp crusaders
  • 117
  • 2
  • 10
0
votes
1 answer

Druid Tuning Configuration

iam beginner using druid and kafka. I want to create interactive data realtime kafka-druid. I still confuse what tuning should i change of this configuration? Thank in advance
Handri Mauludin Maulana
  • 75
  • 1
  • 14
0
votes
1 answer

Oracle-Java | Update 6000 rows in 30 Mins to 1 hour| A Non Primary Non Indexed composite key

It take 2021-03-10 15:48:07,593 INFO [com.ery.integrator.erpcrm.schedular.CustomerTeamsJmsServiceImpl] (EJB default - 2) In CustomerTeamsJmsServiceImpl: ******************************** Batch Processing Started…
fatherazrael
  • 5,511
  • 16
  • 71
  • 155
0
votes
1 answer

Performance issue - max_elapsed_time

I have an sp running in production with max_elapsed_time = 87269.399 and avg_elapsed_time (ms) = 10.24. Also max_logical_reads : 8180303 avg_logical_read = 3803.83795958974 Can anyone please help to understand why we have these much times…
Thara Unnithan
  • 15
  • 3
0
votes
1 answer

Mysql total time SHOW PROFILE is diiferent from SHOW PROFILES

Could someone help me with this issue? When I execute the command SHOW PROFILES, I got a time duration which is different from the command SHOW PROFILE (without "S"), in this case, which one do I have to consider? e.g: For SHOW PROFILES query |…
Doug P
  • 169
  • 1
  • 3
  • 13
0
votes
0 answers

Query to get the OS process (postmaster) and query associated with it in postgres database

Few executables of an application that is connected to the Postgres database are using 100% resources and in Linux OS, I can see that the postmaster is using 100% CPU, so, I am in need to find the queries associated with the postmaster(100%CPU)…
Sujeet Chaurasia
  • 97
  • 8
0
votes
1 answer

Slow performance on table with just over 1 million records: Are the indexes wrong?

I've been asked to look into a performance issue for an app that is becoming progressively slower. Pretty quickly, I was able to narrow down the problem to a single database table. Poorly structured C# code I'm ok at optimizing. But with SQL tables,…
Casey Crookston
  • 13,016
  • 24
  • 107
  • 193
0
votes
1 answer

ORACLE 12c parameter to change , as db performace is a bottleneck with default parameters

we recently upgraded our db from 11g to 12c, now db with 12.2 version on linux. the db is mostly of oltp type, having around 150GB application data and tables having approx 5GB to 10Gb in size, after upgradation the performance of db is degraded, we…
RUDRA PARIDA
  • 1
0
votes
2 answers

NVL function not using index rather FTS, is it possible to modify the query

MY query like below select nvl(a.value1,nvl(b.value1,nvl(c.value1,'')) from table1 a, table2 b table3 c where a.value2=b.value2 and b.value3=c.value3 As this query contains a nvl function which tables the value1 from three of my tables it is…
RUDRA PARIDA
  • 1
0
votes
1 answer

How to configure Mongodb cache size per database?

I have two Mongo databases (A and B). Database A is in a place where speed is very important, while B is used in places where speed is not much of an issue. I would like to somehow limit the size of the available cache for database B, so database A…
4evertoblerone
  • 95
  • 1
  • 3
  • 12
0
votes
1 answer

SQL Server Query Join taking very long when adding an additional column in the join

I'm running a basic query on a table with a unique ID in each table, which is a non-clustered index in each. One table has 8 million rows, and the other has 800,000 rows. When I run the following, it returns 24,000 rows in less than a…
sqlnewbie1979
  • 99
  • 1
  • 11
0
votes
0 answers

Does Microsoft SQL Server 2014 has parameter relate maximum incoming request/sec?

I'm not sure Microsoft SQL Server 2014 limit or unlimited incoming request(record or transaction)/sec.If it has parameter to config please share me please.
NPS
  • 9
  • 2
0
votes
0 answers

Reduce memory consumption of mariadb 15.1.41 for micro instance

Running mariadb in micro instance with 600MB memory, and its a very low usage instance and for testing purpose. Is there a way to reduce the memory consumption for this test database instance? Tried turning off performance schema and other options…
18bytes
  • 5,951
  • 7
  • 42
  • 69
0
votes
1 answer

Increase performance of cassandra

If I increase the size of sstables, performance will be perfect, please anyone can list me all key parameters i want to edit it to increase performance of cassandra. i think exists a lot off parameters want to change it. I tried to edit…
Mohamed Cherradi
  • 11
  • 4
1 2 3
…
10 11