Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 10
Newest
 Teacher
Impact
~8k people reached

  • 0 posts edited
  • 0 helpful flags
  • 6 votes cast
Dec
21
accepted Where/how do I save extra data per column?
Dec
17
awarded  Teacher
Dec
17
revised Where/how do I save extra data per column?
it seems it wasn't clear this is meant as an actual answer
Dec
17
answered Where/how do I save extra data per column?
Dec
17
awarded  Curious
Dec
16
comment Where/how do I save extra data per column?
Yeah, but I wanted to avoid confusion :)
Dec
16
comment Where/how do I save extra data per column?
It does minimize overhead, but I think I know what bugs me on it: see addition to the question: there is no separation between the two clearly different types of information, so when looking for all meta-information you'd have to manually type the right columns and feels like you are adding a hidden property to those colums; one that might be made more explicitly?
Dec
16
revised Where/how do I save extra data per column?
added query example
Dec
16
comment Where/how do I save extra data per column?
Well, on a table with say 15 columns, and some related table holding another batch of those, you'd get a lot of extra size to the table. I'm not sure why, but it feels cluttery.
Dec
16
asked Where/how do I save extra data per column?
Aug
28
revised Space usage when copying
added storage engine
Aug
28
comment Space usage when copying
As stated in the question, it's already mixed. Changing it to statement doesn't help me much: I want to figure out what exactly happened; changing binlog on a production server is not really going to help me there :)
Aug
27
comment Space usage when copying
I have fixed the query itself by the way, so that isn't a real issue: I am mostly wondering what queries would fill up the binlog this much, and why, so I can begin to learn when to expect this.
Aug
27
comment Space usage when copying
But then the replication would break, right? Sounds.. sub-optimal
Aug
26
revised Space usage when copying
added binlog format
Aug
26
revised Space usage when copying
then/than typos
Aug
26
revised Space usage when copying
fixed some typos
Aug
26
asked Space usage when copying
Jan
3
awarded  Notable Question
May
13
comment Mysql reliable with 1000 new entries / minute?
What does mysql being open source have anything to do with it?