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

Hbase cluster running Phoenix is slow using jdbc and python phoenixdb

I have a cluster setup running HBase and a phoenix queryserver. Currently my cluster contains a master node and 3 slaves. The table I am connecting to consists of 124 columns and a total of 16 million rows. A simple COUNT(*) or DISTINCT "value"…
Zeliax
  • 4,987
  • 10
  • 51
  • 79
0
votes
0 answers

postgresql cache and swap memory increasing

I have postgresql(Master and Slave) infrastructure. The postgresql server have 32 GB RAM and 600 MB swap space. We are using java(tomcat) applications. I have performed postgresql tuning using http://pgtune.leopard.in.ua/. But currently my issue is,…
devops
  • 173
  • 4
  • 16
0
votes
0 answers

Teradata system views tuning

I tried to connect teradata using sqlalchemy in order to use read_sql and to_sql methods form pandas. However, the connection is so slow. Even simple stuff, such as pd.read_sql('select current_date'), will cost more than 30 seconds to complete. I…
yl2526
  • 1
  • 2
0
votes
1 answer

I can't find the SQL Server 2005 Database Tuning Advisor

I can't find the SQL Server 2005 Database Tuning Advisor on my computer. Is it something I needed to specifically choose when I installed SQL Server 2005? I looked in All Programs -> Microsoft SQL Server 2005 and also in the C:Program Files…
Lill Lansey
  • 4,775
  • 13
  • 55
  • 77
0
votes
1 answer

Get Full Executed Query in Postgresql

Halo, first, i say thank you for helping me solve my problem before. I'm really newbie using Postgresql. now i have new problem, i do select statement like this one : select * from company where id=10; when i see the query in pg_stat_statements,…
enjelyna pardede
  • 21
  • 1
  • 2
0
votes
1 answer

Performance tuning tips -Plsql/sql-Database

We are facing performance issue in production. Mv refersh program is running for long, almost 13 to 14 hours. In the MV refersh program is trying to refersh 5 MV. Among that one of the MV is running for long. Below is the MV script which is running…
Ajay Shetty
  • 3
  • 4
0
votes
1 answer

How many concurrent connection RDS handle?

I host my two MySql databases on Amazon RDS, which is db.m3.medium and db.r3.large having 5.6.27 innodb engine. Now I want to know, how many concurrent connections these instances can handle? How to load test it? What will be the impact if 1000…
Manish Sapkal
  • 5,591
  • 8
  • 45
  • 74
0
votes
1 answer

Will select parallel query help for non-indexed column in where clause?

the table being queried has billions of records and the select query's where clause is based on non-indexed columns. So a normal select query does a full table scan & hence takes more time. I am trying to use parallel feature to see if it helps…
skpraveen
  • 183
  • 1
  • 5
  • 18
0
votes
1 answer

ORACLE: Calculate storage requirement of table in terms of blocks on paper

I have to calculate storage requirements in terms of blocks for following table: Bill(billno number(7),billdate date,ccode varchar2(20),amount number(9,2)) The table storage attributes are : PCTFREE=20 , INITRANS=4 , PCTUSED=60 , BLOCKSIZE=8K ,…
AkaSh
  • 486
  • 4
  • 16
0
votes
2 answers

SSIS ( SQL Server Integration Services ) & Teradata Volatile Tables . ( Teradata SQL tuning )

I would like to understand what Modalities SQL server Integration service ( SSIS ) uses to connect to Teradata 14 ODBC .NEt OLE DB These ones or more / less than these. My main question is HOW do I IMPLEMENT teradata volatile table create…
user1874594
  • 2,277
  • 1
  • 25
  • 49
0
votes
1 answer

Postgres 9.4: How to fix Query Planner's Choice of Hash Join in ANY ARRAY lookup which runs 10x slower

I realize of course that figuring out these issues can be complex and require lots of info but I'm hoping there is a known issue or workaround for this particular case. I've narrowed down the change in the query that causes the sub-optimal query…
Sarus
  • 3,303
  • 1
  • 23
  • 27
0
votes
1 answer

Oracle PL/SQL - a procedure called by some other team to insert data. Procedure is being called from Java

Contents of procedure - Just two direct insert statements which are inserted through IN parameters. The procedure will be hit every second when a row has to be inserted. It's kind of a recharge. If you recharge, the details will be sent by some…
user1720827
  • 137
  • 1
  • 3
  • 15
0
votes
2 answers

Mysql with bad performance and high cpu load tuning - cs-cart linux

I have a cs-cart installation based in Mysql (MyIsam) with about 3,000 items and a database size of 700MB and index size of 247MB. In the last month for a reason i don't know the performances falled down and are very inconstant. I optimized the DB…
Luca
  • 108
  • 1
  • 11
0
votes
0 answers

Indexing on local table in SQLServer2008

SQL Server help: I have created a local table @Emp in my database and inserted values to it. Can I add clustered indexes on this table? I need to reduce my sorting cost (78%), hence I need to do this.
Swarnava Mukhopadhyay
  • 21
  • 5
0
votes
2 answers

Write a tool to programmatically check Netezza (Pure Data) for skew and get query plan

I am pondering on the idea of writing a .NET tool that connects to a Netezza box with the following functionality: 1. Check distribution/skew of an input list of tables 2. Check query plan of an input query I know can do that using Aginity Workbench…
Some Newbie
  • 1,059
  • 3
  • 14
  • 33
1 2 3
…
10 11