130 reputation
114
bio website
location London, United Kingdom
age
visits member for 2 years, 11 months
seen Nov 17 at 13:58

Nov
10
accepted How to efficiently swap a portion of a large table's data?
Nov
7
awarded  Teacher
Nov
7
revised How to efficiently swap a portion of a large table's data?
added 15 characters in body
Nov
7
answered How to efficiently swap a portion of a large table's data?
Nov
7
asked How to efficiently swap a portion of a large table's data?
Sep
25
awarded  Popular Question
Aug
18
accepted Stored procedures, binlog and SUPER privilege
Aug
18
awarded  Popular Question
Jul
2
awarded  Curious
Apr
22
comment InnoDB primary key efficiency
Excellent explanation, thank you!
Apr
22
accepted InnoDB primary key efficiency
Apr
22
asked InnoDB primary key efficiency
Mar
26
comment Is there any danger using binary data over an UTF-8 MySQL connection?
I'm quite comfortable with Unicode and UTF-8 actually, and the effects of charsets on table fields. But I'm very confused by how MySQL handles charsets while the data is being transmitted over the wire. What I precisely fail to understand is, why the hell the client & connection have a charset, and how this affects the data being transmitted to and from my app! I feel like there's some magic charset conversion happening on-the-fly, and this idea scares me. If the field contains UTF-8, I want my app to receive a UTF-8 string; if it contains binary, I want to get binary back, full stop!
Mar
25
comment Is there any danger using binary data over an UTF-8 MySQL connection?
I'm still confused by this, but you reassure me a little :)
Mar
25
asked Is there any danger using binary data over an UTF-8 MySQL connection?
Nov
5
accepted Check all MySQL tables at once
Nov
5
asked Check all MySQL tables at once
Oct
4
answered Stored procedures, binlog and SUPER privilege
Oct
4
awarded  Commentator
Oct
4
comment Stored procedures, binlog and SUPER privilege
Also, I've rewritten my code to use stored procedures since, and it seems to work! I will detail that in an answer.