275 reputation
114
bio website
location
age
visits member for 2 years, 5 months
seen Sep 13 '13 at 13:28

Jun
4
comment Why don't databases create their own indexes automatically?
A database can already put an index on a table it just currently requires us to command it to, a car physically cannot replace a tire, until we build it some arms to use.
Jun
4
comment Why don't databases create their own indexes automatically?
a more accurate analogy is does your ECU alter the power supplied to the fuel pump to fix fuel/oil flow rates and compensate for dirty lines? to which the answer is yes..
Jun
4
comment Why don't databases create their own indexes automatically?
@KennethFisher the idea wasn't to anticipate future workloads, but to improve on recurring ones. for an example, i constantly hit the user table getting a list of all the posts from a user, this happens once every 10 queries and queries happen about 300/sec, couldn't the DB work out that an index on that would be advantageous just from the hit rate?
Jun
4
comment Why don't databases create their own indexes automatically?
why can't they take an iterative approach to it? i understand that on a server that is pushed to the limit already it'd be a bad thing having your DB attempt to tweak itself automatically and so you'd turn it off. but surely if a database is able to suggest queries to you, then it could surely try it out when at lower than average load and determine if there is a performance hit.
Jun
4
asked Why don't databases create their own indexes automatically?
Apr
5
accepted Comparing two tables for a UUID change and fix it
Apr
3
asked Comparing two tables for a UUID change and fix it
Mar
26
awarded  Tumbleweed
Mar
19
asked How do I check if a constraint exists on Firebird?
Feb
5
accepted Automatic MySQL Sync from master, where Slave was offline for long period of time
Feb
5
asked Automatic MySQL Sync from master, where Slave was offline for long period of time
Jan
31
accepted Master to Slave to Slave Configuration in MySQL
Jan
31
comment Master to Slave to Slave Configuration in MySQL
let us continue this discussion in chat
Jan
31
revised Master to Slave to Slave Configuration in MySQL
Added Master Status
Jan
31
comment Master to Slave to Slave Configuration in MySQL
I have recently updated the snapshot on server 2 by request of the boss
Jan
31
awarded  Editor
Jan
31
comment Master to Slave to Slave Configuration in MySQL
doesn't appear to have it running
Jan
31
revised Master to Slave to Slave Configuration in MySQL
Added Versions
Jan
31
comment Master to Slave to Slave Configuration in MySQL
50MB, server 1 can't go down for more than a minute, server 2/3 are expendable for now, No.
Jan
31
asked Master to Slave to Slave Configuration in MySQL