123 reputation
18
bio website scribblepadofdoom.tumblr.com
location Singapore
age 29
visits member for 3 years, 7 months
seen Oct 20 at 11:34

I'm the CTO at Media Pop a software and social media consultancy in Singapore. We care about what we do, work hard and do fun things. If you know Python and want a job ping me at kit@mediapop.co. :)

Likes

profile for Kit Sunde on Stack Exchange, a network of free, community-driven Q&A sites


Oct
19
awarded  Tumbleweed
Oct
12
asked Computer crash causes MySQL to leaves behind an .err file that stops mysql from booting on reboot
May
28
awarded  Notable Question
Oct
7
awarded  Popular Question
Aug
14
comment How can I get MySQL to accept both resume and resumé on a primary key?
@Fr0zenFyr Thanks I did find the SO one, I also tried googling around for some benchmarks, but I couldn't find much more than opinion. If I get bored I'll benchmark it myself I think. :)
Aug
13
comment How can I get MySQL to accept both resume and resumé on a primary key?
@Fr0zenFyr I was curious about that as well, this could be another question. I'd up vote it.
Aug
10
awarded  Scholar
Aug
10
accepted How can I get MySQL to accept both resume and resumé on a primary key?
Aug
10
awarded  Supporter
Aug
10
comment How can I get MySQL to accept both resume and resumé on a primary key?
Thank you that was helpful, the question linked to bugs.mysql.com/bug.php?id=19567 which covers this issue. I believe I can (for this particular use case) switch to utf8_bin as everything is lowercased.
Aug
10
comment How can I get MySQL to accept both resume and resumé on a primary key?
@ypercube Correct and adding to that, SELECT * FROM foo_person WHERE name='resume' would return 2 results. Which is unwanted since they are two different words.
Aug
9
asked How can I get MySQL to accept both resume and resumé on a primary key?
Oct
12
comment When should I think about upgrading our RDS MySQL instance based on memory usage?
@JNK Where does it say that upgrading isn't going to solve a memory issue? It's saying "here's some things you should know about RDS". I'm not stating I have a memory issue right now, my question is about finding out how to judge when to upgrade something before it's a problem. I could calculate when it'll spend more time garbage collecting than doing any actual work and find a sweet spot for upgrading (or tuning) my server, but I'm sure someone with more experience would have a simpler way of judging these things. I'm not sure if my question is unclear, I'll happily take edit suggestions.
Oct
12
awarded  Citizen Patrol
Oct
12
comment When should I think about upgrading our RDS MySQL instance based on memory usage?
It doesn't seem like this answers my question. I'm trying to understand when garbage collection and memory usage becomes a problem, not so much how to deal with it. I don't currently know if the garbage collection the DB is doing once every 2-3 days is healthy and at what time I should be concerned it's unhealthy, I would like to have some idea before it actually becomes an issue. How to fiddle with settings to free up memory seems like a separate issue, although I welcome the suggestions.
Oct
12
awarded  Editor
Oct
12
revised When should I think about upgrading our RDS MySQL instance based on memory usage?
deleted 19 characters in body
Oct
12
awarded  Student
Oct
12
asked When should I think about upgrading our RDS MySQL instance based on memory usage?
Apr
6
awarded  Autobiographer