2,648 reputation
1529
bio website
location
age
visits member for 2 years, 7 months
seen yesterday

Mar
31
comment Efficient way to fetch/update X records in a loop
It sounds like you're describing a queue of sorts. You might want to look at something like RabbitMQ
Mar
31
answered Delete Query takes a long time
Mar
28
comment Is it possible to have mysql treat row based updates as “upserts”?
The scenario I was talking about was using straight row based replication, hence the "before image" it's using.
Mar
19
answered Mysql used key changes between two consecutive EXPLAINs
Mar
19
comment Generate INSERT statement from SELECT query
Because you ran it twice and already had a copy of your primary key tuple, which enforces uniqueness I'm guessing. If you're doing a fresh run you can either truncate your destination table (I'll leave it to you if wiping everything out for a clean slate is appropriate), or look at the insert on duplicate key update syntax
Mar
18
answered Generate INSERT statement from SELECT query
Mar
14
accepted Native checksum table says there's a difference, pt-table-checksum does not
Mar
14
asked Native checksum table says there's a difference, pt-table-checksum does not
Mar
12
reviewed Approve suggested edit on Is it possible to have mysql treat row based updates as “upserts”?
Mar
12
asked Is it possible to have mysql treat row based updates as “upserts”?
Mar
8
awarded  Nice Answer
Feb
19
revised Method for identifying max_allowed_packet queries generating errors in MySQL
placement of previous edit seemed weird
Feb
19
asked Method for identifying max_allowed_packet queries generating errors in MySQL
Feb
18
answered MySQL replication: slave not updated
Feb
13
answered How can I replicate some tables without transferring the entire log?
Jan
28
comment Why should the most restrictive condition be listed last in the where clause?
I don't know what book you have, but I'd stop reading it.
Jan
27
asked pgpool not selecting new master
Jan
27
answered MySQL User with Host set to a Range of IP Addresses
Jan
27
comment MySQL Space efficient way of storing indexed key-value pairs associated with table
If you're expecting 100M records per month you'll exhaust your keyspace in 3-4 years. If you plan on being around that long, use a bigint for auto inc. At the same time you'll run into other problems if you end up having 4B+ rows in a single table.
Jan
27
awarded  Popular Question