The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
3answers
295 views

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 ?
0
votes
3answers
200 views

mysql need help optimizing query

I have a table containing servers logs, and another table containing rules to match certain and drop them. The logs tables contains around 1 million rows, and there are about 20-30 rules. The ...
1
vote
1answer
103 views

tuning feed item's table query with multiple condition

I have a query like this: SELECT * FROM `rss_item` WHERE `feed_id` = 1 and `timestamp` < 1350698635 ORDER BY `rss_item`.`timestamp` ASC MySQL: 5.1; table engine: innodb Explain result: ...
0
votes
1answer
93 views

Performance tuning in Sybase

Does Sybase have a tool like AWR in Oracle which can be used to identify high load SQL, tell the important waits that are happening, help in understanding the workload? What are the main tools to be ...
1
vote
0answers
14 views

MySQL: index statistics dropped when table dropped?

When a table is dropped, are its index statistics also removed? The reason I ask is that I was hoping to 'prep' the stats by running log playback via the percona-playback tool prior to cutting over ...
1
vote
0answers
1k views

Oracle 10g - Sudden change in execution time for specific query

After the DBAs fiddled with some parameters in our Oracle 10g Production Environment, most queries became a little faster. But a single query (a quite complex one) became dramaticaly slower - it went ...
0
votes
0answers
29 views

Tuning MySQL with InnoDB engine for my application

I've read through a lot of answers, and I realize this is mostly application specific, so I wanted to give some background as to what I'm doing with the database and hopefully get some tips on tuning ...
0
votes
0answers
91 views

MySQL my.cnf performance tuning Need some advice

Our architecture is as follows: Memory : 132GB CPUs : 12 OS & Mysql : 64-bit Disk Space : 2.0 TB DB Engine : MyISAM i only have 1 table innodb (around 400mb) all the rest are ...
0
votes
0answers
44 views

query_cache_limit and query_cache_limit, fine tuning for Magento

I was tuning the config in my.cnf yesterday, and I ran across these two settings. Currently the cache query_cache_limit is set to 128mb, and query_cache_limit is 4mb. Basically I want it to cache as ...
0
votes
0answers
169 views

No query cache efficiency mairaDB

I'm totally new to database tuning, and even though I've done well so far, I'm stuck with my database cache query efficiency 0%. Any help with this would much appreciated I've tried increasing ...
0
votes
0answers
55 views

Optimization of an old query multiple unioned subqueries

I am currently in the process of optimizing a large query that was written for oracle 8i. My company currently uses oracle 10g which gives us a lot of options for optimization. Please Reference the ...
0
votes
0answers
483 views

Low Query cache efficiency after mariadb 5.5 migration

We change from Percona MySQL server 5.5 to MariaDB but performance is not as good as we think. This graph is from a day in MariaDB. You can see the low performance in terms of cache_hits: We have ...
0
votes
0answers
127 views

InnoDB tuning with 1G of ram limit

I am trying to calculate variable moving averages crossover with variable dates. That is: I want to prompt the user for 3 values and 1 option. The input is through a web front end so I can build/edit ...
0
votes
0answers
94 views

mysql: how many disk seeks were made for a select query

I will fire a select query. I want to know how many disk seeks does that query take. mysql documentation has given formula for full table scan. ...
0
votes
0answers
294 views

PostgreSQL can't start after tuning some options

I'm having some issues with "too many clients" and I tried to change the max_connections param (currently 100). I tried to set some value like 300, but when I restart the service, I got this ...