96 reputation
11
bio website melikedev.com
location Murrieta, CA
age 41
visits member for 2 years, 3 months
seen yesterday

We are working on the next big social media project and in need of talented start-up veterans to fill the few remaining advisory board roles. If you are interested in the project drop me a line @ mike.purcell@shouttag.com.


1d
awarded  Benefactor
1d
comment MySQL - Best long read query solution within a replication based system
Thanks for the clear and concise breakdown.
1d
accepted MySQL - Best long read query solution within a replication based system
Apr
11
awarded  Promoter
Apr
8
revised MySQL - Best long read query solution within a replication based system
added 23 characters in body
Apr
8
asked MySQL - Best long read query solution within a replication based system
Feb
25
awarded  Popular Question
Nov
1
awarded  Popular Question
Oct
25
comment MySQL - Add index to low cardinality text column?
Nice. Appreciate the write-up. I actually ended up converting the enums to varchars, then added the indices. Took some refactoring on the lower level api, but seems to work well.
Oct
25
comment MySQL - Add index to low cardinality text column?
I ended up fixing the lower layer code to accept enums, but convert to varchars, so now I can add indices. Thanks again, as I learned something new.
Oct
25
accepted MySQL - Add index to low cardinality text column?
Oct
24
comment MySQL - Add index to low cardinality text column?
Interesting. Thanks for the insight. I'll post back with a status update.
Oct
24
comment MySQL - Add index to low cardinality text column?
Uhhh it's not so much the data contained therein, it's the schema, hence the 'design'.
Oct
24
comment MySQL - Add index to low cardinality text column?
Interesting, didn't even consider a partition. So a partition like this would be faster than adding an index? What if there were multiple enum cols?
Oct
24
awarded  Commentator
Oct
24
comment MySQL - Add index to low cardinality text column?
Unfortunately I cannot as the design is proprietary.
Oct
24
asked MySQL - Add index to low cardinality text column?
Jul
19
awarded  Editor
Jul
19
revised CREATE INDEX vs ALTER TABLE ADD INDEX - MySQLism, or SQL Standard?
edited title
Jul
19
comment CREATE INDEX vs ALTER TABLE ADD INDEX - MySQLism, or SQL Standard?
@a_horse_with_no_name: Duly noted. I don't understand why MySQL forces us to pass an index_name, when clearly it can handle no name underneath. It's a PITA to be forced to do an alter simply to avoid naming indices.