Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
1 8
Newest
 Tumbleweed
Impact
~5k people reached

  • 0 posts edited
  • 1 helpful flag
  • 2 votes cast
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