174 reputation
17
bio website
location
age
visits member for 1 year, 6 months
seen Apr 9 '13 at 7:37

Jan
16
awarded  Popular Question
Nov
19
awarded  Notable Question
Sep
18
awarded  Teacher
May
23
awarded  Popular Question
Mar
18
accepted LOAD DATA INFILE on a MyISAM table blocks user read-queries, can we get around this?
Mar
18
comment LOAD DATA INFILE on a MyISAM table blocks user read-queries, can we get around this?
What does "no free blocks in the middle" mean?
Mar
18
asked LOAD DATA INFILE on a MyISAM table blocks user read-queries, can we get around this?
Mar
18
comment Can I use mysql to serve 100's of millions of small image files?
MongoDB is a great answer, looking through it's feature list, it's pretty spot on, you guys are both right. That was a good pointer. Scary to try to add yet-another puzzle piece to the mix, but it seems necessary.
Mar
17
accepted MySQL LOAD DATA INFILE slows by 80% after a few gigs of input with InnoDB engine
Mar
17
answered MySQL LOAD DATA INFILE slows by 80% after a few gigs of input with InnoDB engine
Mar
17
revised Can I use mysql to serve 100's of millions of small image files?
added 8 characters in body
Mar
17
accepted MySQL: To use MYISAM or INNODB engine? (plot twist enclosed)
Mar
17
asked Can I use mysql to serve 100's of millions of small image files?
Jan
12
accepted What does 'system lock' mean in mysql profiling a LOAD DATA INFILE statement?
Jan
12
asked What does 'system lock' mean in mysql profiling a LOAD DATA INFILE statement?
Jan
12
comment MySQL LOAD DATA INFILE slows by 80% after a few gigs of input with InnoDB engine
The first file loaded in 54s, 2nd in 3m39s, 3rd in 3m9s, 4m7s, 5m21s, and so on. all files aprox the same size.
Jan
12
awarded  Editor
Jan
12
revised MySQL LOAD DATA INFILE slows by 80% after a few gigs of input with InnoDB engine
added 511 characters in body
Jan
12
comment MySQL LOAD DATA INFILE slows by 80% after a few gigs of input with InnoDB engine
Not seeing any difference here, pretty quickly I see the speed drop from 11MB/sec expansion of the DB file to 6MB (after about 2GB) of data and it's continuing to drop. I'm loading all the files in a for loop, separate mysql calls.
Jan
12
comment MySQL: To use MYISAM or INNODB engine? (plot twist enclosed)
I've sent about 3 days on trying to get innodb to take down 100GB reference table, but I'm not having any success. I'm feeling like the only useable option is myisam, not sure I can avoid the joins with myisam, the whole point of the reference table is to support typical join operations. But the data is read only, no need for transactions at least.