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
4
votes
2 answers

Oracle Compatible Parameter to set

Is there any difference in setting the Compatible Parameter to 11.2.0.0 vs 11.2.0.4 ? Are there any advantages / dis-advantages ?
user3470294
  • 190
  • 1
  • 1
  • 12
3
votes
1 answer

Cassandra --JVM Tuning for G1GC

I am getting dropped mutation due to GC.MY young Generation GC is taking long time G1 Young Generation GC in 1804ms. G1 Eden Space: 771751936 -> 0; G1 Old Gen: 5351931920 -> 4995416072; G1 Survivor Space: 83886080 -> 58720256; MUTATION messages…
rishi
  • 41
  • 1
  • 3
3
votes
2 answers

Very Slow Eloquent Insert/Update Queries in Laravel

I have a laravel application which must insert/update thousands of records per second in a for loop. my problem is that my Database insert/update rate is 100-150 writes per second . I have increased the amount of RAM dedicated to my database but got…
Ramin Omrani
  • 3,673
  • 8
  • 34
  • 60
3
votes
1 answer

Which database is performance oriented, MySQL or MariaDB?

Which database is performance oriented, MySQL or MariaDB? Which storage engine is better for all of the following? databases that should be scalable fast in query processing have community support have a lot of tutorials or any other alternatives…
user492888
  • 207
  • 3
  • 17
3
votes
1 answer

Why this mysql query (with is null check) is so slower than this other one?

I getting in doubt with "IS NULL" MySQL check. I have this 2 queries. The first one runs in about 300 seconds. The second one run less then 1 second! Slow query: SELECT count(distinct(u.id)) FROM ips_usuario AS u JOIN ips_fatura AS f ON ((u.id…
Arivan Bastos
  • 1,876
  • 1
  • 20
  • 28
3
votes
3 answers

Undo changes made by SQL Server Database Tuning

I am not sure if this question can be asked here or serverfault. I was wondering...Is there is a way to quickly undo the changes made by SQL Server 2005 Tuning Advsor other than recovering from a backup?
Saif Khan
  • 18,402
  • 29
  • 102
  • 147
3
votes
1 answer

Using SQL Tuning wizard with sp_prepexec statements

I am attempting to use the SQL profiler and Tuning wizard to investigate index usage in my SQL 2008 R2 database. The application connects to the db using ODBC. The db has not Stored Procedures and all the data is accessed using SQL statements. The…
Yossi
  • 136
  • 2
  • 7
2
votes
1 answer

Why is SQLITE taking forever on a simple count query?

I have a set of SQLITE tables that adds up to 7 GB on disk. The particular table I am querying (FQ) has approximately 50 columns, and 3 million rows. I am querying from the sqlite3 interactive shell (sqlite3.exe). The query I am running is: "select…
jwcoder
  • 131
  • 9
2
votes
1 answer

Will SQL Server 2005 Database Engine Tuning Advisor "tune" Temporary Tables?

I'm attempting to use Database Engine Tuning Advisor to tune my database. From the comments it's logging (it's just 40% into the analysis, after running all weekend) it appears that DTA is not capable of tuning operations on Temporary tables. Is…
Greg Dougherty
  • 3,281
  • 8
  • 35
  • 58
2
votes
2 answers

Logging all SQL executed in time period

In MS SQL Server 2008, I would like to investigate and tune the queries that are being executed by an application in a limited time interval. Can I, e.g. from SQL Server Management Studio, generate a log of all SQL being executed and how long time…
someName
  • 1,275
  • 2
  • 14
  • 33
2
votes
2 answers

SQL Server: Number of disk blocks used by index or table

In SQL Server, how can I see the number of disk blocks an index or a tables uses?
someName
  • 1,275
  • 2
  • 14
  • 33
2
votes
1 answer

Risks of changing flushes frequency

Through iostat I could find spikes in disk writes once per minute. I think these spikes are caused by fsync, since MongoDB by default flush data to disk every 60 seconds. I could also find out that coinciding with the spikes slow queries are…
Antonio Val
  • 3,200
  • 1
  • 14
  • 27
2
votes
0 answers

What are the best values for Postgresql.conf for better performance

I am using a DBMS PostgreSQL 9.0.1 on S.O Linux Debian 8 and server HP proliant Ml110-G9 : Processador: (1) Intel Xeon E5-1603v3 (2.8GHz/4-core/10MB/140W) Memória RAM: 8GB DDR4 Disco Rígido: SATA 1TB 7.2K rpm LFF More specifications here:…
Neto
  • 161
  • 7
2
votes
4 answers

Speed and tuning for mySQL (1billion rows)

My company has a mySQL server used by a team of analysts (usually 3-4 at a time). Lately the queries have slowed down, with some of them taking even days, for a database with tables up to 1 billion rows (10^9 records). Server main features: Linux…
user3310782
  • 811
  • 2
  • 10
  • 18
2
votes
2 answers

How to design querying multiple tags on analytics database

I would like to store user purchase custom tags on each transaction, example if user bought shoes then tags are "SPORTS", "NIKE", SHOES, COLOUR_BLACK, SIZE_12,.. These tags are that seller interested in querying back to understand the sales. My…
Kanagavelu Sugumar
  • 18,766
  • 20
  • 94
  • 101
1
2
3
…
10 11