Everything MySQL

A great place to be!

Mark R
  • England
  • United Kingdom
Share on Facebook Share on Facebook Share
  • Blog Posts
  • Discussions
  • Photos
  • Photo Albums
  • Videos

Mark R's Friends

  • Chris
 

Mark R's Page

Gifts Received

Gift

Mark R has not received any gifts yet

Give Mark R a Gift

Latest Activity

Mark R commented on Chris's blog post A MySQL problem or something else?
"I'm not sure why skip-name-resolve is not the default. It makes sense."
Oct 6, 2009
Mark R commented on Sarah Sproehnle's blog post What's faster than REPAIR?
"If your table fits in ram, or rather, the maximum number of tables you're repairing in parallel fit in ram, REPAIRs are fairly fast. If it doesn't, they aren't. This is because to rebuild the secondary indexes it needs to do multiple…"
Sep 17, 2009
Mark R commented on Sarah Sproehnle's blog post What's faster than REPAIR?
"I am not convinced that replaying the binary logs would be faster than a repair. You might not get the same data, for a start. Secondly, you'll end up doing normal inserts rather than a "repair by sorting" index rebuild, normal…"
Sep 17, 2009
Mark R and Chris are now friends
Sep 14, 2009
Mark R commented on Chris's blog post Using TMPFS for MySQL's tmpdir
"Unfortunately there is no way to specify a different temp dir for temporary tables and filesort files. Filesort files can get much larger than temporary tables, and you get very large ones created during MyISAM REPAIR and ALTER operations. A MyISAM…"
Sep 13, 2009
Mark R is now a member of Everything MySQL
Sep 13, 2009

Comment Wall

You need to be a member of Everything MySQL to add comments!

Join Everything MySQL

  • No comments yet!
 
 
 

© 2017   Created by Chris.   Powered by

Badges  |  Report an Issue  |  Terms of Service