The tuning tag has no wiki summary.
3
votes
1answer
720 views
Pgpool, Postgresql and Apache tuning (1000 concurrent spatial queries)
I'm trying to configure a load balancing system.
I've a python script, invoked through mod_wsgi on Apache, that generates a query and executes it on pgpool: request-> wsgi python -> pgpool -> ...
1
vote
1answer
55 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
0answers
72 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
29 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
53 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
...
0
votes
0answers
278 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 ...
