123 reputation
5
bio website market76.com
location
age
visits member for 1 year, 5 months
seen Oct 28 '13 at 22:06

Oct
28
awarded  Popular Question
Oct
11
comment Proper tuning for 30GB InnoDB table on server with 48GB RAM
What is the downside of having your key_buffer_size set too large?
Jul
15
awarded  Supporter
Nov
21
comment mysqlcheck to optimize innodb tables — performance/scheduling
innodb_file_per_table is on.
Nov
20
comment mysqlcheck to optimize innodb tables — performance/scheduling
My main goal is general InnoDB table maintenance, something our current server hasn't received much of. We're using New Relic to record queries and improve query design to optimize from that end too, but would also like to make sure there's not general nightly/weekly type maintenance we can do in order to prevent meltdowns/general issues.
Nov
18
asked mysqlcheck to optimize innodb tables — performance/scheduling
Nov
18
awarded  Scholar
Nov
18
accepted InnoDB Performance Tuning
Nov
17
comment InnoDB Performance Tuning
@DTest, how can I go about changing innodb_flush_log_at_trx_commit? I've looked around online but I want to do it safely.
Nov
15
awarded  Student
Nov
15
awarded  Editor
Nov
15
comment InnoDB Performance Tuning
Thanks for the suggestions. I've updated the original post with GB totals. I will also try #2 and #3 and post results. I'm assuming #3 also requires stoping the MySQL server?
Nov
15
revised InnoDB Performance Tuning
added 263 characters in body
Nov
15
asked InnoDB Performance Tuning