118 reputation
17
bio website scribblepadofdoom.tumblr.com
location Singapore
age 29
visits member for 3 years, 3 months
seen Jun 10 at 10:53

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


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